Changeset: 1366475d0587 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1366475d0587
Added Files:
sql/test/BugTracker-2024/Tests/where-case-null-issue-7429.test
Modified Files:
sql/test/BugTracker-2024/Tests/All
Branch: Dec2023
Log Message:
Add test for issue 7429
diffs (64 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,3 +1,4 @@
inequality-hash-issue-7426
pkey-check-failed-7425
-where-between-issue-7428.test
+where-between-issue-7428
+where-case-null-issue-7429
diff --git a/sql/test/BugTracker-2024/Tests/where-case-null-issue-7429.test
b/sql/test/BugTracker-2024/Tests/where-case-null-issue-7429.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2024/Tests/where-case-null-issue-7429.test
@@ -0,0 +1,50 @@
+statement ok
+CREATE TABLE t7429(c0 VARCHAR)
+
+statement ok
+INSERT INTO t7429 (c0) VALUES ('a'),('b')
+
+query T
+SELECT * FROM t7429
+----
+a
+b
+
+query I
+SELECT (((CASE (NULL)/(1) WHEN NULL THEN true END)OR(false)) IS NULL) FROM
t7429
+----
+1
+1
+
+query T
+SELECT * FROM t7429 WHERE (((CASE (NULL)/(1) WHEN NULL THEN true
END)OR(false)) IS NULL)
+----
+a
+b
+
+query II
+SELECT (CASE (NULL)/(1) WHEN NULL THEN true END), (CASE (NULL)/(1) WHEN NULL
THEN true END)OR(false)
+----
+NULL
+NULL
+
+query I
+SELECT (CASE (NULL)/(1) WHEN NULL THEN true END)OR(false) FROM t7429
+----
+NULL
+NULL
+
+query T
+SELECT * FROM t7429 WHERE NULL
+----
+
+query T
+SELECT * FROM t7429 WHERE (NULL)OR(false)
+----
+
+query T
+SELECT * FROM t7429 WHERE (CASE (NULL)/(1) WHEN NULL THEN true END)OR(false)
+----
+
+statement ok
+DROP TABLE t7429
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
