[
https://issues.apache.org/jira/browse/CALCITE-3461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16963799#comment-16963799
]
Stamatis Zampetakis commented on CALCITE-3461:
----------------------------------------------
If this ticket is a duplicate we should close it and continue discussing under
CALCITE-3456. In that case, the PR should also be updated to refer to 3456.
> SqlToRelConverter substituteSubQuery problem
> --------------------------------------------
>
> Key: CALCITE-3461
> URL: https://issues.apache.org/jira/browse/CALCITE-3461
> Project: Calcite
> Issue Type: Bug
> Reporter: TisNotT
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1h
> 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)
