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

Reply via email to