yql/essentials/tests/sql/suites/select/null_check.sql


1
2
3
4
5
6
7

/* postgres can not */
/* by correct way ;-)
E   assert 'a;;a' == 'a;Void;b'
E     - a;;a
E     + a;Void;b
*/
SELECT 'a', x, 'b' FROM (SELECT Null as x) as sq WHERE x IS NULL;