[
https://issues.apache.org/jira/browse/CALCITE-3461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Danny Chen closed CALCITE-3461.
-------------------------------
Assignee: Danny Chen
Resolution: Fixed
Closed because duplication of CALCITE-3456 which has been resolved.
> SqlToRelConverter substituteSubQuery problem
> --------------------------------------------
>
> Key: CALCITE-3461
> URL: https://issues.apache.org/jira/browse/CALCITE-3461
> Project: Calcite
> Issue Type: Bug
> Reporter: TisNotT
> Assignee: Danny Chen
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1.5h
> Remaining Estimate: 0h
>
> final String sql = "select \n" + " case \n"
> + " when deptno in (1) then '1'\n"
> + "when deptno in (220) then '220' \n"
> + "else null end as deptno,\n"
> + "name,\n"
> + "count(distinct name)as num\n"
> + "from dept\n" + "\n"
> + "where \n"
> + "deptno in(1)\n"
> + " group by name,deptno ";
> Sql like that ,SqlToRelConverter cannot convert from sql to node.
> Bzc,substituteSubQuery handle wrong.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
