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

Library import 241120-1113

1 files changed, 23 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/join/inmem_by_uncomparable_structs.sql b/yql/essentials/tests/sql/suites/join/inmem_by_uncomparable_structs.sql
new file mode 100644
index 0000000000..ec4ad06056
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/join/inmem_by_uncomparable_structs.sql
@@ -0,0 +1,23 @@
+/* syntax version 1 */
+$l = [
+    <|Key:<|a:1, b:2, c:null|>, Lhs:"1,2,#"|>,
+    <|Key:<|a:2, b:3, c:null|>, Lhs:"4,5,#"|>,
+];
+
+$r = [
+    <|Key:<|a:1, b:2, c:3|>, Rhs:"1,2,3"|>,
+    <|Key:<|a:4, b:5, c:6|>, Rhs:"4,5,6"|>,
+];
+
+select Lhs, Rhs from AS_TABLE($l) as l left join AS_TABLE($r) as r using(Key);
+select Lhs from AS_TABLE($l) as l left semi join AS_TABLE($r) as r using(Key);
+select Lhs from AS_TABLE($l) as l left only join AS_TABLE($r) as r using(Key);
+
+select Rhs, Lhs from AS_TABLE($l) as l right join AS_TABLE($r) as r using(Key);
+select Rhs from AS_TABLE($l) as l right semi join AS_TABLE($r) as r using(Key);
+select Rhs from AS_TABLE($l) as l right only join AS_TABLE($r) as r using(Key);
+
+select Lhs, Rhs from AS_TABLE($l) as l inner join AS_TABLE($r) as r using(Key);
+select Lhs, Rhs from AS_TABLE($l) as l full join AS_TABLE($r) as r using(Key);
+select Lhs, Rhs from AS_TABLE($l) as l exclusion join AS_TABLE($r) as r using(Key);
+