search

qri-io / qri

you're invited to a data party!
https://qri.io
GNU General Public License v3.0
1.1k stars 66 forks source link

SQL query: couldn't evaluate formula #1435

Open xxristoskk opened 4 years ago

xxristoskk commented 4 years ago

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.

feep commented 4 years ago

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

Same result.