search

harelba / q

q - Run SQL directly on delimited files and multi-file sqlite databases
http://harelba.github.io/q/
GNU General Public License v3.0
10.19k stars 421 forks source link

IS DISTINCT FROM not working #319

Open shaicoleman opened 1 year ago

shaicoleman commented 1 year ago

e.g. $ q -d, -H -O "SELECT * FROM mycsv.csv mytable WHERE mytable.a IS DISTINCT FROM mytable.b" No files matching '/tmp/mytable.b' have been found

It seems It interprets IS DISTINCT FROM as FROM

q version 3.1.6 via DEB package on Ubuntu 22.04

harelba commented 1 year ago

Indeed it's a bug in q's parsing. Thanks for reporting this.

Tried to find a workaround, but couldn't find one. I'm sorry.

I'll fix it in the next version.