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)