[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726870#comment-17726870 ]
Jiajun Xie commented on CALCITE-5723: ------------------------------------- Thank you for your explanation. The PR looks good and only one small question that needs to be answered. > 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)