Intermediate changes

commit_hash:e6cca97ec9c9627f1ba82a11abf454518fc90972

1 files changed, 18 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/lambda/list_aggregate.yql b/yql/essentials/tests/sql/suites/lambda/list_aggregate.yql
new file mode 100644
index 00000000000..a4c1093ae73
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/lambda/list_aggregate.yql
@@ -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;