[
https://issues.apache.org/jira/browse/CALCITE-7593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yu Xu updated CALCITE-7593:
---------------------------
Description:
SQL：
{code:java}
select * from
(select * from emp order by deptno, ename)
order by ename, deptno{code}
should optimize to:
{code:java}
select * from emp order by ename, deptno{code}
but current plan is :
{code:java}
<![CDATA[
LogicalSort(sort0=[$1], sort1=[$7], dir0=[ASC], dir1=[ASC])
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4],
SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])
]]> {code}
> Can not eliminate redundant nested sorts
> ----------------------------------------
>
> Key: CALCITE-7593
> URL: https://issues.apache.org/jira/browse/CALCITE-7593
> Project: Calcite
> Issue Type: Improvement
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Minor
>
> SQL：
> {code:java}
> select * from
> (select * from emp order by deptno, ename)
> order by ename, deptno{code}
> should optimize to:
> {code:java}
> select * from emp order by ename, deptno{code}
> but current plan is :
> {code:java}
> <![CDATA[
> LogicalSort(sort0=[$1], sort1=[$7], dir0=[ASC], dir1=[ASC])
> LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4],
> SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
> LogicalTableScan(table=[[CATALOG, SALES, EMP]])
> ]]> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
