0.2sec org.apache.calcite.test.MaterializedViewRelOptRulesTest > testJoinAggregateMaterializationAggregateFuncs11() java.lang.AssertionError: Materialized view failed to be matched by optimized results: EnumerableCalc(expr#0..1=[{inputs}], expr#2=[1], expr#3=[+($t1, $t2)], empid=[$t0], EXPR$1=[$t3]) EnumerableAggregate(group=[{2}], agg#0=[COUNT()]) EnumerableHashJoin(condition=[=($0, $1)], joinType=[inner]) EnumerableCalc(expr#0..4=[{inputs}], deptno=[$t1]) EnumerableTableScan(table=[[hr, emps]]) EnumerableCalc(expr#0..3=[{inputs}], deptno=[$t1], empid=[$t2]) EnumerableHashJoin(condition=[=($0, $3)], joinType=[inner]) EnumerableCalc(expr#0..1=[{inputs}], expr#2=[CAST($t1):VARCHAR], name0=[$t2]) EnumerableTableScan(table=[[hr, locations]]) EnumerableCalc(expr#0..4=[{inputs}], expr#5=[CAST($t3):VARCHAR], deptno=[$t0], empid=[$t2], name10=[$t5]) EnumerableHashJoin(condition=[=($1, $4)], joinType=[inner]) EnumerableCalc(expr#0..3=[{inputs}], expr#4=[CAST($t1):VARCHAR], expr#5=[Sarg[(10..20)]], expr#6=[SEARCH($t0, $t5)], deptno=[$t0], name0=[$t4], $condition=[$t6]) EnumerableTableScan(table=[[hr, depts]]) EnumerableCalc(expr#0..1=[{inputs}], expr#2=[CAST($t1):VARCHAR], proj#0..2=[{exprs}]) EnumerableTableScan(table=[[hr, dependents]]) at org.apache.calcite.test.MaterializedViewTester.checkMaterialize(MaterializedViewTester.java:82) at org.apache.calcite.test.MaterializedViewFixture.ok(MaterializedViewFixture.java:56) at org.apache.calcite.test.MaterializedViewRelOptRulesTest.testJoinAggregateMaterializationAggregateFuncs11(MaterializedViewRelOptRulesTest.java:716)