Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 19 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/optimizers/yql-18300-flatmap-over-extend.sql b/yql/essentials/tests/sql/suites/optimizers/yql-18300-flatmap-over-extend.sql
new file mode 100644
index 0000000000..7bd19b7bee
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/optimizers/yql-18300-flatmap-over-extend.sql
@@ -0,0 +1,19 @@
+USE plato;
+
+insert into @tmp with truncate
+select "dummy" as a, "1" as b, ["b", "s"] as data
+order by a;
+
+commit;
+
+
+SELECT a, id
+FROM (
+    SELECT
+        a,
+        ListExtend(
+            [String::AsciiToLower(b)],
+            ListMap(data, String::AsciiToLower)
+        ) AS joins
+    FROM @tmp
+) FLATTEN LIST BY joins AS id;