Changeset: 070843ca205e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/070843ca205e
Added Files:
sql/test/BugTracker-2024/Tests/7543-is-not-distinct-from-true.test
Modified Files:
sql/test/BugTracker-2024/Tests/All
Branch: Aug2024
Log Message:
Add test for GH issue #7543
diffs (36 lines):
diff --git a/sql/test/BugTracker-2024/Tests/7543-is-not-distinct-from-true.test
b/sql/test/BugTracker-2024/Tests/7543-is-not-distinct-from-true.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2024/Tests/7543-is-not-distinct-from-true.test
@@ -0,0 +1,21 @@
+query I nosort
+SELECT (NULL NOT IN ('a'))
+----
+NULL
+
+query I nosort
+SELECT ((NULL NOT IN ('a')) IS DISTINCT FROM true)
+----
+1
+
+-- next should return false instead of NULL
+query I nosort
+SELECT ((NULL NOT IN ('a')) IS NOT DISTINCT FROM true)
+----
+0
+
+query I nosort
+SELECT (NOT ((NULL NOT IN ('a')) IS NOT DISTINCT FROM true))
+----
+1
+
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
@@ -69,5 +69,6 @@ 7537-prepare_stmt_with_dropped_table
7536-mclient-forgets-to-flush
7541-levenshtein
7542-column-name-resolution
+7543-is-not-distinct-from-true
7545-groupby_on_index_col
7547-drop-login-trigger-crash
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
