IS DISTINCT FROM not working

Open shaicoleman opened this issue 2 years ago • 1 comments

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

Sep 18 '23 17:09 shaicoleman

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.

Sep 19 '23 15:09 harelba