Changeset: f4a59ed7bba6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f4a59ed7bba6 Added Files: sql/test/BugTracker-2024/Tests/exp-bin-Bug-7462.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for bug #7462 diffs (37 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 @@ -26,4 +26,5 @@ order-by-false-or-false-Bug-7456 constant-expression-issue-7457 sign-issue-7458 unicode-escape-7461 +exp-bin-Bug-7462 contains-cast-7463 diff --git a/sql/test/BugTracker-2024/Tests/exp-bin-Bug-7462.test b/sql/test/BugTracker-2024/Tests/exp-bin-Bug-7462.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/exp-bin-Bug-7462.test @@ -0,0 +1,23 @@ +statement ok +CREATE TABLE t0(c0 VARCHAR(500), c1 VARCHAR(500)) + +statement ok +INSERT INTO t0(c1) VALUES ('a') + +query TTI +SELECT t0.c1, t0.c0, (((t0.c1 BETWEEN -1 AND 1))OR((t0.c1 BETWEEN -1 AND ('b' IN (t0.c1, t0.c0))))) FROM t0 +---- +a +NULL +NULL + + +-- next query fails in: sql/backends/monet5/rel_bin.c:1680: exp_bin: Assertion `s' failed. +-- with assertion disabled it fails to return a result set +query TT +SELECT t0.c1, t0.c0 FROM t0 WHERE (((t0.c1 BETWEEN -1 AND 1))OR((t0.c1 BETWEEN -1 AND ('b' IN (t0.c1, t0.c0))))) +---- + + +statement ok +DROP TABLE t0 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org