(shardingsphere) branch master updated: Support postgresql and opengauss CHARACTER VARYING type metadata load (#34221)

[zhaojinchao]

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

zhaojinchao 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 680c0db5af1 Support postgresql and opengauss CHARACTER VARYING type 
metadata load (#34221)
680c0db5af1 is described below

commit 680c0db5af1b0faaa10d6402dda916daf41c4e20
Author: Zhengqiang Duan <duanzhengqi...@apache.org>
AuthorDate: Thu Jan 2 10:45:56 2025 +0800

    Support postgresql and opengauss CHARACTER VARYING type metadata load 
(#34221)
    
    * Support postgresql and opengauss CHARACTER VARYING type metadata load
    
    * update release note
---
 RELEASE-NOTES.md                                                         | 1 +
 .../database/opengauss/metadata/database/OpenGaussDatabaseMetaData.java  | 1 +
 .../postgresql/metadata/database/PostgreSQLDatabaseMetaData.java         | 1 +
 3 files changed, 3 insertions(+)

diff --git a/RELEASE-NOTES.md b/RELEASE-NOTES.md
index 0df46139d40..8ecc54deff5 100644
--- a/RELEASE-NOTES.md
+++ b/RELEASE-NOTES.md
@@ -141,6 +141,7 @@
 1. Pipeline: Use case-insensitive identifiers to enhance the table metadata 
loader
 1. Pipeline: Support primary key columns ordering for standard pipeline table 
metadata loader
 1. Sharding: Optimize sharding table index name rewriting rules and remove 
unnecessary suffix rewriting - 
[#31171](https://github.com/apache/shardingsphere/issues/31171)
+1. Metadata: Support postgresql and opengauss CHARACTER VARYING type metadata 
load - [#34221](https://github.com/apache/shardingsphere/pull/34221)
 
 ### Bug Fixes
 
diff --git 
a/infra/database/type/opengauss/src/main/java/org/apache/shardingsphere/infra/database/opengauss/metadata/database/OpenGaussDatabaseMetaData.java
 
b/infra/database/type/opengauss/src/main/java/org/apache/shardingsphere/infra/database/opengauss/metadata/database/OpenGaussDatabaseMetaData.java
index 46bc5ce6cf2..af362026d55 100644
--- 
a/infra/database/type/opengauss/src/main/java/org/apache/shardingsphere/infra/database/opengauss/metadata/database/OpenGaussDatabaseMetaData.java
+++ 
b/infra/database/type/opengauss/src/main/java/org/apache/shardingsphere/infra/database/opengauss/metadata/database/OpenGaussDatabaseMetaData.java
@@ -64,6 +64,7 @@ public final class OpenGaussDatabaseMetaData implements 
DialectDatabaseMetaData
         result.put("NUMERIC", Types.NUMERIC);
         result.put("REAL", Types.REAL);
         result.put("BOOL", Types.BOOLEAN);
+        result.put("CHARACTER VARYING", Types.VARCHAR);
         return result;
     }
     
diff --git 
a/infra/database/type/postgresql/src/main/java/org/apache/shardingsphere/infra/database/postgresql/metadata/database/PostgreSQLDatabaseMetaData.java
 
b/infra/database/type/postgresql/src/main/java/org/apache/shardingsphere/infra/database/postgresql/metadata/database/PostgreSQLDatabaseMetaData.java
index e9fd6a531af..a46cff8aec9 100644
--- 
a/infra/database/type/postgresql/src/main/java/org/apache/shardingsphere/infra/database/postgresql/metadata/database/PostgreSQLDatabaseMetaData.java
+++ 
b/infra/database/type/postgresql/src/main/java/org/apache/shardingsphere/infra/database/postgresql/metadata/database/PostgreSQLDatabaseMetaData.java
@@ -61,6 +61,7 @@ public final class PostgreSQLDatabaseMetaData implements 
DialectDatabaseMetaData
         result.put("NUMERIC", Types.NUMERIC);
         result.put("REAL", Types.REAL);
         result.put("BOOL", Types.BOOLEAN);
+        result.put("CHARACTER VARYING", Types.VARCHAR);
         return result;
     }