Changeset: 163f9e2412c5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/163f9e2412c5
Modified Files:
sql/server/sql_query.c
sql/test/BugTracker-2026/Tests/7770-assertion-failure.test
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
fixing issue # 7770
diffs (59 lines):
diff --git a/sql/server/sql_query.c b/sql/server/sql_query.c
--- a/sql/server/sql_query.c
+++ b/sql/server/sql_query.c
@@ -160,7 +160,6 @@ query_outer_aggregated(sql_query *q, int
{
stacked_query *sq = sql_stack_fetch(q->outer, i);
- assert(sq->grouped);
sq->last_used = e;
sq->used_card = sq->rel->card;
return 0;
diff --git a/sql/test/BugTracker-2026/Tests/7770-assertion-failure.test
b/sql/test/BugTracker-2026/Tests/7770-assertion-failure.test
--- a/sql/test/BugTracker-2026/Tests/7770-assertion-failure.test
+++ b/sql/test/BugTracker-2026/Tests/7770-assertion-failure.test
@@ -5,17 +5,30 @@ statement error 42000!COUNT: aggregate f
SELECT v2 GROUP BY COUNT ( v1 NOT BETWEEN 'x' AND v1 ) >= ( 'x' = 'x' AND v1
BETWEEN -1 AND NULL = v2 >= v2 )
-- sql/server/sql_query.c:163: query_outer_aggregated: Assertion `sq->grouped'
failed.
-statement error 42000!COUNT: aggregate function 'count' not allowed in GROUP
BY clause
+-- statement error 42000!COUNT: aggregate function 'count' not allowed in
GROUP BY clause
+query I
SELECT 50 FROM v0 GROUP BY v1 , v2 HAVING ( 67 = 64 AND ( ( SELECT v2 GROUP BY
COUNT ( v1 NOT BETWEEN 'x' AND v1 ) >= ( 'x' = 'x' AND v1 BETWEEN -1 AND NULL =
v2 >= v2 ) ) ) = 19 )
+----
-- sql/server/sql_query.c:163: query_outer_aggregated: Assertion `sq->grouped'
failed.
-statement error 42000!COUNT: aggregate function 'count' not allowed in GROUP
BY clause
+-- statement error 42000!COUNT: aggregate function 'count' not allowed in
GROUP BY clause
+statement ok rowcount 5
INSERT INTO v0 VALUES ( 7 , 59 ) , ( 23 , 127 ) , ( 0 , 15585972.000000 ) , (
70 , 97506846.000000 )
, ( 76 , ( SELECT 50 FROM v0 GROUP BY v1 , v2 HAVING ( 67 = 64 AND ( ( SELECT
v2 GROUP BY COUNT ( v1 NOT BETWEEN 'x' AND v1 ) >= ( 'x' = 'x' AND v1 BETWEEN
-1 AND NULL = v2 >= v2 ) ) ) = 19 ) ) )
query IR nosort
SELECT v1, v2 FROM v0
----
+70
+97506846.000
+0
+15585972.000
+7
+59.000
+23
+127.000
+76
+NULL
statement ok
DROP TABLE v0
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
@@ -3,7 +3,7 @@ KNOWNFAIL?7758-truncate-sys-tables-corru
7766-assertion-failure
7767-assertion-failure
7769-assertion-failure
-KNOWNFAIL?7770-assertion-failure
+7770-assertion-failure
7771-assertion-failure
KNOWNFAIL?7774-insert-into-renamed-table-assertion-failure
7775-assertion-failure
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
