Changeset: 82c26d0e1589 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/82c26d0e1589 Added Files: sql/test/BugTracker-2026/Tests/8000-select-count-distinct-assert-failure.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #8000 diffs (90 lines): diff --git a/sql/test/BugTracker-2026/Tests/8000-select-count-distinct-assert-failure.test b/sql/test/BugTracker-2026/Tests/8000-select-count-distinct-assert-failure.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/8000-select-count-distinct-assert-failure.test @@ -0,0 +1,77 @@ +statement ok +CREATE TABLE t3 ( + c1 INT NOT NULL, + c10 INT NULL, + PRIMARY KEY (c1) +) + +statement ok rowcount 3 +INSERT INTO t3 VALUES + (1, NULL), + (2, NULL), + (3, NULL) + +query II rowsort +SELECT c1, COUNT(*) AS agg_cnt FROM t3 GROUP BY c1; +---- +1 +1 +2 +1 +3 +1 + +query II rowsort +SELECT c1, COUNT(c10) AS agg_cnt FROM t3 GROUP BY c1; +---- +1 +0 +2 +0 +3 +0 + +-- next query logs server msgs: +-- exp_bin: CRITICAL: Could not find %2.%2 +-- exp_bin: ERROR: Query: 'select c1, count(distinct c10) as agg_cnt from t3 group by c1 +-- and assert(s); fails at: sql/backends/monet5/rel_bin.c:1914 +query II rowsort +SELECT c1, COUNT(DISTINCT c10) AS agg_cnt FROM t3 GROUP BY c1; +---- +1 +0 +2 +0 +3 +0 + +-- Direct grouped subquery. +query I nosort +SELECT COUNT(*) AS cnt +FROM ( + SELECT c1, COUNT(DISTINCT c10) AS agg_cnt + FROM t3 + GROUP BY c1 +) AS s +---- +3 + +-- CTAS form. +statement ok rowcount 3 +CREATE TABLE tt AS +SELECT c1, COUNT(DISTINCT c10) AS agg_cnt +FROM t3 +GROUP BY c1 + +query I nosort +SELECT COUNT(*) AS cnt +FROM tt +---- +3 + +statement ok +DROP TABLE IF EXISTS tt + +statement ok +DROP TABLE IF EXISTS t3 + 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 @@ -180,3 +180,4 @@ KNOWNFAIL?7996-delete-not-exists-correla KNOWNFAIL?7997-recursive-cte-number-overflow-issue KNOWNFAIL?7998-scalar-subquery-error-msg-improvement 7999-not-not-expr-bug +KNOWNFAIL?8000-select-count-distinct-assert-failure _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
