Changeset: aac8fefe7400 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/aac8fefe7400 Added Files: sql/test/BugTracker-2026/Tests/7987-where-null-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #7987 diffs (44 lines): diff --git a/sql/test/BugTracker-2026/Tests/7987-where-null-bug.test b/sql/test/BugTracker-2026/Tests/7987-where-null-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7987-where-null-bug.test @@ -0,0 +1,31 @@ +statement ok +CREATE TABLE t_mdb_val_005(id INT) + +statement ok +INSERT INTO t_mdb_val_005 VALUES (1) + +query T nosort +SELECT (NOT ((NULL IN (1)) AND (NULL IN (1)))) OR (NOT (1 IN (1))) +---- +NULL + +-- bug: WHERE NULL should result in 0 rows returned +query TI rowsort +SELECT 'where' AS query, id +FROM t_mdb_val_005 +WHERE (NOT ((NULL IN (1)) AND (NULL IN (1)))) OR (NOT (1 IN (1))) +---- + +query TIT rowsort +SELECT 'projection' AS query, id, + (NOT ((NULL IN (1)) AND (NULL IN (1)))) OR (NOT (1 IN (1))) + AS predicate_value +FROM t_mdb_val_005 +---- +projection +1 +NULL + +statement ok +DROP TABLE IF EXISTS t_mdb_val_005 + diff --git a/sql/test/BugTracker-2026/Tests/All b/sql/test/BugTracker-2026/Tests/All --- a/sql/test/BugTracker-2026/Tests/All +++ b/sql/test/BugTracker-2026/Tests/All @@ -167,3 +167,4 @@ KNOWNFAIL?7982-range-current-row-bug KNOWNFAIL?7984-exists-select-count-bug KNOWNFAIL?7985-qualify-row_number-over-bug KNOWNFAIL?7986-right-function-bug +KNOWNFAIL?7987-where-null-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
