Changeset: 5e23bd040f7d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5e23bd040f7d
Added Files:
sql/test/BugTracker-2024/Tests/7563-is-distinct-from.test
Modified Files:
sql/test/BugTracker-2024/Tests/All
Branch: Aug2024
Log Message:
Add test for #7563
diffs (35 lines):
diff --git a/sql/test/BugTracker-2024/Tests/7563-is-distinct-from.test
b/sql/test/BugTracker-2024/Tests/7563-is-distinct-from.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2024/Tests/7563-is-distinct-from.test
@@ -0,0 +1,22 @@
+statement ok
+CREATE TABLE t1(c1 VARCHAR(500))
+
+statement ok
+INSERT INTO t1(c1) VALUES ('a')
+
+statement ok
+CREATE VIEW v0(c0) AS SELECT ('a'||NULL) FROM t1
+
+query T
+SELECT * FROM v0
+----
+NULL
+
+query T
+SELECT ((v0.c0 IS NOT DISTINCT FROM v0.c0) AND (v0.c0 = v0.c0)) FROM v0
+----
+NULL
+
+query T
+SELECT * FROM v0 WHERE ((v0.c0 IS NOT DISTINCT FROM v0.c0) AND (v0.c0 =
v0.c0));
+----
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
@@ -86,3 +86,4 @@ 7566-connections-refused
7562-interval-overflow
7569-temp-table-column-reuse
7571-crash-orderby
+7563-is-distinct-from
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]