Changeset: 372f30a9ce9d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/372f30a9ce9d
Modified Files:
sql/test/BugTracker-2026/Tests/7938-not-x-is-const-and-x-is-not-null-bug.test
Branch: Dec2025
Log Message:
Correct outputs to type T.
Also added a query without the NOT, which appears to work correctly.
diffs (39 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
---
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
@@ -1,19 +1,29 @@
-query TI nosort
+query TT 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
+True
NOT YTD
-0
+False
-- strangly when swapping condition order (a AND b) into (b AND a), it works
correct
-query TI nosort
+query TT 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
+True
NOT YTD
-0
+False
+-- without the NOT is also works correct
+query TT nosort
+SELECT x, CASE WHEN (x = 'YTD' AND x IS NOT NULL) THEN 'True' ELSE 'False' END
AS f
+ FROM (VALUES ('YTD'), ('NOT YTD')) AS v(x)
+----
+YTD
+True
+NOT YTD
+False
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
