You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by tu...@apache.org on 2023/03/28 02:22:40 UTC
[shardingsphere] branch master updated: Add more MySQL information_schema tables (#24860)
This is an automated email from the ASF dual-hosted git repository.
tuichenchuxin 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 0af4d4e353b Add more MySQL information_schema tables (#24860)
0af4d4e353b is described below
commit 0af4d4e353b2d770dc573b23ab7cd740455a185f
Author: ZhangCheng <fl...@outlook.com>
AuthorDate: Tue Mar 28 10:22:32 2023 +0800
Add more MySQL information_schema tables (#24860)
---
.../schema/builder/SystemSchemaBuilderRule.java | 4 +-
.../information_schema/innodb_sys_fields.yaml | 43 +++++
.../information_schema/innodb_sys_foreign.yaml | 59 ++++++
.../innodb_sys_foreign_cols.yaml | 51 +++++
.../information_schema/innodb_sys_indexes.yaml | 83 ++++++++
.../information_schema/innodb_sys_tables.yaml | 91 +++++++++
.../information_schema/innodb_sys_tablespaces.yaml | 107 +++++++++++
.../information_schema/innodb_sys_tablestats.yaml | 91 +++++++++
.../information_schema/innodb_sys_virtual.yaml | 43 +++++
.../information_schema/innodb_temp_table_info.yaml | 67 +++++++
.../mysql/information_schema/innodb_trx.yaml | 211 +++++++++++++++++++++
.../builder/SystemSchemaBuilderRuleTest.java | 2 +-
.../schema/builder/SystemSchemaBuilderTest.java | 2 +-
..._mysql_information_schema_innodb_sys_fields.xml | 24 +++
...mysql_information_schema_innodb_sys_foreign.xml | 26 +++
..._information_schema_innodb_sys_foreign_cols.xml | 25 +++
...mysql_information_schema_innodb_sys_indexes.xml | 29 +++
..._mysql_information_schema_innodb_sys_tables.xml | 30 +++
...l_information_schema_innodb_sys_tablespaces.xml | 32 ++++
...ql_information_schema_innodb_sys_tablestats.xml | 30 +++
...mysql_information_schema_innodb_sys_virtual.xml | 24 +++
...l_information_schema_innodb_temp_table_info.xml | 27 +++
.../select_mysql_information_schema_innodb_trx.xml | 45 +++++
.../dql/dql-integration-select-system-schema.xml | 40 ++++
24 files changed, 1183 insertions(+), 3 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 ae00a96886b..70412a77153 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
@@ -40,7 +40,9 @@ public enum SystemSchemaBuilderRule {
"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",
"innodb_ft_config", "innodb_ft_default_stopword", "innodb_ft_deleted", "innodb_ft_index_cache", "innodb_ft_index_table", "innodb_lock_waits", "innodb_locks",
- "innodb_metrics", "innodb_sys_columns", "innodb_sys_datafiles"))),
+ "innodb_metrics", "innodb_sys_columns", "innodb_sys_datafiles",
+ "innodb_sys_fields", "innodb_sys_foreign", "innodb_sys_foreign_cols", "innodb_sys_indexes", "innodb_sys_tables", "innodb_sys_tablespaces",
+ "innodb_sys_tablestats", "innodb_sys_virtual", "innodb_temp_table_info", "innodb_trx"))),
MYSQL_MYSQL("MySQL", "mysql", new HashSet<>(Collections.singleton("db"))),
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_fields.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_fields.yaml
new file mode 100644
index 00000000000..ead378fdf58
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_fields.yaml
@@ -0,0 +1,43 @@
+#
+# 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.
+#
+
+name: INNODB_SYS_FIELDS
+columns:
+ index_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: INDEX_ID
+ primaryKey: false
+ unsigned: true
+ visible: true
+ name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pos:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: POS
+ primaryKey: false
+ unsigned: true
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_foreign.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_foreign.yaml
new file mode 100644
index 00000000000..5b21340c4ed
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_foreign.yaml
@@ -0,0 +1,59 @@
+#
+# 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.
+#
+
+name: INNODB_SYS_FOREIGN
+columns:
+ id:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: ID
+ primaryKey: false
+ unsigned: false
+ visible: true
+ for_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: FOR_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ref_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: REF_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_cols:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: N_COLS
+ primaryKey: false
+ unsigned: true
+ visible: true
+ type:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: TYPE
+ primaryKey: false
+ unsigned: true
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_foreign_cols.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_foreign_cols.yaml
new file mode 100644
index 00000000000..5eae5909063
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_foreign_cols.yaml
@@ -0,0 +1,51 @@
+#
+# 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.
+#
+
+name: INNODB_SYS_FOREIGN_COLS
+columns:
+ id:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: ID
+ primaryKey: false
+ unsigned: false
+ visible: true
+ for_col_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: FOR_COL_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ ref_col_name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: REF_COL_NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ pos:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: POS
+ primaryKey: false
+ unsigned: true
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_indexes.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_indexes.yaml
new file mode 100644
index 00000000000..277ebdfcd26
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_indexes.yaml
@@ -0,0 +1,83 @@
+#
+# 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.
+#
+
+name: INNODB_SYS_INDEXES
+columns:
+ index_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: INDEX_ID
+ primaryKey: false
+ unsigned: true
+ visible: true
+ name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ table_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: TABLE_ID
+ primaryKey: false
+ unsigned: true
+ visible: true
+ type:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: TYPE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_fields:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: N_FIELDS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ page_no:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: PAGE_NO
+ primaryKey: false
+ unsigned: false
+ visible: true
+ space:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SPACE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ merge_threshold:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: MERGE_THRESHOLD
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_tables.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_tables.yaml
new file mode 100644
index 00000000000..57001bf774e
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_tables.yaml
@@ -0,0 +1,91 @@
+#
+# 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.
+#
+
+name: INNODB_SYS_TABLES
+columns:
+ table_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: TABLE_ID
+ primaryKey: false
+ unsigned: true
+ visible: true
+ name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ flag:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: FLAG
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_cols:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: N_COLS
+ primaryKey: false
+ unsigned: false
+ visible: true
+ space:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SPACE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ file_format:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: FILE_FORMAT
+ primaryKey: false
+ unsigned: false
+ visible: true
+ row_format:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: ROW_FORMAT
+ primaryKey: false
+ unsigned: false
+ visible: true
+ zip_page_size:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: ZIP_PAGE_SIZE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ space_type:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: SPACE_TYPE
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_tablespaces.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_tablespaces.yaml
new file mode 100644
index 00000000000..a960730b267
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_tablespaces.yaml
@@ -0,0 +1,107 @@
+#
+# 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.
+#
+
+name: INNODB_SYS_TABLESPACES
+columns:
+ space:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SPACE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ flag:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: FLAG
+ primaryKey: false
+ unsigned: true
+ visible: true
+ file_format:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: FILE_FORMAT
+ primaryKey: false
+ unsigned: false
+ visible: true
+ row_format:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: ROW_FORMAT
+ primaryKey: false
+ unsigned: false
+ visible: true
+ page_size:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: PAGE_SIZE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ zip_page_size:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: ZIP_PAGE_SIZE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ space_type:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: SPACE_TYPE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ fs_block_size:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: FS_BLOCK_SIZE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ file_size:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: FILE_SIZE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ allocated_size:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: ALLOCATED_SIZE
+ primaryKey: false
+ unsigned: true
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_tablestats.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_tablestats.yaml
new file mode 100644
index 00000000000..b4892f4a466
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_tablestats.yaml
@@ -0,0 +1,91 @@
+#
+# 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.
+#
+
+name: INNODB_SYS_TABLESTATS
+columns:
+ table_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: TABLE_ID
+ primaryKey: false
+ unsigned: true
+ visible: true
+ name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ stats_initialized:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: STATS_INITIALIZED
+ primaryKey: false
+ unsigned: false
+ visible: true
+ num_rows:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: NUM_ROWS
+ primaryKey: false
+ unsigned: true
+ visible: true
+ clust_index_size:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: CLUST_INDEX_SIZE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ other_index_size:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: OTHER_INDEX_SIZE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ modified_counter:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: MODIFIED_COUNTER
+ primaryKey: false
+ unsigned: true
+ visible: true
+ autoinc:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: AUTOINC
+ primaryKey: false
+ unsigned: true
+ visible: true
+ ref_count:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: REF_COUNT
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_virtual.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_virtual.yaml
new file mode 100644
index 00000000000..c177e88b223
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_sys_virtual.yaml
@@ -0,0 +1,43 @@
+#
+# 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.
+#
+
+name: INNODB_SYS_VIRTUAL
+columns:
+ table_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: TABLE_ID
+ primaryKey: false
+ unsigned: true
+ visible: true
+ pos:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: POS
+ primaryKey: false
+ unsigned: true
+ visible: true
+ base_pos:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: BASE_POS
+ primaryKey: false
+ unsigned: true
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/innodb_temp_table_info.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_temp_table_info.yaml
new file mode 100644
index 00000000000..7b554bf7fee
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_temp_table_info.yaml
@@ -0,0 +1,67 @@
+#
+# 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.
+#
+
+name: INNODB_TEMP_TABLE_INFO
+columns:
+ table_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: TABLE_ID
+ primaryKey: false
+ unsigned: true
+ visible: true
+ name:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: NAME
+ primaryKey: false
+ unsigned: false
+ visible: true
+ n_cols:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: N_COLS
+ primaryKey: false
+ unsigned: true
+ visible: true
+ space:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: SPACE
+ primaryKey: false
+ unsigned: true
+ visible: true
+ per_table_tablespace:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: PER_TABLE_TABLESPACE
+ primaryKey: false
+ unsigned: false
+ visible: true
+ is_compressed:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: IS_COMPRESSED
+ primaryKey: false
+ unsigned: false
+ visible: true
diff --git a/infra/common/src/main/resources/schema/mysql/information_schema/innodb_trx.yaml b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_trx.yaml
new file mode 100644
index 00000000000..ccbf4146dff
--- /dev/null
+++ b/infra/common/src/main/resources/schema/mysql/information_schema/innodb_trx.yaml
@@ -0,0 +1,211 @@
+#
+# 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.
+#
+
+name: INNODB_TRX
+columns:
+ trx_id:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_state:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_state
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_started:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: trx_started
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_requested_lock_id:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_requested_lock_id
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_wait_started:
+ caseSensitive: false
+ dataType: 93
+ generated: false
+ name: trx_wait_started
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_weight:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_weight
+ primaryKey: false
+ unsigned: true
+ visible: true
+ trx_mysql_thread_id:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_mysql_thread_id
+ primaryKey: false
+ unsigned: true
+ visible: true
+ trx_query:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_query
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_operation_state:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_operation_state
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_tables_in_use:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_tables_in_use
+ primaryKey: false
+ unsigned: true
+ visible: true
+ trx_tables_locked:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_tables_locked
+ primaryKey: false
+ unsigned: true
+ visible: true
+ trx_lock_structs:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_lock_structs
+ primaryKey: false
+ unsigned: true
+ visible: true
+ trx_lock_memory_bytes:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_lock_memory_bytes
+ primaryKey: false
+ unsigned: true
+ visible: true
+ trx_rows_locked:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_rows_locked
+ primaryKey: false
+ unsigned: true
+ visible: true
+ trx_rows_modified:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_rows_modified
+ primaryKey: false
+ unsigned: true
+ visible: true
+ trx_concurrency_tickets:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_concurrency_tickets
+ primaryKey: false
+ unsigned: true
+ visible: true
+ trx_isolation_level:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_isolation_level
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_unique_checks:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_unique_checks
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_foreign_key_checks:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_foreign_key_checks
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_last_foreign_key_error:
+ caseSensitive: false
+ dataType: 12
+ generated: false
+ name: trx_last_foreign_key_error
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_adaptive_hash_latched:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_adaptive_hash_latched
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_adaptive_hash_timeout:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_adaptive_hash_timeout
+ primaryKey: false
+ unsigned: true
+ visible: true
+ trx_is_read_only:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_is_read_only
+ primaryKey: false
+ unsigned: false
+ visible: true
+ trx_autocommit_non_locking:
+ caseSensitive: false
+ dataType: 4
+ generated: false
+ name: trx_autocommit_non_locking
+ 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 78c90c03f6a..1020a9c93b7 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(35));
+ assertThat(actual.getTables().size(), is(45));
}
@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 9bb50b2c22f..5456d6228f8 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(35));
+ assertThat(actual.get("information_schema").getTables().size(), is(45));
}
@Test
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_fields.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_fields.xml
new file mode 100644
index 00000000000..1bdc90ec52a
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_fields.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ 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="index_id" />
+ <column name="name" />
+ <column name="pos" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_foreign.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_foreign.xml
new file mode 100644
index 00000000000..980714751a0
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_foreign.xml
@@ -0,0 +1,26 @@
+<!--
+ ~ 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="id" />
+ <column name="for_name" />
+ <column name="ref_name" />
+ <column name="n_cols" />
+ <column name="type" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_foreign_cols.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_foreign_cols.xml
new file mode 100644
index 00000000000..8f8db767f8d
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_foreign_cols.xml
@@ -0,0 +1,25 @@
+<!--
+ ~ 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="id" />
+ <column name="for_col_name" />
+ <column name="ref_col_name" />
+ <column name="pos" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_indexes.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_indexes.xml
new file mode 100644
index 00000000000..a1bb8510e04
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_indexes.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="index_id" />
+ <column name="name" />
+ <column name="table_id" />
+ <column name="type" />
+ <column name="n_fields" />
+ <column name="page_no" />
+ <column name="space" />
+ <column name="merge_threshold" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_tables.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_tables.xml
new file mode 100644
index 00000000000..a93a7611558
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_tables.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ 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="table_id" />
+ <column name="name" />
+ <column name="flag" />
+ <column name="n_cols" />
+ <column name="space" />
+ <column name="file_format" />
+ <column name="row_format" />
+ <column name="zip_page_size" />
+ <column name="space_type" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_tablespaces.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_tablespaces.xml
new file mode 100644
index 00000000000..bf6a401a082
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_tablespaces.xml
@@ -0,0 +1,32 @@
+<!--
+ ~ 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="space" />
+ <column name="name" />
+ <column name="flag" />
+ <column name="file_format" />
+ <column name="row_format" />
+ <column name="page_size" />
+ <column name="zip_page_size" />
+ <column name="space_type" />
+ <column name="fs_block_size" />
+ <column name="file_size" />
+ <column name="allocated_size" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_tablestats.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_tablestats.xml
new file mode 100644
index 00000000000..f62933b8610
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_tablestats.xml
@@ -0,0 +1,30 @@
+<!--
+ ~ 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="table_id" />
+ <column name="name" />
+ <column name="stats_initialized" />
+ <column name="num_rows" />
+ <column name="clust_index_size" />
+ <column name="other_index_size" />
+ <column name="modified_counter" />
+ <column name="autoinc" />
+ <column name="ref_count" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_virtual.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_virtual.xml
new file mode 100644
index 00000000000..737fe060e58
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_sys_virtual.xml
@@ -0,0 +1,24 @@
+<!--
+ ~ 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="table_id" />
+ <column name="pos" />
+ <column name="base_pos" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_temp_table_info.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_temp_table_info.xml
new file mode 100644
index 00000000000..7b9f8846dfc
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_temp_table_info.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="table_id" />
+ <column name="name" />
+ <column name="n_cols" />
+ <column name="space" />
+ <column name="per_table_tablespace" />
+ <column name="is_compressed" />
+ </metadata>
+</dataset>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_trx.xml b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_trx.xml
new file mode 100644
index 00000000000..5a6aafefe7b
--- /dev/null
+++ b/test/e2e/sql/src/test/resources/cases/dql/dataset/db/select_mysql_information_schema_innodb_trx.xml
@@ -0,0 +1,45 @@
+<!--
+ ~ 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="trx_id" />
+ <column name="trx_state" />
+ <column name="trx_started" />
+ <column name="trx_requested_lock_id" />
+ <column name="trx_wait_started" />
+ <column name="trx_weight" />
+ <column name="trx_mysql_thread_id" />
+ <column name="trx_query" />
+ <column name="trx_operation_state" />
+ <column name="trx_tables_in_use" />
+ <column name="trx_tables_locked" />
+ <column name="trx_lock_structs" />
+ <column name="trx_lock_memory_bytes" />
+ <column name="trx_rows_locked" />
+ <column name="trx_rows_modified" />
+ <column name="trx_concurrency_tickets" />
+ <column name="trx_isolation_level" />
+ <column name="trx_unique_checks" />
+ <column name="trx_foreign_key_checks" />
+ <column name="trx_last_foreign_key_error" />
+ <column name="trx_adaptive_hash_latched" />
+ <column name="trx_adaptive_hash_timeout" />
+ <column name="trx_is_read_only" />
+ <column name="trx_autocommit_non_locking" />
+ </metadata>
+</dataset>
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
index 3b12283577d..59343919d94 100644
--- 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
@@ -125,4 +125,44 @@
<assertion expected-data-file="select_mysql_information_schema_innodb_sys_datafiles.xml" />
</test-case>
+ <test-case sql="select * from information_schema.innodb_sys_fields;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_sys_fields.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_sys_foreign;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_sys_foreign.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_sys_foreign_cols;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_sys_foreign_cols.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_sys_indexes;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_sys_indexes.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_sys_tables;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_sys_tables.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_sys_tablespaces;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_sys_tablespaces.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_sys_tablestats;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_sys_tablestats.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_sys_virtual;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_sys_virtual.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_temp_table_info;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_temp_table_info.xml" />
+ </test-case>
+
+ <test-case sql="select * from information_schema.innodb_trx;" db-types="MySQL" scenario-types="db">
+ <assertion expected-data-file="select_mysql_information_schema_innodb_trx.xml" />
+ </test-case>
+
</integration-test-cases>