Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 23 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/select/use_subrequest_as_table.sqlx b/yql/essentials/tests/sql/suites/select/use_subrequest_as_table.sqlx
new file mode 100644
index 0000000000..a5227e7e2e
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/select/use_subrequest_as_table.sqlx
@@ -0,0 +1,23 @@
+/* postgres can not */
+/* syntax version 1 */
+$script = @@
+def test(src):
+    l = []
+    for i in src:
+        l.append(str(i.test))
+        l.append(str(i.test2))
+    return str(l)
+@@;
+
+$test_table_1 =
+    (
+    SELECT 1 AS test, "a" AS test2
+    UNION ALL
+    SELECT 2 AS test, "b" AS test2
+    );
+
+$callable = Python::test(Callable<(List<Struct<test:Int32,test2:String?>>) -> String?>, $script);
+
+SELECT
+    $callable( $test_table_1 ) -- use as const subrequest should contain one column
+FROM $test_table_1;