Changeset: 780a2100e7e4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/780a2100e7e4 Added Files: sql/test/BugTracker-2024/Tests/where-between-issue-7428.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for issue 7428 diffs (65 lines): diff --git a/sql/test/BugTracker-2024/Tests/All b/sql/test/BugTracker-2024/Tests/All --- a/sql/test/BugTracker-2024/Tests/All +++ b/sql/test/BugTracker-2024/Tests/All @@ -1,2 +1,3 @@ inequality-hash-issue-7426 pkey-check-failed-7425 +where-between-issue-7428.test diff --git a/sql/test/BugTracker-2024/Tests/where-between-issue-7428.test b/sql/test/BugTracker-2024/Tests/where-between-issue-7428.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/where-between-issue-7428.test @@ -0,0 +1,53 @@ +statement ok +CREATE TABLE t0(c0 INTEGER, c1 BOOL, PRIMARY KEY(c0)) + +statement ok +CREATE TABLE t1(c0 INTEGER, PRIMARY KEY(c0)) + +statement ok +INSERT INTO t0 (c0) VALUES (0) + +statement ok +INSERT INTO t1 (c0) VALUES (1),(2),(3) + +query I +SELECT t0.c1 FROM t0, t1 +---- +NULL +NULL +NULL + +query I +SELECT (((true BETWEEN t0.c1 AND t1.c0)) IS NULL) FROM t0, t1 +---- +1 +1 +1 + +query I +SELECT t0.c1 FROM t0, t1 WHERE (((true BETWEEN t0.c1 AND t1.c0)) IS NULL) +---- +NULL +NULL +NULL + +query I +SELECT t0.c1 FROM t0, t1 WHERE NOT (((true BETWEEN t0.c1 AND t1.c0)) IS NOT NULL) +---- +NULL +NULL +NULL + +query I +SELECT t0.c1 FROM t0, t1 WHERE (1 BETWEEN t0.c1 AND t1.c0) IS NULL +---- +NULL +NULL +NULL + +statement ok +DROP TABLE t0 + +statement ok +DROP TABLE t1 + _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
