This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang 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 caddfec8ec4 Add mysql information_schema tables(#24662) (#24684)
caddfec8ec4 is described below
commit caddfec8ec414916831e92b093629de099ae3d59
Author: ZhangCheng <[email protected]>
AuthorDate: Mon Mar 20 15:13:12 2023 +0800
Add mysql information_schema tables(#24662) (#24684)
* Add mysql information_schema tables
* Add mysql information_schema tables
* Add mysql information_schema tables
---
.../schema/builder/SystemSchemaBuilderRule.java | 8 +-
.../{schemata.yaml => character_sets.yaml} | 31 ++-
... => collation_character_set_applicability.yaml} | 33 +--
.../{engines.yaml => collations.yaml} | 36 +--
.../{engines.yaml => column_privileges.yaml} | 40 ++--
.../schema/mysql/information_schema/columns.yaml | 22 ++
.../schema/mysql/information_schema/engines.yaml | 6 +
.../{routines.yaml => events.yaml} | 163 ++++++-------
.../{routines.yaml => files.yaml} | 253 ++++++++++++++-------
.../{schemata.yaml => global_status.yaml} | 33 +--
.../{schemata.yaml => global_variables.yaml} | 33 +--
.../mysql/information_schema/parameters.yaml | 16 ++
.../schema/mysql/information_schema/routines.yaml | 31 +++
.../schema/mysql/information_schema/schemata.yaml | 5 +
.../schema/mysql/information_schema/tables.yaml | 21 ++
.../schema/mysql/information_schema/views.yaml | 10 +
.../builder/SystemSchemaBuilderRuleTest.java | 5 +-
.../schema/builder/SystemSchemaBuilderTest.java | 2 +-
18 files changed, 439 insertions(+), 309 deletions(-)
diff --git
a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
index 55f82670dc1..8e2bd5e8449 100644
---
a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
+++
b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRule.java
@@ -35,8 +35,8 @@ import java.util.Map;
@Getter
public enum SystemSchemaBuilderRule {
- MYSQL_INFORMATION_SCHEMA("MySQL", "information_schema", new
HashSet<>(Arrays.asList("columns", "engines",
- "parameters", "routines", "schemata", "tables", "views"))),
+ MYSQL_INFORMATION_SCHEMA("MySQL", "information_schema", new
HashSet<>(Arrays.asList("character_sets",
"collation_character_set_applicability", "collations", "column_privileges",
"columns",
+ "engines", "events", "files", "global_status", "global_variables",
"parameters", "routines", "schemata", "tables", "views"))),
MYSQL_MYSQL("MySQL", "mysql", new HashSet<>(Collections.singleton("db"))),
@@ -100,7 +100,7 @@ public enum SystemSchemaBuilderRule {
/**
* Value of builder rule.
- *
+ *
* @param databaseType database type
* @param schema schema
* @return builder rule
@@ -114,7 +114,7 @@ public enum SystemSchemaBuilderRule {
/**
* Judge whether current table is system table or not.
- *
+ *
* @param schema schema
* @param tableName table name
* @return whether current table is system table or not
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/character_sets.yaml
similarity index 76%
copy from
infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
copy to
infra/common/src/main/resources/schema/mysql/information_schema/character_sets.yaml
index 9ff6da6c471..661a3426e79 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/character_sets.yaml
@@ -15,40 +15,37 @@
# limitations under the License.
#
-name: SCHEMATA
+name: CHARACTER_SETS
columns:
- catalog_name:
+ character_set_name:
caseSensitive: false
dataType: 12
generated: false
- name: CATALOG_NAME
+ name: CHARACTER_SET_NAME
primaryKey: false
+ unsigned: false
visible: true
- schema_name:
+ default_collate_name:
caseSensitive: false
dataType: 12
generated: false
- name: SCHEMA_NAME
+ name: DEFAULT_COLLATE_NAME
primaryKey: false
+ unsigned: false
visible: true
- default_character_set_name:
+ description:
caseSensitive: false
dataType: 12
generated: false
- name: DEFAULT_CHARACTER_SET_NAME
+ name: DESCRIPTION
primaryKey: false
+ unsigned: false
visible: true
- default_collation_name:
+ maxlen:
caseSensitive: false
- dataType: 12
- generated: false
- name: DEFAULT_COLLATION_NAME
- primaryKey: false
- visible: true
- sql_path:
- caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: SQL_PATH
+ name: MAXLEN
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/collation_character_set_applicability.yaml
similarity index 64%
copy from
infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
copy to
infra/common/src/main/resources/schema/mysql/information_schema/collation_character_set_applicability.yaml
index 9ff6da6c471..54ae043a709 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/collation_character_set_applicability.yaml
@@ -15,40 +15,21 @@
# limitations under the License.
#
-name: SCHEMATA
+name: COLLATION_CHARACTER_SET_APPLICABILITY
columns:
- catalog_name:
+ collation_name:
caseSensitive: false
dataType: 12
generated: false
- name: CATALOG_NAME
+ name: COLLATION_NAME
primaryKey: false
+ unsigned: false
visible: true
- schema_name:
+ character_set_name:
caseSensitive: false
dataType: 12
generated: false
- name: SCHEMA_NAME
- primaryKey: false
- visible: true
- default_character_set_name:
- caseSensitive: false
- dataType: 12
- generated: false
- name: DEFAULT_CHARACTER_SET_NAME
- primaryKey: false
- visible: true
- default_collation_name:
- caseSensitive: false
- dataType: 12
- generated: false
- name: DEFAULT_COLLATION_NAME
- primaryKey: false
- visible: true
- sql_path:
- caseSensitive: false
- dataType: 12
- generated: false
- name: SQL_PATH
+ name: CHARACTER_SET_NAME
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/engines.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
similarity index 78%
copy from
infra/common/src/main/resources/schema/mysql/information_schema/engines.yaml
copy to
infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
index b6956277f6b..96a394a1477 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/engines.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
@@ -15,47 +15,53 @@
# limitations under the License.
#
-name: ENGINES
+name: COLLATIONS
columns:
- engine:
+ collation_name:
caseSensitive: false
dataType: 12
generated: false
- name: ENGINE
+ name: COLLATION_NAME
primaryKey: false
+ unsigned: false
visible: true
- support:
+ character_set_name:
caseSensitive: false
dataType: 12
generated: false
- name: SUPPORT
+ name: CHARACTER_SET_NAME
primaryKey: false
+ unsigned: false
visible: true
- comment:
+ id:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: COMMENT
+ name: ID
primaryKey: false
+ unsigned: false
visible: true
- transactions:
+ is_default:
caseSensitive: false
dataType: 12
generated: false
- name: TRANSACTIONS
+ name: IS_DEFAULT
primaryKey: false
+ unsigned: false
visible: true
- xa:
+ is_compiled:
caseSensitive: false
dataType: 12
generated: false
- name: XA
+ name: IS_COMPILED
primaryKey: false
+ unsigned: false
visible: true
- savepoints:
+ sortlen:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: SAVEPOINTS
+ name: SORTLEN
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/engines.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/column_privileges.yaml
similarity index 72%
copy from
infra/common/src/main/resources/schema/mysql/information_schema/engines.yaml
copy to
infra/common/src/main/resources/schema/mysql/information_schema/column_privileges.yaml
index b6956277f6b..e3451ae47f8 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/engines.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/column_privileges.yaml
@@ -15,47 +15,61 @@
# limitations under the License.
#
-name: ENGINES
+name: COLUMN_PRIVILEGES
columns:
- engine:
+ grantee:
caseSensitive: false
dataType: 12
generated: false
- name: ENGINE
+ name: GRANTEE
primaryKey: false
+ unsigned: false
visible: true
- support:
+ table_catalog:
caseSensitive: false
dataType: 12
generated: false
- name: SUPPORT
+ name: TABLE_CATALOG
primaryKey: false
+ unsigned: false
visible: true
- comment:
+ table_schema:
caseSensitive: false
dataType: 12
generated: false
- name: COMMENT
+ name: TABLE_SCHEMA
primaryKey: false
+ unsigned: false
visible: true
- transactions:
+ table_name:
caseSensitive: false
dataType: 12
generated: false
- name: TRANSACTIONS
+ name: TABLE_NAME
primaryKey: false
+ unsigned: false
visible: true
- xa:
+ column_name:
caseSensitive: false
dataType: 12
generated: false
- name: XA
+ name: COLUMN_NAME
primaryKey: false
+ unsigned: false
visible: true
- savepoints:
+ privilege_type:
caseSensitive: false
dataType: 12
generated: false
- name: SAVEPOINTS
+ name: PRIVILEGE_TYPE
primaryKey: false
+ unsigned: false
+ visible: true
+ is_grantable:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: IS_GRANTABLE
+ primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/columns.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/columns.yaml
index 53ceb42a05a..faa76b4cc4a 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/columns.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/columns.yaml
@@ -23,6 +23,7 @@ columns:
generated: false
name: TABLE_CATALOG
primaryKey: false
+ unsigned: false
visible: true
table_schema:
caseSensitive: false
@@ -30,6 +31,7 @@ columns:
generated: false
name: TABLE_SCHEMA
primaryKey: false
+ unsigned: false
visible: true
table_name:
caseSensitive: false
@@ -37,6 +39,7 @@ columns:
generated: false
name: TABLE_NAME
primaryKey: false
+ unsigned: false
visible: true
column_name:
caseSensitive: false
@@ -44,6 +47,7 @@ columns:
generated: false
name: COLUMN_NAME
primaryKey: false
+ unsigned: false
visible: true
ordinal_position:
caseSensitive: false
@@ -51,12 +55,15 @@ columns:
generated: false
name: ORDINAL_POSITION
primaryKey: false
+ unsigned: true
+ visible: true
column_default:
caseSensitive: false
dataType: -1
generated: false
name: COLUMN_DEFAULT
primaryKey: false
+ unsigned: false
visible: true
is_nullable:
caseSensitive: false
@@ -64,6 +71,7 @@ columns:
generated: false
name: IS_NULLABLE
primaryKey: false
+ unsigned: false
visible: true
data_type:
caseSensitive: false
@@ -71,6 +79,7 @@ columns:
generated: false
name: DATA_TYPE
primaryKey: false
+ unsigned: false
visible: true
character_maximum_length:
caseSensitive: false
@@ -78,6 +87,7 @@ columns:
generated: false
name: CHARACTER_MAXIMUM_LENGTH
primaryKey: false
+ unsigned: true
visible: true
character_octet_length:
caseSensitive: false
@@ -85,6 +95,7 @@ columns:
generated: false
name: CHARACTER_OCTET_LENGTH
primaryKey: false
+ unsigned: true
visible: true
numeric_precision:
caseSensitive: false
@@ -92,6 +103,7 @@ columns:
generated: false
name: NUMERIC_PRECISION
primaryKey: false
+ unsigned: true
visible: true
numeric_scale:
caseSensitive: false
@@ -99,6 +111,7 @@ columns:
generated: false
name: NUMERIC_SCALE
primaryKey: false
+ unsigned: true
visible: true
datetime_precision:
caseSensitive: false
@@ -106,6 +119,7 @@ columns:
generated: false
name: DATETIME_PRECISION
primaryKey: false
+ unsigned: true
visible: true
character_set_name:
caseSensitive: false
@@ -113,6 +127,7 @@ columns:
generated: false
name: CHARACTER_SET_NAME
primaryKey: false
+ unsigned: false
visible: true
collation_name:
caseSensitive: false
@@ -120,6 +135,7 @@ columns:
generated: false
name: COLLATION_NAME
primaryKey: false
+ unsigned: false
visible: true
column_type:
caseSensitive: false
@@ -127,6 +143,7 @@ columns:
generated: false
name: COLUMN_TYPE
primaryKey: false
+ unsigned: false
visible: true
column_key:
caseSensitive: false
@@ -134,6 +151,7 @@ columns:
generated: false
name: COLUMN_KEY
primaryKey: false
+ unsigned: false
visible: true
extra:
caseSensitive: false
@@ -141,6 +159,7 @@ columns:
generated: false
name: EXTRA
primaryKey: false
+ unsigned: false
visible: true
privileges:
caseSensitive: false
@@ -148,6 +167,7 @@ columns:
generated: false
name: PRIVILEGES
primaryKey: false
+ unsigned: false
visible: true
column_comment:
caseSensitive: false
@@ -155,6 +175,7 @@ columns:
generated: false
name: COLUMN_COMMENT
primaryKey: false
+ unsigned: false
visible: true
generation_expression:
caseSensitive: false
@@ -162,4 +183,5 @@ columns:
generated: false
name: GENERATION_EXPRESSION
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/engines.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/engines.yaml
index b6956277f6b..6e4624c898c 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/engines.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/engines.yaml
@@ -23,6 +23,7 @@ columns:
generated: false
name: ENGINE
primaryKey: false
+ unsigned: false
visible: true
support:
caseSensitive: false
@@ -30,6 +31,7 @@ columns:
generated: false
name: SUPPORT
primaryKey: false
+ unsigned: false
visible: true
comment:
caseSensitive: false
@@ -37,6 +39,7 @@ columns:
generated: false
name: COMMENT
primaryKey: false
+ unsigned: false
visible: true
transactions:
caseSensitive: false
@@ -44,6 +47,7 @@ columns:
generated: false
name: TRANSACTIONS
primaryKey: false
+ unsigned: false
visible: true
xa:
caseSensitive: false
@@ -51,6 +55,7 @@ columns:
generated: false
name: XA
primaryKey: false
+ unsigned: false
visible: true
savepoints:
caseSensitive: false
@@ -58,4 +63,5 @@ columns:
generated: false
name: SAVEPOINTS
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/events.yaml
similarity index 65%
copy from
infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
copy to
infra/common/src/main/resources/schema/mysql/information_schema/events.yaml
index 1d7bc22ca48..0272cb7660d 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/events.yaml
@@ -15,168 +15,135 @@
# limitations under the License.
#
-name: ROUTINES
+name: EVENTS
columns:
- specific_name:
+ event_catalog:
caseSensitive: false
dataType: 12
generated: false
- name: SPECIFIC_NAME
+ name: EVENT_CATALOG
primaryKey: false
+ unsigned: false
visible: true
- routine_catalog:
+ event_schema:
caseSensitive: false
dataType: 12
generated: false
- name: ROUTINE_CATALOG
+ name: EVENT_SCHEMA
primaryKey: false
+ unsigned: false
visible: true
- routine_schema:
+ event_name:
caseSensitive: false
dataType: 12
generated: false
- name: ROUTINE_SCHEMA
+ name: EVENT_NAME
primaryKey: false
+ unsigned: false
visible: true
- routine_name:
- caseSensitive: false
- dataType: 12
- generated: false
- name: ROUTINE_NAME
- primaryKey: false
- visible: true
- routine_type:
- caseSensitive: false
- dataType: 12
- generated: false
- name: ROUTINE_TYPE
- primaryKey: false
- visible: true
- data_type:
+ definer:
caseSensitive: false
dataType: 12
generated: false
- name: DATA_TYPE
- primaryKey: false
- visible: true
- character_maximum_length:
- caseSensitive: false
- dataType: 4
- generated: false
- name: CHARACTER_MAXIMUM_LENGTH
- primaryKey: false
- visible: true
- character_octet_length:
- caseSensitive: false
- dataType: 4
- generated: false
- name: CHARACTER_OCTET_LENGTH
- primaryKey: false
- visible: true
- numeric_precision:
- caseSensitive: false
- dataType: -5
- generated: false
- name: NUMERIC_PRECISION
- primaryKey: false
- visible: true
- numeric_scale:
- caseSensitive: false
- dataType: 4
- generated: false
- name: NUMERIC_SCALE
- primaryKey: false
- visible: true
- datetime_precision:
- caseSensitive: false
- dataType: -5
- generated: false
- name: DATETIME_PRECISION
+ name: DEFINER
primaryKey: false
+ unsigned: false
visible: true
- character_set_name:
+ time_zone:
caseSensitive: false
dataType: 12
generated: false
- name: CHARACTER_SET_NAME
+ name: TIME_ZONE
primaryKey: false
+ unsigned: false
visible: true
- collation_name:
+ event_body:
caseSensitive: false
dataType: 12
generated: false
- name: COLLATION_NAME
+ name: EVENT_BODY
primaryKey: false
+ unsigned: false
visible: true
- dtd_identifier:
+ event_definition:
caseSensitive: false
dataType: -1
generated: false
- name: DTD_IDENTIFIER
+ name: EVENT_DEFINITION
primaryKey: false
+ unsigned: false
visible: true
- routine_body:
+ event_type:
caseSensitive: false
dataType: 12
generated: false
- name: ROUTINE_BODY
+ name: EVENT_TYPE
primaryKey: false
+ unsigned: false
visible: true
- routine_definition:
+ execute_at:
caseSensitive: false
- dataType: -1
+ dataType: 93
generated: false
- name: ROUTINE_DEFINITION
+ name: EXECUTE_AT
primaryKey: false
+ unsigned: false
visible: true
- external_name:
+ interval_value:
caseSensitive: false
dataType: 12
generated: false
- name: EXTERNAL_NAME
+ name: INTERVAL_VALUE
primaryKey: false
+ unsigned: false
visible: true
- external_language:
+ interval_field:
caseSensitive: false
dataType: 12
generated: false
- name: EXTERNAL_LANGUAGE
+ name: INTERVAL_FIELD
primaryKey: false
+ unsigned: false
visible: true
- parameter_style:
+ sql_mode:
caseSensitive: false
dataType: 12
generated: false
- name: PARAMETER_STYLE
+ name: SQL_MODE
primaryKey: false
+ unsigned: false
visible: true
- is_deterministic:
+ starts:
caseSensitive: false
- dataType: 12
+ dataType: 93
generated: false
- name: IS_DETERMINISTIC
+ name: STARTS
primaryKey: false
+ unsigned: false
visible: true
- sql_data_access:
+ ends:
caseSensitive: false
- dataType: 12
+ dataType: 93
generated: false
- name: SQL_DATA_ACCESS
+ name: ENDS
primaryKey: false
+ unsigned: false
visible: true
- sql_path:
+ status:
caseSensitive: false
dataType: 12
generated: false
- name: SQL_PATH
+ name: STATUS
primaryKey: false
+ unsigned: false
visible: true
- security_type:
+ on_completion:
caseSensitive: false
dataType: 12
generated: false
- name: SECURITY_TYPE
+ name: ON_COMPLETION
primaryKey: false
+ unsigned: false
visible: true
created:
caseSensitive: false
@@ -184,6 +151,7 @@ columns:
generated: false
name: CREATED
primaryKey: false
+ unsigned: false
visible: true
last_altered:
caseSensitive: false
@@ -191,27 +159,31 @@ columns:
generated: false
name: LAST_ALTERED
primaryKey: false
+ unsigned: false
visible: true
- sql_mode:
+ last_executed:
caseSensitive: false
- dataType: 12
+ dataType: 93
generated: false
- name: SQL_MODE
+ name: LAST_EXECUTED
primaryKey: false
+ unsigned: false
visible: true
- routine_comment:
+ event_comment:
caseSensitive: false
- dataType: -1
+ dataType: 12
generated: false
- name: ROUTINE_COMMENT
+ name: EVENT_COMMENT
primaryKey: false
+ unsigned: false
visible: true
- definer:
+ originator:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: DEFINER
+ name: ORIGINATOR
primaryKey: false
+ unsigned: false
visible: true
character_set_client:
caseSensitive: false
@@ -219,6 +191,7 @@ columns:
generated: false
name: CHARACTER_SET_CLIENT
primaryKey: false
+ unsigned: false
visible: true
collation_connection:
caseSensitive: false
@@ -226,6 +199,7 @@ columns:
generated: false
name: COLLATION_CONNECTION
primaryKey: false
+ unsigned: false
visible: true
database_collation:
caseSensitive: false
@@ -233,4 +207,5 @@ columns:
generated: false
name: DATABASE_COLLATION
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/files.yaml
similarity index 53%
copy from
infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
copy to
infra/common/src/main/resources/schema/mysql/information_schema/files.yaml
index 1d7bc22ca48..5d6a9c4d40a 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/files.yaml
@@ -15,222 +15,309 @@
# limitations under the License.
#
-name: ROUTINES
+name: FILES
columns:
- specific_name:
+ file_id:
+ caseSensitive: false
+ dataType: -5
+ generated: false
+ name: FILE_ID
+ primaryKey: false
+ unsigned: false
+ visible: true
+ file_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: FILE_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ file_type:
caseSensitive: false
dataType: 12
generated: false
- name: SPECIFIC_NAME
+ name: FILE_TYPE
primaryKey: false
+ unsigned: false
visible: true
- routine_catalog:
+ tablespace_name:
caseSensitive: false
dataType: 12
generated: false
- name: ROUTINE_CATALOG
+ name: TABLESPACE_NAME
primaryKey: false
+ unsigned: false
visible: true
- routine_schema:
+ table_catalog:
caseSensitive: false
dataType: 12
generated: false
- name: ROUTINE_SCHEMA
+ name: TABLE_CATALOG
primaryKey: false
+ unsigned: false
visible: true
- routine_name:
+ table_schema:
caseSensitive: false
dataType: 12
generated: false
- name: ROUTINE_NAME
+ name: TABLE_SCHEMA
primaryKey: false
+ unsigned: false
visible: true
- routine_type:
+ table_name:
caseSensitive: false
dataType: 12
generated: false
- name: ROUTINE_TYPE
+ name: TABLE_NAME
primaryKey: false
+ unsigned: false
visible: true
- data_type:
+ logfile_group_name:
caseSensitive: false
dataType: 12
generated: false
- name: DATA_TYPE
+ name: LOGFILE_GROUP_NAME
primaryKey: false
+ unsigned: false
visible: true
- character_maximum_length:
+ logfile_group_number:
caseSensitive: false
- dataType: 4
+ dataType: -5
generated: false
- name: CHARACTER_MAXIMUM_LENGTH
+ name: LOGFILE_GROUP_NUMBER
primaryKey: false
+ unsigned: false
visible: true
- character_octet_length:
+ engine:
caseSensitive: false
- dataType: 4
+ dataType: 12
generated: false
- name: CHARACTER_OCTET_LENGTH
+ name: ENGINE
primaryKey: false
+ unsigned: false
visible: true
- numeric_precision:
+ fulltext_keys:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: FULLTEXT_KEYS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ deleted_rows:
caseSensitive: false
dataType: -5
generated: false
- name: NUMERIC_PRECISION
+ name: DELETED_ROWS
primaryKey: false
+ unsigned: false
visible: true
- numeric_scale:
+ update_count:
caseSensitive: false
- dataType: 4
+ dataType: -5
generated: false
- name: NUMERIC_SCALE
+ name: UPDATE_COUNT
primaryKey: false
+ unsigned: false
visible: true
- datetime_precision:
+ free_extents:
caseSensitive: false
dataType: -5
generated: false
- name: DATETIME_PRECISION
+ name: FREE_EXTENTS
primaryKey: false
+ unsigned: false
visible: true
- character_set_name:
+ total_extents:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: CHARACTER_SET_NAME
+ name: TOTAL_EXTENTS
primaryKey: false
+ unsigned: false
visible: true
- collation_name:
+ extent_size:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: COLLATION_NAME
+ name: EXTENT_SIZE
primaryKey: false
+ unsigned: false
visible: true
- dtd_identifier:
+ initial_size:
caseSensitive: false
- dataType: -1
+ dataType: -5
generated: false
- name: DTD_IDENTIFIER
+ name: INITIAL_SIZE
primaryKey: false
+ unsigned: true
visible: true
- routine_body:
+ maximum_size:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: ROUTINE_BODY
+ name: MAXIMUM_SIZE
primaryKey: false
+ unsigned: true
visible: true
- routine_definition:
+ autoextend_size:
caseSensitive: false
- dataType: -1
+ dataType: -5
generated: false
- name: ROUTINE_DEFINITION
+ name: AUTOEXTEND_SIZE
primaryKey: false
+ unsigned: true
visible: true
- external_name:
+ creation_time:
caseSensitive: false
- dataType: 12
+ dataType: 93
generated: false
- name: EXTERNAL_NAME
+ name: CREATION_TIME
primaryKey: false
+ unsigned: false
visible: true
- external_language:
+ last_update_time:
caseSensitive: false
- dataType: 12
+ dataType: 93
generated: false
- name: EXTERNAL_LANGUAGE
+ name: LAST_UPDATE_TIME
primaryKey: false
+ unsigned: false
visible: true
- parameter_style:
+ last_access_time:
caseSensitive: false
- dataType: 12
+ dataType: 93
generated: false
- name: PARAMETER_STYLE
+ name: LAST_ACCESS_TIME
primaryKey: false
+ unsigned: false
visible: true
- is_deterministic:
+ recover_time:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: IS_DETERMINISTIC
+ name: RECOVER_TIME
primaryKey: false
+ unsigned: false
visible: true
- sql_data_access:
+ transaction_counter:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: SQL_DATA_ACCESS
+ name: TRANSACTION_COUNTER
primaryKey: false
+ unsigned: false
visible: true
- sql_path:
+ version:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: SQL_PATH
+ name: VERSION
primaryKey: false
+ unsigned: true
visible: true
- security_type:
+ row_format:
caseSensitive: false
dataType: 12
generated: false
- name: SECURITY_TYPE
+ name: ROW_FORMAT
primaryKey: false
+ unsigned: false
visible: true
- created:
+ table_rows:
caseSensitive: false
- dataType: 93
+ dataType: -5
generated: false
- name: CREATED
+ name: TABLE_ROWS
primaryKey: false
+ unsigned: true
visible: true
- last_altered:
+ avg_row_length:
caseSensitive: false
- dataType: 93
+ dataType: -5
generated: false
- name: LAST_ALTERED
+ name: AVG_ROW_LENGTH
primaryKey: false
+ unsigned: true
visible: true
- sql_mode:
+ data_length:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: SQL_MODE
+ name: DATA_LENGTH
primaryKey: false
+ unsigned: true
visible: true
- routine_comment:
+ max_data_length:
caseSensitive: false
- dataType: -1
+ dataType: -5
generated: false
- name: ROUTINE_COMMENT
+ name: MAX_DATA_LENGTH
primaryKey: false
+ unsigned: true
visible: true
- definer:
+ index_length:
caseSensitive: false
- dataType: 12
+ dataType: -5
generated: false
- name: DEFINER
+ name: INDEX_LENGTH
primaryKey: false
+ unsigned: true
visible: true
- character_set_client:
+ data_free:
caseSensitive: false
- dataType: 12
+ dataType: -5
+ generated: false
+ name: DATA_FREE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ create_time:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: CREATE_TIME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ update_time:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: UPDATE_TIME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ check_time:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: CHECK_TIME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ checksum:
+ caseSensitive: false
+ dataType: -5
generated: false
- name: CHARACTER_SET_CLIENT
+ name: CHECKSUM
primaryKey: false
+ unsigned: true
visible: true
- collation_connection:
+ status:
caseSensitive: false
dataType: 12
generated: false
- name: COLLATION_CONNECTION
+ name: STATUS
primaryKey: false
+ unsigned: false
visible: true
- database_collation:
+ extra:
caseSensitive: false
dataType: 12
generated: false
- name: DATABASE_COLLATION
+ name: EXTRA
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/global_status.yaml
similarity index 64%
copy from
infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
copy to
infra/common/src/main/resources/schema/mysql/information_schema/global_status.yaml
index 9ff6da6c471..6068181a4a0 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/global_status.yaml
@@ -15,40 +15,21 @@
# limitations under the License.
#
-name: SCHEMATA
+name: GLOBAL_STATUS
columns:
- catalog_name:
+ variable_name:
caseSensitive: false
dataType: 12
generated: false
- name: CATALOG_NAME
+ name: VARIABLE_NAME
primaryKey: false
+ unsigned: false
visible: true
- schema_name:
+ variable_value:
caseSensitive: false
dataType: 12
generated: false
- name: SCHEMA_NAME
- primaryKey: false
- visible: true
- default_character_set_name:
- caseSensitive: false
- dataType: 12
- generated: false
- name: DEFAULT_CHARACTER_SET_NAME
- primaryKey: false
- visible: true
- default_collation_name:
- caseSensitive: false
- dataType: 12
- generated: false
- name: DEFAULT_COLLATION_NAME
- primaryKey: false
- visible: true
- sql_path:
- caseSensitive: false
- dataType: 12
- generated: false
- name: SQL_PATH
+ name: VARIABLE_VALUE
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/global_variables.yaml
similarity index 64%
copy from
infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
copy to
infra/common/src/main/resources/schema/mysql/information_schema/global_variables.yaml
index 9ff6da6c471..64c19f3a01b 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/global_variables.yaml
@@ -15,40 +15,21 @@
# limitations under the License.
#
-name: SCHEMATA
+name: GLOBAL_VARIABLES
columns:
- catalog_name:
+ variable_name:
caseSensitive: false
dataType: 12
generated: false
- name: CATALOG_NAME
+ name: VARIABLE_NAME
primaryKey: false
+ unsigned: false
visible: true
- schema_name:
+ variable_value:
caseSensitive: false
dataType: 12
generated: false
- name: SCHEMA_NAME
- primaryKey: false
- visible: true
- default_character_set_name:
- caseSensitive: false
- dataType: 12
- generated: false
- name: DEFAULT_CHARACTER_SET_NAME
- primaryKey: false
- visible: true
- default_collation_name:
- caseSensitive: false
- dataType: 12
- generated: false
- name: DEFAULT_COLLATION_NAME
- primaryKey: false
- visible: true
- sql_path:
- caseSensitive: false
- dataType: 12
- generated: false
- name: SQL_PATH
+ name: VARIABLE_VALUE
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/parameters.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/parameters.yaml
index 327d317321f..18334ac6ada 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/parameters.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/parameters.yaml
@@ -23,6 +23,7 @@ columns:
generated: false
name: SPECIFIC_CATALOG
primaryKey: false
+ unsigned: false
visible: true
specific_schema:
caseSensitive: false
@@ -30,6 +31,7 @@ columns:
generated: false
name: SPECIFIC_SCHEMA
primaryKey: false
+ unsigned: false
visible: true
specific_name:
caseSensitive: false
@@ -37,6 +39,7 @@ columns:
generated: false
name: SPECIFIC_NAME
primaryKey: false
+ unsigned: false
visible: true
ordinal_position:
caseSensitive: false
@@ -44,6 +47,7 @@ columns:
generated: false
name: ORDINAL_POSITION
primaryKey: false
+ unsigned: false
visible: true
parameter_mode:
caseSensitive: false
@@ -51,6 +55,7 @@ columns:
generated: false
name: PARAMETER_MODE
primaryKey: false
+ unsigned: false
visible: true
parameter_name:
caseSensitive: false
@@ -58,6 +63,7 @@ columns:
generated: false
name: PARAMETER_NAME
primaryKey: false
+ unsigned: false
visible: true
data_type:
caseSensitive: false
@@ -65,6 +71,7 @@ columns:
generated: false
name: DATA_TYPE
primaryKey: false
+ unsigned: false
visible: true
character_maximum_length:
caseSensitive: false
@@ -72,6 +79,7 @@ columns:
generated: false
name: CHARACTER_MAXIMUM_LENGTH
primaryKey: false
+ unsigned: false
visible: true
character_octet_length:
caseSensitive: false
@@ -79,6 +87,7 @@ columns:
generated: false
name: CHARACTER_OCTET_LENGTH
primaryKey: false
+ unsigned: false
visible: true
numeric_precision:
caseSensitive: false
@@ -86,6 +95,7 @@ columns:
generated: false
name: NUMERIC_PRECISION
primaryKey: false
+ unsigned: true
visible: true
numeric_scale:
caseSensitive: false
@@ -93,6 +103,7 @@ columns:
generated: false
name: NUMERIC_SCALE
primaryKey: false
+ unsigned: false
visible: true
datetime_precision:
caseSensitive: false
@@ -100,6 +111,7 @@ columns:
generated: false
name: DATETIME_PRECISION
primaryKey: false
+ unsigned: true
visible: true
character_set_name:
caseSensitive: false
@@ -107,6 +119,7 @@ columns:
generated: false
name: CHARACTER_SET_NAME
primaryKey: false
+ unsigned: false
visible: true
collation_name:
caseSensitive: false
@@ -114,6 +127,7 @@ columns:
generated: false
name: COLLATION_NAME
primaryKey: false
+ unsigned: false
visible: true
dtd_identifier:
caseSensitive: false
@@ -121,6 +135,7 @@ columns:
generated: false
name: DTD_IDENTIFIER
primaryKey: false
+ unsigned: false
visible: true
routine_type:
caseSensitive: false
@@ -128,4 +143,5 @@ columns:
generated: false
name: ROUTINE_TYPE
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
index 1d7bc22ca48..1a5c230e670 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
@@ -23,6 +23,7 @@ columns:
generated: false
name: SPECIFIC_NAME
primaryKey: false
+ unsigned: false
visible: true
routine_catalog:
caseSensitive: false
@@ -30,6 +31,7 @@ columns:
generated: false
name: ROUTINE_CATALOG
primaryKey: false
+ unsigned: false
visible: true
routine_schema:
caseSensitive: false
@@ -37,6 +39,7 @@ columns:
generated: false
name: ROUTINE_SCHEMA
primaryKey: false
+ unsigned: false
visible: true
routine_name:
caseSensitive: false
@@ -44,6 +47,7 @@ columns:
generated: false
name: ROUTINE_NAME
primaryKey: false
+ unsigned: false
visible: true
routine_type:
caseSensitive: false
@@ -51,6 +55,7 @@ columns:
generated: false
name: ROUTINE_TYPE
primaryKey: false
+ unsigned: false
visible: true
data_type:
caseSensitive: false
@@ -58,6 +63,7 @@ columns:
generated: false
name: DATA_TYPE
primaryKey: false
+ unsigned: false
visible: true
character_maximum_length:
caseSensitive: false
@@ -65,6 +71,7 @@ columns:
generated: false
name: CHARACTER_MAXIMUM_LENGTH
primaryKey: false
+ unsigned: false
visible: true
character_octet_length:
caseSensitive: false
@@ -72,6 +79,7 @@ columns:
generated: false
name: CHARACTER_OCTET_LENGTH
primaryKey: false
+ unsigned: false
visible: true
numeric_precision:
caseSensitive: false
@@ -79,6 +87,7 @@ columns:
generated: false
name: NUMERIC_PRECISION
primaryKey: false
+ unsigned: true
visible: true
numeric_scale:
caseSensitive: false
@@ -86,6 +95,7 @@ columns:
generated: false
name: NUMERIC_SCALE
primaryKey: false
+ unsigned: false
visible: true
datetime_precision:
caseSensitive: false
@@ -93,6 +103,7 @@ columns:
generated: false
name: DATETIME_PRECISION
primaryKey: false
+ unsigned: true
visible: true
character_set_name:
caseSensitive: false
@@ -100,6 +111,7 @@ columns:
generated: false
name: CHARACTER_SET_NAME
primaryKey: false
+ unsigned: false
visible: true
collation_name:
caseSensitive: false
@@ -107,6 +119,7 @@ columns:
generated: false
name: COLLATION_NAME
primaryKey: false
+ unsigned: false
visible: true
dtd_identifier:
caseSensitive: false
@@ -114,6 +127,7 @@ columns:
generated: false
name: DTD_IDENTIFIER
primaryKey: false
+ unsigned: false
visible: true
routine_body:
caseSensitive: false
@@ -121,6 +135,7 @@ columns:
generated: false
name: ROUTINE_BODY
primaryKey: false
+ unsigned: false
visible: true
routine_definition:
caseSensitive: false
@@ -128,6 +143,7 @@ columns:
generated: false
name: ROUTINE_DEFINITION
primaryKey: false
+ unsigned: false
visible: true
external_name:
caseSensitive: false
@@ -135,6 +151,7 @@ columns:
generated: false
name: EXTERNAL_NAME
primaryKey: false
+ unsigned: false
visible: true
external_language:
caseSensitive: false
@@ -142,6 +159,7 @@ columns:
generated: false
name: EXTERNAL_LANGUAGE
primaryKey: false
+ unsigned: false
visible: true
parameter_style:
caseSensitive: false
@@ -149,6 +167,7 @@ columns:
generated: false
name: PARAMETER_STYLE
primaryKey: false
+ unsigned: false
visible: true
is_deterministic:
caseSensitive: false
@@ -156,6 +175,7 @@ columns:
generated: false
name: IS_DETERMINISTIC
primaryKey: false
+ unsigned: false
visible: true
sql_data_access:
caseSensitive: false
@@ -163,6 +183,7 @@ columns:
generated: false
name: SQL_DATA_ACCESS
primaryKey: false
+ unsigned: false
visible: true
sql_path:
caseSensitive: false
@@ -170,6 +191,7 @@ columns:
generated: false
name: SQL_PATH
primaryKey: false
+ unsigned: false
visible: true
security_type:
caseSensitive: false
@@ -177,6 +199,7 @@ columns:
generated: false
name: SECURITY_TYPE
primaryKey: false
+ unsigned: false
visible: true
created:
caseSensitive: false
@@ -184,6 +207,7 @@ columns:
generated: false
name: CREATED
primaryKey: false
+ unsigned: false
visible: true
last_altered:
caseSensitive: false
@@ -191,6 +215,7 @@ columns:
generated: false
name: LAST_ALTERED
primaryKey: false
+ unsigned: false
visible: true
sql_mode:
caseSensitive: false
@@ -198,6 +223,7 @@ columns:
generated: false
name: SQL_MODE
primaryKey: false
+ unsigned: false
visible: true
routine_comment:
caseSensitive: false
@@ -205,6 +231,7 @@ columns:
generated: false
name: ROUTINE_COMMENT
primaryKey: false
+ unsigned: false
visible: true
definer:
caseSensitive: false
@@ -212,6 +239,7 @@ columns:
generated: false
name: DEFINER
primaryKey: false
+ unsigned: false
visible: true
character_set_client:
caseSensitive: false
@@ -219,6 +247,7 @@ columns:
generated: false
name: CHARACTER_SET_CLIENT
primaryKey: false
+ unsigned: false
visible: true
collation_connection:
caseSensitive: false
@@ -226,6 +255,7 @@ columns:
generated: false
name: COLLATION_CONNECTION
primaryKey: false
+ unsigned: false
visible: true
database_collation:
caseSensitive: false
@@ -233,4 +263,5 @@ columns:
generated: false
name: DATABASE_COLLATION
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
index 9ff6da6c471..35123d119d2 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/schemata.yaml
@@ -23,6 +23,7 @@ columns:
generated: false
name: CATALOG_NAME
primaryKey: false
+ unsigned: false
visible: true
schema_name:
caseSensitive: false
@@ -30,6 +31,7 @@ columns:
generated: false
name: SCHEMA_NAME
primaryKey: false
+ unsigned: false
visible: true
default_character_set_name:
caseSensitive: false
@@ -37,6 +39,7 @@ columns:
generated: false
name: DEFAULT_CHARACTER_SET_NAME
primaryKey: false
+ unsigned: false
visible: true
default_collation_name:
caseSensitive: false
@@ -44,6 +47,7 @@ columns:
generated: false
name: DEFAULT_COLLATION_NAME
primaryKey: false
+ unsigned: false
visible: true
sql_path:
caseSensitive: false
@@ -51,4 +55,5 @@ columns:
generated: false
name: SQL_PATH
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/tables.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/tables.yaml
index 509f6d533cf..d9a5b9122ae 100644
---
a/infra/common/src/main/resources/schema/mysql/information_schema/tables.yaml
+++
b/infra/common/src/main/resources/schema/mysql/information_schema/tables.yaml
@@ -23,6 +23,7 @@ columns:
generated: false
name: TABLE_CATALOG
primaryKey: false
+ unsigned: false
visible: true
table_schema:
caseSensitive: false
@@ -30,6 +31,7 @@ columns:
generated: false
name: TABLE_SCHEMA
primaryKey: false
+ unsigned: false
visible: true
table_name:
caseSensitive: false
@@ -37,6 +39,7 @@ columns:
generated: false
name: TABLE_NAME
primaryKey: false
+ unsigned: false
visible: true
table_type:
caseSensitive: false
@@ -44,6 +47,7 @@ columns:
generated: false
name: TABLE_TYPE
primaryKey: false
+ unsigned: false
visible: true
engine:
caseSensitive: false
@@ -51,6 +55,7 @@ columns:
generated: false
name: ENGINE
primaryKey: false
+ unsigned: false
visible: true
version:
caseSensitive: false
@@ -58,6 +63,7 @@ columns:
generated: false
name: VERSION
primaryKey: false
+ unsigned: true
visible: true
row_format:
caseSensitive: false
@@ -65,6 +71,7 @@ columns:
generated: false
name: ROW_FORMAT
primaryKey: false
+ unsigned: false
visible: true
table_rows:
caseSensitive: false
@@ -72,6 +79,7 @@ columns:
generated: false
name: TABLE_ROWS
primaryKey: false
+ unsigned: true
visible: true
avg_row_length:
caseSensitive: false
@@ -79,6 +87,7 @@ columns:
generated: false
name: AVG_ROW_LENGTH
primaryKey: false
+ unsigned: true
visible: true
data_length:
caseSensitive: false
@@ -86,6 +95,7 @@ columns:
generated: false
name: DATA_LENGTH
primaryKey: false
+ unsigned: true
visible: true
max_data_length:
caseSensitive: false
@@ -93,6 +103,7 @@ columns:
generated: false
name: MAX_DATA_LENGTH
primaryKey: false
+ unsigned: true
visible: true
index_length:
caseSensitive: false
@@ -100,6 +111,7 @@ columns:
generated: false
name: INDEX_LENGTH
primaryKey: false
+ unsigned: true
visible: true
data_free:
caseSensitive: false
@@ -107,6 +119,7 @@ columns:
generated: false
name: DATA_FREE
primaryKey: false
+ unsigned: true
visible: true
auto_increment:
caseSensitive: false
@@ -114,6 +127,7 @@ columns:
generated: false
name: AUTO_INCREMENT
primaryKey: false
+ unsigned: true
visible: true
create_time:
caseSensitive: false
@@ -121,6 +135,7 @@ columns:
generated: false
name: CREATE_TIME
primaryKey: false
+ unsigned: false
visible: true
update_time:
caseSensitive: false
@@ -128,6 +143,7 @@ columns:
generated: false
name: UPDATE_TIME
primaryKey: false
+ unsigned: false
visible: true
check_time:
caseSensitive: false
@@ -135,6 +151,7 @@ columns:
generated: false
name: CHECK_TIME
primaryKey: false
+ unsigned: false
visible: true
table_collation:
caseSensitive: false
@@ -142,6 +159,7 @@ columns:
generated: false
name: TABLE_COLLATION
primaryKey: false
+ unsigned: false
visible: true
checksum:
caseSensitive: false
@@ -149,6 +167,7 @@ columns:
generated: false
name: CHECKSUM
primaryKey: false
+ unsigned: true
visible: true
create_options:
caseSensitive: false
@@ -156,6 +175,7 @@ columns:
generated: false
name: CREATE_OPTIONS
primaryKey: false
+ unsigned: false
visible: true
table_comment:
caseSensitive: false
@@ -163,4 +183,5 @@ columns:
generated: false
name: TABLE_COMMENT
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/main/resources/schema/mysql/information_schema/views.yaml
b/infra/common/src/main/resources/schema/mysql/information_schema/views.yaml
index e526362ba78..4369f783765 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/views.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/views.yaml
@@ -23,6 +23,7 @@ columns:
generated: false
name: TABLE_CATALOG
primaryKey: false
+ unsigned: false
visible: true
table_schema:
caseSensitive: false
@@ -30,6 +31,7 @@ columns:
generated: false
name: TABLE_SCHEMA
primaryKey: false
+ unsigned: false
visible: true
table_name:
caseSensitive: false
@@ -37,6 +39,7 @@ columns:
generated: false
name: TABLE_NAME
primaryKey: false
+ unsigned: false
visible: true
view_definition:
caseSensitive: false
@@ -44,6 +47,7 @@ columns:
generated: false
name: VIEW_DEFINITION
primaryKey: false
+ unsigned: false
visible: true
check_option:
caseSensitive: false
@@ -51,6 +55,7 @@ columns:
generated: false
name: CHECK_OPTION
primaryKey: false
+ unsigned: false
visible: true
is_updatable:
caseSensitive: false
@@ -58,6 +63,7 @@ columns:
generated: false
name: IS_UPDATABLE
primaryKey: false
+ unsigned: false
visible: true
definer:
caseSensitive: false
@@ -65,6 +71,7 @@ columns:
generated: false
name: DEFINER
primaryKey: false
+ unsigned: false
visible: true
security_type:
caseSensitive: false
@@ -72,6 +79,7 @@ columns:
generated: false
name: SECURITY_TYPE
primaryKey: false
+ unsigned: false
visible: true
character_set_client:
caseSensitive: false
@@ -79,6 +87,7 @@ columns:
generated: false
name: CHARACTER_SET_CLIENT
primaryKey: false
+ unsigned: false
visible: true
collation_connection:
caseSensitive: false
@@ -86,4 +95,5 @@ columns:
generated: false
name: COLLATION_CONNECTION
primaryKey: false
+ unsigned: false
visible: true
diff --git
a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRuleTest.java
b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRuleTest.java
index b2c253d7d46..daf5f486fdb 100644
---
a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRuleTest.java
+++
b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderRuleTest.java
@@ -20,9 +20,6 @@ package
org.apache.shardingsphere.infra.metadata.database.schema.builder;
import org.apache.shardingsphere.infra.database.type.dialect.MySQLDatabaseType;
import org.junit.jupiter.api.Test;
-import java.util.Arrays;
-import java.util.HashSet;
-
import static org.hamcrest.CoreMatchers.is;
import static org.hamcrest.MatcherAssert.assertThat;
import static org.junit.jupiter.api.Assertions.assertFalse;
@@ -35,7 +32,7 @@ public final class SystemSchemaBuilderRuleTest {
public void assertValueOfSchemaPathSuccess() {
SystemSchemaBuilderRule actual = SystemSchemaBuilderRule.valueOf(new
MySQLDatabaseType().getType(), "information_schema");
assertThat(actual,
is(SystemSchemaBuilderRule.MYSQL_INFORMATION_SCHEMA));
- assertThat(actual.getTables(), is(new
HashSet<>(Arrays.asList("columns", "engines", "parameters", "routines",
"schemata", "tables", "views"))));
+ assertThat(actual.getTables().size(), is(15));
}
@Test
diff --git
a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java
b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java
index d2f05f73216..42197fe371e 100644
---
a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java
+++
b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/schema/builder/SystemSchemaBuilderTest.java
@@ -36,7 +36,7 @@ public final class SystemSchemaBuilderTest {
Map<String, ShardingSphereSchema> actual =
SystemSchemaBuilder.build("information_schema", new MySQLDatabaseType());
assertThat(actual.size(), is(1));
assertTrue(actual.containsKey("information_schema"));
- assertThat(actual.get("information_schema").getTables().size(), is(7));
+ assertThat(actual.get("information_schema").getTables().size(),
is(15));
}
@Test
