[ 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)