Wenrui Meng created CALCITE-6007:
------------------------------------
Summary: Sqlwith as subquery without alias doesn't have correct
alias setup
Key: CALCITE-6007
URL: https://issues.apache.org/jira/browse/CALCITE-6007
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.35.0, 1.34.0
Reporter: Wenrui Meng
{code:java}
SELECT
a,
b
FROM (
WITH
sub AS (
SELECT
1 AS a,
2 AS b)
SELECT
*
FROM
sub)
WHERE
a IS NOT null
{code}
It will generate the following SQL statement after validation
{code:java}
SELECT
EXPR$0.a,
EXPR$0.b
FROM (
WITH
sub AS (
SELECT
1 AS a,
2 AS b)
SELECT
sub.a AS a, sub.b AS b
FROM
sub)
WHERE
EXPR$0.a IS NOT null
{code}
The validated SQL become invalid since there is no EXPR$0 alias append for the
SqlWith sub query but used in the expression outside.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
