You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/03/26 05:38:57 UTC
[shardingsphere] branch master updated: Add mysql information schema tables (#24823)
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 680795db876 Add mysql information schema tables (#24823)
680795db876 is described below
commit 680795db876b2182d8b67f9671ce36f2fc920b5d
Author: ZhangCheng <fl...@outlook.com>
AuthorDate: Sun Mar 26 13:38:48 2023 +0800
Add mysql information schema tables (#24823)
* Add mysql information schema tables
* Add mysql information schema tables
* Add mysql information schema tables
---
.../schema/builder/SystemSchemaBuilderRule.java | 4 +-
.../mysql/information_schema/character_sets.yaml | 2 +-
.../mysql/information_schema/collations.yaml | 4 +-
.../schema/mysql/information_schema/columns.yaml | 12 +-
.../schema/mysql/information_schema/events.yaml | 2 +-
.../schema/mysql/information_schema/files.yaml | 40 ++--
.../{tables.yaml => innodb_buffer_page.yaml} | 146 ++++++-------
.../{tables.yaml => innodb_buffer_page_lru.yaml} | 146 ++++++-------
...routines.yaml => innodb_buffer_pool_stats.yaml} | 234 +++++++++++----------
.../{collations.yaml => innodb_cmp.yaml} | 38 ++--
.../{collations.yaml => innodb_cmp_per_index.yaml} | 50 +++--
...ations.yaml => innodb_cmp_per_index_reset.yaml} | 50 +++--
.../{collations.yaml => innodb_cmp_reset.yaml} | 38 ++--
.../{collations.yaml => innodb_cmpmem.yaml} | 38 ++--
.../{collations.yaml => innodb_cmpmem_reset.yaml} | 38 ++--
...cter_sets.yaml => innodb_ft_being_deleted.yaml} | 34 +--
.../mysql/information_schema/parameters.yaml | 4 +-
.../schema/mysql/information_schema/routines.yaml | 4 +-
.../schema/mysql/information_schema/tables.yaml | 18 +-
.../builder/SystemSchemaBuilderRuleTest.java | 2 +-
.../schema/builder/SystemSchemaBuilderTest.java | 2 +-
...mysql_information_schema_innodb_buffer_page.xml | 41 ++++
...l_information_schema_innodb_buffer_page_lru.xml | 41 ++++
...information_schema_innodb_buffer_pool_stats.xml | 53 +++++
.../select_mysql_information_schema_innodb_cmp.xml | 27 +++
...sql_information_schema_innodb_cmp_per_index.xml | 29 +++
...formation_schema_innodb_cmp_per_index_reset.xml | 29 +++
...t_mysql_information_schema_innodb_cmp_reset.xml | 27 +++
...lect_mysql_information_schema_innodb_cmpmem.xml | 27 +++
...ysql_information_schema_innodb_cmpmem_reset.xml | 27 +++
..._information_schema_innodb_ft_being_deleted.xml | 22 ++
.../dql/dataset/db/select_sys_data_for_og.xml | 2 +-
.../dql/dql-integration-select-system-schema.xml | 88 ++++++++
33 files changed, 866 insertions(+), 453 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 8e2bd5e8449..c16581928e3 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
@@ -36,7 +36,9 @@ import java.util.Map;
public enum SystemSchemaBuilderRule {
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"))),
+ "engines", "events", "files", "global_status", "global_variables", "parameters", "routines", "schemata", "tables", "views",
+ "innodb_buffer_page", "innodb_buffer_page_lru", "innodb_buffer_pool_stats", "innodb_cmp", "innodb_cmp_per_index", "innodb_cmp_per_index_reset", "innodb_cmp_reset",
+ "innodb_cmpmem", "innodb_cmpmem_reset", "innodb_ft_being_deleted"))),
MYSQL_MYSQL("MySQL", "mysql", new HashSet<>(Collections.singleton("db"))),
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/character_sets.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/character_sets.yaml
index 661a3426e79..2ed32815310 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/character_sets.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/character_sets.yaml
@@ -43,7 +43,7 @@ columns:
visible: true
maxlen:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: MAXLEN
primaryKey: false
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
index 96a394a1477..1409b418389 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
@@ -35,7 +35,7 @@ columns:
visible: true
id:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: ID
primaryKey: false
@@ -59,7 +59,7 @@ columns:
visible: true
sortlen:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: SORTLEN
primaryKey: false
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 faa76b4cc4a..b38d0dbc4a7 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
@@ -51,7 +51,7 @@ columns:
visible: true
ordinal_position:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: ORDINAL_POSITION
primaryKey: false
@@ -83,7 +83,7 @@ columns:
visible: true
character_maximum_length:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: CHARACTER_MAXIMUM_LENGTH
primaryKey: false
@@ -91,7 +91,7 @@ columns:
visible: true
character_octet_length:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: CHARACTER_OCTET_LENGTH
primaryKey: false
@@ -99,7 +99,7 @@ columns:
visible: true
numeric_precision:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: NUMERIC_PRECISION
primaryKey: false
@@ -107,7 +107,7 @@ columns:
visible: true
numeric_scale:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: NUMERIC_SCALE
primaryKey: false
@@ -115,7 +115,7 @@ columns:
visible: true
datetime_precision:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: DATETIME_PRECISION
primaryKey: false
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/events.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/events.yaml
index 0272cb7660d..ded0b318ebc 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/events.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/events.yaml
@@ -179,7 +179,7 @@ columns:
visible: true
originator:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: ORIGINATOR
primaryKey: false
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/files.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/files.yaml
index 5d6a9c4d40a..bf8fbf90128 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/files.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/files.yaml
@@ -19,7 +19,7 @@ name: FILES
columns:
file_id:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: FILE_ID
primaryKey: false
@@ -83,7 +83,7 @@ columns:
visible: true
logfile_group_number:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: LOGFILE_GROUP_NUMBER
primaryKey: false
@@ -107,7 +107,7 @@ columns:
visible: true
deleted_rows:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: DELETED_ROWS
primaryKey: false
@@ -115,7 +115,7 @@ columns:
visible: true
update_count:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: UPDATE_COUNT
primaryKey: false
@@ -123,7 +123,7 @@ columns:
visible: true
free_extents:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: FREE_EXTENTS
primaryKey: false
@@ -131,7 +131,7 @@ columns:
visible: true
total_extents:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: TOTAL_EXTENTS
primaryKey: false
@@ -139,7 +139,7 @@ columns:
visible: true
extent_size:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: EXTENT_SIZE
primaryKey: false
@@ -147,7 +147,7 @@ columns:
visible: true
initial_size:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: INITIAL_SIZE
primaryKey: false
@@ -155,7 +155,7 @@ columns:
visible: true
maximum_size:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: MAXIMUM_SIZE
primaryKey: false
@@ -163,7 +163,7 @@ columns:
visible: true
autoextend_size:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: AUTOEXTEND_SIZE
primaryKey: false
@@ -195,7 +195,7 @@ columns:
visible: true
recover_time:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: RECOVER_TIME
primaryKey: false
@@ -203,7 +203,7 @@ columns:
visible: true
transaction_counter:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: TRANSACTION_COUNTER
primaryKey: false
@@ -211,7 +211,7 @@ columns:
visible: true
version:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: VERSION
primaryKey: false
@@ -227,7 +227,7 @@ columns:
visible: true
table_rows:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: TABLE_ROWS
primaryKey: false
@@ -235,7 +235,7 @@ columns:
visible: true
avg_row_length:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: AVG_ROW_LENGTH
primaryKey: false
@@ -243,7 +243,7 @@ columns:
visible: true
data_length:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: DATA_LENGTH
primaryKey: false
@@ -251,7 +251,7 @@ columns:
visible: true
max_data_length:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: MAX_DATA_LENGTH
primaryKey: false
@@ -259,7 +259,7 @@ columns:
visible: true
index_length:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: INDEX_LENGTH
primaryKey: false
@@ -267,7 +267,7 @@ columns:
visible: true
data_free:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: DATA_FREE
primaryKey: false
@@ -299,7 +299,7 @@ columns:
visible: true
checksum:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: CHECKSUM
primaryKey: false
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/tables.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_buffer_page.yaml
similarity index 71%
copy from infra/common/src/main/resources/schema/mysql/information_schema/tables.yaml
copy to infra/common/src/main/resources/schema/mysql/information_schema/innodb_buffer_page.yaml
index d9a5b9122ae..9b5afd01bfa 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/tables.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_buffer_page.yaml
@@ -15,173 +15,165 @@
# limitations under the License.
#
-name: TABLES
+name: INNODB_BUFFER_PAGE
columns:
- table_catalog:
+ pool_id:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: TABLE_CATALOG
+ name: POOL_ID
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- table_schema:
+ block_id:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: TABLE_SCHEMA
+ name: BLOCK_ID
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- table_name:
+ space:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: TABLE_NAME
+ name: SPACE
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- table_type:
+ page_number:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: TABLE_TYPE
+ name: PAGE_NUMBER
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- engine:
+ page_type:
caseSensitive: false
dataType: 12
generated: false
- name: ENGINE
+ name: PAGE_TYPE
primaryKey: false
unsigned: false
visible: true
- version:
+ flush_type:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: VERSION
+ name: FLUSH_TYPE
primaryKey: false
unsigned: true
visible: true
- row_format:
+ fix_count:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: ROW_FORMAT
+ name: FIX_COUNT
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- table_rows:
+ is_hashed:
caseSensitive: false
- dataType: -5
+ dataType: 12
generated: false
- name: TABLE_ROWS
+ name: IS_HASHED
primaryKey: false
- unsigned: true
+ unsigned: false
visible: true
- avg_row_length:
+ newest_modification:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: AVG_ROW_LENGTH
+ name: NEWEST_MODIFICATION
primaryKey: false
unsigned: true
visible: true
- data_length:
+ oldest_modification:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: DATA_LENGTH
+ name: OLDEST_MODIFICATION
primaryKey: false
unsigned: true
visible: true
- max_data_length:
+ access_time:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: MAX_DATA_LENGTH
+ name: ACCESS_TIME
primaryKey: false
unsigned: true
visible: true
- index_length:
+ table_name:
caseSensitive: false
- dataType: -5
+ dataType: 12
generated: false
- name: INDEX_LENGTH
+ name: TABLE_NAME
primaryKey: false
- unsigned: true
+ unsigned: false
visible: true
- data_free:
+ index_name:
caseSensitive: false
- dataType: -5
+ dataType: 12
generated: false
- name: DATA_FREE
+ name: INDEX_NAME
primaryKey: false
- unsigned: true
+ unsigned: false
visible: true
- auto_increment:
+ number_records:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: AUTO_INCREMENT
+ name: NUMBER_RECORDS
primaryKey: false
unsigned: true
visible: true
- create_time:
+ data_size:
caseSensitive: false
- dataType: 93
+ dataType: 4
generated: false
- name: CREATE_TIME
+ name: DATA_SIZE
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- update_time:
+ compressed_size:
caseSensitive: false
- dataType: 93
+ dataType: 4
generated: false
- name: UPDATE_TIME
+ name: COMPRESSED_SIZE
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- check_time:
+ page_state:
caseSensitive: false
- dataType: 93
+ dataType: 12
generated: false
- name: CHECK_TIME
+ name: PAGE_STATE
primaryKey: false
unsigned: false
visible: true
- table_collation:
+ io_fix:
caseSensitive: false
dataType: 12
generated: false
- name: TABLE_COLLATION
+ name: IO_FIX
primaryKey: false
unsigned: false
visible: true
- checksum:
- caseSensitive: false
- dataType: -5
- generated: false
- name: CHECKSUM
- primaryKey: false
- unsigned: true
- visible: true
- create_options:
+ is_old:
caseSensitive: false
dataType: 12
generated: false
- name: CREATE_OPTIONS
+ name: IS_OLD
primaryKey: false
unsigned: false
visible: true
- table_comment:
+ free_page_clock:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: TABLE_COMMENT
+ name: FREE_PAGE_CLOCK
primaryKey: false
- unsigned: false
+ unsigned: true
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/innodb_buffer_page_lru.yaml
similarity index 71%
copy from infra/common/src/main/resources/schema/mysql/information_schema/tables.yaml
copy to infra/common/src/main/resources/schema/mysql/information_schema/innodb_buffer_page_lru.yaml
index d9a5b9122ae..653bd5cc894 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/tables.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_buffer_page_lru.yaml
@@ -15,173 +15,165 @@
# limitations under the License.
#
-name: TABLES
+name: INNODB_BUFFER_PAGE_LRU
columns:
- table_catalog:
+ pool_id:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: TABLE_CATALOG
+ name: POOL_ID
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- table_schema:
+ lru_position:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: TABLE_SCHEMA
+ name: LRU_POSITION
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- table_name:
+ space:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: TABLE_NAME
+ name: SPACE
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- table_type:
+ page_number:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: TABLE_TYPE
+ name: PAGE_NUMBER
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- engine:
+ page_type:
caseSensitive: false
dataType: 12
generated: false
- name: ENGINE
+ name: PAGE_TYPE
primaryKey: false
unsigned: false
visible: true
- version:
+ flush_type:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: VERSION
+ name: FLUSH_TYPE
primaryKey: false
unsigned: true
visible: true
- row_format:
+ fix_count:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: ROW_FORMAT
+ name: FIX_COUNT
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- table_rows:
+ is_hashed:
caseSensitive: false
- dataType: -5
+ dataType: 12
generated: false
- name: TABLE_ROWS
+ name: IS_HASHED
primaryKey: false
- unsigned: true
+ unsigned: false
visible: true
- avg_row_length:
+ newest_modification:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: AVG_ROW_LENGTH
+ name: NEWEST_MODIFICATION
primaryKey: false
unsigned: true
visible: true
- data_length:
+ oldest_modification:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: DATA_LENGTH
+ name: OLDEST_MODIFICATION
primaryKey: false
unsigned: true
visible: true
- max_data_length:
+ access_time:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: MAX_DATA_LENGTH
+ name: ACCESS_TIME
primaryKey: false
unsigned: true
visible: true
- index_length:
+ table_name:
caseSensitive: false
- dataType: -5
+ dataType: 12
generated: false
- name: INDEX_LENGTH
+ name: TABLE_NAME
primaryKey: false
- unsigned: true
+ unsigned: false
visible: true
- data_free:
+ index_name:
caseSensitive: false
- dataType: -5
+ dataType: 12
generated: false
- name: DATA_FREE
+ name: INDEX_NAME
primaryKey: false
- unsigned: true
+ unsigned: false
visible: true
- auto_increment:
+ number_records:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: AUTO_INCREMENT
+ name: NUMBER_RECORDS
primaryKey: false
unsigned: true
visible: true
- create_time:
+ data_size:
caseSensitive: false
- dataType: 93
+ dataType: 4
generated: false
- name: CREATE_TIME
+ name: DATA_SIZE
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- update_time:
+ compressed_size:
caseSensitive: false
- dataType: 93
+ dataType: 4
generated: false
- name: UPDATE_TIME
+ name: COMPRESSED_SIZE
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- check_time:
+ compressed:
caseSensitive: false
- dataType: 93
+ dataType: 12
generated: false
- name: CHECK_TIME
+ name: COMPRESSED
primaryKey: false
unsigned: false
visible: true
- table_collation:
+ io_fix:
caseSensitive: false
dataType: 12
generated: false
- name: TABLE_COLLATION
+ name: IO_FIX
primaryKey: false
unsigned: false
visible: true
- checksum:
- caseSensitive: false
- dataType: -5
- generated: false
- name: CHECKSUM
- primaryKey: false
- unsigned: true
- visible: true
- create_options:
+ is_old:
caseSensitive: false
dataType: 12
generated: false
- name: CREATE_OPTIONS
+ name: IS_OLD
primaryKey: false
unsigned: false
visible: true
- table_comment:
+ free_page_clock:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: TABLE_COMMENT
+ name: FREE_PAGE_CLOCK
primaryKey: false
- unsigned: false
+ unsigned: true
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/innodb_buffer_pool_stats.yaml
similarity index 58%
copy from infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
copy to infra/common/src/main/resources/schema/mysql/information_schema/innodb_buffer_pool_stats.yaml
index 1a5c230e670..1c3ae313484 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/routines.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_buffer_pool_stats.yaml
@@ -15,253 +15,261 @@
# limitations under the License.
#
-name: ROUTINES
+name: INNODB_BUFFER_POOL_STATS
columns:
- specific_name:
+ pool_id:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: SPECIFIC_NAME
+ name: POOL_ID
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- routine_catalog:
+ pool_size:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: ROUTINE_CATALOG
+ name: POOL_SIZE
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- routine_schema:
+ free_buffers:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: ROUTINE_SCHEMA
+ name: FREE_BUFFERS
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- routine_name:
+ database_pages:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: ROUTINE_NAME
+ name: DATABASE_PAGES
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- routine_type:
+ old_database_pages:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: ROUTINE_TYPE
+ name: OLD_DATABASE_PAGES
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- data_type:
+ modified_database_pages:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: DATA_TYPE
+ name: MODIFIED_DATABASE_PAGES
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- character_maximum_length:
+ pending_decompress:
caseSensitive: false
dataType: 4
generated: false
- name: CHARACTER_MAXIMUM_LENGTH
+ name: PENDING_DECOMPRESS
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- character_octet_length:
+ pending_reads:
caseSensitive: false
dataType: 4
generated: false
- name: CHARACTER_OCTET_LENGTH
+ name: PENDING_READS
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- numeric_precision:
+ pending_flush_lru:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: NUMERIC_PRECISION
+ name: PENDING_FLUSH_LRU
primaryKey: false
unsigned: true
visible: true
- numeric_scale:
+ pending_flush_list:
caseSensitive: false
dataType: 4
generated: false
- name: NUMERIC_SCALE
+ name: PENDING_FLUSH_LIST
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- datetime_precision:
+ pages_made_young:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: DATETIME_PRECISION
+ name: PAGES_MADE_YOUNG
primaryKey: false
unsigned: true
visible: true
- character_set_name:
+ pages_not_made_young:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: CHARACTER_SET_NAME
+ name: PAGES_NOT_MADE_YOUNG
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- collation_name:
+ pages_made_young_rate:
caseSensitive: false
- dataType: 12
+ dataType: 8
generated: false
- name: COLLATION_NAME
+ name: PAGES_MADE_YOUNG_RATE
primaryKey: false
unsigned: false
visible: true
- dtd_identifier:
+ pages_made_not_young_rate:
caseSensitive: false
- dataType: -1
+ dataType: 8
generated: false
- name: DTD_IDENTIFIER
+ name: PAGES_MADE_NOT_YOUNG_RATE
primaryKey: false
unsigned: false
visible: true
- routine_body:
+ number_pages_read:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: ROUTINE_BODY
+ name: NUMBER_PAGES_READ
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- routine_definition:
+ number_pages_created:
caseSensitive: false
- dataType: -1
+ dataType: 4
generated: false
- name: ROUTINE_DEFINITION
+ name: NUMBER_PAGES_CREATED
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- external_name:
+ number_pages_written:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: EXTERNAL_NAME
+ name: NUMBER_PAGES_WRITTEN
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- external_language:
+ pages_read_rate:
caseSensitive: false
- dataType: 12
+ dataType: 8
generated: false
- name: EXTERNAL_LANGUAGE
+ name: PAGES_READ_RATE
primaryKey: false
unsigned: false
visible: true
- parameter_style:
+ pages_create_rate:
caseSensitive: false
- dataType: 12
+ dataType: 8
generated: false
- name: PARAMETER_STYLE
+ name: PAGES_CREATE_RATE
primaryKey: false
unsigned: false
visible: true
- is_deterministic:
+ pages_written_rate:
caseSensitive: false
- dataType: 12
+ dataType: 8
generated: false
- name: IS_DETERMINISTIC
+ name: PAGES_WRITTEN_RATE
primaryKey: false
unsigned: false
visible: true
- sql_data_access:
+ number_pages_get:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: SQL_DATA_ACCESS
+ name: NUMBER_PAGES_GET
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- sql_path:
+ hit_rate:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: SQL_PATH
+ name: HIT_RATE
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- security_type:
+ young_make_per_thousand_gets:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: SECURITY_TYPE
+ name: YOUNG_MAKE_PER_THOUSAND_GETS
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- created:
+ not_young_make_per_thousand_gets:
caseSensitive: false
- dataType: 93
+ dataType: 4
generated: false
- name: CREATED
+ name: NOT_YOUNG_MAKE_PER_THOUSAND_GETS
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- last_altered:
+ number_pages_read_ahead:
caseSensitive: false
- dataType: 93
+ dataType: 4
generated: false
- name: LAST_ALTERED
+ name: NUMBER_PAGES_READ_AHEAD
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- sql_mode:
+ number_read_ahead_evicted:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: SQL_MODE
+ name: NUMBER_READ_AHEAD_EVICTED
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- routine_comment:
+ read_ahead_rate:
caseSensitive: false
- dataType: -1
+ dataType: 8
generated: false
- name: ROUTINE_COMMENT
+ name: READ_AHEAD_RATE
primaryKey: false
unsigned: false
visible: true
- definer:
+ read_ahead_evicted_rate:
caseSensitive: false
- dataType: 12
+ dataType: 8
generated: false
- name: DEFINER
+ name: READ_AHEAD_EVICTED_RATE
primaryKey: false
unsigned: false
visible: true
- character_set_client:
+ lru_io_total:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: CHARACTER_SET_CLIENT
+ name: LRU_IO_TOTAL
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- collation_connection:
+ lru_io_current:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: COLLATION_CONNECTION
+ name: LRU_IO_CURRENT
primaryKey: false
- unsigned: false
+ unsigned: true
visible: true
- database_collation:
+ uncompress_total:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: DATABASE_COLLATION
+ name: UNCOMPRESS_TOTAL
primaryKey: false
- unsigned: false
+ unsigned: true
+ visible: true
+ uncompress_current:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: UNCOMPRESS_CURRENT
+ primaryKey: false
+ unsigned: true
visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp.yaml
similarity index 79%
copy from infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
copy to infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp.yaml
index 96a394a1477..6424b9005f0 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp.yaml
@@ -15,53 +15,53 @@
# limitations under the License.
#
-name: COLLATIONS
+name: INNODB_CMP
columns:
- collation_name:
+ page_size:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: COLLATION_NAME
+ name: page_size
primaryKey: false
unsigned: false
visible: true
- character_set_name:
+ compress_ops:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: CHARACTER_SET_NAME
+ name: compress_ops
primaryKey: false
unsigned: false
visible: true
- id:
+ compress_ops_ok:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: ID
+ name: compress_ops_ok
primaryKey: false
unsigned: false
visible: true
- is_default:
+ compress_time:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: IS_DEFAULT
+ name: compress_time
primaryKey: false
unsigned: false
visible: true
- is_compiled:
+ uncompress_ops:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: IS_COMPILED
+ name: uncompress_ops
primaryKey: false
unsigned: false
visible: true
- sortlen:
+ uncompress_time:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: SORTLEN
+ name: uncompress_time
primaryKey: false
unsigned: false
visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp_per_index.yaml
similarity index 69%
copy from infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
copy to infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp_per_index.yaml
index 96a394a1477..0bf0963227f 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp_per_index.yaml
@@ -15,53 +15,69 @@
# limitations under the License.
#
-name: COLLATIONS
+name: INNODB_CMP_PER_INDEX
columns:
- collation_name:
+ database_name:
caseSensitive: false
dataType: 12
generated: false
- name: COLLATION_NAME
+ name: database_name
primaryKey: false
unsigned: false
visible: true
- character_set_name:
+ table_name:
caseSensitive: false
dataType: 12
generated: false
- name: CHARACTER_SET_NAME
+ name: table_name
primaryKey: false
unsigned: false
visible: true
- id:
+ index_name:
caseSensitive: false
- dataType: -5
+ dataType: 12
generated: false
- name: ID
+ name: index_name
primaryKey: false
unsigned: false
visible: true
- is_default:
+ compress_ops:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: IS_DEFAULT
+ name: compress_ops
primaryKey: false
unsigned: false
visible: true
- is_compiled:
+ compress_ops_ok:
caseSensitive: false
- dataType: 12
+ dataType: 4
+ generated: false
+ name: compress_ops_ok
+ primaryKey: false
+ unsigned: false
+ visible: true
+ compress_time:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: compress_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ uncompress_ops:
+ caseSensitive: false
+ dataType: 4
generated: false
- name: IS_COMPILED
+ name: uncompress_ops
primaryKey: false
unsigned: false
visible: true
- sortlen:
+ uncompress_time:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: SORTLEN
+ name: uncompress_time
primaryKey: false
unsigned: false
visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp_per_index_reset.yaml
similarity index 69%
copy from infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
copy to infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp_per_index_reset.yaml
index 96a394a1477..0cbcb94a1d4 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp_per_index_reset.yaml
@@ -15,53 +15,69 @@
# limitations under the License.
#
-name: COLLATIONS
+name: INNODB_CMP_PER_INDEX_RESET
columns:
- collation_name:
+ database_name:
caseSensitive: false
dataType: 12
generated: false
- name: COLLATION_NAME
+ name: database_name
primaryKey: false
unsigned: false
visible: true
- character_set_name:
+ table_name:
caseSensitive: false
dataType: 12
generated: false
- name: CHARACTER_SET_NAME
+ name: table_name
primaryKey: false
unsigned: false
visible: true
- id:
+ index_name:
caseSensitive: false
- dataType: -5
+ dataType: 12
generated: false
- name: ID
+ name: index_name
primaryKey: false
unsigned: false
visible: true
- is_default:
+ compress_ops:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: IS_DEFAULT
+ name: compress_ops
primaryKey: false
unsigned: false
visible: true
- is_compiled:
+ compress_ops_ok:
caseSensitive: false
- dataType: 12
+ dataType: 4
+ generated: false
+ name: compress_ops_ok
+ primaryKey: false
+ unsigned: false
+ visible: true
+ compress_time:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: compress_time
+ primaryKey: false
+ unsigned: false
+ visible: true
+ uncompress_ops:
+ caseSensitive: false
+ dataType: 4
generated: false
- name: IS_COMPILED
+ name: uncompress_ops
primaryKey: false
unsigned: false
visible: true
- sortlen:
+ uncompress_time:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: SORTLEN
+ name: uncompress_time
primaryKey: false
unsigned: false
visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp_reset.yaml
similarity index 79%
copy from infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
copy to infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp_reset.yaml
index 96a394a1477..f9f18ce8961 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmp_reset.yaml
@@ -15,53 +15,53 @@
# limitations under the License.
#
-name: COLLATIONS
+name: INNODB_CMP_RESET
columns:
- collation_name:
+ page_size:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: COLLATION_NAME
+ name: page_size
primaryKey: false
unsigned: false
visible: true
- character_set_name:
+ compress_ops:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: CHARACTER_SET_NAME
+ name: compress_ops
primaryKey: false
unsigned: false
visible: true
- id:
+ compress_ops_ok:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: ID
+ name: compress_ops_ok
primaryKey: false
unsigned: false
visible: true
- is_default:
+ compress_time:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: IS_DEFAULT
+ name: compress_time
primaryKey: false
unsigned: false
visible: true
- is_compiled:
+ uncompress_ops:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: IS_COMPILED
+ name: uncompress_ops
primaryKey: false
unsigned: false
visible: true
- sortlen:
+ uncompress_time:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: SORTLEN
+ name: uncompress_time
primaryKey: false
unsigned: false
visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmpmem.yaml
similarity index 79%
copy from infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
copy to infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmpmem.yaml
index 96a394a1477..538b3b56016 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmpmem.yaml
@@ -15,53 +15,53 @@
# limitations under the License.
#
-name: COLLATIONS
+name: INNODB_CMPMEM
columns:
- collation_name:
+ page_size:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: COLLATION_NAME
+ name: page_size
primaryKey: false
unsigned: false
visible: true
- character_set_name:
+ buffer_pool_instance:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: CHARACTER_SET_NAME
+ name: buffer_pool_instance
primaryKey: false
unsigned: false
visible: true
- id:
+ pages_used:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: ID
+ name: pages_used
primaryKey: false
unsigned: false
visible: true
- is_default:
+ pages_free:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: IS_DEFAULT
+ name: pages_free
primaryKey: false
unsigned: false
visible: true
- is_compiled:
+ relocation_ops:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: IS_COMPILED
+ name: relocation_ops
primaryKey: false
unsigned: false
visible: true
- sortlen:
+ relocation_time:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: SORTLEN
+ name: relocation_time
primaryKey: false
unsigned: false
visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmpmem_reset.yaml
similarity index 79%
copy from infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
copy to infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmpmem_reset.yaml
index 96a394a1477..fbd9c737e44 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/collations.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_cmpmem_reset.yaml
@@ -15,53 +15,53 @@
# limitations under the License.
#
-name: COLLATIONS
+name: INNODB_CMPMEM_RESET
columns:
- collation_name:
+ page_size:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: COLLATION_NAME
+ name: page_size
primaryKey: false
unsigned: false
visible: true
- character_set_name:
+ buffer_pool_instance:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: CHARACTER_SET_NAME
+ name: buffer_pool_instance
primaryKey: false
unsigned: false
visible: true
- id:
+ pages_used:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: ID
+ name: pages_used
primaryKey: false
unsigned: false
visible: true
- is_default:
+ pages_free:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: IS_DEFAULT
+ name: pages_free
primaryKey: false
unsigned: false
visible: true
- is_compiled:
+ relocation_ops:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: IS_COMPILED
+ name: relocation_ops
primaryKey: false
unsigned: false
visible: true
- sortlen:
+ relocation_time:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
- name: SORTLEN
+ name: relocation_time
primaryKey: false
unsigned: false
visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/character_sets.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_ft_being_deleted.yaml
similarity index 59%
copy from infra/common/src/main/resources/schema/mysql/information_schema/character_sets.yaml
copy to infra/common/src/main/resources/schema/mysql/information_schema/innodb_ft_being_deleted.yaml
index 661a3426e79..a849d1ea602 100644
--- a/infra/common/src/main/resources/schema/mysql/information_schema/character_sets.yaml
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_ft_being_deleted.yaml
@@ -15,37 +15,13 @@
# limitations under the License.
#
-name: CHARACTER_SETS
+name: INNODB_FT_BEING_DELETED
columns:
- character_set_name:
+ doc_id:
caseSensitive: false
- dataType: 12
+ dataType: 4
generated: false
- name: CHARACTER_SET_NAME
+ name: DOC_ID
primaryKey: false
- unsigned: false
- visible: true
- default_collate_name:
- caseSensitive: false
- dataType: 12
- generated: false
- name: DEFAULT_COLLATE_NAME
- primaryKey: false
- unsigned: false
- visible: true
- description:
- caseSensitive: false
- dataType: 12
- generated: false
- name: DESCRIPTION
- primaryKey: false
- unsigned: false
- visible: true
- maxlen:
- caseSensitive: false
- dataType: -5
- generated: false
- name: MAXLEN
- primaryKey: false
- unsigned: false
+ unsigned: true
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 18334ac6ada..165afb88ab3 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
@@ -91,7 +91,7 @@ columns:
visible: true
numeric_precision:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: NUMERIC_PRECISION
primaryKey: false
@@ -107,7 +107,7 @@ columns:
visible: true
datetime_precision:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: DATETIME_PRECISION
primaryKey: false
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 1a5c230e670..6aaa2c4d356 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
@@ -83,7 +83,7 @@ columns:
visible: true
numeric_precision:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: NUMERIC_PRECISION
primaryKey: false
@@ -99,7 +99,7 @@ columns:
visible: true
datetime_precision:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: DATETIME_PRECISION
primaryKey: false
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 d9a5b9122ae..d8a3673daa2 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
@@ -59,7 +59,7 @@ columns:
visible: true
version:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: VERSION
primaryKey: false
@@ -75,7 +75,7 @@ columns:
visible: true
table_rows:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: TABLE_ROWS
primaryKey: false
@@ -83,7 +83,7 @@ columns:
visible: true
avg_row_length:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: AVG_ROW_LENGTH
primaryKey: false
@@ -91,7 +91,7 @@ columns:
visible: true
data_length:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: DATA_LENGTH
primaryKey: false
@@ -99,7 +99,7 @@ columns:
visible: true
max_data_length:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: MAX_DATA_LENGTH
primaryKey: false
@@ -107,7 +107,7 @@ columns:
visible: true
index_length:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: INDEX_LENGTH
primaryKey: false
@@ -115,7 +115,7 @@ columns:
visible: true
data_free:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: DATA_FREE
primaryKey: false
@@ -123,7 +123,7 @@ columns:
visible: true
auto_increment:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: AUTO_INCREMENT
primaryKey: false
@@ -163,7 +163,7 @@ columns:
visible: true
checksum:
caseSensitive: false
- dataType: -5
+ dataType: 4
generated: false
name: CHECKSUM
primaryKey: false
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 29e566be6e8..c4466c918ce 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
@@ -32,7 +32,7 @@ class SystemSchemaBuilderRuleTest {
void assertValueOfSchemaPathSuccess() {
SystemSchemaBuilderRule actual = SystemSchemaBuilderRule.valueOf(new MySQLDatabaseType().getType(), "information_schema");
assertThat(actual, is(SystemSchemaBuilderRule.MYSQL_INFORMATION_SCHEMA));
- assertThat(actual.getTables().size(), is(15));
+ assertThat(actual.getTables().size(), is(25));
}
@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 a756998b270..7572b3f818e 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 @@ 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(15));
+ assertThat(actual.get("information_schema").getTables().size(), is(25));
}
@Test
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_buffer_page.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_buffer_page.xml
new file mode 100644
index 00000000000..8797dc7342e
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_buffer_page.xml
@@ -0,0 +1,41 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="pool_id" />
+ <column name="block_id" />
+ <column name="space" />
+ <column name="page_number" />
+ <column name="page_type" />
+ <column name="flush_type" />
+ <column name="fix_count" />
+ <column name="is_hashed" />
+ <column name="newest_modification" />
+ <column name="oldest_modification" />
+ <column name="access_time" />
+ <column name="table_name" />
+ <column name="index_name" />
+ <column name="number_records" />
+ <column name="data_size" />
+ <column name="compressed_size" />
+ <column name="page_state" />
+ <column name="io_fix" />
+ <column name="is_old" />
+ <column name="free_page_clock" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_buffer_page_lru.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_buffer_page_lru.xml
new file mode 100644
index 00000000000..4c51ac7412f
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_buffer_page_lru.xml
@@ -0,0 +1,41 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="pool_id" />
+ <column name="lru_position" />
+ <column name="space" />
+ <column name="page_number" />
+ <column name="page_type" />
+ <column name="flush_type" />
+ <column name="fix_count" />
+ <column name="is_hashed" />
+ <column name="newest_modification" />
+ <column name="oldest_modification" />
+ <column name="access_time" />
+ <column name="table_name" />
+ <column name="index_name" />
+ <column name="number_records" />
+ <column name="data_size" />
+ <column name="compressed_size" />
+ <column name="compressed" />
+ <column name="io_fix" />
+ <column name="is_old" />
+ <column name="free_page_clock" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_buffer_pool_stats.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_buffer_pool_stats.xml
new file mode 100644
index 00000000000..0af0b138c53
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_buffer_pool_stats.xml
@@ -0,0 +1,53 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="pool_id" />
+ <column name="pool_size" />
+ <column name="free_buffers" />
+ <column name="database_pages" />
+ <column name="old_database_pages" />
+ <column name="modified_database_pages" />
+ <column name="pending_decompress" />
+ <column name="pending_reads" />
+ <column name="pending_flush_lru" />
+ <column name="pending_flush_list" />
+ <column name="pages_made_young" />
+ <column name="pages_not_made_young" />
+ <column name="pages_made_young_rate" />
+ <column name="pages_made_not_young_rate" />
+ <column name="number_pages_read" />
+ <column name="number_pages_created" />
+ <column name="number_pages_written" />
+ <column name="pages_read_rate" />
+ <column name="pages_create_rate" />
+ <column name="pages_written_rate" />
+ <column name="number_pages_get" />
+ <column name="hit_rate" />
+ <column name="young_make_per_thousand_gets" />
+ <column name="not_young_make_per_thousand_gets" />
+ <column name="number_pages_read_ahead" />
+ <column name="number_read_ahead_evicted" />
+ <column name="read_ahead_rate" />
+ <column name="read_ahead_evicted_rate" />
+ <column name="lru_io_total" />
+ <column name="lru_io_current" />
+ <column name="uncompress_total" />
+ <column name="uncompress_current" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp.xml
new file mode 100644
index 00000000000..fa9401b26f0
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="page_size" />
+ <column name="compress_ops" />
+ <column name="compress_ops_ok" />
+ <column name="compress_time" />
+ <column name="uncompress_ops" />
+ <column name="uncompress_time" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp_per_index.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp_per_index.xml
new file mode 100644
index 00000000000..f89b01a3fb0
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp_per_index.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="database_name" />
+ <column name="table_name" />
+ <column name="index_name" />
+ <column name="compress_ops" />
+ <column name="compress_ops_ok" />
+ <column name="compress_time" />
+ <column name="uncompress_ops" />
+ <column name="uncompress_time" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp_per_index_reset.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp_per_index_reset.xml
new file mode 100644
index 00000000000..f89b01a3fb0
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp_per_index_reset.xml
@@ -0,0 +1,29 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="database_name" />
+ <column name="table_name" />
+ <column name="index_name" />
+ <column name="compress_ops" />
+ <column name="compress_ops_ok" />
+ <column name="compress_time" />
+ <column name="uncompress_ops" />
+ <column name="uncompress_time" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp_reset.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp_reset.xml
new file mode 100644
index 00000000000..fa9401b26f0
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmp_reset.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="page_size" />
+ <column name="compress_ops" />
+ <column name="compress_ops_ok" />
+ <column name="compress_time" />
+ <column name="uncompress_ops" />
+ <column name="uncompress_time" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmpmem.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmpmem.xml
new file mode 100644
index 00000000000..e780c841843
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmpmem.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="page_size" />
+ <column name="buffer_pool_instance" />
+ <column name="pages_used" />
+ <column name="pages_free" />
+ <column name="relocation_ops" />
+ <column name="relocation_time" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmpmem_reset.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmpmem_reset.xml
new file mode 100644
index 00000000000..e780c841843
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_cmpmem_reset.xml
@@ -0,0 +1,27 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="page_size" />
+ <column name="buffer_pool_instance" />
+ <column name="pages_used" />
+ <column name="pages_free" />
+ <column name="relocation_ops" />
+ <column name="relocation_time" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_ft_being_deleted.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_ft_being_deleted.xml
new file mode 100644
index 00000000000..118fba02a27
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_ft_being_deleted.xml
@@ -0,0 +1,22 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata>
+ <column name="doc_id" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_sys_data_for_og.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_sys_data_for_og.xml
index bdfa0c022e1..b82a8d7803e 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_sys_data_for_og.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_sys_data_for_og.xml
@@ -35,7 +35,7 @@
<row values="public | t_order_item_federate_sharding | table | mock user |" />
<row values="public | t_order_item_join_view | view | mock user |" mayNotExist="true" />
<row values="public | t_order_subquery_view | view | mock user |" mayNotExist="true" />
- <row values="public | t_order_union_view | view | mock user |" mayNotExist="true"/>
+ <row values="public | t_order_union_view | view | mock user |" mayNotExist="true" />
<row values="public | t_product | table | mock user |" />
<row values="public | t_product_category | table | mock user |" />
<row values="public | t_product_detail | table | mock user |" />
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml
new file mode 100644
index 00000000000..52e41b16d9e
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml
@@ -0,0 +1,88 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<integration-test-cases>
+ <test-case sql="select * from information_schema.innodb_buffer_page;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_page.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_buffer_page_lru;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_page_lru.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_buffer_pool_stats;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_pool_stats.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_cmp;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_cmp.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_cmp_per_index;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_per_index.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_cmp_per_index_reset;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_per_index_reset.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_cmp_reset;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_reset.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_buffer_page;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_page.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_buffer_page_lru;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_page_lru.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_buffer_pool_stats;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_pool_stats.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_cmp;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_cmp.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_cmp_per_index;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_per_index.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_cmp_per_index_reset;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_per_index_reset.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_cmp_reset;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_reset.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_cmpmem;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_cmpmem.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_cmpmem_reset;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_cmpmem_reset.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_ft_being_deleted;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_ft_being_deleted.xml" />
+ </test-case>
+
+</integration-test-cases>