Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

1 files changed, 35 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/join/yql-14829_leftonly.sql b/yql/essentials/tests/sql/suites/join/yql-14829_leftonly.sql
new file mode 100644
index 0000000000..50ef1bae40
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/join/yql-14829_leftonly.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_leftonly = (
+    SELECT 
+        x.id AS id 
+    FROM 
+        @x AS x
+        LEFT ONLY JOIN @y AS y
+        ON x.id == y.id
+);
+
+SELECT
+    *
+FROM 
+    @a AS a
+    LEFT ONLY JOIN $xy_leftonly AS b
+    ON a.id == b.id;
+