[
https://issues.apache.org/jira/browse/CALCITE-1719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gian Merlino updated CALCITE-1719:
----------------------------------
Description:
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.
was:
Useful for subqueries like {{SELECT * FROM (...) LIMIT X}}, where the inner
query might have an order by or limit.
-Patch in https://github.com/apache/calcite/pull/410 x-
> 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)
