You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "Jing Ge (Jira)" <ji...@apache.org> on 2022/08/16 21:35:00 UTC

[jira] [Created] (FLINK-29003) sqlServerDialect should support limit clause

Jing Ge created FLINK-29003:
-------------------------------

             Summary: sqlServerDialect should support limit clause
                 Key: FLINK-29003
                 URL: https://issues.apache.org/jira/browse/FLINK-29003
             Project: Flink
          Issue Type: New Feature
          Components: Connectors / JDBC
    Affects Versions: 1.16.0
            Reporter: Jing Ge
             Fix For: 1.17.0


SQL Server does not support limit natively, it supports by OFFSET syntax and requires ORDER BY to be valid, with the current structure.

This should not be only related to dialect, but also need to change or introduce a new {{pushdownXXX}} in the relevant pushdown mechanism.

Please see [https://github.com/apache/flink/pull/20235/files#r917362437] for details.



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