[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861008#comment-17861008 ]
Caican Cai commented on CALCITE-6440: ------------------------------------- I have submitted a PR, but I think it would be better if it could be done in SortRemoveConstantKeysRule > SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER > BY 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)