[CALCITE-3060] Materialized view: "target out of range" error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.21.0
• Labels: pull-request-available
• Assignee: Feng Zhu
• Reporter: Anton Haidai
• Created: 10/May/19 15:05
• Updated: 10/Sep/19 21:37
• Resolved: 29/Jun/19 20:57

Description

"MaterializationTest":

@Test public void testPermutationError() {
    CalciteAssert.that()
        .withMaterializations(
            HR_FKUK_MODEL,
            "m0",
            "select min(\"salary\"), count(*), max(\"salary\"), sum(\"salary\"), \"empid\" from \"emps\" group by \"empid\"",
            "m1",
            "select min(\"salary\"), count(*), max(\"salary\"), sum(\"salary\"), \"deptno\", \"empid\" from \"emps\" group by \"empid\", \"deptno\""
        )
        .query(
            "select count(*), \"empid\" from \"emps\" group by \"empid\"")
        .enableMaterializations(true)
        .explainContains("EnumerableTableScan(table=[[hr, m0]])")
        .sameResultWithMaterializationsDisabled();
  }

Error (looks like the mapping is expected to be bijection but it is not):

Caused by: java.lang.IllegalArgumentException: target out of range
	at org.apache.calcite.util.Permutation.<init>(Permutation.java:69)
	at org.apache.calcite.util.mapping.Mappings.bijection(Mappings.java:394)
	at org.apache.calcite.rel.mutable.MutableRels.createProject(MutableRels.java:142)
	at org.apache.calcite.plan.SubstitutionVisitor.unifyAggregates(SubstitutionVisitor.java:1269)
	at org.apache.calcite.plan.SubstitutionVisitor$AggregateOnProjectToAggregateUnifyRule.apply(SubstitutionVisitor.java:1345)
	at org.apache.calcite.plan.SubstitutionVisitor.go(SubstitutionVisitor.java:531)
	at org.apache.calcite.plan.SubstitutionVisitor.go(SubstitutionVisitor.java:466)	

Issue Links

• is related to: CALCITE-3052 Error while applying rule MaterializedViewAggregateRule(Project-Aggregate): ArrayIndexOutOfBoundsException
• links to: GitHub Pull Request #1268