Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

1 files changed, 16 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/optimizers/yql-4240-aggregate_whole_struct.sql b/yql/essentials/tests/sql/suites/optimizers/yql-4240-aggregate_whole_struct.sql
new file mode 100644
index 0000000000..bf646532d4
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/optimizers/yql-4240-aggregate_whole_struct.sql
@@ -0,0 +1,16 @@
+/* postgres can not */
+use plato;
+
+$data = (select value as attr, key as urlBase, cast(subkey as int32) as dupsCount from Input0);
+
+        SELECT
+            urlBase,
+            SUM(dupsCount) as allDocs,
+            MAX_BY(AsStruct(dupsCount as dupsCount, attr as attr), dupsCount) as best
+        FROM (
+            SELECT urlBase, attr, count(*) as dupsCount
+            FROM $data
+            GROUP BY urlBase, attr
+        )
+        GROUP BY urlBase
+        ORDER BY urlBase