You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Anton Haidai (JIRA)" <ji...@apache.org> on 2019/05/17 15:59:00 UTC

[jira] [Updated] (CALCITE-3076) Error when AggregateJoinTransposeRule is used on empty LogicalValues

     [ https://issues.apache.org/jira/browse/CALCITE-3076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anton Haidai updated CALCITE-3076:
----------------------------------
    Description: 
RelOptRulesTest:
{code}
  @Test public void testPushAggregateThroughJoinOnEmptyLogicalValuesError() {
    final HepProgram preProgram = new HepProgramBuilder()
        .addRuleInstance(AggregateProjectMergeRule.INSTANCE)
        .addRuleInstance(ReduceExpressionsRule.FilterReduceExpressionsRule.FILTER_INSTANCE)
        .build();

    final HepProgram program = new HepProgramBuilder()
        .addRuleInstance(AggregateJoinTransposeRule.EXTENDED)
        .build();

    final String sql =
        "select count(*) volume, sum(C1.sal) C1_sum_sal " +
        "from (select sal, ename from sales.emp where 1=2) C1 " +
        "inner join (select ename from sales.emp) C2   " +
        "on C1.ename = C2.ename ";
    sql(sql).withPre(preProgram).with(program).check();
  }
{code}

Error:
{code}
java.lang.IllegalArgumentException: Cannot infer return type for *; operand types: [VARCHAR(20), BIGINT]

	at org.apache.calcite.sql.SqlOperator.inferReturnType(SqlOperator.java:474)
	at org.apache.calcite.rex.RexBuilder.deriveReturnType(RexBuilder.java:276)
	at org.apache.calcite.rex.RexBuilder.makeCall(RexBuilder.java:250)
	at org.apache.calcite.sql.SqlSplittableAggFunction$AbstractSumSplitter.topSplit(SqlSplittableAggFunction.java:298)
	at org.apache.calcite.rel.rules.AggregateJoinTransposeRule.onMatch(AggregateJoinTransposeRule.java:342)
	at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:319)
	at org.apache.calcite.plan.hep.HepPlanner.applyRule(HepPlanner.java:559)
	at org.apache.calcite.plan.hep.HepPlanner.applyRules(HepPlanner.java:418)
	at org.apache.calcite.plan.hep.HepPlanner.executeInstruction(HepPlanner.java:255)
	at org.apache.calcite.plan.hep.HepInstruction$RuleInstance.execute(HepInstruction.java:127)
{code}

  was:
RelOptRulesTest:
{code}
  @Test public void testPushAggregateThroughJoinOnEmptyLogicalValuesError() {
    final HepProgram preProgram = new HepProgramBuilder()
        .addRuleInstance(AggregateProjectMergeRule.INSTANCE)
        .addRuleInstance(ReduceExpressionsRule.FilterReduceExpressionsRule.FILTER_INSTANCE)
        .build();

    final HepProgram program = new HepProgramBuilder()
        .addRuleInstance(AggregateJoinTransposeRule.EXTENDED)
        .build();

    final String sql =
        "select count(*) volume, sum(C1.sal) C1_max_sal " +
        "from (select sal, ename from sales.emp where 1=2) C1 " +
        "inner join (select ename from sales.emp) C2   " +
        "on C1.ename = C2.ename ";
    sql(sql).withPre(preProgram).with(program).check();
  }
{code}

Error:
{code}
java.lang.IllegalArgumentException: Cannot infer return type for *; operand types: [VARCHAR(20), BIGINT]

	at org.apache.calcite.sql.SqlOperator.inferReturnType(SqlOperator.java:474)
	at org.apache.calcite.rex.RexBuilder.deriveReturnType(RexBuilder.java:276)
	at org.apache.calcite.rex.RexBuilder.makeCall(RexBuilder.java:250)
	at org.apache.calcite.sql.SqlSplittableAggFunction$AbstractSumSplitter.topSplit(SqlSplittableAggFunction.java:298)
	at org.apache.calcite.rel.rules.AggregateJoinTransposeRule.onMatch(AggregateJoinTransposeRule.java:342)
	at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:319)
	at org.apache.calcite.plan.hep.HepPlanner.applyRule(HepPlanner.java:559)
	at org.apache.calcite.plan.hep.HepPlanner.applyRules(HepPlanner.java:418)
	at org.apache.calcite.plan.hep.HepPlanner.executeInstruction(HepPlanner.java:255)
	at org.apache.calcite.plan.hep.HepInstruction$RuleInstance.execute(HepInstruction.java:127)
{code}


> Error when AggregateJoinTransposeRule is used on empty LogicalValues
> --------------------------------------------------------------------
>
>                 Key: CALCITE-3076
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3076
>             Project: Calcite
>          Issue Type: Bug
>    Affects Versions: 1.19.0
>            Reporter: Anton Haidai
>            Priority: Major
>
> RelOptRulesTest:
> {code}
>   @Test public void testPushAggregateThroughJoinOnEmptyLogicalValuesError() {
>     final HepProgram preProgram = new HepProgramBuilder()
>         .addRuleInstance(AggregateProjectMergeRule.INSTANCE)
>         .addRuleInstance(ReduceExpressionsRule.FilterReduceExpressionsRule.FILTER_INSTANCE)
>         .build();
>     final HepProgram program = new HepProgramBuilder()
>         .addRuleInstance(AggregateJoinTransposeRule.EXTENDED)
>         .build();
>     final String sql =
>         "select count(*) volume, sum(C1.sal) C1_sum_sal " +
>         "from (select sal, ename from sales.emp where 1=2) C1 " +
>         "inner join (select ename from sales.emp) C2   " +
>         "on C1.ename = C2.ename ";
>     sql(sql).withPre(preProgram).with(program).check();
>   }
> {code}
> Error:
> {code}
> java.lang.IllegalArgumentException: Cannot infer return type for *; operand types: [VARCHAR(20), BIGINT]
> 	at org.apache.calcite.sql.SqlOperator.inferReturnType(SqlOperator.java:474)
> 	at org.apache.calcite.rex.RexBuilder.deriveReturnType(RexBuilder.java:276)
> 	at org.apache.calcite.rex.RexBuilder.makeCall(RexBuilder.java:250)
> 	at org.apache.calcite.sql.SqlSplittableAggFunction$AbstractSumSplitter.topSplit(SqlSplittableAggFunction.java:298)
> 	at org.apache.calcite.rel.rules.AggregateJoinTransposeRule.onMatch(AggregateJoinTransposeRule.java:342)
> 	at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:319)
> 	at org.apache.calcite.plan.hep.HepPlanner.applyRule(HepPlanner.java:559)
> 	at org.apache.calcite.plan.hep.HepPlanner.applyRules(HepPlanner.java:418)
> 	at org.apache.calcite.plan.hep.HepPlanner.executeInstruction(HepPlanner.java:255)
> 	at org.apache.calcite.plan.hep.HepInstruction$RuleInstance.execute(HepInstruction.java:127)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)