You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2023/06/28 12:56:44 UTC
[shardingsphere] branch master updated: Add default required system tables (#26672)
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 b4230205244 Add default required system tables (#26672)
b4230205244 is described below
commit b42302052444f20371540c1113b98165430f3457
Author: ZhangCheng <ch...@apache.org>
AuthorDate: Wed Jun 28 20:56:37 2023 +0800
Add default required system tables (#26672)
---
.../builder/KernelSupportedSystemTables.java | 38 +++++++++++++++++++++-
1 file changed, 37 insertions(+), 1 deletion(-)
diff --git a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/KernelSupportedSystemTables.java b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/KernelSupportedSystemTables.java
index d242fd71832..f91d199060d 100644
--- a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/KernelSupportedSystemTables.java
+++ b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/KernelSupportedSystemTables.java
@@ -22,6 +22,7 @@ import lombok.RequiredArgsConstructor;
import java.util.Arrays;
import java.util.Collection;
+import java.util.Collections;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Map;
@@ -33,12 +34,47 @@ import java.util.Map;
@Getter
public enum KernelSupportedSystemTables {
+ MYSQL_SYS("MySQL", "sys", new HashSet<>(Collections.singleton("sys_config"))),
+
MYSQL_SHARDING_SPHERE("MySQL", "shardingsphere", new HashSet<>(Arrays.asList("sharding_table_statistics", "cluster_information"))),
- POSTGRESQL_PG_CATALOG("PostgreSQL", "pg_catalog", new HashSet<>(Arrays.asList("pg_class", "pg_namespace"))),
+ POSTGRESQL_INFORMATION_SCHEMA("PostgreSQL", "information_schema", new HashSet<>(Arrays.asList("columns", "tables", "views"))),
+
+ POSTGRESQL_PG_CATALOG("PostgreSQL", "pg_catalog", new HashSet<>(Arrays.asList("pg_aggregate", "pg_class", "pg_database", "pg_tables", "pg_inherits",
+ "pg_tablespace", "pg_trigger", "pg_namespace", "pg_roles"))),
POSTGRESQL_SHARDING_SPHERE("PostgreSQL", "shardingsphere", new HashSet<>(Arrays.asList("sharding_table_statistics", "cluster_information"))),
+ OPEN_GAUSS_INFORMATION_SCHEMA("openGauss", "information_schema", Collections.emptySet()),
+
+ OPEN_GAUSS_PG_CATALOG("openGauss", "pg_catalog", new HashSet<>(Arrays.asList("pg_class", "pg_namespace"))),
+
+ OPEN_GAUSS_BLOCKCHAIN("openGauss", "blockchain", Collections.emptySet()),
+
+ OPEN_GAUSS_CSTORE("openGauss", "cstore", Collections.emptySet()),
+
+ OPEN_GAUSS_DB4AI("openGauss", "db4ai", Collections.emptySet()),
+
+ OPEN_GAUSS_DBE_PERF("openGauss", "dbe_perf", Collections.emptySet()),
+
+ OPEN_GAUSS_DBE_PLDEBUGGER("openGauss", "dbe_pldebugger", Collections.emptySet()),
+
+ OPEN_GAUSS_GAUSSDB("openGauss", "gaussdb", Collections.emptySet()),
+
+ OPEN_GAUSS_ORACLE("openGauss", "oracle", Collections.emptySet()),
+
+ OPEN_GAUSS_PKG_SERVICE("openGauss", "pkg_service", Collections.emptySet()),
+
+ OPEN_GAUSS_SNAPSHOT("openGauss", "snapshot", Collections.emptySet()),
+
+ OPEN_GAUSS_PLDEVELOPER("openGauss", "dbe_pldeveloper", Collections.emptySet()),
+
+ OPEN_GAUSS_PG_TOAST("openGauss", "pg_toast", Collections.emptySet()),
+
+ OPEN_GAUSS_PKG_UTIL("openGauss", "pkg_util", Collections.emptySet()),
+
+ OPEN_GAUSS_SQLADVISOR("openGauss", "sqladvisor", Collections.emptySet()),
+
OPEN_GAUSS_SHARDING_SPHERE("openGauss", "shardingsphere", new HashSet<>(Arrays.asList("sharding_table_statistics", "cluster_information")));
private static final Map<String, KernelSupportedSystemTables> SCHEMA_NAME_TO_TABLES = new HashMap<>(values().length, 1F);