You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "TisNotT (Jira)" <ji...@apache.org> on 2019/10/30 13:32:00 UTC

[jira] [Created] (CALCITE-3461) SqlToRelConverter substituteSubQuery bug

TisNotT created CALCITE-3461:
--------------------------------

             Summary: SqlToRelConverter substituteSubQuery  bug
                 Key: CALCITE-3461
                 URL: https://issues.apache.org/jira/browse/CALCITE-3461
             Project: Calcite
          Issue Type: Bug
            Reporter: TisNotT


  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)