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


1
2
3
4
5
6
7
8
9
10
11
12
13

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

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