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 2022/12/02 10:23:06 UTC
[shardingsphere] branch master updated: Optimize ShardingStatisticsTableCollector & add it. (#22592)
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 5ac27dbc6e4 Optimize ShardingStatisticsTableCollector & add it. (#22592)
5ac27dbc6e4 is described below
commit 5ac27dbc6e44972bbf1224e871c80443138fe3fa
Author: Chuxin Chen <ch...@qq.com>
AuthorDate: Fri Dec 2 18:22:59 2022 +0800
Optimize ShardingStatisticsTableCollector & add it. (#22592)
---
.../data/ShardingStatisticsTableCollector.java | 24 +++--
.../mysql/select_sharding_table_statistics.xml | 108 +++++++++++++++++++++
.../opengauss/select_sharding_table_statistics.xml | 108 +++++++++++++++++++++
.../select_sharding_table_statistics.xml | 108 +++++++++++++++++++++
.../select_sharding_table_statistics.xml | 28 ++++++
.../cases/ral/ral-integration-test-cases.xml | 4 +
6 files changed, 373 insertions(+), 7 deletions(-)
diff --git a/features/sharding/core/src/main/java/org/apache/shardingsphere/sharding/metadata/data/ShardingStatisticsTableCollector.java b/features/sharding/core/src/main/java/org/apache/shardingsphere/sharding/metadata/data/ShardingStatisticsTableCollector.java
index a45da3c0dbc..c6ac39bca00 100644
--- a/features/sharding/core/src/main/java/org/apache/shardingsphere/sharding/metadata/data/ShardingStatisticsTableCollector.java
+++ b/features/sharding/core/src/main/java/org/apache/shardingsphere/sharding/metadata/data/ShardingStatisticsTableCollector.java
@@ -53,16 +53,27 @@ public final class ShardingStatisticsTableCollector implements ShardingSphereDat
@Override
public Optional<ShardingSphereTableData> collect(final String databaseName, final ShardingSphereTable table,
final Map<String, ShardingSphereDatabase> shardingSphereDatabases) throws SQLException {
- ShardingSphereDatabase shardingSphereDatabase = shardingSphereDatabases.get(databaseName);
+ ShardingSphereTableData result = new ShardingSphereTableData(SHARDING_TABLE_STATISTICS);
+ DatabaseType protocolType = shardingSphereDatabases.values().iterator().next().getProtocolType();
+ if (protocolType instanceof PostgreSQLDatabaseType || protocolType instanceof OpenGaussDatabaseType) {
+ collectFromDatabase(shardingSphereDatabases.get(databaseName), result);
+ } else {
+ for (ShardingSphereDatabase each : shardingSphereDatabases.values()) {
+ collectFromDatabase(each, result);
+ }
+ }
+ return result.getRows().isEmpty() ? Optional.empty() : Optional.of(result);
+ }
+
+ private void collectFromDatabase(final ShardingSphereDatabase shardingSphereDatabase, final ShardingSphereTableData tableData) throws SQLException {
Optional<ShardingRule> shardingRule = shardingSphereDatabase.getRuleMetaData().findSingleRule(ShardingRule.class);
if (!shardingRule.isPresent()) {
- return Optional.empty();
+ return;
}
- return Optional.of(collectForShardingStatisticTable(shardingSphereDatabase, shardingRule.get()));
+ collectForShardingStatisticTable(shardingSphereDatabase, shardingRule.get(), tableData);
}
- private ShardingSphereTableData collectForShardingStatisticTable(final ShardingSphereDatabase shardingSphereDatabase, final ShardingRule shardingRule) throws SQLException {
- ShardingSphereTableData result = new ShardingSphereTableData(SHARDING_TABLE_STATISTICS);
+ private void collectForShardingStatisticTable(final ShardingSphereDatabase shardingSphereDatabase, final ShardingRule shardingRule, final ShardingSphereTableData tableData) throws SQLException {
int count = 1;
for (TableRule each : shardingRule.getTableRules().values()) {
for (DataNode dataNode : each.getActualDataNodes()) {
@@ -73,10 +84,9 @@ public final class ShardingStatisticsTableCollector implements ShardingSphereDat
row.add(dataNode.getDataSourceName());
row.add(dataNode.getTableName());
addTableRowsAndDataLength(shardingSphereDatabase.getResourceMetaData().getDataSources(), dataNode, row, shardingSphereDatabase.getProtocolType());
- result.getRows().add(new ShardingSphereRowData(row));
+ tableData.getRows().add(new ShardingSphereRowData(row));
}
}
- return result;
}
private void addTableRowsAndDataLength(final Map<String, DataSource> dataSources, final DataNode dataNode, final List<Object> row, final DatabaseType databaseType) throws SQLException {
diff --git a/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/mysql/select_sharding_table_statistics.xml b/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/mysql/select_sharding_table_statistics.xml
new file mode 100644
index 00000000000..7a298b8f92f
--- /dev/null
+++ b/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/mysql/select_sharding_table_statistics.xml
@@ -0,0 +1,108 @@
+<!--
+ ~ 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" assertion="false" />
+ <column name="logic_database_name" />
+ <column name="logic_table_name" />
+ <column name="actual_database_name" />
+ <column name="actual_table_name" />
+ <column name="row_count" assertion="false" />
+ <column name="size" assertion="false" />
+ </metadata>
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_26 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_1 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_21 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_26 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_19 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_4 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_14 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_29 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_15 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_0 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_21 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_6 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_10 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_37 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_34 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_11 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_1 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_20 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_16 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_27 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_6 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_23 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_35 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_5 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_19 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_32 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_28 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_22 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_14 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_30 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_12 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_8 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_23 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_3 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_2 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_30 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_10 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_38 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_32 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_9 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_29 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_4 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_25 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_24 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_13 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_31 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_33 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_17 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_25 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_18 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_33 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_27 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_7 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_22 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_39 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_37 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_11 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_0 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_15 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_13 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_28 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_35 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_16 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_20 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_17 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_36 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_36 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_3 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_31 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_38 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_34 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_8 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_12 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_39 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_7 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_9 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_18 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_2 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_24 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_5 | | " />
+</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/opengauss/select_sharding_table_statistics.xml b/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/opengauss/select_sharding_table_statistics.xml
new file mode 100644
index 00000000000..27139105a49
--- /dev/null
+++ b/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/opengauss/select_sharding_table_statistics.xml
@@ -0,0 +1,108 @@
+<!--
+ ~ 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" assertion="false" />
+ <column name="logic_database_name" />
+ <column name="logic_table_name" />
+ <column name="actual_database_name" />
+ <column name="actual_table_name" />
+ <column name="row_count" assertion="false" />
+ <column name="size" assertion="false" />
+ </metadata>
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_20 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_16 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_30 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_35 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_10 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_13 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_35 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_10 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_1 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_8 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_11 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_25 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_22 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_27 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_0 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_25 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_34 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_28 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_1 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_29 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_5 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_38 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_32 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_2 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_36 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_11 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_7 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_15 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_38 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_12 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_37 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_0 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_18 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_32 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_34 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_3 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_31 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_14 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_19 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_24 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_29 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_39 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_24 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_33 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_9 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_39 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_12 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_19 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_17 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_13 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_9 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_4 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_21 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_4 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_8 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_14 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_28 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_20 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_26 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_6 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_30 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_23 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_23 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_3 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_17 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_7 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_5 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_6 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_27 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_18 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_15 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_33 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_22 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_37 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_21 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_16 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_36 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_2 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_31 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_26 | | " />
+</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/postgresql/select_sharding_table_statistics.xml b/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/postgresql/select_sharding_table_statistics.xml
new file mode 100644
index 00000000000..27139105a49
--- /dev/null
+++ b/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/postgresql/select_sharding_table_statistics.xml
@@ -0,0 +1,108 @@
+<!--
+ ~ 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" assertion="false" />
+ <column name="logic_database_name" />
+ <column name="logic_table_name" />
+ <column name="actual_database_name" />
+ <column name="actual_table_name" />
+ <column name="row_count" assertion="false" />
+ <column name="size" assertion="false" />
+ </metadata>
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_20 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_16 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_30 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_35 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_10 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_13 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_35 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_10 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_1 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_8 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_11 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_25 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_22 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_27 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_0 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_25 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_34 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_28 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_1 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_29 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_5 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_38 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_32 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_2 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_36 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_11 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_7 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_15 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_38 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_12 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_37 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_0 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_18 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_32 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_34 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_3 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_31 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_14 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_19 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_24 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_29 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_39 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_24 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_33 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_9 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_39 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_12 | | " />
+ <row values=" | empty_rules | t_user | write_ds_9 | t_user_19 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_7 | t_user_item_17 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_13 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_9 | t_user_item_9 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_4 | t_user_item_4 | | " />
+ <row values=" | empty_rules | t_user | write_ds_1 | t_user_21 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_4 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_8 | t_user_item_8 | | " />
+ <row values=" | empty_rules | t_user | write_ds_4 | t_user_14 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_28 | | " />
+ <row values=" | empty_rules | t_user | write_ds_0 | t_user_20 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_26 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_6 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_0 | t_user_item_30 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_23 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_23 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_3 | t_user_item_3 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_17 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_7 | | " />
+ <row values=" | empty_rules | t_user | write_ds_5 | t_user_5 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_6 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_27 | | " />
+ <row values=" | empty_rules | t_user | write_ds_8 | t_user_18 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_5 | t_user_item_15 | | " />
+ <row values=" | empty_rules | t_user | write_ds_3 | t_user_33 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_2 | t_user_item_22 | | " />
+ <row values=" | empty_rules | t_user | write_ds_7 | t_user_37 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_21 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_16 | | " />
+ <row values=" | empty_rules | t_user | write_ds_6 | t_user_36 | | " />
+ <row values=" | empty_rules | t_user | write_ds_2 | t_user_2 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_1 | t_user_item_31 | | " />
+ <row values=" | empty_rules | t_user_item | write_ds_6 | t_user_item_26 | | " />
+</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/select_sharding_table_statistics.xml b/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/select_sharding_table_statistics.xml
new file mode 100644
index 00000000000..4f5b677918f
--- /dev/null
+++ b/test/integration-test/test-suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/select_sharding_table_statistics.xml
@@ -0,0 +1,28 @@
+<!--
+ ~ 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" assertion="false" />
+ <column name="logic_database_name" />
+ <column name="logic_table_name" />
+ <column name="actual_database_name" />
+ <column name="actual_table_name" />
+ <column name="row_count" assertion="false" />
+ <column name="size" assertion="false" />
+ </metadata>
+</dataset>
diff --git a/test/integration-test/test-suite/src/test/resources/cases/ral/ral-integration-test-cases.xml b/test/integration-test/test-suite/src/test/resources/cases/ral/ral-integration-test-cases.xml
index cf16a454a29..1d66396e96e 100644
--- a/test/integration-test/test-suite/src/test/resources/cases/ral/ral-integration-test-cases.xml
+++ b/test/integration-test/test-suite/src/test/resources/cases/ral/ral-integration-test-cases.xml
@@ -97,5 +97,9 @@
<test-case sql="SELECT n.nspname as "Schema", c.relname as "Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN 'index' WHEN 'I' THEN 'global partition index' WHEN 'S' THEN 'sequence' WHEN 'L' THEN 'large sequence' WHEN 'f' THEN 'foreign table' WHEN 'm' THEN 'materialized view' WHEN 'e' THEN 'stream' WHEN 'o' THEN 'contview' END as "Type", pg_catalog.pg_get_userbyid(c.relowner) as "Owner", c.reloptions as "Stora [...]
<assertion expected-data-file="select_sys_data_for_og.xml" />
</test-case>
+
+ <test-case sql="select * from shardingsphere.sharding_table_statistics;" db-types="MySQL,PostgreSQL,openGauss">
+ <assertion expected-data-file="select_sharding_table_statistics.xml" />
+ </test-case>
</integration-test-cases>