[incubator-seatunnel] branch dev updated: update the condition to 1 = 0 about get table operation (#2186)

[ki...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

kirs pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/incubator-seatunnel.git


The following commit(s) were added to refs/heads/dev by this push:
     new 7c56d7143 update the condition to 1 = 0 about get table operation (#2186)
7c56d7143 is described below

commit 7c56d7143b8aff5a3296090655508710ba2f0b71
Author: Xiao Zhao <49...@users.noreply.github.com>
AuthorDate: Tue Jul 19 09:57:08 2022 +0800

    update the condition to 1 = 0 about get table operation (#2186)
---
 .../seatunnel/connectors/seatunnel/jdbc/catalog/MySqlCatalog.java       | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/catalog/MySqlCatalog.java b/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/catalog/MySqlCatalog.java
index 4f6e61ce5..c3aa84ae4 100644
--- a/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/catalog/MySqlCatalog.java
+++ b/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/catalog/MySqlCatalog.java
@@ -130,7 +130,7 @@ public class MySqlCatalog extends AbstractJdbcCatalog {
                 getPrimaryKey(metaData, tablePath.getDatabaseName(), tablePath.getTableName());
 
             PreparedStatement ps =
-                conn.prepareStatement(String.format("SELECT * FROM %s LIMIT 1;", tablePath.getFullName()));
+                conn.prepareStatement(String.format("SELECT * FROM %s WHERE 1 = 0;", tablePath.getFullName()));
 
             ResultSetMetaData tableMetaData = ps.getMetaData();