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

Library import 241120-1113

1 files changed, 29 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/join/yql-8125.sql b/yql/essentials/tests/sql/suites/join/yql-8125.sql
new file mode 100644
index 0000000000..b3d81a5509
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/join/yql-8125.sql
@@ -0,0 +1,29 @@
+use plato;
+
+PRAGMA yt.JoinCollectColumnarStatistics="async";
+
+INSERT INTO @yang_ids
+SELECT
+    *
+    from Input
+    where subkey <= "3"
+    LIMIT 100;
+commit;
+
+INSERT INTO @yang_ids
+    SELECT
+        *
+        from Input as j
+        LEFT ONLY JOIN @yang_ids
+        USING(key);
+commit;
+
+INSERT INTO @yang_ids
+    SELECT
+        *
+        from Input as j
+        LEFT ONLY JOIN @yang_ids
+        USING(key);
+commit;
+
+select * from @yang_ids;