Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 16 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/join/convert_check_key_mem2.sql b/yql/essentials/tests/sql/suites/join/convert_check_key_mem2.sql
new file mode 100644
index 0000000000..d4afb00ee7
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/join/convert_check_key_mem2.sql
@@ -0,0 +1,16 @@
+/* postgres can not */
+PRAGMA DisableSimpleColumns;
+
+$a = AsList(
+    AsStruct(255ut AS K, 1 AS V),
+    AsStruct(127ut AS K, 2 AS V),
+    AsStruct(0ut   AS K, 3 AS V));
+
+$b = AsList(
+    AsStruct(Int8("-1")  AS K, 1 AS V),
+    AsStruct(Int8("127") AS K, 2 AS V),
+    AsStruct(Int8("0")   AS K, 3 AS V));
+
+select a.K, b.V from as_table($a) as a
+  join as_table($b) as b on a.K = b.K and a.V = b.V
+order by a.K, b.V;