[
https://issues.apache.org/jira/browse/CALCITE-5086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17545238#comment-17545238
]
yanjing.wang edited comment on CALCITE-5086 at 6/2/22 2:22 AM:
---------------------------------------------------------------
I see, I noticed that
{code:java}
[ LIMIT [ start, ] { count | ALL } ] {code}
the rule seems not to be correct, should it be this?
{code:java}
[ LIMIT { [ start, ] count | ALL } ] {code}
was (Author: yanjing.wang):
I see, I noticed that
{code:java}
[ LIMIT [ start, ] { count | ALL } ] {code}
> Core parser should allow "OFFSET" to occur before "LIMIT"
> ---------------------------------------------------------
>
> Key: CALCITE-5086
> URL: https://issues.apache.org/jira/browse/CALCITE-5086
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.30.0
> Environment: jdk8
> Reporter: yanjing.wang
> Assignee: yanjing.wang
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.31.0
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> The core parser supports 'LIMIT count OFFSET start' now, otherwise trino
> supports 'OFFSET start LIMIT count', we can make an improvement to support
> both.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
