ydb/yql/essentials/tests/sql/suites/expr/as_dict_dict_key.sql

/* postgres can not */
$d1 = AsDict(
    AsTuple(AsList(1,2,3),"foo"),
    AsTuple(AsList(1,2),"bar")
);


$d2 = AsDict(
    AsTuple(AsList(1,3),"baz"),
    AsTuple(AsList(1,2),"qwe")
);

$d3 = DictCreate(DictKeyType(TypeOf($d2)), DictPayloadType(TypeOf($d2)));

$d = AsDict(
    AsTuple($d1, 17),
    AsTuple($d2, 32)
);

select ListSort(ListFlatten(ListMap(DictItems($d), ($x) -> {return ListMap(DictItems($x.0), ($y) -> {return ($y, $x.1)})}))),
    ListSort(ListFlatten(ListMap(DictKeys($d), ($x) -> {return DictItems($x)}))),
    ListSort(DictPayloads($d));
select DictLookup($d,$d1), DictLookup($d,$d3);
select DictContains($d,$d1), DictContains($d,$d3);