[jira] [Created] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[Caican Cai (Jira)]

Caican Cai created CALCITE-6440:
-----------------------------------

             Summary: Add optimization to returns empty when The Order By 
parameter in the Sort operator is empty
                 Key: CALCITE-6440
                 URL: https://issues.apache.org/jira/browse/CALCITE-6440
             Project: Calcite
          Issue Type: New Feature
          Components: core
    Affects Versions: 1.37.0
            Reporter: Caican Cai
             Fix For: 1.38.0


For the following SQL:
{code:java}
select * from task order by null; {code}
We could rewrite it to:
{code:java}
 select * from task;{code}



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