[ https://issues.apache.org/jira/browse/CALCITE-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728527#comment-17728527 ]
Jiajun Xie commented on CALCITE-5723: ------------------------------------- Fixed in [d98f96d|https://github.com/apache/calcite/commit/d98f96d830e2114aff4166476ebedf6bd82a4c4e] [~VAE] Thanks for the pr. > 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)