yql/essentials/tests/sql/suites/expr/dict_comp.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

/* postgres can not */
select AsTuple(
    AsDict(AsTuple(1,2u)) == AsDict(AsTuple(1,2)),
    AsDict(AsTuple(1,2u)) == AsDict(AsTuple(1,3)),
    AsDict(AsTuple(1,2u)) == AsDict(AsTuple(1,2), AsTuple(3,4)),
    AsDict(AsTuple(1,2u)) == AsDict(AsTuple(2,2)),
    AsDict(AsTuple(1u,2l)) == AsDict(AsTuple(1u,just(2u))),
    AsDict(AsTuple(1,2u)) == AsDict(AsTuple(1,2/0)),
);

select AsTuple(
    AsDict(AsTuple(1,2u)) != AsDict(AsTuple(1,2)),
    AsDict(AsTuple(1,2u)) != AsDict(AsTuple(1,3)),
    AsDict(AsTuple(1,2u)) != AsDict(AsTuple(1,2), AsTuple(3,4)),
    AsDict(AsTuple(1,2u)) != AsDict(AsTuple(2,2)),
    AsDict(AsTuple(1u,2l)) != AsDict(AsTuple(1u,just(2u))),
    AsDict(AsTuple(1,2u)) != AsDict(AsTuple(1,2/0)),
);