This is an automated email from the ASF dual-hosted git repository.
zhangliang 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 da7dec1 Integrate test for jdbc:shadow -> h2 test cases cannot run.
(#15376)
da7dec1 is described below
commit da7dec1529e2c6ff6ee067fd696c1f1779c4ca12
Author: liguoping <[email protected]>
AuthorDate: Sun Feb 13 12:35:03 2022 +0800
Integrate test for jdbc:shadow -> h2 test cases cannot run. (#15376)
* shadow H2
* use h2 under h2 folder
* config-readwrite-splitting.yaml, error host name fixed
* use real h2 jdbc url
---
.../docker/proxy/conf/db/h2/config-db.yaml | 20 +++---
.../h2/config-dbtbl-with-readwrite-splitting.yaml | 40 +++++------
...dbtbl-with-readwrite-splitting-and-encrypt.yaml | 40 +++++------
.../proxy/conf/encrypt/h2/config-encrypt.yaml | 2 +-
.../h2/config-readwrite-splitting.yaml | 6 +-
.../docker/proxy/conf/shadow/h2/config-shadow.yaml | 84 ++++++++++++++++++++++
.../docker/proxy/conf/shadow/h2/logback.xml | 33 +++++++++
.../proxy/conf/shadow/h2/server.yaml} | 35 ++++++---
.../h2/config-sharding-governance.yaml | 2 +-
.../docker/proxy/conf/tbl/h2/config-tbl.yaml | 2 +-
.../src/test/resources/env/engine-env.properties | 2 +-
.../resources/env/shadow/init-sql/h2/init-db.sql | 16 +++++
.../env/shadow/init-sql/h2/init-shadow_db.sql | 16 +++++
.../test/resources/env/shadow/init-sql/h2/init.sql | 21 ++++++
14 files changed, 252 insertions(+), 67 deletions(-)
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/db/h2/config-db.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/db/h2/config-db.yaml
index 7ced0f2..58cacb5 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/db/h2/config-db.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/db/h2/config-db.yaml
@@ -19,7 +19,7 @@ schemaName: db
dataSources:
ds_0:
- url:
jdbc:h2://mysql.db.host:3306/db_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:db_0;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_1:
- url:
jdbc:mysql://mysql.db.host:3306/db_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:db_1;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_2:
- url:
jdbc:mysql://mysql.db.host:3306/db_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:db_2;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_3:
- url:
jdbc:mysql://mysql.db.host:3306/db_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:db_3;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_4:
- url:
jdbc:mysql://mysql.db.host:3306/db_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:db_4;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_5:
- url:
jdbc:mysql://mysql.db.host:3306/db_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:db_5;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_6:
- url:
jdbc:mysql://mysql.db.host:3306/db_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:db_6;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_7:
- url:
jdbc:mysql://mysql.db.host:3306/db_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:db_7;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_8:
- url:
jdbc:mysql://mysql.db.host:3306/db_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:db_8;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
ds_9:
- url:
jdbc:mysql://mysql.db.host:3306/db_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:db_9;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/dbtbl_with_readwrite_splitting/h2/config-dbtbl-with-readwrite-splitting.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/dbtbl_with_readwrite_splitting/h2/config-dbtbl-with-readwrite-splitting.yaml
index ef27856..6f0dba1 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/dbtbl_with_readwrite_splitting/h2/config-dbtbl-with-readwrite-splitting.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/dbtbl_with_readwrite_splitting/h2/config-dbtbl-with-readwrite-splitting.yaml
@@ -19,7 +19,7 @@ schemaName: dbtbl_with_readwrite_splitting
dataSources:
write_ds_0:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds_0;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_1:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds_1;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_2:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds_2;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_3:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds_3;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_4:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds_4;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_5:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds_5;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_6:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds_6;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_7:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds_7;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_8:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds_8;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
write_ds_9:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds_9;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -109,7 +109,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_0:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_ds_0;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -118,7 +118,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_1:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_ds_1;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -127,7 +127,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_2:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_ds_2;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -136,7 +136,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_3:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_ds_3;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -145,7 +145,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_4:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_ds_4;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -154,7 +154,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_5:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_ds_5;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -163,7 +163,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_6:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_ds_6;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -172,7 +172,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_7:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_ds_7;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -181,7 +181,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_8:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_ds_8;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -190,7 +190,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_ds_9:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_ds_9;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/dbtbl_with_readwrite_splitting_and_encrypt/h2/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/dbtbl_with_readwrite_splitting_and_encrypt/h2/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
index e6deffd..22ca34f 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/dbtbl_with_readwrite_splitting_and_encrypt/h2/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/dbtbl_with_readwrite_splitting_and_encrypt/h2/config-dbtbl-with-readwrite-splitting-and-encrypt.yaml
@@ -19,7 +19,7 @@ schemaName: dbtbl_with_readwrite_splitting_and_encrypt
dataSources:
encrypt_write_ds_0:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_write_ds_0;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_1:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_write_ds_1;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_2:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_write_ds_2;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -46,7 +46,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_3:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_write_ds_3;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -55,7 +55,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_4:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_write_ds_4;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -64,7 +64,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_5:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_write_ds_5;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -73,7 +73,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_6:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_write_ds_6;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -82,7 +82,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_7:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_write_ds_7;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -91,7 +91,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_8:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_write_ds_8;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -100,7 +100,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_write_ds_9:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_write_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_write_ds_9;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -109,7 +109,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_0:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_read_ds_0;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -118,7 +118,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_1:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_read_ds_1;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -127,7 +127,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_2:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_2?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_read_ds_2;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -136,7 +136,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_3:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_3?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_read_ds_3;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -145,7 +145,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_4:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_4?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_read_ds_4;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -154,7 +154,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_5:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_5?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_read_ds_5;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -163,7 +163,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_6:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_6?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_read_ds_6;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -172,7 +172,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_7:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_7?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_read_ds_7;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -181,7 +181,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_8:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_8?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_read_ds_8;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -190,7 +190,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
encrypt_read_ds_9:
- url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting_and_encrypt.host:3306/encrypt_read_ds_9?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt_read_ds_9;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/encrypt/h2/config-encrypt.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/encrypt/h2/config-encrypt.yaml
index 60a24dc..2e13d13 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/encrypt/h2/config-encrypt.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/encrypt/h2/config-encrypt.yaml
@@ -19,7 +19,7 @@ schemaName: encrypt
dataSources:
encrypt:
- url:
jdbc:mysql://mysql.encrypt.host:3306/encrypt?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:encrypt;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/readwrite_splitting/h2/config-readwrite-splitting.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/readwrite_splitting/h2/config-readwrite-splitting.yaml
index f2c46d2..3afe4a4 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/readwrite_splitting/h2/config-readwrite-splitting.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/readwrite_splitting/h2/config-readwrite-splitting.yaml
@@ -19,7 +19,7 @@ schemaName: readwrite_splitting
dataSources:
write_ds:
- url:
jdbc:mysql://mysql.readwrite_splitting.host:3306/write_ds?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:write_ds;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -28,7 +28,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_0:
- url:
jdbc:mysql://mysql.db.readwrite_splitting:3306/read_0?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_0;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
@@ -37,7 +37,7 @@ dataSources:
maxPoolSize: 2
minPoolSize: 2
read_1:
- url:
jdbc:mysql://mysql.db.readwrite_splitting:3306/read_1?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:read_1;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/shadow/h2/config-shadow.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/shadow/h2/config-shadow.yaml
new file mode 100644
index 0000000..96ab539
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/shadow/h2/config-shadow.yaml
@@ -0,0 +1,84 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+schemaName: shadow
+
+dataSources:
+ db:
+ url: jdbc:h2:mem:db;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
+ username: root
+ password:
+ connectionTimeoutMilliseconds: 30000
+ idleTimeoutMilliseconds: 60000
+ maxLifetimeMilliseconds: 1800000
+ maxPoolSize: 2
+ minPoolSize: 2
+ shadow_db:
+ url:
jdbc:h2:mem:shadow_db;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
+ username: root
+ password:
+ connectionTimeoutMilliseconds: 30000
+ idleTimeoutMilliseconds: 60000
+ maxLifetimeMilliseconds: 1800000
+ maxPoolSize: 2
+ minPoolSize: 2
+
+rules:
+- !SHADOW
+ dataSources:
+ shadowDataSource:
+ sourceDataSourceName: db
+ shadowDataSourceName: shadow_db
+ tables:
+ t_order:
+ dataSourceNames:
+ - shadowDataSource
+ shadowAlgorithmNames:
+ - user-id-insert-match-algorithm
+ - user-id-update-match-algorithm
+ - user-id-delete-match-algorithm
+ - user-id-select-match-algorithm
+ - simple-hint-algorithm
+ shadowAlgorithms:
+ user-id-insert-match-algorithm:
+ type: VALUE_MATCH
+ props:
+ operation: insert
+ column: user_id
+ value: 0
+ user-id-update-match-algorithm:
+ type: VALUE_MATCH
+ props:
+ operation: update
+ column: user_id
+ value: 0
+ user-id-delete-match-algorithm:
+ type: VALUE_MATCH
+ props:
+ operation: delete
+ column: user_id
+ value: 0
+ user-id-select-match-algorithm:
+ type: VALUE_MATCH
+ props:
+ operation: select
+ column: user_id
+ value: 0
+ simple-hint-algorithm:
+ type: SIMPLE_HINT
+ props:
+ foo: bar
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/shadow/h2/logback.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/shadow/h2/logback.xml
new file mode 100644
index 0000000..1494746
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/shadow/h2/logback.xml
@@ -0,0 +1,33 @@
+<?xml version="1.0"?>
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<configuration>
+ <appender name="console" class="ch.qos.logback.core.ConsoleAppender">
+ <encoder>
+ <pattern>[%-5level] %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread]
%logger{36} - %msg%n</pattern>
+ </encoder>
+ </appender>
+ <logger name="org.apache.shardingsphere" level="info" additivity="false">
+ <appender-ref ref="console" />
+ </logger>
+
+ <root>
+ <level value="info" />
+ <appender-ref ref="console" />
+ </root>
+</configuration>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/engine-env.properties
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/shadow/h2/server.yaml
similarity index 55%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/engine-env.properties
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/shadow/h2/server.yaml
index 4a46096..72254e9 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/engine-env.properties
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/shadow/h2/server.yaml
@@ -15,15 +15,30 @@
# limitations under the License.
#
-# EMBEDDED, DOCKER, NATIVE
-it.env.type=${it.env}
+#mode:
+# type: Cluster
+# repository:
+# type: ZooKeeper
+# props:
+# namespace: governance_ds
+# server-lists: zk:2181
+# retryIntervalMilliseconds: 500
+# timeToLiveSeconds: 60
+# maxRetries: 3
+# operationTimeoutMilliseconds: 500
+# overwrite: true
-it.adapters=jdbc
+rules:
+ - !AUTHORITY
+ users:
+ - root@:root
+ provider:
+ type: ALL_PRIVILEGES_PERMITTED
-#it.scenarios=db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_governance,shadow
-it.scenarios=db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt
-
-#it.databases=H2,MySQL,PostgreSQL
-it.databases=H2
-
-it.run.additional.cases=false
+props:
+ max-connections-size-per-query: 1
+ kernel-executor-size: 16 # Infinite by default.
+ proxy-frontend-flush-threshold: 128 # The default value is 128.
+ proxy-opentracing-enabled: false
+ proxy-hint-enabled: false
+ sql-show: false
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/sharding_governance/h2/config-sharding-governance.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/sharding_governance/h2/config-sharding-governance.yaml
index 7ddca74..4141464 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/sharding_governance/h2/config-sharding-governance.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/sharding_governance/h2/config-sharding-governance.yaml
@@ -19,7 +19,7 @@ schemaName: sharding_governance
dataSources:
governance_db:
- url:
jdbc:mysql://mysql.sharding_governance.host:3306/governance_db?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url:
jdbc:h2:mem:governance_db;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/tbl/h2/config-tbl.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/tbl/h2/config-tbl.yaml
index a63c881..e935ddc 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/tbl/h2/config-tbl.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/proxy/conf/tbl/h2/config-tbl.yaml
@@ -19,7 +19,7 @@ schemaName: tbl
dataSources:
tbl:
- url:
jdbc:mysql://mysql.tbl.host:3306/tbl?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
+ url: jdbc:h2:mem:tbl;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL
username: root
password:
connectionTimeoutMilliseconds: 30000
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/engine-env.properties
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/engine-env.properties
index 4a46096..209d19e 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/engine-env.properties
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/engine-env.properties
@@ -21,7 +21,7 @@ it.env.type=${it.env}
it.adapters=jdbc
#it.scenarios=db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_governance,shadow
-it.scenarios=db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt
+it.scenarios=db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,shadow
#it.databases=H2,MySQL,PostgreSQL
it.databases=H2
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/shadow/init-sql/h2/init-db.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/shadow/init-sql/h2/init-db.sql
new file mode 100644
index 0000000..e3b8a18
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/shadow/init-sql/h2/init-db.sql
@@ -0,0 +1,16 @@
+--
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+--
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/shadow/init-sql/h2/init-shadow_db.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/shadow/init-sql/h2/init-shadow_db.sql
new file mode 100644
index 0000000..e3b8a18
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/shadow/init-sql/h2/init-shadow_db.sql
@@ -0,0 +1,16 @@
+--
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+--
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/shadow/init-sql/h2/init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/shadow/init-sql/h2/init.sql
new file mode 100644
index 0000000..9d7b1b9
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/shadow/init-sql/h2/init.sql
@@ -0,0 +1,21 @@
+--
+-- Licensed to the Apache Software Foundation (ASF) under one or more
+-- contributor license agreements. See the NOTICE file distributed with
+-- this work for additional information regarding copyright ownership.
+-- The ASF licenses this file to You under the Apache License, Version 2.0
+-- (the "License"); you may not use this file except in compliance with
+-- the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+--
+DROP TABLE IF EXISTS t_order;
+
+CREATE TABLE t_order (order_id BIGINT NOT NULL, user_id INT NOT NULL,
order_name VARCHAR(32) NOT NULL, type_char CHAR(1) NOT NULL, type_boolean
BOOLEAN NOT NULL, type_smallint SMALLINT NOT NULL,
+ type_enum ENUM('spring', 'summer', 'autumn',
'winter'), type_decimal DECIMAL(18,2) NOT NULL, type_date DATE NOT NULL,
type_time TIME NOT NULL, type_timestamp TIMESTAMP NOT NULL,
+ PRIMARY KEY (order_id));
