[jira] [Commented] (CALCITE-3461) SqlToRelConverter substituteSubQuery problem

["Julian Hyde (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-3461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16966976#comment-16966976 ] 

Julian Hyde commented on CALCITE-3461:
--------------------------------------

[~Sharpshow], FYI a PR with a 'close #nnn' comment only gets closed when the commit is merged into Apache's master branch. Which is the behavior we want. I believe you can manually close your own PRs.

> 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 10m
>  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)