We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Q1:
SELECT NULL IN (NULL)
Result: True. No problem
True
Q2:
SELECT NULL IN ('0', NULL)
Result: False. Wondering why additional element in list leads to False?
False
7.4
ubuntu 22
ext4
Yuancheng Jiang
National University of Singapore
No response
The text was updated successfully, but these errors were encountered:
SELECT NULL IN ('0', NULL) -- false SELECT NULL IN (null::string, NULL) -- true SELECT NULL IN (NULL, '0') -- false
NULL values get added to the deferred list:
NULL
questdb/core/src/main/java/io/questdb/griffin/engine/functions/bool/InStrFunctionFactory.java
Lines 72 to 78 in 4d5890b
Deferred list never gets into the set, so lookup fails:
Lines 105 to 110 in 4d5890b
Lines 118 to 122 in 4d5890b
Sorry, something went wrong.
nwoolmer
Successfully merging a pull request may close this issue.
To reproduce
Q1:
Result:
True
. No problemQ2:
Result:
False
. Wondering why additional element in list leads to False?QuestDB version:
7.4
OS, in case of Docker specify Docker and the Host OS:
ubuntu 22
File System, in case of Docker specify Host File System:
ext4
Full Name:
Yuancheng Jiang
Affiliation:
National University of Singapore
Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?
Additional context
No response
The text was updated successfully, but these errors were encountered: