yanjing.wang created CALCITE-4512:
-------------------------------------
Summary: 'case when' project alias equals 'when condition column
name or then column name' causes validation error
Key: CALCITE-4512
URL: https://issues.apache.org/jira/browse/CALCITE-4512
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.26.0
Reporter: yanjing.wang
Fix For: 1.27.0
String sql = "select case when ds > 20200103 then ds else id end as ds,
count(distinct id) from depts group by case when ds > 20200103 then ds else id
end";
'case when ds > 20200103 then ds else id end as ds' has alias ds, and 'when ds
> 20200103' has column ds or ' then ds ' has ds, validation raises exception.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
