Changeset: 49c74f0f13d4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/49c74f0f13d4 Added Files: sql/test/BugTracker-2024/Tests/between-true-and-null-Bug-7465.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for issue $7465 diffs (35 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 @@ -28,3 +28,4 @@ sign-issue-7458 unicode-escape-7461 exp-bin-Bug-7462 contains-cast-7463 +between-true-and-null-Bug-7465 diff --git a/sql/test/BugTracker-2024/Tests/between-true-and-null-Bug-7465.test b/sql/test/BugTracker-2024/Tests/between-true-and-null-Bug-7465.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/between-true-and-null-Bug-7465.test @@ -0,0 +1,22 @@ +statement ok +CREATE TABLE t1(c0 BOOLEAN) + +statement ok +INSERT INTO t1 (c0) VALUES (true) + +query I +SELECT * FROM t1 +---- +1 + +query I +SELECT (((t1.c0 NOT IN (true)))=((t1.c0 BETWEEN true AND NULL))) FROM t1 +---- +NULL + +query I +SELECT * FROM t1 WHERE (((t1.c0 NOT IN (true)))=((t1.c0 BETWEEN true AND NULL))) +---- + +statement ok +DROP TABLE t1 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
