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

Library import 241120-1113

1 files changed, 18 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/lambda/list_aggregate.sql b/yql/essentials/tests/sql/suites/lambda/list_aggregate.sql
new file mode 100644
index 0000000000..a4c1093ae7
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/lambda/list_aggregate.sql
@@ -0,0 +1,18 @@
+/* syntax version 1 */
+$subst = ($names, $indices) -> {
+    RETURN ListMap(
+        $indices,
+        ($index) -> {
+            RETURN $names[$index];
+        }
+    );
+};
+
+$table = (
+    SELECT AsList("a", "b") AS names, AsList(0, 0, 1) AS indices
+    UNION ALL
+    SELECT AsList("c", "d") AS names, AsList(0, 1, 1) AS indices
+);
+
+SELECT AGGREGATE_LIST($subst(names, indices))
+FROM $table;