[
https://issues.apache.org/jira/browse/CALCITE-3461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16963294#comment-16963294
]
Julian Hyde commented on CALCITE-3461:
--------------------------------------
FYI You don't need to open a new PR; just add a new commit to the branch of
your original PR. (New commits are best; don't squash or rebase unless the
reviewer asks you to.)
> SqlToRelConverter substituteSubQuery bug
> -----------------------------------------
>
> 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: 0.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)
