Changeset: b76827c293cf for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b76827c293cf
Modified Files:
sql/test/BugTracker-2026/Tests/7993-query-groupby-rollup-bug.test
sql/test/BugTracker-2026/Tests/All
Branch: default
Log Message:
approved output and enabled test, issue #7993 was fixed by reimplemented
decorrelation algoritm
diffs (40 lines):
diff --git a/sql/test/BugTracker-2026/Tests/7993-query-groupby-rollup-bug.test
b/sql/test/BugTracker-2026/Tests/7993-query-groupby-rollup-bug.test
--- a/sql/test/BugTracker-2026/Tests/7993-query-groupby-rollup-bug.test
+++ b/sql/test/BugTracker-2026/Tests/7993-query-groupby-rollup-bug.test
@@ -17,19 +17,14 @@ SELECT COUNT(*) FROM n3a
AND EXISTS (SELECT 1 FROM n3b WHERE n3b.c0 = n3a.c0)
GROUP BY ROLLUP(n3a.c1)
----
-REF 1 (2)
-semijoin (
-| select (
-| | [ ]
-| ) [ boolean(1) "false" ],
-| project (
-| | table("sys"."n3b") [ "n3b"."c0", "n3b"."%TID%" ]
-| ) [ tinyint(1) "1" as "%3"."%3", "n3b"."c0" ]
-) [ ("n3b"."c0") = ("n3a"."c0") ]
project (
| project (
| | group by (
-| | | & REF 1
+| | | project (
+| | | | select (
+| | | | | [ int(5) NULL as "n3a"."c0", int(2) NULL as "n3a"."c1" ]
+| | | | ) [ boolean(1) "false" ]
+| | | ) [ "n3a"."c1" ]
| | ) [ ] [ "sys"."count"() as "%2"."%2" ]
| ) [ "%2"."%2" ]
) [ "%2"."%2" ]
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
@@ -175,7 +175,7 @@ KNOWNFAIL?7989-window-avg-bug
KNOWNFAIL?7990-rank-filter-bug
7991-group_concat-null-separator-bug
KNOWNFAIL?7992-window-date-range-interval-bug
-KNOWNFAIL?7993-query-groupby-rollup-bug
+7993-query-groupby-rollup-bug
KNOWNFAIL?7994-exists-groupby-rollup-bug
KNOWNFAIL?7995-left-join-lateral-subquery-bug
KNOWNFAIL?7996-delete-not-exists-correlated-query-bug
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
