[ https://issues.apache.org/jira/browse/CALCITE-4058?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17132978#comment-17132978 ]
Rui Wang commented on CALCITE-4058: ----------------------------------- I would guess people will have lots of opinions on this idea :) > Add Limit and LogicalLimit operator and deprecate limit in Sort > --------------------------------------------------------------- > > Key: CALCITE-4058 > URL: https://issues.apache.org/jira/browse/CALCITE-4058 > Project: Calcite > Issue Type: New Feature > Components: core > Reporter: Haisheng Yuan > Priority: Major > > Add {{Limit}} base class and {{LogicalLimit}} operator. > Fetch and offset should not be in Sort operator, we should deprecate the > fields while keeping the Sort work for compatibility. > {code:java} > select * from foo limit 5 offset 3; > select * from foo order by a; > {code} > The above 2 queries are totally different query, but have the same operators, > SortxxxTranspose sometimes means limit push down, which is counter-intuitive. -- This message was sent by Atlassian Jira (v8.3.4#803005)