qri icon indicating copy to clipboard operation
qri copied to clipboard

SQL query: couldn't evaluate formula

Open xxristoskk opened this issue 4 years ago • 1 comments

What version of qri are you using (qri version)?

0.9.7

What is your OS and version?

Linux Mint Cinnamon 19.3

What did you do?

qri sql "SELECT * FROM xristosk/july_daily_covid19_jh as july WHERE july.fips = 36001"

What happened?

couldn't get next record: couldn't evaluate formula: invalid operands to equal 45001 and 36001 with types Float and Int

What did you expect to happen?

SQL result table

Also tried using 36001.0 and got the following error: couldn't get next record: couldn't evaluate formula: invalid operands to equal '' and 36001 with types String and Float

I think the column might be mixed with empty strings or Null values

edit: corrected qri sql... line.

xxristoskk avatar Jul 08 '20 15:07 xxristoskk

Tried both int 360001 and float 36001.0 queries in qri 0.9.9.

Same result.

feep avatar Jul 08 '20 16:07 feep