Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
values
/
values_str_21.q
blob: 985aa06257ba9604c975bb605e3c12b71613fc6d [
file
] [
log
] [
blame
]
SELECT id FROM
(
VALUES
(
''
),(
'asdfkjhasdjkhgavdjhkgdvkjhg'
),(
'aaaaa'
),(
''
),(
'zzzzzzz'
),(
'a'
),(
'z'
),(
'non-null-value'
))
tbl
(
id
)
WHERE NULLIF
(
id
,
''
)
IS NULL
;