Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 13 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/action/pass_subquery_as_param.sql b/yql/essentials/tests/sql/suites/action/pass_subquery_as_param.sql
new file mode 100644
index 0000000000..23e1af9551
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/action/pass_subquery_as_param.sql
@@ -0,0 +1,13 @@
+/* syntax version 1 */
+/* postgres can not */
+define subquery $dup($x) as
+   select * from $x(1)
+   union all
+   select * from $x(2);
+end define;
+
+define subquery $sub($n) as
+   select $n * 10;
+end define;
+           
+select * from $dup($sub);