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 <[email protected]>
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>
