IS DISTINCT FROM not working

Question

IS DISTINCT FROM not working

shaicoleman opened this issue a year 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

Answer 1 · 2023-09-19T15:14:37.000Z

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.