Changeset: 46a04180e96c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/46a04180e96c Added Files: sql/test/BugTracker-2026/Tests/7937-where-not-in-values-null-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7937 diffs (49 lines): diff --git a/sql/test/BugTracker-2026/Tests/7937-where-not-in-values-null-bug.test b/sql/test/BugTracker-2026/Tests/7937-where-not-in-values-null-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7937-where-not-in-values-null-bug.test @@ -0,0 +1,36 @@ +statement ok +CREATE TABLE t (a int primary key, b int) + +statement ok +INSERT INTO t VALUES (0, 0) + +-- next query returns a row but should not return a row +query II nosort +SELECT * FROM t WHERE a NOT IN (VALUES (null)) +---- + +query II nosort +SELECT * FROM t WHERE b NOT IN (VALUES (null)) +---- + +statement ok +DROP TABLE t + +-- it appears the bug is due to a not null constraint for column a (which is added implicitly for primary key columns) +statement ok +CREATE TABLE t (a int not null, b int) + +statement ok +INSERT INTO t VALUES (0, 0) + +-- next query returns a row but should not return a row +query II nosort +SELECT * FROM t WHERE a NOT IN (VALUES (null)) +---- + +query II nosort +SELECT * FROM t WHERE b NOT IN (VALUES (null)) +---- + +statement ok +DROP TABLE t 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 @@ -128,3 +128,4 @@ KNOWNFAIL?7931-rel2bin_select-assertion- 7932-canditer_init-assertion-failure 7933-query-without-result-bug 7934-ALGouterselect-assertion-failure +7937-where-not-in-values-null-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
