Changeset: 54746b3d75ac for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/54746b3d75ac
Added Files:
sql/test/BugTracker-2026/Tests/7938-not-x-is-const-and-x-is-not-null-bug.test
Modified Files:
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
Add test for #7938
diffs (32 lines):
diff --git
a/sql/test/BugTracker-2026/Tests/7938-not-x-is-const-and-x-is-not-null-bug.test
b/sql/test/BugTracker-2026/Tests/7938-not-x-is-const-and-x-is-not-null-bug.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2026/Tests/7938-not-x-is-const-and-x-is-not-null-bug.test
@@ -0,0 +1,19 @@
+query TI nosort
+SELECT x, CASE WHEN NOT(x = 'YTD' AND x IS NOT NULL) THEN 'False' ELSE 'True'
END AS f
+ FROM (VALUES ('YTD'), ('NOT YTD')) AS v(x)
+----
+YTD
+1
+NOT YTD
+0
+
+-- strangly when swapping condition order (a AND b) into (b AND a), it works
correct
+query TI nosort
+SELECT x, CASE WHEN NOT(x IS NOT NULL AND x = 'YTD') THEN 'False' ELSE 'True'
END AS f
+ FROM (VALUES ('YTD'), ('NOT YTD')) AS v(x)
+----
+YTD
+1
+NOT YTD
+0
+
diff --git a/sql/test/BugTracker-2026/Tests/All
b/sql/test/BugTracker-2026/Tests/All
--- a/sql/test/BugTracker-2026/Tests/All
+++ b/sql/test/BugTracker-2026/Tests/All
@@ -129,3 +129,4 @@ KNOWNFAIL?7931-rel2bin_select-assertion-
7933-query-without-result-bug
7934-ALGouterselect-assertion-failure
KNOWNFAIL?7937-where-not-in-values-null-bug
+KNOWNFAIL?7938-not-x-is-const-and-x-is-not-null-bug
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
