This is an automated email from the ASF dual-hosted git repository.
panjuan 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 801c823 add init.sql (#9742)
801c823 is described below
commit 801c82305bb1a1e686f972903d7b80d8df731b15
Author: Jieker <[email protected]>
AuthorDate: Fri Mar 19 16:08:36 2021 +0800
add init.sql (#9742)
---
.../env/dbtbl_with_read_write_splitting/init-sql/h2/init.sql | 2 ++
.../env/dbtbl_with_read_write_splitting/init-sql/mysql/init.sql | 2 ++
.../env/dbtbl_with_read_write_splitting/init-sql/oracle/init.sql | 2 ++
.../dbtbl_with_read_write_splitting/init-sql/postgresql/init.sql | 1 +
.../dbtbl_with_read_write_splitting/init-sql/sqlserver/init.sql | 2 ++
.../init-sql/h2/init.sql | 2 ++
.../init-sql/mysql/init.sql | 2 ++
.../init-sql/oracle/init.sql | 2 ++
.../init-sql/postgresql/init.sql | 1 +
.../init-sql/sqlserver/init.sql | 2 ++
.../src/test/resources/env/encrypt/init-sql/h2/init.sql | 2 ++
.../src/test/resources/env/encrypt/init-sql/mysql/init.sql | 1 +
.../src/test/resources/env/encrypt/init-sql/oracle/init.sql | 1 +
.../src/test/resources/env/encrypt/init-sql/postgresql/init.sql | 7 ++++---
.../src/test/resources/env/encrypt/init-sql/sqlserver/init.sql | 1 +
.../test/resources/env/read_write_splitting/init-sql/h2/init.sql | 2 ++
.../resources/env/read_write_splitting/init-sql/mysql/init.sql | 3 +++
.../resources/env/read_write_splitting/init-sql/oracle/init.sql | 3 +++
.../env/read_write_splitting/init-sql/postgresql/init.sql | 1 +
.../resources/env/read_write_splitting/init-sql/sqlserver/init.sql | 3 +++
.../src/test/resources/env/tbl/init-sql/h2/init.sql | 3 +++
.../src/test/resources/env/tbl/init-sql/mysql/init.sql | 2 ++
.../src/test/resources/env/tbl/init-sql/oracle/init.sql | 4 +++-
.../src/test/resources/env/tbl/init-sql/postgresql/init.sql | 2 ++
.../src/test/resources/env/tbl/init-sql/sqlserver/init.sql | 4 +++-
25 files changed, 52 insertions(+), 5 deletions(-)
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/h2/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/h2/init.sql
index 63f093f..315dc79 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/h2/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/h2/init.sql
@@ -36,6 +36,7 @@ DROP TABLE IF EXISTS t_order_item_8;
DROP TABLE IF EXISTS t_order_9;
DROP TABLE IF EXISTS t_order_item_9;
DROP TABLE IF EXISTS t_broadcast_table;
+DROP TABLE IF EXISTS t_single_table;
CREATE TABLE t_order_0 (order_id INT NOT NULL, user_id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE t_order_item_0 (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
@@ -57,6 +58,7 @@ CREATE TABLE t_order_8 (order_id INT NOT NULL, user_id INT
NOT NULL, status VARC
CREATE TABLE t_order_item_8 (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
CREATE TABLE t_order_9 (order_id INT NOT NULL, user_id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE t_order_item_9 (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
+CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order_0 ON t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/mysql/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/mysql/init.sql
index c1c0da3..53c6486 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/mysql/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/mysql/init.sql
@@ -84,6 +84,7 @@ CREATE TABLE write_ds_0.t_order_item_8 (item_id INT NOT NULL,
order_id INT NOT N
CREATE TABLE write_ds_0.t_order_9 (order_id INT NOT NULL, user_id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE write_ds_0.t_order_item_9 (item_id INT NOT NULL, order_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_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (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 order_index_t_order_0 ON write_ds_0.t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON write_ds_0.t_order_1 (order_id);
CREATE INDEX order_index_t_order_2 ON write_ds_0.t_order_2 (order_id);
@@ -404,6 +405,7 @@ CREATE TABLE read_ds_0.t_order_item_8 (item_id INT NOT
NULL, order_id INT NOT NU
CREATE TABLE read_ds_0.t_order_9 (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_ds_0.t_order_item_9 (item_id INT NOT NULL, order_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_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (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 order_index_t_order_0 ON read_ds_0.t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON read_ds_0.t_order_1 (order_id);
CREATE INDEX order_index_t_order_2 ON read_ds_0.t_order_2 (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/oracle/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/oracle/init.sql
index 2bd878f..2bcb7af 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/oracle/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/oracle/init.sql
@@ -80,6 +80,7 @@ CREATE TABLE write_ds_0.t_order_8 (order_id INT NOT NULL,
user_id INT NOT NULL,
CREATE TABLE write_ds_0.t_order_item_8 (item_id INT NOT NULL, order_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_order_9 (order_id INT NOT NULL, user_id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE write_ds_0.t_order_item_9 (item_id INT NOT NULL, order_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 TABLE write_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order_0 ON write_ds_0.t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON write_ds_0.t_order_1 (order_id);
@@ -401,6 +402,7 @@ CREATE TABLE read_ds_0.t_order_item_8 (item_id INT NOT
NULL, order_id INT NOT NU
CREATE TABLE read_ds_0.t_order_9 (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_ds_0.t_order_item_9 (item_id INT NOT NULL, order_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_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (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 order_index_t_order_0 ON read_ds_0.t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON read_ds_0.t_order_1 (order_id);
CREATE INDEX order_index_t_order_2 ON read_ds_0.t_order_2 (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/postgresql/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/postgresql/init.sql
index 2a1fa7a..514ef46 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/postgresql/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/postgresql/init.sql
@@ -35,6 +35,7 @@ CREATE TABLE t_order_8 (order_id INT NOT NULL, user_id INT
NOT NULL, status VARC
CREATE TABLE t_order_item_8 (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
CREATE TABLE t_order_9 (order_id INT NOT NULL, user_id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE t_order_item_9 (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
+CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order_0 ON t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON t_order_1 (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/sqlserver/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/sqlserver/init.sql
index 3b313d1..d9e2582 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/sqlserver/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting/init-sql/sqlserver/init.sql
@@ -80,6 +80,7 @@ CREATE TABLE write_ds_0.t_order_8 (order_id INT NOT NULL,
user_id INT NOT NULL,
CREATE TABLE write_ds_0.t_order_item_8 (item_id INT NOT NULL, order_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_order_9 (order_id INT NOT NULL, user_id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE write_ds_0.t_order_item_9 (item_id INT NOT NULL, order_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 TABLE write_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order_0 ON write_ds_0.t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON write_ds_0.t_order_1 (order_id);
@@ -400,6 +401,7 @@ CREATE TABLE read_ds_0.t_order_8 (order_id INT NOT NULL,
user_id INT NOT NULL, s
CREATE TABLE read_ds_0.t_order_item_8 (item_id INT NOT NULL, order_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_order_9 (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_ds_0.t_order_item_9 (item_id INT NOT NULL, order_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 TABLE read_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order_0 ON read_ds_0.t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON read_ds_0.t_order_1 (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/h2/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/h2/init.sql
index 26936c5..b722d39 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/h2/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/h2/init.sql
@@ -35,6 +35,7 @@ DROP TABLE IF EXISTS t_user_8;
DROP TABLE IF EXISTS t_user_item_8;
DROP TABLE IF EXISTS t_user_9;
DROP TABLE IF EXISTS t_user_item_9;
+DROP TABLE IF EXISTS t_single_table;
CREATE TABLE 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 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));
@@ -56,6 +57,7 @@ CREATE TABLE t_user_8 (user_id INT NOT NULL, address_id INT
NOT NULL, pwd_plain
CREATE TABLE 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 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 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 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 t_user_0 (user_id);
CREATE INDEX user_index_t_user_1 ON t_user_1 (user_id);
CREATE INDEX user_index_t_user_2 ON t_user_2 (user_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/mysql/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/mysql/init.sql
index cd39b62..be5a1de 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/mysql/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/mysql/init.sql
@@ -83,6 +83,7 @@ CREATE TABLE encrypt_write_ds_0.t_user_8 (user_id INT NOT
NULL, address_id INT N
CREATE TABLE encrypt_write_ds_0.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_0.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_0.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_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_1 ON encrypt_write_ds_0.t_user_1 (user_id);
CREATE INDEX user_index_t_user_2 ON encrypt_write_ds_0.t_user_2 (user_id);
@@ -393,6 +394,7 @@ CREATE TABLE encrypt_read_ds_0.t_user_8 (user_id INT NOT
NULL, address_id INT NO
CREATE TABLE encrypt_read_ds_0.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_0.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_0.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_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_1 ON encrypt_read_ds_0.t_user_1 (user_id);
CREATE INDEX user_index_t_user_2 ON encrypt_read_ds_0.t_user_2 (user_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/oracle/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/oracle/init.sql
index 7cb14df..5f5281c 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/oracle/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/oracle/init.sql
@@ -80,6 +80,7 @@ CREATE TABLE encrypt_write_ds_0.t_user_8 (user_id INT NOT
NULL, address_id INT N
CREATE TABLE encrypt_write_ds_0.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_0.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_0.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_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_1 ON encrypt_write_ds_0.t_user_1 (user_id);
CREATE INDEX user_index_t_user_2 ON encrypt_write_ds_0.t_user_2 (user_id);
@@ -390,6 +391,7 @@ CREATE TABLE encrypt_read_ds_0.t_user_8 (user_id INT NOT
NULL, address_id INT NO
CREATE TABLE encrypt_read_ds_0.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_0.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_0.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_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_1 ON encrypt_read_ds_0.t_user_1 (user_id);
CREATE INDEX user_index_t_user_2 ON encrypt_read_ds_0.t_user_2 (user_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/postgresql/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/postgresql/init.sql
index 3b315ee..ba0275d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/postgresql/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/postgresql/init.sql
@@ -35,6 +35,7 @@ CREATE TABLE t_user_8 (user_id INT NOT NULL, address_id INT
NOT NULL, pwd_plain
CREATE TABLE 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 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 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 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 t_user_0 (user_id);
CREATE INDEX user_index_t_user_1 ON t_user_1 (user_id);
CREATE INDEX user_index_t_user_2 ON t_user_2 (user_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/sqlserver/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/sqlserver/init.sql
index 45f07a8..901b35b 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/sqlserver/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/dbtbl_with_read_write_splitting_and_encrypt/init-sql/sqlserver/init.sql
@@ -80,6 +80,7 @@ CREATE TABLE encrypt_write_ds_0.t_user_8 (user_id INT NOT
NULL, address_id INT N
CREATE TABLE encrypt_write_ds_0.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_0.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_0.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_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_1 ON encrypt_write_ds_0.t_user_1 (user_id);
CREATE INDEX user_index_t_user_2 ON encrypt_write_ds_0.t_user_2 (user_id);
@@ -390,6 +391,7 @@ CREATE TABLE encrypt_read_ds_0.t_user_8 (user_id INT NOT
NULL, address_id INT NO
CREATE TABLE encrypt_read_ds_0.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_0.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_0.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_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_1 ON encrypt_read_ds_0.t_user_1 (user_id);
CREATE INDEX user_index_t_user_2 ON encrypt_read_ds_0.t_user_2 (user_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/h2/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/h2/init.sql
index 34715ca..70f0ddc 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/h2/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/h2/init.sql
@@ -16,7 +16,9 @@
--
DROP TABLE IF EXISTS t_user;
DROP TABLE IF EXISTS t_user_item;
+DROP TABLE IF EXISTS t_single_table;
CREATE TABLE t_user (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 t_user_item (item_id INT NOT NULL, user_id INT NOT NULL, status
VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE 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 ON t_user (user_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/mysql/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/mysql/init.sql
index 84c8e9c..6c47cf6 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/mysql/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/mysql/init.sql
@@ -27,4 +27,5 @@ CREATE DATABASE encrypt;
CREATE TABLE encrypt.t_user (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.t_user_item (item_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE encrypt.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 ON encrypt.t_user (user_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/oracle/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/oracle/init.sql
index 7c8a9fa..f84c49a 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/oracle/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/oracle/init.sql
@@ -24,4 +24,5 @@ CREATE SCHEMA encrypt;
CREATE TABLE encrypt.t_user (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.t_user_item (item_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE encrypt.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 ON encrypt.t_user (user_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/postgresql/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/postgresql/init.sql
index a8b46ee..697bc1f 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/postgresql/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/postgresql/init.sql
@@ -15,6 +15,7 @@
-- limitations under the License.
--
-CREATE TABLE encrypt.t_user (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.t_user_item (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 ON encrypt.t_user (user_id);
+CREATE TABLE t_user (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 t_user_item (item_id INT NOT NULL, user_id INT NOT NULL, status
VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE 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 ON t_user (user_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/sqlserver/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/sqlserver/init.sql
index ecd550e..1b7e937 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/sqlserver/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/encrypt/init-sql/sqlserver/init.sql
@@ -24,4 +24,5 @@ CREATE DATABASE encrypt;
CREATE TABLE encrypt.t_user (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.t_user_item (item_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE encrypt.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 ON encrypt.t_user (user_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/h2/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/h2/init.sql
index 0fd19c9..6155722 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/h2/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/h2/init.sql
@@ -18,8 +18,10 @@
DROP TABLE IF EXISTS t_order;
DROP TABLE IF EXISTS t_order_item;
DROP TABLE IF EXISTS t_broadcast_table;
+DROP TABLE IF EXISTS t_single_table;
CREATE TABLE t_order (order_id INT NOT NULL, user_id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE t_order_item (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
+CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/mysql/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/mysql/init.sql
index 5960f47..26087b8 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/mysql/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/mysql/init.sql
@@ -31,15 +31,18 @@ CREATE DATABASE read_1;
CREATE TABLE write_ds.t_order (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE write_ds.t_order_item (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
+CREATE TABLE write_ds.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE write_ds.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON write_ds.t_order (order_id);
CREATE TABLE read_0.t_order (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_0.t_order_item (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
+CREATE TABLE read_0.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE read_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_0.t_order (order_id);
CREATE TABLE read_1.t_order (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_1.t_order_item (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
+CREATE TABLE read_1.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE read_1.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_1.t_order (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/oracle/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/oracle/init.sql
index a9f32fc..345a76d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/oracle/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/oracle/init.sql
@@ -28,15 +28,18 @@ CREATE SCHEMA read_1;
CREATE TABLE write_ds.t_order (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE write_ds.t_order_item (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
+CREATE TABLE write_ds.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE write_ds.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON write_ds.t_order (order_id);
CREATE TABLE read_0.t_order (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_0.t_order_item (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
+CREATE TABLE read_0.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE read_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_0.t_order (order_id);
CREATE TABLE read_1.t_order (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_1.t_order_item (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
+CREATE TABLE read_1.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE read_1.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_1.t_order (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/postgresql/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/postgresql/init.sql
index d639b18..5cfe191 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/postgresql/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/postgresql/init.sql
@@ -17,5 +17,6 @@
CREATE TABLE t_order (order_id INT NOT NULL, user_id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE t_order_item (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
+CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/sqlserver/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/sqlserver/init.sql
index ec1340a..9c99746 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/sqlserver/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/read_write_splitting/init-sql/sqlserver/init.sql
@@ -28,15 +28,18 @@ CREATE DATABASE read_1;
CREATE TABLE write_ds.t_order (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE write_ds.t_order_item (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
+CREATE TABLE write_ds.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE write_ds.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON write_ds.t_order (order_id);
CREATE TABLE read_0.t_order (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_0.t_order_item (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
+CREATE TABLE read_0.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE read_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_0.t_order (order_id);
CREATE TABLE read_1.t_order (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_1.t_order_item (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
+CREATE TABLE read_1.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE read_1.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE INDEX order_index_t_order ON read_1.t_order (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/h2/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/h2/init.sql
index 195c6a1..562b343 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/h2/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/h2/init.sql
@@ -36,6 +36,7 @@ DROP TABLE IF EXISTS t_order_item_8;
DROP TABLE IF EXISTS t_order_9;
DROP TABLE IF EXISTS t_order_item_9;
DROP TABLE IF EXISTS t_broadcast_table;
+DROP TABLE IF EXISTS t_single_table;
CREATE TABLE t_order_0 (order_id INT NOT NULL, user_id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE t_order_item_0 (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
@@ -78,3 +79,5 @@ CREATE TABLE t_order_item_9 (item_id INT NOT NULL, order_id
INT NOT NULL, user_i
CREATE INDEX order_index_t_order_9 ON t_order_9 (order_id);
CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
+
+CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (single_id));
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/mysql/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/mysql/init.sql
index 86c04c8..6c76788 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/mysql/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/mysql/init.sql
@@ -66,3 +66,5 @@ CREATE TABLE tbl.t_order_item_9 (item_id INT NOT NULL,
order_id INT NOT NULL, us
CREATE INDEX order_index_t_order_9 ON tbl.t_order_9 (order_id);
CREATE TABLE tbl.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
+
+CREATE TABLE tbl.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/oracle/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/oracle/init.sql
index 2382bb1..d8ce3a5 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/oracle/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/oracle/init.sql
@@ -62,4 +62,6 @@ CREATE TABLE tbl.t_order_9 (order_id INT NOT NULL, user_id
INT NOT NULL, status
CREATE TABLE tbl.t_order_item_9 (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
CREATE INDEX order_index_t_order_9 ON tbl.t_order_9 (order_id);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
+CREATE TABLE tbl.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
+
+CREATE TABLE tbl.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/postgresql/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/postgresql/init.sql
index 7b5dee1..2d824cd 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/postgresql/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/postgresql/init.sql
@@ -56,3 +56,5 @@ CREATE TABLE t_order_item_9 (item_id INT NOT NULL, order_id
INT NOT NULL, user_i
CREATE INDEX order_index_t_order_9 ON t_order_9 (order_id);
CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
+
+CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (single_id));
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/sqlserver/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/sqlserver/init.sql
index 9b5397d..e10e8a0 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/sqlserver/init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/sqlserver/init.sql
@@ -62,4 +62,6 @@ CREATE TABLE tbl.t_order_9 (order_id INT NOT NULL, user_id
INT NOT NULL, status
CREATE TABLE tbl.t_order_item_9 (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
CREATE INDEX order_index_t_order_9 ON tbl.t_order_9 (order_id);
-CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
+CREATE TABLE tbl.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id));
+
+CREATE TABLE tbl.t_single_table (single_id INT NOT NULL, id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (single_id));
