You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "ZheHu (Jira)" <ji...@apache.org> on 2023/05/25 08:22:00 UTC

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

ZheHu created CALCITE-5723:
------------------------------

             Summary: Oracle dialect generates SQL that cannot be recoginized 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


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)