Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 16 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/action/subquery_merge_nested_subquery.sql b/yql/essentials/tests/sql/suites/action/subquery_merge_nested_subquery.sql
new file mode 100644
index 0000000000..47317a548e
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/action/subquery_merge_nested_subquery.sql
@@ -0,0 +1,16 @@
+/* syntax version 1 */
+/* postgres can not */
+USE plato;
+
+DEFINE SUBQUERY $get_tables_list($dir) AS
+        SELECT
+            Unwrap($dir || "/" || CAST(TableName(Path, "yt") AS String)) AS Path,
+        FROM FOLDER($dir)
+END DEFINE;
+
+DEFINE SUBQUERY $get_all_tables_list($dirs) AS
+        $get_src_tables = SubqueryExtendFor(UNWRAP(ListUniq($dirs)), $get_tables_list);
+        select * from $get_src_tables();
+END DEFINE;
+    
+process $get_all_tables_list([""]);