asdfgh19 created CALCITE-5594: --------------------------------- Summary: LatticeTest#testLatticeWithNoMeasures returns results not as expected Key: CALCITE-5594 URL: https://issues.apache.org/jira/browse/CALCITE-5594 Project: Calcite Issue Type: Test Components: core Affects Versions: 1.34.0 Reporter: asdfgh19
I changed the test testLatticeWithNoMeasures in LatticeTest to the following and ran, it returned 4. After that I changed enableMaterializations to false and re-run, the result returned 86837. Wondering why the results returned from the materialized view and from the original table are inconsistent. {code:java} @Test void testLatticeWithNoMeasures() { foodmartModel(" auto: false,\n" + " tiles: [ {\n" + " dimensions: [ 'the_year', ['t', 'quarter'] ],\n" + " measures: [ ]\n" + " } ]\n") .query("select count(*)\n" + "from \"foodmart\".\"sales_fact_1997\" as s\n" + "join \"foodmart\".\"time_by_day\" as t using (\"time_id\")\n") .enableMaterializations(true) .returns(rs -> { try { while (rs.next()) { System.out.println(rs.getObject(1)); } } catch (Exception e) { fail(e); } }); } {code} The explain looks like this, should the original count be replaced by sum(count) in the materialized view, like MaterializedViewRelOptRulesTest#testAggregateMaterializationAggregateFuncs2. {code:java} EnumerableAggregate(group=[{}], EXPR$0=[COUNT()]) EnumerableTableScan(table=[[adhoc, m{32, 36} {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)