[ https://issues.apache.org/jira/browse/CALCITE-1544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde resolved CALCITE-1544. ---------------------------------- Resolution: Cannot Reproduce Cannot reproduce. I tried {code} @Test public void testAggJoin() { final String sql = "select e.deptno\n" + "from emp as e join dept as d on e.deptno = d.deptno\n" + "group by e.deptno\n"; withEmpDept(sql).runs(); } {code} > AggregateJoinTransposeRule transform failed > ------------------------------------------- > > Key: CALCITE-1544 > URL: https://issues.apache.org/jira/browse/CALCITE-1544 > Project: Calcite > Issue Type: Bug > Reporter: Kurt Young > Assignee: Julian Hyde > > Here is the sql to reproduce the failure: > {code} > select e.deptno > from sales.emp as e join sales.dept as d on e.deptno = d.deptno > group by e.deptno > {code} > After push the aggregator past join, the RowType seems been changed. -- This message was sent by Atlassian JIRA (v6.3.4#6332)