Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

IS DISTINCT FROM not working #319

Open
shaicoleman opened this issue Sep 18, 2023 · 1 comment
Open

IS DISTINCT FROM not working #319

shaicoleman opened this issue Sep 18, 2023 · 1 comment

Comments

@shaicoleman
Copy link

shaicoleman commented Sep 18, 2023

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
Copy link
Owner

harelba commented Sep 19, 2023

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants