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