YQL-19206 Move contrib/ydb/library/yql/tests/sql/suites -> yql/essentials/tests/sql/suites

commit_hash:d0ef1f92b09c94db7c2408f946d2a4c62b603f00

1 files changed, 23 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/join/mapjoin_opt_vs_2xopt.sql b/yql/essentials/tests/sql/suites/join/mapjoin_opt_vs_2xopt.sql
new file mode 100644
index 0000000000..73171384f0
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/join/mapjoin_opt_vs_2xopt.sql
@@ -0,0 +1,23 @@
+use plato;
+
+pragma yt.MapJoinLimit="1m";
+
+$t1 = AsList(
+    AsStruct(Just(1) AS Key),
+    AsStruct(Just(2) AS Key),
+    AsStruct(Just(3) AS Key));
+
+$t2 = AsList(
+    AsStruct(Just(Just(2)) AS Key),
+    AsStruct(Just(Just(3)) AS Key),
+    AsStruct(Just(Just(4)) AS Key),
+    AsStruct(Just(Just(5)) AS Key),
+    AsStruct(Just(Just(6)) AS Key));
+
+insert into @t1 select * from as_table($t1);
+insert into @t2 select * from as_table($t2);
+
+commit;
+
+select *
+from @t1 as a join @t2 as b using(Key);