[ 
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)

Reply via email to