Changeset: 7a66789bad22 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/7a66789bad22
Modified Files:
sql/test/BugTracker-2026/Tests/7966-optimize-select-distinct-from-union-queries.test
Branch: pp_hashjoin
Log Message:
approved output
diffs (61 lines):
diff --git
a/sql/test/BugTracker-2026/Tests/7966-optimize-select-distinct-from-union-queries.test
b/sql/test/BugTracker-2026/Tests/7966-optimize-select-distinct-from-union-queries.test
---
a/sql/test/BugTracker-2026/Tests/7966-optimize-select-distinct-from-union-queries.test
+++
b/sql/test/BugTracker-2026/Tests/7966-optimize-select-distinct-from-union-queries.test
@@ -23,19 +23,15 @@ WHERE a >= 200
group by (
| munion (
| | project (
-| | | project (
-| | | | select (
-| | | | | table("sys"."outer_distinct_union_t") [ "outer_distinct_union_t"."a"
]
-| | | | ) [ ("outer_distinct_union_t"."a") <= (int(31) "800") ]
-| | | ) [ "outer_distinct_union_t"."a" ]
-| | ) [ "outer_distinct_union_t"."a", "outer_distinct_union_t"."a" ],
+| | | select (
+| | | | table("sys"."outer_distinct_union_t") [ "outer_distinct_union_t"."a" ]
+| | | ) [ ("outer_distinct_union_t"."a") <= (int(31) "800") ]
+| | ) [ "outer_distinct_union_t"."a" ],
| | project (
-| | | project (
-| | | | select (
-| | | | | table("sys"."outer_distinct_union_t") [ "outer_distinct_union_t"."a"
]
-| | | | ) [ ("outer_distinct_union_t"."a") >= (int(31) "200") ]
-| | | ) [ "outer_distinct_union_t"."a" ]
-| | ) [ "outer_distinct_union_t"."a", "outer_distinct_union_t"."a" ]
+| | | select (
+| | | | table("sys"."outer_distinct_union_t") [ "outer_distinct_union_t"."a" ]
+| | | ) [ ("outer_distinct_union_t"."a") >= (int(31) "200") ]
+| | ) [ "outer_distinct_union_t"."a" ]
| ) [ "outer_distinct_union_t"."a" ]
) [ "outer_distinct_union_t"."a" ] [ "outer_distinct_union_t"."a" ]
@@ -58,20 +54,16 @@ group by (
| group by (
| | munion (
| | | project (
-| | | | project (
-| | | | | select (
-| | | | | | table("sys"."outer_distinct_union_t") [
"outer_distinct_union_t"."a" ]
-| | | | | ) [ ("outer_distinct_union_t"."a") <= (int(31) "800") ]
-| | | | ) [ "outer_distinct_union_t"."a" as "u"."a" ]
-| | | ) [ "u"."a", "u"."a" ],
+| | | | select (
+| | | | | table("sys"."outer_distinct_union_t") [ "outer_distinct_union_t"."a"
]
+| | | | ) [ ("outer_distinct_union_t"."a") <= (int(31) "800") ]
+| | | ) [ "outer_distinct_union_t"."a" ],
| | | project (
-| | | | project (
-| | | | | select (
-| | | | | | table("sys"."outer_distinct_union_t") [
"outer_distinct_union_t"."a" ]
-| | | | | ) [ ("outer_distinct_union_t"."a") >= (int(31) "200") ]
-| | | | ) [ "outer_distinct_union_t"."a" as "u"."a" ]
-| | | ) [ "u"."a", "u"."a" ]
-| | ) [ "u"."a" ]
+| | | | select (
+| | | | | table("sys"."outer_distinct_union_t") [ "outer_distinct_union_t"."a"
]
+| | | | ) [ ("outer_distinct_union_t"."a") >= (int(31) "200") ]
+| | | ) [ "outer_distinct_union_t"."a" ]
+| | ) [ "outer_distinct_union_t"."a" as "u"."a" ]
| ) [ "u"."a" ] [ "u"."a" ]
) [ "u"."a" ] [ "u"."a" ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
