[jira] [Comment Edited] (CALCITE-5723) Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch

["Jiajun Xie (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726789#comment-17726789 ] 

Jiajun Xie edited comment on CALCITE-5723 at 5/27/23 10:01 AM:
---------------------------------------------------------------

Does oracle(<12) support other similar syntax?

e.g.
{code:java}
limit ... offset ...{code}


was (Author: jiajunbernoulli):
Does oracle(<12) support other similar syntax?

> Oracle dialect generates SQL that cannot be recognized by lower version Oracle Server(<12) when unparsing OffsetFetch
> ---------------------------------------------------------------------------------------------------------------------
>
>                 Key: CALCITE-5723
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5723
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.34.0
>            Reporter: ZheHu
>            Assignee: ZheHu
>            Priority: Minor
>              Labels: pull-request-available
>             Fix For: 1.35.0
>
>
> Current OracleSqlDialect unparses offset/fetch using ANSI standard "OFFSET offset ROWS FETCH NEXT  fetch ROWS ONLY" syntax. However, Oracle supports such syntax since 12c.



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