You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
Consider the test case below. It is unexpected that the third query returns true, since the second query returns null, which means that the WHERE clause in the third query should be evaluated to null and thus return an empty result.
To Reproduce
DROPTABLE t0 CASCADE;
DROPTABLE t1 CASCADE;
CREATETABLEt1(c0 BOOLEAN);
INSERT INTO t1 (c0) VALUES (true);
SELECT*FROM t1; -- trueSELECT (((t1.c0 NOT IN (true)))=((t1.c0 BETWEEN true ANDNULL))) FROM t1; -- nullSELECT*FROM t1 WHERE (((t1.c0 NOT IN (true)))=((t1.c0 BETWEEN true ANDNULL)));
-- Expected: Empty set-- Actual: true
Expected behavior
As mentioned above
Screenshots
N/A
Software versions
Build from source:
> docker exec monetdb-test mserver5 --version --dbname=monetdb
MonetDB 5 server 11.50.0 (hg id: c9e0977) (64-bit, 128-bit integers)
This is an unreleased version
Copyright (c) 1993 - July 2008 CWI
Copyright (c) August 2008 - 2023 MonetDB B.V., all rights reserved
Visit https://www.monetdb.org/ for further information
Found 503.5GiB available memory, 128 available cpu cores
Libraries:
Compiled by: @618e73c727b6 (x86_64-pc-linux-gnu)
Compilation: /usr/bin/cc
Linking : /usr/bin/ld
Issue labeling
Bug
Additional context
Add any other context about the problem here.
The text was updated successfully, but these errors were encountered:
Describe the bug
Consider the test case below. It is unexpected that the third query returns
true
, since the second query returnsnull
, which means that theWHERE
clause in the third query should be evaluated tonull
and thus return an empty result.To Reproduce
Expected behavior
As mentioned above
Screenshots
N/A
Software versions
Build from source:
Issue labeling
Bug
Additional context
Add any other context about the problem here.
The text was updated successfully, but these errors were encountered: