Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 35 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/join/yql-14829_left.sql b/yql/essentials/tests/sql/suites/join/yql-14829_left.sql
new file mode 100644
index 0000000000..8e36a759e2
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/join/yql-14829_left.sql
@@ -0,0 +1,35 @@
+USE plato;
+
+pragma yt.JoinEnableStarJoin="true";
+
+insert into @x
+select Just('xxx') as id
+order by id;
+
+insert into @y
+select Just('yyy') as id
+order by id;
+
+insert into @a
+select Just('aaa') as id
+order by id;
+
+commit;
+
+
+$xy_left = (
+    SELECT 
+        x.id AS id 
+    FROM 
+        ANY @x AS x
+        LEFT JOIN ANY @y AS y
+        ON x.id == y.id
+);
+
+SELECT
+    *
+FROM 
+    ANY @a AS a
+    LEFT JOIN ANY $xy_left AS b
+    ON a.id == b.id;
+