Changeset: d92fbbee7818 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d92fbbee7818
Added Files:
sql/test/BugTracker-2024/Tests/inner-join-contains-7466.test
Modified Files:
sql/test/BugTracker-2024/Tests/All
Branch: Dec2023
Log Message:
Add test for issue #7466
diffs (59 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
@@ -29,3 +29,4 @@ unicode-escape-7461
exp-bin-Bug-7462
contains-cast-7463
between-true-and-null-Bug-7465
+inner-join-contains-7466
diff --git a/sql/test/BugTracker-2024/Tests/inner-join-contains-7466.test
b/sql/test/BugTracker-2024/Tests/inner-join-contains-7466.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2024/Tests/inner-join-contains-7466.test
@@ -0,0 +1,46 @@
+statement ok
+CREATE TABLE t0(c1 INT)
+
+statement ok
+INSERT INTO t0 VALUES(4)
+
+statement ok
+CREATE TABLE t1(c1 VARCHAR(500))
+
+statement ok
+INSERT INTO t1 VALUES ('abc')
+
+statement ok
+CREATE VIEW v0(c0) AS SELECT (('a')||('b')) FROM t1
+
+query TIT nosort
+SELECT * FROM t1, t0 INNER JOIN v0 ON t0.c1
+----
+abc
+4
+ab
+
+query TIT nosort
+SELECT * FROM t1, t0 INNER JOIN v0 ON t0.c1 WHERE (NOT CONTAINS((t1.c1 >
'a'), t0.c1))
+----
+abc
+4
+ab
+
+query TIT nosort
+SELECT * FROM t1, t0 INNER JOIN v0 ON t0.c1 WHERE CONTAINS((t1.c1 > 'a'),
t0.c1)
+ UNION ALL
+SELECT * FROM t1, t0 INNER JOIN v0 ON t0.c1 WHERE (NOT CONTAINS((t1.c1 >
'a'), t0.c1))
+----
+abc
+4
+ab
+
+statement ok
+DROP VIEW v0
+
+statement ok
+DROP TABLE t0
+
+statement ok
+DROP TABLE t1
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
