[ https://issues.apache.org/jira/browse/CALCITE-1984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16165581#comment-16165581 ]
fei.chen edited comment on CALCITE-1984 at 9/14/17 1:15 AM: ------------------------------------------------------------ Julian Hyde , Jesus Camacho Rodriguez thanks a lot. was (Author: chenfe...@163.com): Julian Hyde , Jesus Camacho Rodriguez thinks a lot. > Incorrect rewriting with materialized views using DISTINCT in aggregate > functions > --------------------------------------------------------------------------------- > > Key: CALCITE-1984 > URL: https://issues.apache.org/jira/browse/CALCITE-1984 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.13.0 > Reporter: fei.chen > Assignee: Jesus Camacho Rodriguez > Fix For: 1.15.0 > > > I had written a test as follows . It runs to succeed . But , the result seems > not right . The “count distinct” aggregation should not be changed to “count”. > {code:java} > @Test public void testAggregateMaterializationOnCountDistinctQuery1() { > checkMaterialize( > "select \"deptno\", \"empid\" ,\"salary\"\n" > + "from \"emps\" group by \"deptno\", \"empid\",\"salary\"", > "select \"deptno\", count( distinct \"empid\")" + "from (select > \"deptno\", \"empid\" \n" > + "from \"emps\" group by \"deptno\", \"empid\") group by > \"deptno\"", > HR_FKUK_MODEL, > CalciteAssert.checkResultContains( > "EnumerableAggregate(group=[{0}], S=[COUNT($1)])\n" + > " EnumerableTableScan(table=[[hr, m0]]")); > } > {code} > -- This message was sent by Atlassian JIRA (v6.4.14#64029)