search

UBOdin / mimir

Data-ish exploration through SQL+Uncertainty
http://mimirdb.info
Apache License 2.0
26 stars 13 forks source link

Error compiling float/int addition #355

Closed okennedy closed 4 years ago

okennedy commented 4 years ago 
mimir> select cast(h as int)*60*60+cast(m as int)*60+cast(s as float) from extract_warm_start;
QUERY took: 7 ms
Error: Error while compiling  ( ( ( (CAST(regexp_extract(`value`, '^(\d{2}):(\d{2}):(\d{2}.\d{3})', 1) AS int)*60) *60) + (CAST(regexp_extract(`value`, '^(\d{2}):(\d{2}):(\d{2}.\d{3})', 2) AS int)*60) ) +CAST(regexp_extract(`value`, '^(\d{2}):(\d{2}):(\d{2}.\d{3})', 3) AS real))