Changeset: d19783ae5577 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d19783ae5577 Added Files: sql/test/BugTracker-2026/Tests/8001-select-count-where-having-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #8001 diffs (53 lines): diff --git a/sql/test/BugTracker-2026/Tests/8001-select-count-where-having-bug.test b/sql/test/BugTracker-2026/Tests/8001-select-count-where-having-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/8001-select-count-where-having-bug.test @@ -0,0 +1,40 @@ +statement ok +CREATE TABLE t4 ( + c1 INT, + c10 INT +) + +statement ok rowcount 2 +INSERT INTO t4 VALUES + (10, NULL), + (20, NULL) + +-- Direct query over the empty filtered input. +query I nosort +SELECT COUNT(*) AS cnt +FROM t4 +WHERE c10 IS NOT NULL +HAVING AVG(c1) <> 0.03 +---- +0 + +-- CTAS form. +statement ok rowcount 0 +CREATE TABLE tt AS +SELECT * +FROM t4 +WHERE c10 IS NOT NULL + +query I nosort +SELECT COUNT(*) AS cnt +FROM tt +HAVING AVG(c1) <> 0.03 +---- +0 + +statement ok +DROP TABLE IF EXISTS tt + +statement ok +DROP TABLE IF EXISTS t4 + 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 @@ -181,3 +181,4 @@ KNOWNFAIL?7997-recursive-cte-number-over KNOWNFAIL?7998-scalar-subquery-error-msg-improvement 7999-not-not-expr-bug KNOWNFAIL?8000-select-count-distinct-assert-failure +KNOWNFAIL?8001-select-count-where-having-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
