(shardingsphere) branch master updated: Fix load table type from MySQL (#29964)

[jianglongtao]

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

jianglongtao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new 5cd1f0d8fa0 Fix load table type from MySQL (#29964)
5cd1f0d8fa0 is described below

commit 5cd1f0d8fa07c9ac3ed519d20d1380981e830cc4
Author: ChenJiaHao <chenjia...@apache.org>
AuthorDate: Fri Feb 2 15:42:18 2024 +0800

    Fix load table type from MySQL (#29964)
---
 .../infra/database/mysql/metadata/data/loader/MySQLMetaDataLoader.java  | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git 
a/infra/database/type/mysql/src/main/java/org/apache/shardingsphere/infra/database/mysql/metadata/data/loader/MySQLMetaDataLoader.java
 
b/infra/database/type/mysql/src/main/java/org/apache/shardingsphere/infra/database/mysql/metadata/data/loader/MySQLMetaDataLoader.java
index 3f9e0cff2f4..01922cf240e 100644
--- 
a/infra/database/type/mysql/src/main/java/org/apache/shardingsphere/infra/database/mysql/metadata/data/loader/MySQLMetaDataLoader.java
+++ 
b/infra/database/type/mysql/src/main/java/org/apache/shardingsphere/infra/database/mysql/metadata/data/loader/MySQLMetaDataLoader.java
@@ -63,7 +63,7 @@ public final class MySQLMetaDataLoader implements 
DialectMetaDataLoader {
     private static final String CONSTRAINT_META_DATA_SQL = "SELECT 
CONSTRAINT_NAME, TABLE_NAME, REFERENCED_TABLE_NAME FROM 
information_schema.KEY_COLUMN_USAGE "
             + "WHERE TABLE_NAME IN (%s) AND REFERENCED_TABLE_SCHEMA IS NOT 
NULL";
     
-    private static final String VIEW_META_DATA_SQL = "SELECT TABLE_NAME FROM 
information_schema.VIEWS WHERE TABLE_SCHEMA=? AND TABLE_SCHEMA IN (%s)";
+    private static final String VIEW_META_DATA_SQL = "SELECT TABLE_NAME FROM 
information_schema.VIEWS WHERE TABLE_SCHEMA=? AND TABLE_NAME IN (%s)";
     
     @Override
     public Collection<SchemaMetaData> load(final MetaDataLoaderMaterial 
material) throws SQLException {