Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 23 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/optimizers/yql-7324_duplicate_arg.sql b/yql/essentials/tests/sql/suites/optimizers/yql-7324_duplicate_arg.sql
new file mode 100644
index 0000000000..df26751a74
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/optimizers/yql-7324_duplicate_arg.sql
@@ -0,0 +1,23 @@
+/* postgres can not */
+/* syntax version 1 */
+USE plato;
+
+$to_int = ($x) -> { return cast($x as Int32) };
+$to_in_list = ($col) -> { return ListMap(String::SplitToList($col, ","), $to_int) };
+
+$input = (
+    SELECT
+        $to_in_list(key) AS event_ids,
+        $to_in_list(subkey) AS test_ids
+    FROM
+        Input
+    WHERE
+        value = "aaa"
+);
+
+SELECT
+    event_id,
+    test_ids
+FROM
+    $input
+FLATTEN BY event_ids AS event_id;