Changeset: 23899c1219f7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/23899c1219f7
Added Files:
sql/test/BugTracker-2026/Tests/7984-exists-select-count-bug.test
Modified Files:
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
Add test for issue #7984
diffs (57 lines):
diff --git a/sql/test/BugTracker-2026/Tests/7984-exists-select-count-bug.test
b/sql/test/BugTracker-2026/Tests/7984-exists-select-count-bug.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7984-exists-select-count-bug.test
@@ -0,0 +1,44 @@
+statement ok
+CREATE TABLE ea(x INT)
+
+statement ok
+INSERT INTO ea VALUES (1),(2)
+
+statement ok
+CREATE TABLE eb(y INT)
+
+statement ok
+INSERT INTO eb VALUES (1)
+
+query ITI rowsort
+SELECT ea.x,
+ EXISTS (SELECT COUNT(*) FROM eb WHERE eb.y = ea.x) AS e, -- did the
subquery produce a row?
+ (SELECT COUNT(*) FROM eb WHERE eb.y = ea.x) AS v -- the value
of that same subquery
+FROM ea ORDER BY ea.x
+----
+1
+True
+1
+2
+True
+0
+
+-- MonetDB: {1} expected: {1, 2} one row silently dropped
+query I rowsort
+SELECT ea.x FROM ea WHERE EXISTS (SELECT COUNT(*) FROM eb WHERE eb.y =
ea.x) ORDER BY ea.x
+----
+1
+2
+
+-- MonetDB: {2} expected: {} one row silently invented
+query I rowsort
+SELECT ea.x FROM ea WHERE NOT EXISTS (SELECT COUNT(*) FROM eb WHERE eb.y =
ea.x) ORDER BY ea.x
+----
+
+
+statement ok
+DROP TABLE IF EXISTS ea
+
+statement ok
+DROP TABLE IF EXISTS eb
+
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
@@ -164,3 +164,4 @@ KNOWNFAIL?7974-muli-column-not-in-subque
KNOWNFAIL?7980-lag-offset-ignored-bug
7981-not-x-lt-x-bug
KNOWNFAIL?7982-range-current-row-bug
+KNOWNFAIL?7984-exists-select-count-bug
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
