Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 28 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/join/lookupjoin_bug7646_subst.sql b/yql/essentials/tests/sql/suites/join/lookupjoin_bug7646_subst.sql
new file mode 100644
index 0000000000..e91ef8f7c2
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/join/lookupjoin_bug7646_subst.sql
@@ -0,0 +1,28 @@
+USE plato;
+PRAGMA DisableSimpleColumns;
+PRAGMA yt.LookupJoinLimit="64k";
+PRAGMA yt.LookupJoinMaxRows="100";
+
+$campaigns_data = AsList(
+    AsStruct(Just(1) as id),
+    AsStruct(Just(2) as id));
+    
+$strategies_data = AsList(
+    AsStruct(Just(1) as id),
+    AsStruct(Just(2) as id));
+    
+$lottery_data = AsList(
+    AsStruct(Just(1) as id, Just(2) as campaign_id, Just(3) as strategy_id));
+
+
+INSERT INTO @campaigns SELECT * FROM AS_TABLE($campaigns_data) ORDER BY id;
+INSERT INTO @strategies SELECT * FROM AS_TABLE($strategies_data) ORDER BY id;
+INSERT INTO @lottery SELECT * FROM AS_TABLE($lottery_data) ORDER BY id;
+
+COMMIT;
+
+SELECT
+    lottery.id AS lottery_id
+FROM @lottery AS lottery
+    JOIN @campaigns AS campaigns ON lottery.campaign_id = campaigns.id
+    JOIN @strategies AS strategies ON lottery.strategy_id = strategies.id