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 2022/09/08 02:02:03 UTC
[shardingsphere] branch master updated: Refactor resource and db name of empty_ruls scenario (#20862)
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 fe952e26b91 Refactor resource and db name of empty_ruls scenario (#20862)
fe952e26b91 is described below
commit fe952e26b91616ba4e9517265143973940b20724
Author: zhaojinchao <zh...@apache.org>
AuthorDate: Thu Sep 8 10:01:56 2022 +0800
Refactor resource and db name of empty_ruls scenario (#20862)
---
.../mysql/preview_federation_select.xml | 22 +-
.../postgresql/preview_federation_select.xml | 22 +-
.../cases/ral/dataset/empty_rules/preview_sql.xml | 20 +-
.../alter_readwrite_splitting_rules.xml | 4 +-
.../create_readwrite_splitting_rules.xml | 4 +-
.../dataset/empty_rules/create_sharding_rules.xml | 2 +-
.../rdl/dataset/empty_rules/mysql/add_resource.xml | 40 +-
.../dataset/empty_rules/mysql/alter_resource.xml | 40 +-
.../dataset/empty_rules/mysql/drop_resource.xml | 40 +-
.../empty_rules/postgresql/add_resource.xml | 40 +-
.../empty_rules/postgresql/alter_resource.xml | 40 +-
.../empty_rules/postgresql/drop_resource.xml | 40 +-
.../cases/rdl/rdl-integration-test-cases.xml | 28 +-
.../env/scenario/empty_rules/authority.xml | 40 +-
.../scenario/empty_rules/data/actual/databases.xml | 40 +-
.../data/actual/init-sql/mysql/01-actual-init.sql | 564 ++++++++++-----------
.../actual/init-sql/postgresql/01-actual-init.sql | 120 ++---
.../proxy/conf/mysql/config-empty-rules.yaml | 88 ++--
.../proxy/conf/postgresql/config-empty-rules.yaml | 88 ++--
19 files changed, 641 insertions(+), 641 deletions(-)
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/mysql/preview_federation_select.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/mysql/preview_federation_select.xml
index 8cfb91cd1f1..ea822b9f69c 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/mysql/preview_federation_select.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/mysql/preview_federation_select.xml
@@ -20,15 +20,15 @@
<column name="data_source_name" />
<column name="actual_sql" />
</metadata>
- <row values="encrypt_write_ds_0| SELECT * FROM `t_user_item_0` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_10` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_20` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_30` WHERE CAST(`user_id` AS SIGNED) = 1" />
- <row values="encrypt_write_ds_1| SELECT * FROM `t_user_item_1` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_11` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_21` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_31` WHERE CAST(`user_id` AS SIGNED) = 1" />
- <row values="encrypt_write_ds_2| SELECT * FROM `t_user_item_2` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_12` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_22` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_32` WHERE CAST(`user_id` AS SIGNED) = 1" />
- <row values="encrypt_write_ds_3| SELECT * FROM `t_user_item_3` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_13` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_23` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_33` WHERE CAST(`user_id` AS SIGNED) = 1" />
- <row values="encrypt_write_ds_4| SELECT * FROM `t_user_item_4` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_14` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_24` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_34` WHERE CAST(`user_id` AS SIGNED) = 1" />
- <row values="encrypt_write_ds_5| SELECT * FROM `t_user_item_5` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_15` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_25` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_35` WHERE CAST(`user_id` AS SIGNED) = 1" />
- <row values="encrypt_write_ds_6| SELECT * FROM `t_user_item_6` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_16` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_26` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_36` WHERE CAST(`user_id` AS SIGNED) = 1" />
- <row values="encrypt_write_ds_7| SELECT * FROM `t_user_item_7` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_17` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_27` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_37` WHERE CAST(`user_id` AS SIGNED) = 1" />
- <row values="encrypt_write_ds_8| SELECT * FROM `t_user_item_8` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_18` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_28` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_38` WHERE CAST(`user_id` AS SIGNED) = 1" />
- <row values="encrypt_write_ds_9| SELECT * FROM `t_user_item_9` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_19` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_29` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_39` WHERE CAST(`user_id` AS SIGNED) = 1" />
- <row values="encrypt_read_ds_0| SELECT * FROM `t_single_table`" />
+ <row values="write_ds_0| SELECT * FROM `t_user_item_0` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_10` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_20` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_30` WHERE CAST(`user_id` AS SIGNED) = 1" />
+ <row values="write_ds_1| SELECT * FROM `t_user_item_1` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_11` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_21` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_31` WHERE CAST(`user_id` AS SIGNED) = 1" />
+ <row values="write_ds_2| SELECT * FROM `t_user_item_2` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_12` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_22` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_32` WHERE CAST(`user_id` AS SIGNED) = 1" />
+ <row values="write_ds_3| SELECT * FROM `t_user_item_3` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_13` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_23` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_33` WHERE CAST(`user_id` AS SIGNED) = 1" />
+ <row values="write_ds_4| SELECT * FROM `t_user_item_4` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_14` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_24` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_34` WHERE CAST(`user_id` AS SIGNED) = 1" />
+ <row values="write_ds_5| SELECT * FROM `t_user_item_5` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_15` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_25` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_35` WHERE CAST(`user_id` AS SIGNED) = 1" />
+ <row values="write_ds_6| SELECT * FROM `t_user_item_6` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_16` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_26` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_36` WHERE CAST(`user_id` AS SIGNED) = 1" />
+ <row values="write_ds_7| SELECT * FROM `t_user_item_7` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_17` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_27` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_37` WHERE CAST(`user_id` AS SIGNED) = 1" />
+ <row values="write_ds_8| SELECT * FROM `t_user_item_8` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_18` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_28` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_38` WHERE CAST(`user_id` AS SIGNED) = 1" />
+ <row values="write_ds_9| SELECT * FROM `t_user_item_9` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_19` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_29` WHERE CAST(`user_id` AS SIGNED) = 1 UNION ALL SELECT * FROM `t_user_item_39` WHERE CAST(`user_id` AS SIGNED) = 1" />
+ <row values="read_ds_0| SELECT * FROM `t_single_table`" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/postgresql/preview_federation_select.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/postgresql/preview_federation_select.xml
index 654ff437ba6..e320f27f0eb 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/postgresql/preview_federation_select.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/postgresql/preview_federation_select.xml
@@ -20,15 +20,15 @@
<column name="data_source_name" />
<column name="actual_sql" />
</metadata>
- <row values="encrypt_write_ds_0| SELECT * FROM "public"."t_user_item_0" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_10" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_20" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_30" WHERE CAST("user_id" AS INTEGER) = 1" />
- <row values="encrypt_write_ds_1| SELECT * FROM "public"."t_user_item_1" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_11" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_21" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_31" WHERE CAST("user_id" AS INTEGER) = 1" />
- <row values="encrypt_write_ds_2| SELECT * FROM "public"."t_user_item_2" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_12" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_22" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_32" WHERE CAST("user_id" AS INTEGER) = 1" />
- <row values="encrypt_write_ds_3| SELECT * FROM "public"."t_user_item_3" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_13" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_23" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_33" WHERE CAST("user_id" AS INTEGER) = 1" />
- <row values="encrypt_write_ds_4| SELECT * FROM "public"."t_user_item_4" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_14" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_24" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_34" WHERE CAST("user_id" AS INTEGER) = 1" />
- <row values="encrypt_write_ds_5| SELECT * FROM "public"."t_user_item_5" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_15" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_25" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_35" WHERE CAST("user_id" AS INTEGER) = 1" />
- <row values="encrypt_write_ds_6| SELECT * FROM "public"."t_user_item_6" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_16" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_26" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_36" WHERE CAST("user_id" AS INTEGER) = 1" />
- <row values="encrypt_write_ds_7| SELECT * FROM "public"."t_user_item_7" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_17" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_27" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_37" WHERE CAST("user_id" AS INTEGER) = 1" />
- <row values="encrypt_write_ds_8| SELECT * FROM "public"."t_user_item_8" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_18" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_28" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_38" WHERE CAST("user_id" AS INTEGER) = 1" />
- <row values="encrypt_write_ds_9| SELECT * FROM "public"."t_user_item_9" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_19" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_29" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_39" WHERE CAST("user_id" AS INTEGER) = 1" />
- <row values="encrypt_read_ds_0| SELECT * FROM "public"."t_single_table"" />
+ <row values="write_ds_0| SELECT * FROM "public"."t_user_item_0" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_10" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_20" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_30" WHERE CAST("user_id" AS INTEGER) = 1" />
+ <row values="write_ds_1| SELECT * FROM "public"."t_user_item_1" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_11" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_21" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_31" WHERE CAST("user_id" AS INTEGER) = 1" />
+ <row values="write_ds_2| SELECT * FROM "public"."t_user_item_2" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_12" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_22" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_32" WHERE CAST("user_id" AS INTEGER) = 1" />
+ <row values="write_ds_3| SELECT * FROM "public"."t_user_item_3" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_13" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_23" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_33" WHERE CAST("user_id" AS INTEGER) = 1" />
+ <row values="write_ds_4| SELECT * FROM "public"."t_user_item_4" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_14" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_24" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_34" WHERE CAST("user_id" AS INTEGER) = 1" />
+ <row values="write_ds_5| SELECT * FROM "public"."t_user_item_5" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_15" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_25" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_35" WHERE CAST("user_id" AS INTEGER) = 1" />
+ <row values="write_ds_6| SELECT * FROM "public"."t_user_item_6" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_16" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_26" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_36" WHERE CAST("user_id" AS INTEGER) = 1" />
+ <row values="write_ds_7| SELECT * FROM "public"."t_user_item_7" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_17" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_27" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_37" WHERE CAST("user_id" AS INTEGER) = 1" />
+ <row values="write_ds_8| SELECT * FROM "public"."t_user_item_8" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_18" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_28" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_38" WHERE CAST("user_id" AS INTEGER) = 1" />
+ <row values="write_ds_9| SELECT * FROM "public"."t_user_item_9" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_19" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_29" WHERE CAST("user_id" AS INTEGER) = 1 UNION ALL SELECT * FROM "public"."t_user_item_39" WHERE CAST("user_id" AS INTEGER) = 1" />
+ <row values="read_ds_0| SELECT * FROM "public"."t_single_table"" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/preview_sql.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/preview_sql.xml
index 7bc4351a744..47b2a357a78 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/preview_sql.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/preview_sql.xml
@@ -20,14 +20,14 @@
<column name="data_source_name" />
<column name="actual_sql" />
</metadata>
- <row values="encrypt_write_ds_0| select * from t_user_item_0 UNION ALL select * from t_user_item_10 UNION ALL select * from t_user_item_20 UNION ALL select * from t_user_item_30" />
- <row values="encrypt_write_ds_1| select * from t_user_item_1 UNION ALL select * from t_user_item_11 UNION ALL select * from t_user_item_21 UNION ALL select * from t_user_item_31" />
- <row values="encrypt_write_ds_2| select * from t_user_item_2 UNION ALL select * from t_user_item_12 UNION ALL select * from t_user_item_22 UNION ALL select * from t_user_item_32" />
- <row values="encrypt_write_ds_3| select * from t_user_item_3 UNION ALL select * from t_user_item_13 UNION ALL select * from t_user_item_23 UNION ALL select * from t_user_item_33" />
- <row values="encrypt_write_ds_4| select * from t_user_item_4 UNION ALL select * from t_user_item_14 UNION ALL select * from t_user_item_24 UNION ALL select * from t_user_item_34" />
- <row values="encrypt_write_ds_5| select * from t_user_item_5 UNION ALL select * from t_user_item_15 UNION ALL select * from t_user_item_25 UNION ALL select * from t_user_item_35" />
- <row values="encrypt_write_ds_6| select * from t_user_item_6 UNION ALL select * from t_user_item_16 UNION ALL select * from t_user_item_26 UNION ALL select * from t_user_item_36" />
- <row values="encrypt_write_ds_7| select * from t_user_item_7 UNION ALL select * from t_user_item_17 UNION ALL select * from t_user_item_27 UNION ALL select * from t_user_item_37" />
- <row values="encrypt_write_ds_8| select * from t_user_item_8 UNION ALL select * from t_user_item_18 UNION ALL select * from t_user_item_28 UNION ALL select * from t_user_item_38" />
- <row values="encrypt_write_ds_9| select * from t_user_item_9 UNION ALL select * from t_user_item_19 UNION ALL select * from t_user_item_29 UNION ALL select * from t_user_item_39" />
+ <row values="write_ds_0| select * from t_user_item_0 UNION ALL select * from t_user_item_10 UNION ALL select * from t_user_item_20 UNION ALL select * from t_user_item_30" />
+ <row values="write_ds_1| select * from t_user_item_1 UNION ALL select * from t_user_item_11 UNION ALL select * from t_user_item_21 UNION ALL select * from t_user_item_31" />
+ <row values="write_ds_2| select * from t_user_item_2 UNION ALL select * from t_user_item_12 UNION ALL select * from t_user_item_22 UNION ALL select * from t_user_item_32" />
+ <row values="write_ds_3| select * from t_user_item_3 UNION ALL select * from t_user_item_13 UNION ALL select * from t_user_item_23 UNION ALL select * from t_user_item_33" />
+ <row values="write_ds_4| select * from t_user_item_4 UNION ALL select * from t_user_item_14 UNION ALL select * from t_user_item_24 UNION ALL select * from t_user_item_34" />
+ <row values="write_ds_5| select * from t_user_item_5 UNION ALL select * from t_user_item_15 UNION ALL select * from t_user_item_25 UNION ALL select * from t_user_item_35" />
+ <row values="write_ds_6| select * from t_user_item_6 UNION ALL select * from t_user_item_16 UNION ALL select * from t_user_item_26 UNION ALL select * from t_user_item_36" />
+ <row values="write_ds_7| select * from t_user_item_7 UNION ALL select * from t_user_item_17 UNION ALL select * from t_user_item_27 UNION ALL select * from t_user_item_37" />
+ <row values="write_ds_8| select * from t_user_item_8 UNION ALL select * from t_user_item_18 UNION ALL select * from t_user_item_28 UNION ALL select * from t_user_item_38" />
+ <row values="write_ds_9| select * from t_user_item_9 UNION ALL select * from t_user_item_19 UNION ALL select * from t_user_item_29 UNION ALL select * from t_user_item_39" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/alter_readwrite_splitting_rules.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/alter_readwrite_splitting_rules.xml
index 33b3811da7c..6abc0922b5c 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/alter_readwrite_splitting_rules.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/alter_readwrite_splitting_rules.xml
@@ -25,6 +25,6 @@
<column name="load_balancer_type" />
<column name="load_balancer_props" />
</metadata>
- <row values="readwrite_ds_0| | | encrypt_write_ds_0| encrypt_read_ds_0| ROUND_ROBIN| " />
- <row values="readwrite_ds_1| | | encrypt_write_ds_1| encrypt_read_ds_1,encrypt_read_ds_2| RANDOM| read_weight='2:1'" />
+ <row values="readwrite_ds_0| | | write_ds_0| read_ds_0| ROUND_ROBIN| " />
+ <row values="readwrite_ds_1| | | write_ds_1| read_ds_1,read_ds_2| RANDOM| read_weight='2:1'" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/create_readwrite_splitting_rules.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/create_readwrite_splitting_rules.xml
index 835f89a41e1..34932803e7b 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/create_readwrite_splitting_rules.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/create_readwrite_splitting_rules.xml
@@ -25,6 +25,6 @@
<column name="load_balancer_type" />
<column name="load_balancer_props" />
</metadata>
- <row values="readwrite_ds_0| | | encrypt_write_ds_0| encrypt_read_ds_0| ROUND_ROBIN| " />
- <row values="readwrite_ds_1| | | encrypt_write_ds_1| encrypt_read_ds_1| ROUND_ROBIN| " />
+ <row values="readwrite_ds_0| | | write_ds_0| read_ds_0| ROUND_ROBIN| " />
+ <row values="readwrite_ds_1| | | write_ds_1| read_ds_1| ROUND_ROBIN| " />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/create_sharding_rules.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/create_sharding_rules.xml
index f2f278a639c..121290c99b9 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/create_sharding_rules.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/create_sharding_rules.xml
@@ -32,5 +32,5 @@
<column name="key_generator_type" />
<column name="key_generator_props" />
</metadata>
- <row values="t_user| | encrypt_write_ds_${0..9}| | | | | MOD| user_id| MOD| sharding-count=40| | | " />
+ <row values="t_user| | write_ds_${0..9}| | | | | MOD| user_id| MOD| sharding-count=40| | | " />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/add_resource.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/add_resource.xml
index 81ecaf8bbfb..57943621c84 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/add_resource.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/add_resource.xml
@@ -30,26 +30,26 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"oataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
+ <row values="write_ds_0| MySQL| mysql.empty_rules.host| 3306| write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"oataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_1| MySQL| mysql.empty_rules.host| 3306| write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_2| MySQL| mysql.empty_rules.host| 3306| write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_3| MySQL| mysql.empty_rules.host| 3306| write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_4| MySQL| mysql.empty_rules.host| 3306| write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_5| MySQL| mysql.empty_rules.host| 3306| write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_6| MySQL| mysql.empty_rules.host| 3306| write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_7| MySQL| mysql.empty_rules.host| 3306| write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_8| MySQL| mysql.empty_rules.host| 3306| write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_9| MySQL| mysql.empty_rules.host| 3306| write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="read_ds_0| MySQL| mysql.empty_rules.host| 3306| read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_1| MySQL| mysql.empty_rules.host| 3306| read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_2| MySQL| mysql.empty_rules.host| 3306| read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_3| MySQL| mysql.empty_rules.host| 3306| read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_4| MySQL| mysql.empty_rules.host| 3306| read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_5| MySQL| mysql.empty_rules.host| 3306| read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_6| MySQL| mysql.empty_rules.host| 3306| read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_7| MySQL| mysql.empty_rules.host| 3306| read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_8| MySQL| mysql.empty_rules.host| 3306| read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_9| MySQL| mysql.empty_rules.host| 3306| read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
<row values="rdl_test_0| MySQL| mysql.empty_rules.host| 3306| rdl_test_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
<row values="rdl_test_1| MySQL| mysql.empty_rules.host| 3306| rdl_test_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
<row values="rdl_test_2| MySQL| mysql.empty_rules.host| 3306| rdl_test_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/alter_resource.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/alter_resource.xml
index 81a39952291..ce9dffd38f6 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/alter_resource.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/alter_resource.xml
@@ -30,25 +30,25 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
+ <row values="write_ds_0| MySQL| mysql.empty_rules.host| 3306| write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_1| MySQL| mysql.empty_rules.host| 3306| write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_2| MySQL| mysql.empty_rules.host| 3306| write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_3| MySQL| mysql.empty_rules.host| 3306| write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_4| MySQL| mysql.empty_rules.host| 3306| write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_5| MySQL| mysql.empty_rules.host| 3306| write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_6| MySQL| mysql.empty_rules.host| 3306| write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_7| MySQL| mysql.empty_rules.host| 3306| write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_8| MySQL| mysql.empty_rules.host| 3306| write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_9| MySQL| mysql.empty_rules.host| 3306| write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="read_ds_0| MySQL| mysql.empty_rules.host| 3306| read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_1| MySQL| mysql.empty_rules.host| 3306| read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_2| MySQL| mysql.empty_rules.host| 3306| read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_3| MySQL| mysql.empty_rules.host| 3306| read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_4| MySQL| mysql.empty_rules.host| 3306| read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_5| MySQL| mysql.empty_rules.host| 3306| read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_6| MySQL| mysql.empty_rules.host| 3306| read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_7| MySQL| mysql.empty_rules.host| 3306| read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_8| MySQL| mysql.empty_rules.host| 3306| read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_9| MySQL| mysql.empty_rules.host| 3306| read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
<row values="rdl_test_0| MySQL| mysql.empty_rules.host| 3306| rdl_test_0| 30000| 60000| 1800000| 2| 2| false| {"maxLifetimeMilliseconds":180000,"readOnly":false,"minPoolSize":10,"idleTimeoutMilliseconds":6000,"maxPoolSize":10,"connectionTimeoutMilliseconds":3000}" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/drop_resource.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/drop_resource.xml
index d3c706789bd..e9afe483752 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/drop_resource.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/mysql/drop_resource.xml
@@ -30,24 +30,24 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_write_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_write_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMeta [...]
- <row values="encrypt_read_ds_0| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_1| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_2| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_3| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_4| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_5| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_6| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_7| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_8| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
- <row values="encrypt_read_ds_9| MySQL| mysql.empty_rules.host| 3306| encrypt_read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetada [...]
+ <row values="write_ds_0| MySQL| mysql.empty_rules.host| 3306| write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_1| MySQL| mysql.empty_rules.host| 3306| write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_2| MySQL| mysql.empty_rules.host| 3306| write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_3| MySQL| mysql.empty_rules.host| 3306| write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_4| MySQL| mysql.empty_rules.host| 3306| write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_5| MySQL| mysql.empty_rules.host| 3306| write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_6| MySQL| mysql.empty_rules.host| 3306| write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_7| MySQL| mysql.empty_rules.host| 3306| write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_8| MySQL| mysql.empty_rules.host| 3306| write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="write_ds_9| MySQL| mysql.empty_rules.host| 3306| write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":& [...]
+ <row values="read_ds_0| MySQL| mysql.empty_rules.host| 3306| read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_1| MySQL| mysql.empty_rules.host| 3306| read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_2| MySQL| mysql.empty_rules.host| 3306| read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_3| MySQL| mysql.empty_rules.host| 3306| read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_4| MySQL| mysql.empty_rules.host| 3306| read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_5| MySQL| mysql.empty_rules.host| 3306| read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_6| MySQL| mysql.empty_rules.host| 3306| read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_7| MySQL| mysql.empty_rules.host| 3306| read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_8| MySQL| mysql.empty_rules.host| 3306| read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
+ <row values="read_ds_9| MySQL| mysql.empty_rules.host| 3306| read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":&qu [...]
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/add_resource.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/add_resource.xml
index 4082b856156..a0895c89525 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/add_resource.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/add_resource.xml
@@ -30,26 +30,26 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_write_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_read_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
+ <row values="write_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="read_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
<row values="rdl_test_0| PostgreSQL| postgresql.empty_rules.host| 5432| rdl_test_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
<row values="rdl_test_1| PostgreSQL| postgresql.empty_rules.host| 5432| rdl_test_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
<row values="rdl_test_2| PostgreSQL| postgresql.empty_rules.host| 5432| rdl_test_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/alter_resource.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/alter_resource.xml
index a972ee9b76f..afac90b0278 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/alter_resource.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/alter_resource.xml
@@ -30,25 +30,25 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_write_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_read_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
+ <row values="write_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="read_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
<row values="rdl_test_0| PostgreSQL| postgresql.empty_rules.host| 5432| rdl_test_0| 30000| 60000| 1800000| 2| 2| false| {"maxLifetimeMilliseconds":180000,"readOnly":false,"minPoolSize":10,"idleTimeoutMilliseconds":6000,"maxPoolSize":10,"connectionTimeoutMilliseconds":3000}" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/drop_resource.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/drop_resource.xml
index a3e5e958ba8..e6aa3543392 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/drop_resource.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/dataset/empty_rules/postgresql/drop_resource.xml
@@ -30,24 +30,24 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="encrypt_write_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_write_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoComm [...]
- <row values="encrypt_read_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
- <row values="encrypt_read_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| encrypt_read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit [...]
+ <row values="write_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="write_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| write_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru [...]
+ <row values="read_ds_0| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_0| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_1| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_1| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_2| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_2| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_3| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_3| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_4| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_4| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_5| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_5| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_6| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_6| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_7| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_7| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_8| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_8| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
+ <row values="read_ds_9| PostgreSQL| postgresql.empty_rules.host| 5432| read_ds_9| 30000| 60000| 1800000| 2| 2| false| {"dataSourceProperties":{},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true& [...]
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/rdl-integration-test-cases.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/rdl-integration-test-cases.xml
index c67bf06afd3..8284a90630d 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/rdl-integration-test-cases.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/rdl/rdl-integration-test-cases.xml
@@ -64,7 +64,7 @@
<!-- <test-case sql="SHOW SHARDING TABLE RULE t_user">-->
<!-- <assertion expected-data-file="create_sharding_rules.xml">-->
<!-- <initial-sql sql="DROP SHARDING TABLE RULE t_user;CREATE SHARDING TABLE RULE t_user (-->
-<!-- RESOURCES("encrypt_write_ds_${0..9}"),-->
+<!-- RESOURCES("write_ds_${0..9}"),-->
<!-- SHARDING_COLUMN=user_id, TYPE(NAME=MOD, PROPERTIES("sharding-count"=40)))))"/>-->
<!-- <destroy-sql sql="DROP SHARDING TABLE RULE t_user" />-->
<!-- </assertion>-->
@@ -74,7 +74,7 @@
<!-- <assertion expected-data-file="drop_sharding_rules.xml">-->
<!-- <initial-sql sql="DROP SHARDING TABLE RULE t_user_item"/>-->
<!-- <destroy-sql sql="CREATE SHARDING TABLE RULE t_user_item (-->
-<!-- RESOURCES("encrypt_write_ds_${0..9}"),-->
+<!-- RESOURCES("write_ds_${0..9}"),-->
<!-- SHARDING_COLUMN=user_id, TYPE(NAME=MOD, PROPERTIES("sharding-count"=40)))))" />-->
<!-- </assertion>-->
<!-- </test-case>-->
@@ -82,7 +82,7 @@
<!-- <test-case sql="SHOW SHARDING BINDING TABLE RULES">-->
<!-- <assertion expected-data-file="create_binding_rules.xml">-->
<!-- <initial-sql sql="CREATE SHARDING TABLE RULE t_user (-->
-<!-- RESOURCES("encrypt_write_ds_${0..9}"),-->
+<!-- RESOURCES("write_ds_${0..9}"),-->
<!-- SHARDING_COLUMN=user_id, TYPE(NAME=MOD, PROPERTIES("sharding-count"=40)))));-->
<!-- CREATE SHARDING BINDING TABLE RULES (t_user,t_user_item)"/>-->
<!-- <destroy-sql sql="DROP SHARDING BINDING TABLE RULES;DROP SHARDING TABLE RULE t_user" />-->
@@ -92,7 +92,7 @@
<!-- <test-case sql="SHOW SHARDING BINDING TABLE RULES">-->
<!-- <assertion expected-data-file="alter_binding_rules.xml">-->
<!-- <initial-sql sql="CREATE SHARDING TABLE RULE t_user (-->
-<!-- RESOURCES("encrypt_write_ds_${0..9}"),-->
+<!-- RESOURCES("write_ds_${0..9}"),-->
<!-- SHARDING_COLUMN=user_id, TYPE(NAME=MOD, PROPERTIES("sharding-count"=40)))));-->
<!-- ALTER SHARDING BINDING TABLE RULES (t_user,t_user_item);"/>-->
<!-- <destroy-sql sql="DROP SHARDING BINDING TABLE RULES;DROP SHARDING TABLE RULE t_user" />-->
@@ -102,7 +102,7 @@
<!-- <test-case sql="SHOW SHARDING BINDING TABLE RULES">-->
<!-- <assertion expected-data-file="drop_binding_rules.xml">-->
<!-- <initial-sql sql="CREATE SHARDING TABLE RULE t_user (-->
-<!-- RESOURCES("encrypt_write_ds_${0..9}"),-->
+<!-- RESOURCES("write_ds_${0..9}"),-->
<!-- SHARDING_COLUMN=user_id, TYPE(NAME=MOD, PROPERTIES("sharding-count"=40)))));-->
<!-- CREATE SHARDING BINDING TABLE RULES (t_user,t_user_item);-->
<!-- DROP SHARDING BINDING TABLE RULES;DROP SHARDING TABLE RULE t_user"/>-->
@@ -124,7 +124,7 @@
<!-- </test-case>-->
<!-- -->
<!-- <test-case sql="SHOW ENCRYPT TABLE RULE t_user">-->
-<!-- <assertion expected-data-file="create_encrypt_rule.xml">-->
+<!-- <assertion expected-data-file="create_rule.xml">-->
<!-- <initial-sql sql="CREATE ENCRYPT RULE t_user (COLUMNS ((-->
<!-- NAME=pwd, PLAIN=pwd_plain, CIPHER=pwd_cipher, TYPE(NAME="AES",-->
<!-- PROPERTIES("aes-key-value"='123456abc')))))"/>-->
@@ -133,7 +133,7 @@
<!-- </test-case>-->
<!-- -->
<!-- <test-case sql="SHOW ENCRYPT TABLE RULE t_user">-->
-<!-- <assertion expected-data-file="alter_encrypt_rule.xml">-->
+<!-- <assertion expected-data-file="alter_rule.xml">-->
<!-- <initial-sql sql="CREATE ENCRYPT RULE t_user (COLUMNS ((-->
<!-- NAME=pwd, PLAIN=pwd_plain, CIPHER=pwd_cipher, TYPE(NAME="AES", PROPERTIES("aes-key-value"='123456abc')))));-->
<!-- ALTER ENCRYPT RULE t_user (COLUMNS ((NAME=pwd, PLAIN=pwd_plain, CIPHER=pwd_cipher, TYPE(NAME="AES",-->
@@ -143,7 +143,7 @@
<!-- </test-case>-->
<!-- -->
<!-- <test-case sql="SHOW ENCRYPT RULES">-->
-<!-- <assertion expected-data-file="drop_encrypt_rule.xml">-->
+<!-- <assertion expected-data-file="drop_rule.xml">-->
<!-- <initial-sql sql="CREATE ENCRYPT RULE t_user (COLUMNS ((-->
<!-- NAME=pwd, PLAIN=pwd_plain, CIPHER=pwd_cipher, TYPE(NAME="AES",-->
<!-- PROPERTIES("aes-key-value"='123456abc')))));-->
@@ -153,18 +153,18 @@
<!-- -->
<!-- <test-case sql="SHOW READWRITE_SPLITTING RULES">-->
<!-- <assertion expected-data-file="create_readwrite_splitting_rules.xml">-->
-<!-- <initial-sql sql="CREATE READWRITE_SPLITTING RULE readwrite_ds_1 (WRITE_RESOURCE=encrypt_write_ds_1,-->
-<!-- READ_RESOURCES(encrypt_read_ds_1), TYPE(NAME=ROUND_ROBIN))"/>-->
+<!-- <initial-sql sql="CREATE READWRITE_SPLITTING RULE readwrite_ds_1 (WRITE_RESOURCE=write_ds_1,-->
+<!-- READ_RESOURCES(read_ds_1), TYPE(NAME=ROUND_ROBIN))"/>-->
<!-- <destroy-sql sql="DROP READWRITE_SPLITTING RULE readwrite_ds_1" />-->
<!-- </assertion>-->
<!-- </test-case>-->
<!-- -->
<!-- <test-case sql="SHOW READWRITE_SPLITTING RULES">-->
<!-- <assertion expected-data-file="alter_readwrite_splitting_rules.xml">-->
-<!-- <initial-sql sql="CREATE READWRITE_SPLITTING RULE readwrite_ds_1 (WRITE_RESOURCE=encrypt_write_ds_1,-->
-<!-- READ_RESOURCES(encrypt_read_ds_1), TYPE(NAME=ROUND_ROBIN));-->
-<!-- ALTER READWRITE_SPLITTING RULE readwrite_ds_1 (WRITE_RESOURCE=encrypt_write_ds_1,-->
-<!-- READ_RESOURCES(encrypt_read_ds_1, encrypt_read_ds_2), TYPE(NAME=RANDOM,PROPERTIES(read_weight='2:1')))"/>-->
+<!-- <initial-sql sql="CREATE READWRITE_SPLITTING RULE readwrite_ds_1 (WRITE_RESOURCE=write_ds_1,-->
+<!-- READ_RESOURCES(read_ds_1), TYPE(NAME=ROUND_ROBIN));-->
+<!-- ALTER READWRITE_SPLITTING RULE readwrite_ds_1 (WRITE_RESOURCE=write_ds_1,-->
+<!-- READ_RESOURCES(read_ds_1, read_ds_2), TYPE(NAME=RANDOM,PROPERTIES(read_weight='2:1')))"/>-->
<!-- <destroy-sql sql="DROP READWRITE_SPLITTING RULE readwrite_ds_1;" />-->
<!-- </assertion>-->
<!-- </test-case>-->
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/authority.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/authority.xml
index e02da70721c..e410e85bb21 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/authority.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/authority.xml
@@ -50,26 +50,26 @@
<user-create>
<sql>CREATE ROLE default_role</sql>
<sql>CREATE USER user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_write_ds_0.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_write_ds_1.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_write_ds_2.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_write_ds_3.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_write_ds_4.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_write_ds_5.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_write_ds_6.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_write_ds_7.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_write_ds_8.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_write_ds_9.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_read_ds_0.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_read_ds_1.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_read_ds_2.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_read_ds_3.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_read_ds_4.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_read_ds_5.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_read_ds_6.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_read_ds_7.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_read_ds_8.* to user_dev@localhost</sql>
- <sql>GRANT select,update,insert,delete on encrypt_read_ds_9.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on write_ds_0.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on write_ds_1.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on write_ds_2.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on write_ds_3.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on write_ds_4.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on write_ds_5.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on write_ds_6.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on write_ds_7.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on write_ds_8.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on write_ds_9.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on read_ds_0.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on read_ds_1.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on read_ds_2.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on read_ds_3.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on read_ds_4.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on read_ds_5.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on read_ds_6.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on read_ds_7.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on read_ds_8.* to user_dev@localhost</sql>
+ <sql>GRANT select,update,insert,delete on read_ds_9.* to user_dev@localhost</sql>
</user-create>
<user-drop>
<sql>DROP USER IF EXISTS user_dev@localhost</sql>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/databases.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/databases.xml
index eb8634a182b..4deb55bb82c 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/databases.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/databases.xml
@@ -17,24 +17,24 @@
-->
<databases>
- <database>encrypt_write_ds_0</database>
- <database>encrypt_write_ds_1</database>
- <database>encrypt_write_ds_2</database>
- <database>encrypt_write_ds_3</database>
- <database>encrypt_write_ds_4</database>
- <database>encrypt_write_ds_5</database>
- <database>encrypt_write_ds_6</database>
- <database>encrypt_write_ds_7</database>
- <database>encrypt_write_ds_8</database>
- <database>encrypt_write_ds_9</database>
- <database>encrypt_read_ds_0</database>
- <database>encrypt_read_ds_1</database>
- <database>encrypt_read_ds_2</database>
- <database>encrypt_read_ds_3</database>
- <database>encrypt_read_ds_4</database>
- <database>encrypt_read_ds_5</database>
- <database>encrypt_read_ds_6</database>
- <database>encrypt_read_ds_7</database>
- <database>encrypt_read_ds_8</database>
- <database>encrypt_read_ds_9</database>
+ <database>write_ds_0</database>
+ <database>write_ds_1</database>
+ <database>write_ds_2</database>
+ <database>write_ds_3</database>
+ <database>write_ds_4</database>
+ <database>write_ds_5</database>
+ <database>write_ds_6</database>
+ <database>write_ds_7</database>
+ <database>write_ds_8</database>
+ <database>write_ds_9</database>
+ <database>read_ds_0</database>
+ <database>read_ds_1</database>
+ <database>read_ds_2</database>
+ <database>read_ds_3</database>
+ <database>read_ds_4</database>
+ <database>read_ds_5</database>
+ <database>read_ds_6</database>
+ <database>read_ds_7</database>
+ <database>read_ds_8</database>
+ <database>read_ds_9</database>
</databases>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/mysql/01-actual-init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/mysql/01-actual-init.sql
index 5d5e0611f6f..ff01fa4ce08 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/mysql/01-actual-init.sql
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/mysql/01-actual-init.sql
@@ -18,310 +18,310 @@
SET character_set_database='utf8';
SET character_set_server='utf8';
-DROP DATABASE IF EXISTS encrypt_write_ds_0;
-DROP DATABASE IF EXISTS encrypt_write_ds_1;
-DROP DATABASE IF EXISTS encrypt_write_ds_2;
-DROP DATABASE IF EXISTS encrypt_write_ds_3;
-DROP DATABASE IF EXISTS encrypt_write_ds_4;
-DROP DATABASE IF EXISTS encrypt_write_ds_5;
-DROP DATABASE IF EXISTS encrypt_write_ds_6;
-DROP DATABASE IF EXISTS encrypt_write_ds_7;
-DROP DATABASE IF EXISTS encrypt_write_ds_8;
-DROP DATABASE IF EXISTS encrypt_write_ds_9;
-DROP DATABASE IF EXISTS encrypt_read_ds_0;
-DROP DATABASE IF EXISTS encrypt_read_ds_1;
-DROP DATABASE IF EXISTS encrypt_read_ds_2;
-DROP DATABASE IF EXISTS encrypt_read_ds_3;
-DROP DATABASE IF EXISTS encrypt_read_ds_4;
-DROP DATABASE IF EXISTS encrypt_read_ds_5;
-DROP DATABASE IF EXISTS encrypt_read_ds_6;
-DROP DATABASE IF EXISTS encrypt_read_ds_7;
-DROP DATABASE IF EXISTS encrypt_read_ds_8;
-DROP DATABASE IF EXISTS encrypt_read_ds_9;
+DROP DATABASE IF EXISTS write_ds_0;
+DROP DATABASE IF EXISTS write_ds_1;
+DROP DATABASE IF EXISTS write_ds_2;
+DROP DATABASE IF EXISTS write_ds_3;
+DROP DATABASE IF EXISTS write_ds_4;
+DROP DATABASE IF EXISTS write_ds_5;
+DROP DATABASE IF EXISTS write_ds_6;
+DROP DATABASE IF EXISTS write_ds_7;
+DROP DATABASE IF EXISTS write_ds_8;
+DROP DATABASE IF EXISTS write_ds_9;
+DROP DATABASE IF EXISTS read_ds_0;
+DROP DATABASE IF EXISTS read_ds_1;
+DROP DATABASE IF EXISTS read_ds_2;
+DROP DATABASE IF EXISTS read_ds_3;
+DROP DATABASE IF EXISTS read_ds_4;
+DROP DATABASE IF EXISTS read_ds_5;
+DROP DATABASE IF EXISTS read_ds_6;
+DROP DATABASE IF EXISTS read_ds_7;
+DROP DATABASE IF EXISTS read_ds_8;
+DROP DATABASE IF EXISTS read_ds_9;
-CREATE DATABASE encrypt_write_ds_0;
-CREATE DATABASE encrypt_write_ds_1;
-CREATE DATABASE encrypt_write_ds_2;
-CREATE DATABASE encrypt_write_ds_3;
-CREATE DATABASE encrypt_write_ds_4;
-CREATE DATABASE encrypt_write_ds_5;
-CREATE DATABASE encrypt_write_ds_6;
-CREATE DATABASE encrypt_write_ds_7;
-CREATE DATABASE encrypt_write_ds_8;
-CREATE DATABASE encrypt_write_ds_9;
-CREATE DATABASE encrypt_read_ds_0;
-CREATE DATABASE encrypt_read_ds_1;
-CREATE DATABASE encrypt_read_ds_2;
-CREATE DATABASE encrypt_read_ds_3;
-CREATE DATABASE encrypt_read_ds_4;
-CREATE DATABASE encrypt_read_ds_5;
-CREATE DATABASE encrypt_read_ds_6;
-CREATE DATABASE encrypt_read_ds_7;
-CREATE DATABASE encrypt_read_ds_8;
-CREATE DATABASE encrypt_read_ds_9;
+CREATE DATABASE write_ds_0;
+CREATE DATABASE write_ds_1;
+CREATE DATABASE write_ds_2;
+CREATE DATABASE write_ds_3;
+CREATE DATABASE write_ds_4;
+CREATE DATABASE write_ds_5;
+CREATE DATABASE write_ds_6;
+CREATE DATABASE write_ds_7;
+CREATE DATABASE write_ds_8;
+CREATE DATABASE write_ds_9;
+CREATE DATABASE read_ds_0;
+CREATE DATABASE read_ds_1;
+CREATE DATABASE read_ds_2;
+CREATE DATABASE read_ds_3;
+CREATE DATABASE read_ds_4;
+CREATE DATABASE read_ds_5;
+CREATE DATABASE read_ds_6;
+CREATE DATABASE read_ds_7;
+CREATE DATABASE read_ds_8;
+CREATE DATABASE read_ds_9;
CREATE DATABASE rdl_test_0;
CREATE DATABASE rdl_test_1;
CREATE DATABASE rdl_test_2;
-CREATE TABLE encrypt_write_ds_0.t_user_0 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_0.t_user_item_0 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_0.t_user_10 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_0.t_user_item_10 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_0.t_user_20 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_0.t_user_item_20 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_0.t_user_30 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_0.t_user_item_30 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_0.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE INDEX user_index_t_user_0 ON encrypt_write_ds_0.t_user_0 (user_id);
-CREATE INDEX user_index_t_user_10 ON encrypt_write_ds_0.t_user_10 (user_id);
-CREATE INDEX user_index_t_user_20 ON encrypt_write_ds_0.t_user_20 (user_id);
-CREATE INDEX user_index_t_user_30 ON encrypt_write_ds_0.t_user_30 (user_id);
+CREATE TABLE write_ds_0.t_user_0 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_0.t_user_item_0 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_0.t_user_10 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_0.t_user_item_10 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_0.t_user_20 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_0.t_user_item_20 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_0.t_user_30 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_0.t_user_item_30 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_0.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
+CREATE INDEX user_index_t_user_0 ON write_ds_0.t_user_0 (user_id);
+CREATE INDEX user_index_t_user_10 ON write_ds_0.t_user_10 (user_id);
+CREATE INDEX user_index_t_user_20 ON write_ds_0.t_user_20 (user_id);
+CREATE INDEX user_index_t_user_30 ON write_ds_0.t_user_30 (user_id);
-CREATE TABLE encrypt_write_ds_1.t_user_1 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_1.t_user_item_1 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_1.t_user_11 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_1.t_user_item_11 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_1.t_user_21 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_1.t_user_item_21 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_1.t_user_31 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_1.t_user_item_31 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_1 ON encrypt_write_ds_1.t_user_1 (user_id);
-CREATE INDEX user_index_t_user_11 ON encrypt_write_ds_1.t_user_11 (user_id);
-CREATE INDEX user_index_t_user_21 ON encrypt_write_ds_1.t_user_21 (user_id);
-CREATE INDEX user_index_t_user_31 ON encrypt_write_ds_1.t_user_31 (user_id);
+CREATE TABLE write_ds_1.t_user_1 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_1.t_user_item_1 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_1.t_user_11 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_1.t_user_item_11 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_1.t_user_21 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_1.t_user_item_21 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_1.t_user_31 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_1.t_user_item_31 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_1 ON write_ds_1.t_user_1 (user_id);
+CREATE INDEX user_index_t_user_11 ON write_ds_1.t_user_11 (user_id);
+CREATE INDEX user_index_t_user_21 ON write_ds_1.t_user_21 (user_id);
+CREATE INDEX user_index_t_user_31 ON write_ds_1.t_user_31 (user_id);
-CREATE TABLE encrypt_write_ds_2.t_user_2 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_2.t_user_item_2 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_2.t_user_12 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_2.t_user_item_12 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_2.t_user_22 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_2.t_user_item_22 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_2.t_user_32 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_2.t_user_item_32 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_2 ON encrypt_write_ds_2.t_user_2 (user_id);
-CREATE INDEX user_index_t_user_12 ON encrypt_write_ds_2.t_user_12 (user_id);
-CREATE INDEX user_index_t_user_22 ON encrypt_write_ds_2.t_user_22 (user_id);
-CREATE INDEX user_index_t_user_32 ON encrypt_write_ds_2.t_user_32 (user_id);
+CREATE TABLE write_ds_2.t_user_2 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_2.t_user_item_2 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_2.t_user_12 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_2.t_user_item_12 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_2.t_user_22 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_2.t_user_item_22 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_2.t_user_32 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_2.t_user_item_32 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_2 ON write_ds_2.t_user_2 (user_id);
+CREATE INDEX user_index_t_user_12 ON write_ds_2.t_user_12 (user_id);
+CREATE INDEX user_index_t_user_22 ON write_ds_2.t_user_22 (user_id);
+CREATE INDEX user_index_t_user_32 ON write_ds_2.t_user_32 (user_id);
-CREATE TABLE encrypt_write_ds_3.t_user_3 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_3.t_user_item_3 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_3.t_user_13 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_3.t_user_item_13 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_3.t_user_23 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_3.t_user_item_23 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_3.t_user_33 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_3.t_user_item_33 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_3 ON encrypt_write_ds_3.t_user_3 (user_id);
-CREATE INDEX user_index_t_user_13 ON encrypt_write_ds_3.t_user_13 (user_id);
-CREATE INDEX user_index_t_user_23 ON encrypt_write_ds_3.t_user_23 (user_id);
-CREATE INDEX user_index_t_user_33 ON encrypt_write_ds_3.t_user_33 (user_id);
+CREATE TABLE write_ds_3.t_user_3 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_3.t_user_item_3 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_3.t_user_13 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_3.t_user_item_13 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_3.t_user_23 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_3.t_user_item_23 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_3.t_user_33 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_3.t_user_item_33 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_3 ON write_ds_3.t_user_3 (user_id);
+CREATE INDEX user_index_t_user_13 ON write_ds_3.t_user_13 (user_id);
+CREATE INDEX user_index_t_user_23 ON write_ds_3.t_user_23 (user_id);
+CREATE INDEX user_index_t_user_33 ON write_ds_3.t_user_33 (user_id);
-CREATE TABLE encrypt_write_ds_4.t_user_4 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_4.t_user_item_4 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_4.t_user_14 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_4.t_user_item_14 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_4.t_user_24 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_4.t_user_item_24 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_4.t_user_34 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_4.t_user_item_34 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_4 ON encrypt_write_ds_4.t_user_4 (user_id);
-CREATE INDEX user_index_t_user_14 ON encrypt_write_ds_4.t_user_14 (user_id);
-CREATE INDEX user_index_t_user_24 ON encrypt_write_ds_4.t_user_24 (user_id);
-CREATE INDEX user_index_t_user_34 ON encrypt_write_ds_4.t_user_34 (user_id);
+CREATE TABLE write_ds_4.t_user_4 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_4.t_user_item_4 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_4.t_user_14 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_4.t_user_item_14 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_4.t_user_24 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_4.t_user_item_24 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_4.t_user_34 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_4.t_user_item_34 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_4 ON write_ds_4.t_user_4 (user_id);
+CREATE INDEX user_index_t_user_14 ON write_ds_4.t_user_14 (user_id);
+CREATE INDEX user_index_t_user_24 ON write_ds_4.t_user_24 (user_id);
+CREATE INDEX user_index_t_user_34 ON write_ds_4.t_user_34 (user_id);
-CREATE TABLE encrypt_write_ds_5.t_user_5 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_5.t_user_item_5 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_5.t_user_15 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_5.t_user_item_15 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_5.t_user_25 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_5.t_user_item_25 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_5.t_user_35 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_5.t_user_item_35 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_5 ON encrypt_write_ds_5.t_user_5 (user_id);
-CREATE INDEX user_index_t_user_15 ON encrypt_write_ds_5.t_user_15 (user_id);
-CREATE INDEX user_index_t_user_25 ON encrypt_write_ds_5.t_user_25 (user_id);
-CREATE INDEX user_index_t_user_35 ON encrypt_write_ds_5.t_user_35 (user_id);
+CREATE TABLE write_ds_5.t_user_5 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_5.t_user_item_5 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_5.t_user_15 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_5.t_user_item_15 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_5.t_user_25 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_5.t_user_item_25 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_5.t_user_35 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_5.t_user_item_35 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_5 ON write_ds_5.t_user_5 (user_id);
+CREATE INDEX user_index_t_user_15 ON write_ds_5.t_user_15 (user_id);
+CREATE INDEX user_index_t_user_25 ON write_ds_5.t_user_25 (user_id);
+CREATE INDEX user_index_t_user_35 ON write_ds_5.t_user_35 (user_id);
-CREATE TABLE encrypt_write_ds_6.t_user_6 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_6.t_user_item_6 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_6.t_user_16 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_6.t_user_item_16 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_6.t_user_26 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_6.t_user_item_26 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_6.t_user_36 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_6.t_user_item_36 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_6 ON encrypt_write_ds_6.t_user_6 (user_id);
-CREATE INDEX user_index_t_user_16 ON encrypt_write_ds_6.t_user_16 (user_id);
-CREATE INDEX user_index_t_user_26 ON encrypt_write_ds_6.t_user_26 (user_id);
-CREATE INDEX user_index_t_user_36 ON encrypt_write_ds_6.t_user_36 (user_id);
+CREATE TABLE write_ds_6.t_user_6 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_6.t_user_item_6 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_6.t_user_16 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_6.t_user_item_16 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_6.t_user_26 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_6.t_user_item_26 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_6.t_user_36 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_6.t_user_item_36 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_6 ON write_ds_6.t_user_6 (user_id);
+CREATE INDEX user_index_t_user_16 ON write_ds_6.t_user_16 (user_id);
+CREATE INDEX user_index_t_user_26 ON write_ds_6.t_user_26 (user_id);
+CREATE INDEX user_index_t_user_36 ON write_ds_6.t_user_36 (user_id);
-CREATE TABLE encrypt_write_ds_7.t_user_7 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_7.t_user_item_7 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_7.t_user_17 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_7.t_user_item_17 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_7.t_user_27 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_7.t_user_item_27 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_7.t_user_37 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_7.t_user_item_37 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_7 ON encrypt_write_ds_7.t_user_7 (user_id);
-CREATE INDEX user_index_t_user_17 ON encrypt_write_ds_7.t_user_17 (user_id);
-CREATE INDEX user_index_t_user_27 ON encrypt_write_ds_7.t_user_27 (user_id);
-CREATE INDEX user_index_t_user_37 ON encrypt_write_ds_7.t_user_37 (user_id);
+CREATE TABLE write_ds_7.t_user_7 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_7.t_user_item_7 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_7.t_user_17 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_7.t_user_item_17 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_7.t_user_27 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_7.t_user_item_27 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_7.t_user_37 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_7.t_user_item_37 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_7 ON write_ds_7.t_user_7 (user_id);
+CREATE INDEX user_index_t_user_17 ON write_ds_7.t_user_17 (user_id);
+CREATE INDEX user_index_t_user_27 ON write_ds_7.t_user_27 (user_id);
+CREATE INDEX user_index_t_user_37 ON write_ds_7.t_user_37 (user_id);
-CREATE TABLE encrypt_write_ds_8.t_user_8 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_8.t_user_item_8 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_8.t_user_18 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_8.t_user_item_18 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_8.t_user_28 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_8.t_user_item_28 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_8.t_user_38 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_8.t_user_item_38 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_8 ON encrypt_write_ds_8.t_user_8 (user_id);
-CREATE INDEX user_index_t_user_18 ON encrypt_write_ds_8.t_user_18 (user_id);
-CREATE INDEX user_index_t_user_28 ON encrypt_write_ds_8.t_user_28 (user_id);
-CREATE INDEX user_index_t_user_38 ON encrypt_write_ds_8.t_user_38 (user_id);
+CREATE TABLE write_ds_8.t_user_8 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_8.t_user_item_8 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_8.t_user_18 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_8.t_user_item_18 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_8.t_user_28 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_8.t_user_item_28 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_8.t_user_38 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_8.t_user_item_38 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_8 ON write_ds_8.t_user_8 (user_id);
+CREATE INDEX user_index_t_user_18 ON write_ds_8.t_user_18 (user_id);
+CREATE INDEX user_index_t_user_28 ON write_ds_8.t_user_28 (user_id);
+CREATE INDEX user_index_t_user_38 ON write_ds_8.t_user_38 (user_id);
-CREATE TABLE encrypt_write_ds_9.t_user_9 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_9.t_user_item_9 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_9.t_user_19 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_9.t_user_item_19 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_9.t_user_29 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_9.t_user_item_29 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_write_ds_9.t_user_39 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_write_ds_9.t_user_item_39 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_9 ON encrypt_write_ds_9.t_user_9 (user_id);
-CREATE INDEX user_index_t_user_19 ON encrypt_write_ds_9.t_user_19 (user_id);
-CREATE INDEX user_index_t_user_29 ON encrypt_write_ds_9.t_user_29 (user_id);
-CREATE INDEX user_index_t_user_39 ON encrypt_write_ds_9.t_user_39 (user_id);
+CREATE TABLE write_ds_9.t_user_9 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_9.t_user_item_9 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_9.t_user_19 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_9.t_user_item_19 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_9.t_user_29 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_9.t_user_item_29 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE write_ds_9.t_user_39 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE write_ds_9.t_user_item_39 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_9 ON write_ds_9.t_user_9 (user_id);
+CREATE INDEX user_index_t_user_19 ON write_ds_9.t_user_19 (user_id);
+CREATE INDEX user_index_t_user_29 ON write_ds_9.t_user_29 (user_id);
+CREATE INDEX user_index_t_user_39 ON write_ds_9.t_user_39 (user_id);
-CREATE TABLE encrypt_read_ds_0.t_user_0 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_0.t_user_item_0 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_0.t_user_10 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_0.t_user_item_10 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_0.t_user_20 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_0.t_user_item_20 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_0.t_user_30 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_0.t_user_item_30 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_0.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
-CREATE INDEX user_index_t_user_0 ON encrypt_read_ds_0.t_user_0 (user_id);
-CREATE INDEX user_index_t_user_10 ON encrypt_read_ds_0.t_user_10 (user_id);
-CREATE INDEX user_index_t_user_20 ON encrypt_read_ds_0.t_user_20 (user_id);
-CREATE INDEX user_index_t_user_30 ON encrypt_read_ds_0.t_user_30 (user_id);
+CREATE TABLE read_ds_0.t_user_0 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_0.t_user_item_0 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_0.t_user_10 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_0.t_user_item_10 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_0.t_user_20 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_0.t_user_item_20 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_0.t_user_30 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_0.t_user_item_30 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_0.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
+CREATE INDEX user_index_t_user_0 ON read_ds_0.t_user_0 (user_id);
+CREATE INDEX user_index_t_user_10 ON read_ds_0.t_user_10 (user_id);
+CREATE INDEX user_index_t_user_20 ON read_ds_0.t_user_20 (user_id);
+CREATE INDEX user_index_t_user_30 ON read_ds_0.t_user_30 (user_id);
-CREATE TABLE encrypt_read_ds_1.t_user_1 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_1.t_user_item_1 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_1.t_user_11 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_1.t_user_item_11 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_1.t_user_21 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_1.t_user_item_21 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_1.t_user_31 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_1.t_user_item_31 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_1 ON encrypt_read_ds_1.t_user_1 (user_id);
-CREATE INDEX user_index_t_user_11 ON encrypt_read_ds_1.t_user_11 (user_id);
-CREATE INDEX user_index_t_user_21 ON encrypt_read_ds_1.t_user_21 (user_id);
-CREATE INDEX user_index_t_user_31 ON encrypt_read_ds_1.t_user_31 (user_id);
+CREATE TABLE read_ds_1.t_user_1 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_1.t_user_item_1 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_1.t_user_11 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_1.t_user_item_11 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_1.t_user_21 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_1.t_user_item_21 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_1.t_user_31 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_1.t_user_item_31 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_1 ON read_ds_1.t_user_1 (user_id);
+CREATE INDEX user_index_t_user_11 ON read_ds_1.t_user_11 (user_id);
+CREATE INDEX user_index_t_user_21 ON read_ds_1.t_user_21 (user_id);
+CREATE INDEX user_index_t_user_31 ON read_ds_1.t_user_31 (user_id);
-CREATE TABLE encrypt_read_ds_2.t_user_2 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_2.t_user_item_2 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_2.t_user_12 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_2.t_user_item_12 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_2.t_user_22 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_2.t_user_item_22 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_2.t_user_32 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_2.t_user_item_32 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_2 ON encrypt_read_ds_2.t_user_2 (user_id);
-CREATE INDEX user_index_t_user_12 ON encrypt_read_ds_2.t_user_12 (user_id);
-CREATE INDEX user_index_t_user_22 ON encrypt_read_ds_2.t_user_22 (user_id);
-CREATE INDEX user_index_t_user_32 ON encrypt_read_ds_2.t_user_32 (user_id);
+CREATE TABLE read_ds_2.t_user_2 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_2.t_user_item_2 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_2.t_user_12 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_2.t_user_item_12 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_2.t_user_22 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_2.t_user_item_22 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_2.t_user_32 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_2.t_user_item_32 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_2 ON read_ds_2.t_user_2 (user_id);
+CREATE INDEX user_index_t_user_12 ON read_ds_2.t_user_12 (user_id);
+CREATE INDEX user_index_t_user_22 ON read_ds_2.t_user_22 (user_id);
+CREATE INDEX user_index_t_user_32 ON read_ds_2.t_user_32 (user_id);
-CREATE TABLE encrypt_read_ds_3.t_user_3 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_3.t_user_item_3 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_3.t_user_13 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_3.t_user_item_13 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_3.t_user_23 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_3.t_user_item_23 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_3.t_user_33 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_3.t_user_item_33 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_3 ON encrypt_read_ds_3.t_user_3 (user_id);
-CREATE INDEX user_index_t_user_13 ON encrypt_read_ds_3.t_user_13 (user_id);
-CREATE INDEX user_index_t_user_23 ON encrypt_read_ds_3.t_user_23 (user_id);
-CREATE INDEX user_index_t_user_33 ON encrypt_read_ds_3.t_user_33 (user_id);
+CREATE TABLE read_ds_3.t_user_3 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_3.t_user_item_3 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_3.t_user_13 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_3.t_user_item_13 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_3.t_user_23 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_3.t_user_item_23 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_3.t_user_33 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_3.t_user_item_33 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_3 ON read_ds_3.t_user_3 (user_id);
+CREATE INDEX user_index_t_user_13 ON read_ds_3.t_user_13 (user_id);
+CREATE INDEX user_index_t_user_23 ON read_ds_3.t_user_23 (user_id);
+CREATE INDEX user_index_t_user_33 ON read_ds_3.t_user_33 (user_id);
-CREATE TABLE encrypt_read_ds_4.t_user_4 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_4.t_user_item_4 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_4.t_user_14 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_4.t_user_item_14 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_4.t_user_24 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_4.t_user_item_24 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_4.t_user_34 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_4.t_user_item_34 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_4 ON encrypt_read_ds_4.t_user_4 (user_id);
-CREATE INDEX user_index_t_user_14 ON encrypt_read_ds_4.t_user_14 (user_id);
-CREATE INDEX user_index_t_user_24 ON encrypt_read_ds_4.t_user_24 (user_id);
-CREATE INDEX user_index_t_user_34 ON encrypt_read_ds_4.t_user_34 (user_id);
+CREATE TABLE read_ds_4.t_user_4 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_4.t_user_item_4 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_4.t_user_14 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_4.t_user_item_14 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_4.t_user_24 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_4.t_user_item_24 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_4.t_user_34 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_4.t_user_item_34 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_4 ON read_ds_4.t_user_4 (user_id);
+CREATE INDEX user_index_t_user_14 ON read_ds_4.t_user_14 (user_id);
+CREATE INDEX user_index_t_user_24 ON read_ds_4.t_user_24 (user_id);
+CREATE INDEX user_index_t_user_34 ON read_ds_4.t_user_34 (user_id);
-CREATE TABLE encrypt_read_ds_5.t_user_5 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_5.t_user_item_5 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_5.t_user_15 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_5.t_user_item_15 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_5.t_user_25 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_5.t_user_item_25 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_5.t_user_35 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_5.t_user_item_35 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_5 ON encrypt_read_ds_5.t_user_5 (user_id);
-CREATE INDEX user_index_t_user_15 ON encrypt_read_ds_5.t_user_15 (user_id);
-CREATE INDEX user_index_t_user_25 ON encrypt_read_ds_5.t_user_25 (user_id);
-CREATE INDEX user_index_t_user_35 ON encrypt_read_ds_5.t_user_35 (user_id);
+CREATE TABLE read_ds_5.t_user_5 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_5.t_user_item_5 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_5.t_user_15 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_5.t_user_item_15 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_5.t_user_25 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_5.t_user_item_25 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_5.t_user_35 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_5.t_user_item_35 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_5 ON read_ds_5.t_user_5 (user_id);
+CREATE INDEX user_index_t_user_15 ON read_ds_5.t_user_15 (user_id);
+CREATE INDEX user_index_t_user_25 ON read_ds_5.t_user_25 (user_id);
+CREATE INDEX user_index_t_user_35 ON read_ds_5.t_user_35 (user_id);
-CREATE TABLE encrypt_read_ds_6.t_user_6 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_6.t_user_item_6 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_6.t_user_16 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_6.t_user_item_16 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_6.t_user_26 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_6.t_user_item_26 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_6.t_user_36 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_6.t_user_item_36 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_6 ON encrypt_read_ds_6.t_user_6 (user_id);
-CREATE INDEX user_index_t_user_16 ON encrypt_read_ds_6.t_user_16 (user_id);
-CREATE INDEX user_index_t_user_26 ON encrypt_read_ds_6.t_user_26 (user_id);
-CREATE INDEX user_index_t_user_36 ON encrypt_read_ds_6.t_user_36 (user_id);
+CREATE TABLE read_ds_6.t_user_6 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_6.t_user_item_6 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_6.t_user_16 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_6.t_user_item_16 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_6.t_user_26 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_6.t_user_item_26 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_6.t_user_36 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_6.t_user_item_36 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_6 ON read_ds_6.t_user_6 (user_id);
+CREATE INDEX user_index_t_user_16 ON read_ds_6.t_user_16 (user_id);
+CREATE INDEX user_index_t_user_26 ON read_ds_6.t_user_26 (user_id);
+CREATE INDEX user_index_t_user_36 ON read_ds_6.t_user_36 (user_id);
-CREATE TABLE encrypt_read_ds_7.t_user_7 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_7.t_user_item_7 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_7.t_user_17 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_7.t_user_item_17 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_7.t_user_27 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_7.t_user_item_27 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_7.t_user_37 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_7.t_user_item_37 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_7 ON encrypt_read_ds_7.t_user_7 (user_id);
-CREATE INDEX user_index_t_user_17 ON encrypt_read_ds_7.t_user_17 (user_id);
-CREATE INDEX user_index_t_user_27 ON encrypt_read_ds_7.t_user_27 (user_id);
-CREATE INDEX user_index_t_user_37 ON encrypt_read_ds_7.t_user_37 (user_id);
+CREATE TABLE read_ds_7.t_user_7 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_7.t_user_item_7 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_7.t_user_17 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_7.t_user_item_17 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_7.t_user_27 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_7.t_user_item_27 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_7.t_user_37 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_7.t_user_item_37 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_7 ON read_ds_7.t_user_7 (user_id);
+CREATE INDEX user_index_t_user_17 ON read_ds_7.t_user_17 (user_id);
+CREATE INDEX user_index_t_user_27 ON read_ds_7.t_user_27 (user_id);
+CREATE INDEX user_index_t_user_37 ON read_ds_7.t_user_37 (user_id);
-CREATE TABLE encrypt_read_ds_8.t_user_8 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_8.t_user_item_8 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_8.t_user_18 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_8.t_user_item_18 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_8.t_user_28 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_8.t_user_item_28 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_8.t_user_38 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_8.t_user_item_38 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_8 ON encrypt_read_ds_8.t_user_8 (user_id);
-CREATE INDEX user_index_t_user_18 ON encrypt_read_ds_8.t_user_18 (user_id);
-CREATE INDEX user_index_t_user_28 ON encrypt_read_ds_8.t_user_28 (user_id);
-CREATE INDEX user_index_t_user_38 ON encrypt_read_ds_8.t_user_38 (user_id);
+CREATE TABLE read_ds_8.t_user_8 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_8.t_user_item_8 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_8.t_user_18 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_8.t_user_item_18 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_8.t_user_28 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_8.t_user_item_28 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_8.t_user_38 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_8.t_user_item_38 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_8 ON read_ds_8.t_user_8 (user_id);
+CREATE INDEX user_index_t_user_18 ON read_ds_8.t_user_18 (user_id);
+CREATE INDEX user_index_t_user_28 ON read_ds_8.t_user_28 (user_id);
+CREATE INDEX user_index_t_user_38 ON read_ds_8.t_user_38 (user_id);
-CREATE TABLE encrypt_read_ds_9.t_user_9 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_9.t_user_item_9 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_9.t_user_19 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_9.t_user_item_19 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_9.t_user_29 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_9.t_user_item_29 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE TABLE encrypt_read_ds_9.t_user_39 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE encrypt_read_ds_9.t_user_item_39 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
-CREATE INDEX user_index_t_user_9 ON encrypt_read_ds_9.t_user_9 (user_id);
-CREATE INDEX user_index_t_user_19 ON encrypt_read_ds_9.t_user_19 (user_id);
-CREATE INDEX user_index_t_user_29 ON encrypt_read_ds_9.t_user_29 (user_id);
-CREATE INDEX user_index_t_user_39 ON encrypt_read_ds_9.t_user_39 (user_id);
+CREATE TABLE read_ds_9.t_user_9 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_9.t_user_item_9 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_9.t_user_19 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_9.t_user_item_19 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_9.t_user_29 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_9.t_user_item_29 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE read_ds_9.t_user_39 (user_id INT NOT NULL, address_id INT NOT NULL, pwd_plain VARCHAR(45) NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE read_ds_9.t_user_item_39 (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE INDEX user_index_t_user_9 ON read_ds_9.t_user_9 (user_id);
+CREATE INDEX user_index_t_user_19 ON read_ds_9.t_user_19 (user_id);
+CREATE INDEX user_index_t_user_29 ON read_ds_9.t_user_29 (user_id);
+CREATE INDEX user_index_t_user_39 ON read_ds_9.t_user_39 (user_id);
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/postgresql/01-actual-init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/postgresql/01-actual-init.sql
index 8e0d8477797..20f334e4321 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/postgresql/01-actual-init.sql
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -15,56 +15,56 @@
-- limitations under the License.
--
-CREATE DATABASE encrypt_write_ds_0;
-CREATE DATABASE encrypt_write_ds_1;
-CREATE DATABASE encrypt_write_ds_2;
-CREATE DATABASE encrypt_write_ds_3;
-CREATE DATABASE encrypt_write_ds_4;
-CREATE DATABASE encrypt_write_ds_5;
-CREATE DATABASE encrypt_write_ds_6;
-CREATE DATABASE encrypt_write_ds_7;
-CREATE DATABASE encrypt_write_ds_8;
-CREATE DATABASE encrypt_write_ds_9;
-CREATE DATABASE encrypt_read_ds_0;
-CREATE DATABASE encrypt_read_ds_1;
-CREATE DATABASE encrypt_read_ds_2;
-CREATE DATABASE encrypt_read_ds_3;
-CREATE DATABASE encrypt_read_ds_4;
-CREATE DATABASE encrypt_read_ds_5;
-CREATE DATABASE encrypt_read_ds_6;
-CREATE DATABASE encrypt_read_ds_7;
-CREATE DATABASE encrypt_read_ds_8;
-CREATE DATABASE encrypt_read_ds_9;
+CREATE DATABASE write_ds_0;
+CREATE DATABASE write_ds_1;
+CREATE DATABASE write_ds_2;
+CREATE DATABASE write_ds_3;
+CREATE DATABASE write_ds_4;
+CREATE DATABASE write_ds_5;
+CREATE DATABASE write_ds_6;
+CREATE DATABASE write_ds_7;
+CREATE DATABASE write_ds_8;
+CREATE DATABASE write_ds_9;
+CREATE DATABASE read_ds_0;
+CREATE DATABASE read_ds_1;
+CREATE DATABASE read_ds_2;
+CREATE DATABASE read_ds_3;
+CREATE DATABASE read_ds_4;
+CREATE DATABASE read_ds_5;
+CREATE DATABASE read_ds_6;
+CREATE DATABASE read_ds_7;
+CREATE DATABASE read_ds_8;
+CREATE DATABASE read_ds_9;
CREATE DATABASE rdl_test_0;
CREATE DATABASE rdl_test_1;
CREATE DATABASE rdl_test_2;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_0 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_1 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_2 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_3 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_4 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_5 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_6 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_7 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_8 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_9 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_0 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_1 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_2 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_3 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_4 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_5 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_6 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_7 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_8 TO test_user;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_9 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_1 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_2 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_3 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_4 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_5 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_6 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_7 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_8 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_9 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_1 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_2 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_3 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_4 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_5 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_6 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_7 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_8 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_9 TO test_user;
GRANT ALL PRIVILEGES ON DATABASE rdl_test_0 TO test_user;
GRANT ALL PRIVILEGES ON DATABASE rdl_test_1 TO test_user;
GRANT ALL PRIVILEGES ON DATABASE rdl_test_2 TO test_user;
-\c encrypt_write_ds_0
+\c write_ds_0
DROP TABLE IF EXISTS t_user_0;
DROP TABLE IF EXISTS t_user_item_0;
@@ -90,7 +90,7 @@ CREATE INDEX user_index_t_user_10 ON t_user_10 (user_id);
CREATE INDEX user_index_t_user_20 ON t_user_20 (user_id);
CREATE INDEX user_index_t_user_30 ON t_user_30 (user_id);
-\c encrypt_write_ds_1
+\c write_ds_1
DROP TABLE IF EXISTS t_user_1;
DROP TABLE IF EXISTS t_user_item_1;
@@ -114,7 +114,7 @@ CREATE INDEX user_index_t_user_11 ON t_user_11 (user_id);
CREATE INDEX user_index_t_user_21 ON t_user_21 (user_id);
CREATE INDEX user_index_t_user_31 ON t_user_31 (user_id);
-\c encrypt_write_ds_2
+\c write_ds_2
DROP TABLE IF EXISTS t_user_2;
DROP TABLE IF EXISTS t_user_item_2;
@@ -138,7 +138,7 @@ CREATE INDEX user_index_t_user_12 ON t_user_12 (user_id);
CREATE INDEX user_index_t_user_22 ON t_user_22 (user_id);
CREATE INDEX user_index_t_user_32 ON t_user_32 (user_id);
-\c encrypt_write_ds_3
+\c write_ds_3
DROP TABLE IF EXISTS t_user_3;
DROP TABLE IF EXISTS t_user_item_3;
@@ -162,7 +162,7 @@ CREATE INDEX user_index_t_user_13 ON t_user_13 (user_id);
CREATE INDEX user_index_t_user_23 ON t_user_23 (user_id);
CREATE INDEX user_index_t_user_33 ON t_user_33 (user_id);
-\c encrypt_write_ds_4
+\c write_ds_4
DROP TABLE IF EXISTS t_user_4;
DROP TABLE IF EXISTS t_user_item_4;
@@ -186,7 +186,7 @@ CREATE INDEX user_index_t_user_14 ON t_user_14 (user_id);
CREATE INDEX user_index_t_user_24 ON t_user_24 (user_id);
CREATE INDEX user_index_t_user_34 ON t_user_34 (user_id);
-\c encrypt_write_ds_5
+\c write_ds_5
DROP TABLE IF EXISTS t_user_5;
DROP TABLE IF EXISTS t_user_item_5;
@@ -210,7 +210,7 @@ CREATE INDEX user_index_t_user_15 ON t_user_15 (user_id);
CREATE INDEX user_index_t_user_25 ON t_user_25 (user_id);
CREATE INDEX user_index_t_user_35 ON t_user_35 (user_id);
-\c encrypt_write_ds_6
+\c write_ds_6
DROP TABLE IF EXISTS t_user_6;
DROP TABLE IF EXISTS t_user_item_6;
@@ -234,7 +234,7 @@ CREATE INDEX user_index_t_user_16 ON t_user_16 (user_id);
CREATE INDEX user_index_t_user_26 ON t_user_26 (user_id);
CREATE INDEX user_index_t_user_36 ON t_user_36 (user_id);
-\c encrypt_write_ds_7
+\c write_ds_7
DROP TABLE IF EXISTS t_user_7;
DROP TABLE IF EXISTS t_user_item_7;
@@ -258,7 +258,7 @@ CREATE INDEX user_index_t_user_17 ON t_user_17 (user_id);
CREATE INDEX user_index_t_user_27 ON t_user_27 (user_id);
CREATE INDEX user_index_t_user_37 ON t_user_37 (user_id);
-\c encrypt_write_ds_8
+\c write_ds_8
DROP TABLE IF EXISTS t_user_8;
DROP TABLE IF EXISTS t_user_item_8;
@@ -282,7 +282,7 @@ CREATE INDEX user_index_t_user_18 ON t_user_18 (user_id);
CREATE INDEX user_index_t_user_28 ON t_user_28 (user_id);
CREATE INDEX user_index_t_user_38 ON t_user_38 (user_id);
-\c encrypt_write_ds_9
+\c write_ds_9
DROP TABLE IF EXISTS t_user_9;
DROP TABLE IF EXISTS t_user_item_9;
@@ -306,7 +306,7 @@ CREATE INDEX user_index_t_user_19 ON t_user_19 (user_id);
CREATE INDEX user_index_t_user_29 ON t_user_29 (user_id);
CREATE INDEX user_index_t_user_39 ON t_user_39 (user_id);
-\c encrypt_read_ds_0
+\c read_ds_0
DROP TABLE IF EXISTS t_user_0;
DROP TABLE IF EXISTS t_user_item_0;
@@ -332,7 +332,7 @@ CREATE INDEX user_index_t_user_10 ON t_user_10 (user_id);
CREATE INDEX user_index_t_user_20 ON t_user_20 (user_id);
CREATE INDEX user_index_t_user_30 ON t_user_30 (user_id);
-\c encrypt_read_ds_1
+\c read_ds_1
DROP TABLE IF EXISTS t_user_1;
DROP TABLE IF EXISTS t_user_item_1;
@@ -356,7 +356,7 @@ CREATE INDEX user_index_t_user_11 ON t_user_11 (user_id);
CREATE INDEX user_index_t_user_21 ON t_user_21 (user_id);
CREATE INDEX user_index_t_user_31 ON t_user_31 (user_id);
-\c encrypt_read_ds_2
+\c read_ds_2
DROP TABLE IF EXISTS t_user_2;
DROP TABLE IF EXISTS t_user_item_2;
@@ -380,7 +380,7 @@ CREATE INDEX user_index_t_user_12 ON t_user_12 (user_id);
CREATE INDEX user_index_t_user_22 ON t_user_22 (user_id);
CREATE INDEX user_index_t_user_32 ON t_user_32 (user_id);
-\c encrypt_read_ds_3
+\c read_ds_3
DROP TABLE IF EXISTS t_user_3;
DROP TABLE IF EXISTS t_user_item_3;
@@ -404,7 +404,7 @@ CREATE INDEX user_index_t_user_13 ON t_user_13 (user_id);
CREATE INDEX user_index_t_user_23 ON t_user_23 (user_id);
CREATE INDEX user_index_t_user_33 ON t_user_33 (user_id);
-\c encrypt_read_ds_4
+\c read_ds_4
DROP TABLE IF EXISTS t_user_4;
DROP TABLE IF EXISTS t_user_item_4;
@@ -428,7 +428,7 @@ CREATE INDEX user_index_t_user_14 ON t_user_14 (user_id);
CREATE INDEX user_index_t_user_24 ON t_user_24 (user_id);
CREATE INDEX user_index_t_user_34 ON t_user_34 (user_id);
-\c encrypt_read_ds_5
+\c read_ds_5
DROP TABLE IF EXISTS t_user_5;
DROP TABLE IF EXISTS t_user_item_5;
@@ -452,7 +452,7 @@ CREATE INDEX user_index_t_user_15 ON t_user_15 (user_id);
CREATE INDEX user_index_t_user_25 ON t_user_25 (user_id);
CREATE INDEX user_index_t_user_35 ON t_user_35 (user_id);
-\c encrypt_read_ds_6
+\c read_ds_6
DROP TABLE IF EXISTS t_user_6;
DROP TABLE IF EXISTS t_user_item_6;
@@ -476,7 +476,7 @@ CREATE INDEX user_index_t_user_16 ON t_user_16 (user_id);
CREATE INDEX user_index_t_user_26 ON t_user_26 (user_id);
CREATE INDEX user_index_t_user_36 ON t_user_36 (user_id);
-\c encrypt_read_ds_7
+\c read_ds_7
DROP TABLE IF EXISTS t_user_7;
DROP TABLE IF EXISTS t_user_item_7;
@@ -500,7 +500,7 @@ CREATE INDEX user_index_t_user_17 ON t_user_17 (user_id);
CREATE INDEX user_index_t_user_27 ON t_user_27 (user_id);
CREATE INDEX user_index_t_user_37 ON t_user_37 (user_id);
-\c encrypt_read_ds_8
+\c read_ds_8
DROP TABLE IF EXISTS t_user_8;
DROP TABLE IF EXISTS t_user_item_8;
@@ -524,7 +524,7 @@ CREATE INDEX user_index_t_user_18 ON t_user_18 (user_id);
CREATE INDEX user_index_t_user_28 ON t_user_28 (user_id);
CREATE INDEX user_index_t_user_38 ON t_user_38 (user_id);
-\c encrypt_read_ds_9
+\c read_ds_9
DROP TABLE IF EXISTS t_user_9;
DROP TABLE IF EXISTS t_user_item_9;
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
index 5e02f4e8ac8..26df88ba59c 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/mysql/config-empty-rules.yaml
@@ -18,8 +18,8 @@
databaseName: empty_rules
dataSources:
- encrypt_write_ds_0:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ write_ds_0:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -27,8 +27,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_1:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ write_ds_1:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -36,8 +36,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_2:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ write_ds_2:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -45,8 +45,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_3:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ write_ds_3:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -54,8 +54,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_4:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ write_ds_4:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -63,8 +63,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_5:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ write_ds_5:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -72,8 +72,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_6:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ write_ds_6:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -81,8 +81,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_7:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ write_ds_7:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -90,8 +90,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_8:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ write_ds_8:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -99,8 +99,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_9:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ write_ds_9:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -108,8 +108,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_0:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ read_ds_0:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -117,8 +117,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_1:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ read_ds_1:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -126,8 +126,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_2:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ read_ds_2:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -135,8 +135,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_3:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ read_ds_3:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -144,8 +144,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_4:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ read_ds_4:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -153,8 +153,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_5:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ read_ds_5:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -162,8 +162,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_6:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ read_ds_6:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -171,8 +171,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_7:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ read_ds_7:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -180,8 +180,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_8:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ read_ds_8:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -189,8 +189,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_9:
- url: jdbc:mysql://mysql.empty_rules.host:3306/encrypt_read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ read_ds_9:
+ url: jdbc:mysql://mysql.empty_rules.host:3306/read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -212,7 +212,7 @@ rules:
- !SHARDING
autoTables:
t_user:
- actualDataSources: encrypt_write_ds_${0..9}
+ actualDataSources: write_ds_${0..9}
shardingStrategy:
standard:
shardingColumn: user_id
@@ -221,7 +221,7 @@ rules:
column: user_id
keyGeneratorName: constant
t_user_item:
- actualDataSources: encrypt_write_ds_${0..9}
+ actualDataSources: write_ds_${0..9}
shardingStrategy:
standard:
shardingColumn: user_id
@@ -244,9 +244,9 @@ rules:
dataSources:
readwrite_ds_0:
staticStrategy:
- writeDataSourceName: encrypt_write_ds_0
+ writeDataSourceName: write_ds_0
readDataSourceNames:
- - encrypt_read_ds_0
+ - read_ds_0
loadBalancerName: roundRobin
loadBalancers:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/postgresql/config-empty-rules.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/postgresql/config-empty-rules.yaml
index 2341513d9bf..6f0b6724fe0 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/postgresql/config-empty-rules.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/proxy/conf/postgresql/config-empty-rules.yaml
@@ -18,8 +18,8 @@
databaseName: empty_rules
dataSources:
- encrypt_write_ds_0:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_0
+ write_ds_0:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/write_ds_0
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -27,8 +27,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_1:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_1
+ write_ds_1:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/write_ds_1
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -36,8 +36,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_2:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_2
+ write_ds_2:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/write_ds_2
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -45,8 +45,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_3:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_3
+ write_ds_3:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/write_ds_3
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -54,8 +54,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_4:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_4
+ write_ds_4:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/write_ds_4
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -63,8 +63,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_5:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_5
+ write_ds_5:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/write_ds_5
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -72,8 +72,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_6:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_6
+ write_ds_6:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/write_ds_6
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -81,8 +81,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_7:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_7
+ write_ds_7:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/write_ds_7
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -90,8 +90,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_8:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_8
+ write_ds_8:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/write_ds_8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -99,8 +99,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_write_ds_9:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_write_ds_9
+ write_ds_9:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/write_ds_9
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -108,8 +108,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_0:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_0
+ read_ds_0:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/read_ds_0
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -117,8 +117,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_1:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_1
+ read_ds_1:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/read_ds_1
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -126,8 +126,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_2:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_2
+ read_ds_2:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/read_ds_2
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -135,8 +135,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_3:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_3
+ read_ds_3:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/read_ds_3
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -144,8 +144,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_4:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_4
+ read_ds_4:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/read_ds_4
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -153,8 +153,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_5:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_5
+ read_ds_5:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/read_ds_5
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -162,8 +162,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_6:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_6
+ read_ds_6:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/read_ds_6
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -171,8 +171,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_7:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_7
+ read_ds_7:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/read_ds_7
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -180,8 +180,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_8:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_8
+ read_ds_8:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/read_ds_8
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -189,8 +189,8 @@ dataSources:
maxLifetimeMilliseconds: 1800000
maxPoolSize: 2
minPoolSize: 2
- encrypt_read_ds_9:
- url: jdbc:postgresql://postgresql.empty_rules.host:5432/encrypt_read_ds_9
+ read_ds_9:
+ url: jdbc:postgresql://postgresql.empty_rules.host:5432/read_ds_9
username: test_user
password: Test@123
connectionTimeoutMilliseconds: 30000
@@ -212,7 +212,7 @@ rules:
- !SHARDING
autoTables:
t_user:
- actualDataSources: encrypt_write_ds_${0..9}
+ actualDataSources: write_ds_${0..9}
shardingStrategy:
standard:
shardingColumn: user_id
@@ -221,7 +221,7 @@ rules:
column: user_id
keyGeneratorName: constant
t_user_item:
- actualDataSources: encrypt_write_ds_${0..9}
+ actualDataSources: write_ds_${0..9}
shardingStrategy:
standard:
shardingColumn: user_id
@@ -244,9 +244,9 @@ rules:
dataSources:
readwrite_ds_0:
staticStrategy:
- writeDataSourceName: encrypt_write_ds_0
+ writeDataSourceName: write_ds_0
readDataSourceNames:
- - encrypt_read_ds_0
+ - read_ds_0
loadBalancerName: roundRobin
loadBalancers:
roundRobin: