You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "weihua zhang (Jira)" <ji...@apache.org> on 2025/07/22 12:10:00 UTC

[jira] [Created] (CALCITE-7104) remove duplicate same sort keys

weihua zhang created CALCITE-7104:
-------------------------------------

             Summary: remove duplicate same sort keys
                 Key: CALCITE-7104
                 URL: https://issues.apache.org/jira/browse/CALCITE-7104
             Project: Calcite
          Issue Type: Improvement
            Reporter: weihua zhang



{code:sql}
select d1, d2 from  (select deptno as d1, deptno as d2 from dept ) as tmp order by d1, d2;
{code}


{noformat}
LogicalSort(sort0=[$0], sort1=[$1], dir0=[ASC], dir1=[ASC]), id = 2245
  LogicalProject(D1=[$0], D2=[$0]), id = 2244
    LogicalTableScan(table=[[default, dept]]), id = 2240
{noformat}

LogicalSort can change to:
{noformat}
LogicalSort(sort0=[$0], dir0=[ASC]), id = 2245
  LogicalProject(D1=[$0], D2=[$0]), id = 2244
    LogicalTableScan(table=[[default, dept]]), id = 2240
{noformat}




--
This message was sent by Atlassian Jira
(v8.20.10#820010)