[
https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yanjing.wang updated CALCITE-4512:
----------------------------------
Environment: jvm: open-jdk8
> '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
> Environment: jvm: open-jdk8
> Reporter: yanjing.wang
> Priority: Major
> 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)
