qri
qri copied to clipboard
SQL query: couldn't evaluate formula
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.
Tried both int 360001
and float 36001.0
queries in qri 0.9.9.
Same result.