[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Caican Cai updated CALCITE-6440: -------------------------------- Summary: Add optimization to remove sortkey when The Order By parameter in the Sort operator is null (was: Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty) > Add optimization to remove sortkey when The Order By parameter in the Sort > operator is null > ------------------------------------------------------------------------------------------- > > 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 > Priority: Major > Labels: pull-request-available > 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)