Changeset: 2d564d86a024 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2d564d86a024 Added Files: sql/test/BugTracker-2026/Tests/7999-not-not-expr-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #7999 diffs (43 lines): diff --git a/sql/test/BugTracker-2026/Tests/7999-not-not-expr-bug.test b/sql/test/BugTracker-2026/Tests/7999-not-not-expr-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7999-not-not-expr-bug.test @@ -0,0 +1,30 @@ +statement ok +CREATE TABLE t4 ( + c2 SMALLINT, + c4 TIME +) + +statement ok rowcount 2 +INSERT INTO t4 VALUES + (26, NULL), + (35, NULL) + +query I rowsort +SELECT c2 +FROM t4 +WHERE c2 > 26 +ORDER BY c2 +---- +35 + +query I rowsort +SELECT c2 +FROM t4 +WHERE NOT (NOT (c2 > 26)) +ORDER BY c2 +---- +35 + +statement ok +DROP TABLE IF EXISTS t4 + 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 @@ -179,3 +179,4 @@ KNOWNFAIL?7995-left-join-lateral-subquer KNOWNFAIL?7996-delete-not-exists-correlated-query-bug KNOWNFAIL?7997-recursive-cte-number-overflow-issue KNOWNFAIL?7998-scalar-subquery-error-msg-improvement +7999-not-not-expr-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
