Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 12 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/flatten_by/flatten_expr_struct.sql b/yql/essentials/tests/sql/suites/flatten_by/flatten_expr_struct.sql
new file mode 100644
index 0000000000..35ca94eeb8
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/flatten_by/flatten_expr_struct.sql
@@ -0,0 +1,12 @@
+/* syntax version 1 */
+/* postgres can not */
+USE plato;
+
+$data = select 1 as n, AsList(4, 5, 6) as l, AsStruct(10 as n, AsList(1, 2, 3) as l) as s union all
+        select 2 as n, AsList(4, 5)    as l, AsStruct(20 as n, AsList(1, 2)    as l) as s;
+
+select n,l from $data      flatten by s.l as l order by n,l;
+select n,l from $data      flatten by (s.l as l) order by n,l;
+select n,l from $data      flatten by (ListExtend(s.l, AsList(100)) as l) order by n,l;
+
+select n,l,sl from $data flatten by (l, s.l as sl) order by n,l,sl