yql/essentials/tests/sql/suites/pg/distinct_from_pg_null.yql


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

select
    Nothing(pgint8) IS DISTINCT FROM NULL,
    Nothing(pgint8) IS NOT DISTINCT FROM NULL,
    NULL IS DISTINCT FROM Nothing(pgint8),
    NULL IS NOT DISTINCT FROM Nothing(pgint8),
    Opaque(Nothing(pgint8)) IS DISTINCT FROM NULL,
    Opaque(Nothing(pgint8)) IS NOT DISTINCT FROM NULL,
    NULL IS DISTINCT FROM Opaque(Nothing(pgint8)),
    NULL IS NOT DISTINCT FROM Opaque(Nothing(pgint8))
;

select
    1p IS DISTINCT FROM NULL,
    1p IS NOT DISTINCT FROM NULL,
    NULL IS DISTINCT FROM 1p,
    NULL IS NOT DISTINCT FROM 1p,
    Opaque(1p) IS DISTINCT FROM NULL,
    Opaque(1p) IS NOT DISTINCT FROM NULL,
    NULL IS DISTINCT FROM Opaque(1p),
    NULL IS NOT DISTINCT FROM Opaque(1p)
;