[jira] [Created] (CALCITE-7761) Preserve OFFSET and FETCH when rewriting outer ORDER BY

[Kirill Tkalenko (Jira)]

Kirill Tkalenko created CALCITE-7761:
----------------------------------------

             Summary: Preserve OFFSET and FETCH when rewriting outer ORDER BY
                 Key: CALCITE-7761
                 URL: https://issues.apache.org/jira/browse/CALCITE-7761
             Project: Calcite
          Issue Type: Improvement
            Reporter: Kirill Tkalenko
            Assignee: Kirill Tkalenko


{{SqlValidatorImpl.performUnconditionalRewrites}} may overwrite {{OFFSET}} or 
{{FETCH}} previously added to an inner {{SELECT}} during query rewriting. Merge 
the outer {{SqlOrderBy}} only when the inner {{SELECT}} has no {{{}ORDER 
BY{}}}, {{{}OFFSET{}}}, or {{{}FETCH{}}}.



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