[
https://issues.apache.org/jira/browse/CALCITE-1719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15982376#comment-15982376
]
Gian Merlino commented on CALCITE-1719:
---------------------------------------
I just re-titled and updated the description -- hope it's accurate now.
> Collapse nested limits
> ----------------------
>
> Key: CALCITE-1719
> URL: https://issues.apache.org/jira/browse/CALCITE-1719
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Gian Merlino
> Assignee: Julian Hyde
>
> Useful for subqueries like {{SELECT * FROM (...) LIMIT X}}, where the inner
> query might have an order by or limit.
> Originally proposed to be fixed by an optimizer rule, but for reasons later
> on in the jira, it seems it's better to do this in SqlToRelConverter instead.
> Original patch was in https://github.com/apache/calcite/pull/410, now closed.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)