[
https://issues.apache.org/jira/browse/CALCITE-6878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17933630#comment-17933630
]
Ruben Q L commented on CALCITE-6878:
------------------------------------
We need to be careful with sort.fetch and sort.offset values. Are we sure this
rule wouldn't change the semantics of the query if fetch/offset are present in
the Sort operator?
> Implement FilterSortTransposeRule
> ---------------------------------
>
> Key: CALCITE-6878
> URL: https://issues.apache.org/jira/browse/CALCITE-6878
> Project: Calcite
> Issue Type: New Feature
> Reporter: Zhen Chen
> Assignee: Zhen Chen
> Priority: Major
> Labels: pull-request-available
>
> Do we need this rule?
> from:
> {code:java}
> LogicalFilter(condition=[<($0, 10)])
> LogicalSort(sort0=[$0], dir0=[ASC])
> LogicalProject(EMPNO=[$0])
> LogicalTableScan(table=[[scott, EMP]]) {code}
> to:
> {code:java}
> LogicalSort(sort0=[$0], dir0=[ASC])
> LogicalFilter(condition=[<($0, 10)])
> LogicalProject(EMPNO=[$0])
> LogicalTableScan(table=[[scott, EMP]]) {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
