You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Xurenhe (Jira)" <ji...@apache.org> on 2022/09/23 03:11:00 UTC

[jira] [Created] (CALCITE-5296) CASE statement within grouping-sets's item throws exception during sql_to_rel

Xurenhe created CALCITE-5296:
--------------------------------

             Summary: CASE statement within grouping-sets's item throws exception during sql_to_rel
                 Key: CALCITE-5296
                 URL: https://issues.apache.org/jira/browse/CALCITE-5296
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Xurenhe
            Assignee: Xurenhe


CALCITE throws exception during the stage of sql_to_rel, when executing *CASE* statement  after the statement of {*}ROLLUP{*}, and grouping's item exists in the *CASE* statement.

Test case:(org.apache.calcite.test.SqlToRelConverterTest#testCaseWhenGroupingSet)

 

 
{code:java}
// JAVA: org.apache.calcite.test.SqlToRelConverterTest#testCaseWhenGroupingSet

@Test void testCaseWhenGroupingSet() {
  final String sql = "select deptno, case when grouping(deptno) = 0 then deptno else 1 end\n"
      + "from emp\n"
      + "group by rollup(deptno, job)";
  sql(sql).ok();
}

// XML: org/apache/calcite/test/SqlToRelConverterTest.xml:456 
  <TestCase name="testCaseWhenGroupingSet">
    <Resource name="sql">
      <![CDATA[SELECT deptno, CASE WHEN grouping(deptno) = 0 THEN deptno ELSE 1 END
FROM emp
GROUP BY ROLLUP(deptno, job)]]>
    </Resource>
    <Resource name="plan">
      <![CDATA[
LogicalProject(DEPTNO=[$0], EXPR$1=[CASE(=($2, 0), $0, 1)])
  LogicalAggregate(group=[{0, 1}], groups=[[{0, 1}, {0}, {}]], agg#0=[GROUPING($0)])
    LogicalProject(DEPTNO=[$7], JOB=[$2])
      LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]>
    </Resource>
  </TestCase>{code}
 

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)