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


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

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

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