yql/essentials/tests/sql/suites/join/convert_check_key_mem2.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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;