Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
case_expr
/
cs_expr_cte2.q
blob: 4ffdf015fd0eb9864e0e807db7ba8f9b7b83b790 [
file
] [
log
] [
blame
]
with
data
(
v
)
as
(
(
SELECT
(
CASE WHEN
true
THEN
1
ELSE
0
end
)
FROM
(
VALUES
(
1
))
sub_query
)
union
all
(
SELECT
(
CASE WHEN
true
THEN
0
ELSE
1
end
)
FROM
(
VALUES
(
1
))
sub_query
)
)
SELECT
*
FROM data
;