You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2025/09/17 04:56:37 UTC

(shardingsphere) branch master updated: Remove useless H2 database for SQL and operation E2E (#36597)

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 e71dced4101 Remove useless H2 database for SQL and operation E2E (#36597)
e71dced4101 is described below

commit e71dced4101081f92861270ad32a2c41218dd7e0
Author: Liang Zhang <zh...@apache.org>
AuthorDate: Wed Sep 17 12:56:31 2025 +0800

    Remove useless H2 database for SQL and operation E2E (#36597)
---
 .../atomic/storage/StorageContainerFactory.java    |   3 -
 .../type/embedded/EmbeddedStorageContainer.java    | 121 ---------------------
 .../e2e/env/runtime/DataSourceEnvironment.java     |   9 --
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  16 ---
 .../init-sql/h2/60-scenario-expected-init.sql      |  16 ---
 .../param/array/E2ETestParameterGenerator.java     |   2 +-
 .../resources/cases/ddl/e2e-ddl-alter-table.xml    |   4 +-
 .../test/resources/cases/ddl/e2e-ddl-truncate.xml  |   4 +-
 .../test/resources/cases/dml/e2e-dml-delete.xml    |   4 +-
 .../test/resources/cases/dml/e2e-dml-insert.xml    |   2 +-
 .../test/resources/cases/dml/e2e-dml-update.xml    |  16 +--
 .../passthrough/e2e-dql-select-for-passthrough.xml |   2 +-
 .../cases/dql/e2e-dql-select-expression.xml        |   4 +-
 .../cases/dql/e2e-dql-select-group-by.xml          |   6 +-
 .../resources/cases/dql/e2e-dql-select-join.xml    |  10 +-
 .../test/resources/cases/dql/e2e-dql-select-or.xml |   2 +-
 .../cases/dql/e2e-dql-select-order-by.xml          |  10 +-
 .../cases/dql/e2e-dql-select-projection.xml        |   2 +-
 .../test/resources/cases/dql/e2e-dql-select.xml    |   4 +-
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  28 -----
 .../data/actual/init-sql/h2/actual-db_0-init.sql   |  22 ----
 .../data/actual/init-sql/h2/actual-db_1-init.sql   |  22 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  36 ------
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  73 -------------
 .../actual/init-sql/h2/actual-read_ds_0-init.sql   |  22 ----
 .../actual/init-sql/h2/actual-read_ds_1-init.sql   |  22 ----
 .../actual/init-sql/h2/actual-write_ds_0-init.sql  |  22 ----
 .../actual/init-sql/h2/actual-write_ds_1-init.sql  |  22 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  36 ------
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  63 -----------
 .../init-sql/h2/actual-encrypt_read_ds_0-init.sql  |  20 ----
 .../init-sql/h2/actual-encrypt_read_ds_1-init.sql  |  22 ----
 .../init-sql/h2/actual-encrypt_write_ds_0-init.sql |  20 ----
 .../init-sql/h2/actual-encrypt_write_ds_1-init.sql |  22 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  36 ------
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  28 -----
 .../init-sql/h2/60-scenario-expected-init.sql      |  28 -----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  22 ----
 .../init-sql/h2/actual-encrypt_read_ds-init.sql    |  20 ----
 .../init-sql/h2/actual-encrypt_write_ds-init.sql   |  20 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  24 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  21 ----
 .../data/actual/init-sql/h2/actual-db-init.sql     |  16 ---
 .../actual/init-sql/h2/actual-shadow_db-init.sql   |  16 ---
 .../init-sql/h2/60-scenario-expected-init.sql      |  22 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  19 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  20 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  19 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  20 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  19 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  20 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  20 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  20 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  24 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  24 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  21 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  22 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  21 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  70 ------------
 .../init-sql/h2/60-scenario-expected-init.sql      |  36 ------
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  19 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  20 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  19 ----
 .../init-sql/h2/60-scenario-expected-init.sql      |  20 ----
 .../actual/init-sql/h2/50-scenario-actual-init.sql |  77 -------------
 .../init-sql/h2/60-scenario-expected-init.sql      |  24 ----
 66 files changed, 36 insertions(+), 1460 deletions(-)

diff --git a/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/container/atomic/storage/StorageContainerFactory.java b/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/container/atomic/storage/StorageContainerFactory.java
index 4af1ccb2e4e..3f745ebdd08 100644
--- a/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/container/atomic/storage/StorageContainerFactory.java
+++ b/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/container/atomic/storage/StorageContainerFactory.java
@@ -23,7 +23,6 @@ import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
 import org.apache.shardingsphere.test.e2e.env.container.atomic.storage.option.StorageContainerConfigurationOption;
 import org.apache.shardingsphere.test.e2e.env.container.atomic.storage.type.docker.DockerStorageContainer;
 import org.apache.shardingsphere.test.e2e.env.container.atomic.storage.type.docker.impl.HiveContainer;
-import org.apache.shardingsphere.test.e2e.env.container.atomic.storage.type.embedded.EmbeddedStorageContainer;
 import org.apache.shardingsphere.test.e2e.env.runtime.E2ETestEnvironment;
 
 /**
@@ -64,8 +63,6 @@ public final class StorageContainerFactory {
                 return new DockerStorageContainer(storageContainerImage, option, scenario);
             case "Hive":
                 return new HiveContainer(storageContainerImage, option, scenario);
-            case "H2":
-                return new EmbeddedStorageContainer(databaseType, scenario);
             default:
                 throw new RuntimeException(String.format("Database `%s` is unknown.", databaseType.getType()));
         }
diff --git a/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/container/atomic/storage/type/embedded/EmbeddedStorageContainer.java b/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/container/atomic/storage/type/embedded/EmbeddedStorageContainer.java
deleted file mode 100644
index 9bf1097c071..00000000000
--- a/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/container/atomic/storage/type/embedded/EmbeddedStorageContainer.java
+++ /dev/null
@@ -1,121 +0,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.
- */
-
-package org.apache.shardingsphere.test.e2e.env.container.atomic.storage.type.embedded;
-
-import lombok.Getter;
-import lombok.SneakyThrows;
-import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
-import org.apache.shardingsphere.test.e2e.env.container.atomic.EmbeddedITContainer;
-import org.apache.shardingsphere.test.e2e.env.container.atomic.storage.StorageContainer;
-import org.apache.shardingsphere.test.e2e.env.container.atomic.util.StorageContainerUtils;
-import org.apache.shardingsphere.test.e2e.env.runtime.DataSourceEnvironment;
-import org.apache.shardingsphere.test.e2e.env.runtime.E2ETestEnvironment;
-import org.apache.shardingsphere.test.e2e.env.runtime.scenario.database.DatabaseEnvironmentManager;
-import org.apache.shardingsphere.test.e2e.env.runtime.scenario.path.ScenarioDataPath;
-import org.apache.shardingsphere.test.e2e.env.runtime.scenario.path.ScenarioDataPath.Type;
-import org.h2.tools.RunScript;
-
-import javax.sql.DataSource;
-import java.io.FileReader;
-import java.io.IOException;
-import java.sql.Connection;
-import java.sql.SQLException;
-import java.util.Collection;
-import java.util.Collections;
-import java.util.LinkedHashMap;
-import java.util.Map;
-import java.util.Map.Entry;
-import java.util.Optional;
-import java.util.stream.Collectors;
-
-/**
- * Embedded storage container.
- */
-public final class EmbeddedStorageContainer implements EmbeddedITContainer, StorageContainer {
-    
-    private final DatabaseType databaseType;
-    
-    private final String scenario;
-    
-    private final ScenarioDataPath scenarioDataPath;
-    
-    @Getter
-    private final Map<String, DataSource> actualDataSourceMap;
-    
-    @Getter
-    private final Map<String, DataSource> expectedDataSourceMap;
-    
-    public EmbeddedStorageContainer(final DatabaseType databaseType, final String scenario) {
-        this.databaseType = databaseType;
-        this.scenario = scenario;
-        scenarioDataPath = new ScenarioDataPath(scenario);
-        actualDataSourceMap = createDataSourceMap(Type.ACTUAL);
-        expectedDataSourceMap = createDataSourceMap(Type.EXPECTED);
-    }
-    
-    private Map<String, DataSource> createDataSourceMap(final Type type) {
-        E2ETestEnvironment env = E2ETestEnvironment.getInstance();
-        Collection<String> databaseNames = DatabaseEnvironmentManager.getDatabaseTypes(scenario, databaseType, type).entrySet().stream()
-                .filter(entry -> entry.getValue().getClass().isAssignableFrom(databaseType.getClass())).map(Entry::getKey).collect(Collectors.toList());
-        Map<String, DataSource> result = new LinkedHashMap<>(databaseNames.size(), 1F);
-        databaseNames.forEach(each -> result.put(each, StorageContainerUtils.generateDataSource(
-                DataSourceEnvironment.getURL(databaseType, env.getNativeStorageHost(), env.getNativeStoragePort(), each), env.getNativeStorageUsername(), env.getNativeStoragePassword())));
-        return result;
-    }
-    
-    @Override
-    @SneakyThrows({IOException.class, SQLException.class})
-    public void start() {
-        fillActualDataSet();
-        fillExpectedDataSet();
-    }
-    
-    private void fillActualDataSet() throws SQLException, IOException {
-        for (Entry<String, DataSource> entry : getActualDataSourceMap().entrySet()) {
-            executeInitSQL(entry.getValue(), scenarioDataPath.getInitSQLFile(Type.ACTUAL, databaseType));
-            Optional<String> dbInitSQLFile = scenarioDataPath.findActualDatabaseInitSQLFile(entry.getKey(), databaseType);
-            if (dbInitSQLFile.isPresent()) {
-                executeInitSQL(entry.getValue(), dbInitSQLFile.get());
-            }
-        }
-    }
-    
-    private void fillExpectedDataSet() throws SQLException, IOException {
-        for (Entry<String, DataSource> entry : getExpectedDataSourceMap().entrySet()) {
-            executeInitSQL(entry.getValue(), scenarioDataPath.getInitSQLFile(Type.EXPECTED, databaseType));
-        }
-    }
-    
-    private void executeInitSQL(final DataSource dataSource, final String initSQLFile) throws SQLException, IOException {
-        try (
-                Connection connection = dataSource.getConnection();
-                FileReader reader = new FileReader(initSQLFile)) {
-            RunScript.execute(connection, reader);
-        }
-    }
-    
-    @Override
-    public String getAbbreviation() {
-        return databaseType.getType().toLowerCase();
-    }
-    
-    @Override
-    public Map<String, String> getLinkReplacements() {
-        return Collections.emptyMap();
-    }
-}
diff --git a/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/runtime/DataSourceEnvironment.java b/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/runtime/DataSourceEnvironment.java
index 5e3c8c78c5a..d2117320247 100644
--- a/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/runtime/DataSourceEnvironment.java
+++ b/test/e2e/env/src/test/java/org/apache/shardingsphere/test/e2e/env/runtime/DataSourceEnvironment.java
@@ -33,8 +33,6 @@ public final class DataSourceEnvironment {
      */
     public static String getDriverClassName(final DatabaseType databaseType) {
         switch (databaseType.getType()) {
-            case "H2":
-                return "org.h2.Driver";
             case "MySQL":
                 return "com.mysql.cj.jdbc.Driver";
             case "MariaDB":
@@ -61,9 +59,6 @@ public final class DataSourceEnvironment {
      */
     public static String getURL(final DatabaseType databaseType, final String host, final int port) {
         switch (databaseType.getType()) {
-            case "H2":
-                E2ETestEnvironment env = E2ETestEnvironment.getInstance();
-                return String.format("jdbc:h2:mem:test_db;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MySQL;USER=%s;PASSWORD=%s", env.getNativeStorageUsername(), env.getNativeStoragePassword());
             case "MySQL":
                 return String.format("jdbc:mysql://%s:%s?useSSL=true&requireSSL=true&enabledTLSProtocols=TLSv1.2,TLSv1.3&verifyServerCertificate=false"
                         + "&useServerPrepStmts=true&useLocalSessionState=true&characterEncoding=utf-8&allowMultiQueries=true&rewriteBatchedStatements=true", host, port);
@@ -93,10 +88,6 @@ public final class DataSourceEnvironment {
      */
     public static String getURL(final DatabaseType databaseType, final String host, final int port, final String dataSourceName) {
         switch (databaseType.getType()) {
-            case "H2":
-                E2ETestEnvironment env = E2ETestEnvironment.getInstance();
-                return String.format("jdbc:h2:mem:%s;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MySQL;USER=%s;PASSWORD=%s",
-                        dataSourceName, env.getNativeStorageUsername(), env.getNativeStoragePassword());
             case "MySQL":
                 return String.format(
                         "jdbc:mysql://%s:%s/%s?useSSL=true&requireSSL=true&enabledTLSProtocols=TLSv1.2,TLSv1.3&verifyServerCertificate=false"
diff --git a/test/e2e/operation/showprocesslist/src/test/resources/env/scenario/cluster_jdbc_proxy/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/operation/showprocesslist/src/test/resources/env/scenario/cluster_jdbc_proxy/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index e3b8a181bea..00000000000
--- a/test/e2e/operation/showprocesslist/src/test/resources/env/scenario/cluster_jdbc_proxy/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,16 +0,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.
---
diff --git a/test/e2e/operation/showprocesslist/src/test/resources/env/scenario/cluster_jdbc_proxy/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/operation/showprocesslist/src/test/resources/env/scenario/cluster_jdbc_proxy/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index e3b8a181bea..00000000000
--- a/test/e2e/operation/showprocesslist/src/test/resources/env/scenario/cluster_jdbc_proxy/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,16 +0,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.
---
diff --git a/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/sql/framework/param/array/E2ETestParameterGenerator.java b/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/sql/framework/param/array/E2ETestParameterGenerator.java
index 2ae9dd5e304..9fb096c42ec 100644
--- a/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/sql/framework/param/array/E2ETestParameterGenerator.java
+++ b/test/e2e/sql/src/test/java/org/apache/shardingsphere/test/e2e/sql/framework/param/array/E2ETestParameterGenerator.java
@@ -194,7 +194,7 @@ public final class E2ETestParameterGenerator {
     }
     
     private Collection<DatabaseType> getDatabaseTypes(final String databaseTypes) {
-        String candidates = Strings.isNullOrEmpty(databaseTypes) ? "H2,MySQL,Oracle,SQLServer,PostgreSQL,openGauss,Hive" : databaseTypes;
+        String candidates = Strings.isNullOrEmpty(databaseTypes) ? "MySQL,Oracle,SQLServer,PostgreSQL,openGauss,Hive" : databaseTypes;
         return Splitter.on(',').trimResults().splitToList(candidates).stream().map(each -> TypedSPILoader.getService(DatabaseType.class, each)).collect(Collectors.toList());
     }
 }
diff --git a/test/e2e/sql/src/test/resources/cases/ddl/e2e-ddl-alter-table.xml b/test/e2e/sql/src/test/resources/cases/ddl/e2e-ddl-alter-table.xml
index 0b885ff941a..ba4b6f6d220 100644
--- a/test/e2e/sql/src/test/resources/cases/ddl/e2e-ddl-alter-table.xml
+++ b/test/e2e/sql/src/test/resources/cases/ddl/e2e-ddl-alter-table.xml
@@ -31,7 +31,7 @@
         </assertion>
     </test-case>
 	
-    <test-case sql="ALTER TABLE t_order_details CHANGE description description_new varchar(10)" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="ALTER TABLE t_order_details CHANGE description description_new varchar(10)" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-file="alter_change.xml">
             <initial-sql sql="CREATE TABLE t_order_details(id int, description varchar(10))" affected-table="t_order_details" />
             <destroy-sql sql="DROP TABLE t_order_details" />
@@ -59,7 +59,7 @@
         </assertion>
     </test-case>
 	
-    <test-case sql="ALTER TABLE t_broadcast_table_for_ddl CHANGE description description_new varchar(10)" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="ALTER TABLE t_broadcast_table_for_ddl CHANGE description description_new varchar(10)" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-file="alter_broadcast_change.xml">
             <initial-sql sql="CREATE TABLE t_broadcast_table_for_ddl(id int, description varchar(10))" affected-table="t_broadcast_table_for_ddl" />
             <destroy-sql sql="DROP TABLE t_broadcast_table_for_ddl" />
diff --git a/test/e2e/sql/src/test/resources/cases/ddl/e2e-ddl-truncate.xml b/test/e2e/sql/src/test/resources/cases/ddl/e2e-ddl-truncate.xml
index 2221a803402..9a88439b200 100644
--- a/test/e2e/sql/src/test/resources/cases/ddl/e2e-ddl-truncate.xml
+++ b/test/e2e/sql/src/test/resources/cases/ddl/e2e-ddl-truncate.xml
@@ -17,7 +17,7 @@
   -->
 
 <e2e-test-cases>
-    <test-case sql="TRUNCATE TABLE t_order_details" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="TRUNCATE TABLE t_order_details" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-file="unchanged_table.xml">
             <initial-sql sql="CREATE TABLE t_order_details(id int, description varchar(10))" affected-table="t_order_details" />
             <destroy-sql sql="DROP TABLE t_order_details" />
@@ -31,7 +31,7 @@
         </assertion>
     </test-case>
 
-    <test-case sql="TRUNCATE TABLE t_broadcast_table_for_ddl" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="TRUNCATE TABLE t_broadcast_table_for_ddl" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-file="unchanged_broadcast_table.xml">
             <initial-sql sql="CREATE TABLE t_broadcast_table_for_ddl(id int, description varchar(10))" affected-table="t_broadcast_table_for_ddl" />
             <destroy-sql sql="DROP TABLE t_broadcast_table_for_ddl" />
diff --git a/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-delete.xml b/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-delete.xml
index c20cfee4e90..71084a404b2 100644
--- a/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-delete.xml
+++ b/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-delete.xml
@@ -32,11 +32,11 @@
         <assertion parameters="init:String" expected-data-file="delete_without_sharding_value.xml" />
     </test-case>
     
-    <test-case sql="DELETE FROM t_user WHERE user_id = ?" db-types="H2,MySQL,PostgreSQL,openGauss" scenario-types="encrypt">
+    <test-case sql="DELETE FROM t_user WHERE user_id = ?" db-types="MySQL,PostgreSQL,openGauss" scenario-types="encrypt">
         <assertion parameters="10:int" expected-data-file="delete_user_table.xml" />
     </test-case>
     
-    <test-case sql="DELETE FROM t_user WHERE password = ?" db-types="H2,MySQL,PostgreSQL,openGauss" scenario-types="encrypt">
+    <test-case sql="DELETE FROM t_user WHERE password = ?" db-types="MySQL,PostgreSQL,openGauss" scenario-types="encrypt">
         <assertion parameters="111111:String" expected-data-file="delete_user_table.xml" />
     </test-case>
     
diff --git a/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-insert.xml b/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-insert.xml
index ed2b608b74b..9a7f9e0e586 100644
--- a/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-insert.xml
+++ b/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-insert.xml
@@ -113,7 +113,7 @@
         <assertion parameters="1:int, 2:int, 2:int, insert:String" expected-data-file="batch_insert_for_order.xml" />
     </test-case>
     
-    <!--<test-case sql="INSERT INTO t_order (order_id, user_id, status) VALUES (?, ?, SUBSTR(?, 1)), (?, ?, SUBSTR(?, 1))" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">-->
+    <!--<test-case sql="INSERT INTO t_order (order_id, user_id, status) VALUES (?, ?, SUBSTR(?, 1)), (?, ?, SUBSTR(?, 1))" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">-->
     <!--<assertion parameters="1:int, 1:int, insert:String, 2:int, 2:int, insert:String" expected-data-file="pro_insert_order_value.xml" />-->
     <!--</test-case>-->
     
diff --git a/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-update.xml b/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-update.xml
index 7428713e290..1f200e1fa5c 100644
--- a/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-update.xml
+++ b/test/e2e/sql/src/test/resources/cases/dml/e2e-dml-update.xml
@@ -28,11 +28,11 @@
         <assertion parameters="update:String, 2800:int, 28:int" expected-data-file="update_batch_4.xml" />
     </test-case>
     
-    <test-case sql="UPDATE t_order AS o SET o.status = ? WHERE o.order_id = ? AND o.user_id = ?" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="UPDATE t_order AS o SET o.status = ? WHERE o.order_id = ? AND o.user_id = ?" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion parameters="update:String, 1000:int, 10:int" expected-data-file="update.xml" />
     </test-case>
     
-    <test-case sql="UPDATE t_order o SET o.status = 'finished'" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="UPDATE t_order o SET o.status = 'finished'" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-file="update_without_condition.xml" />
     </test-case>
     
@@ -40,7 +40,7 @@
         <assertion expected-data-file="update.xml" />
     </test-case>
     
-    <test-case sql="UPDATE t_order SET status = 'update' WHERE (order_id = ? OR order_id = ?) AND user_id = ?" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="UPDATE t_order SET status = 'update' WHERE (order_id = ? OR order_id = ?) AND user_id = ?" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion parameters="1000:int, 0:int, 10:int" expected-data-file="update.xml" />
     </test-case>
     
@@ -49,7 +49,7 @@
     </test-case>
     
     <!-- TODO FIXED ME PostgreSQL return 0 and replace with standard table structure -->
-    <!--<test-case sql="UPDATE t_broadcast_table b SET b.status = 'finished'" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
+    <!--<test-case sql="UPDATE t_broadcast_table b SET b.status = 'finished'" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
         <assertion expected-data-file="update_broadcast_table.xml" />
     </test-case>-->
     
@@ -58,19 +58,19 @@
     <!--        <assertion expected-data-file="update_single_table.xml" />-->
     <!--    </test-case>-->
     
-    <test-case sql="UPDATE t_user u SET u.password = ? WHERE u.user_id = ?" db-types="H2,MySQL,openGauss" scenario-types="encrypt">
+    <test-case sql="UPDATE t_user u SET u.password = ? WHERE u.user_id = ?" db-types="MySQL,openGauss" scenario-types="encrypt">
         <assertion parameters="222222:String, 10:int" expected-data-file="update_user_table.xml" />
     </test-case>
     
-    <test-case sql="UPDATE t_user u SET u.telephone = ? WHERE u.password = ?" db-types="H2,MySQL,openGauss" scenario-types="encrypt">
+    <test-case sql="UPDATE t_user u SET u.telephone = ? WHERE u.password = ?" db-types="MySQL,openGauss" scenario-types="encrypt">
         <assertion parameters="12345678901:String, 111111:String" expected-data-file="update_user_table_by_pwd.xml" />
     </test-case>
     
-    <test-case sql="UPDATE t_user SET password = ? WHERE user_id = ?" db-types="H2,MySQL,PostgreSQL,openGauss" scenario-types="encrypt">
+    <test-case sql="UPDATE t_user SET password = ? WHERE user_id = ?" db-types="MySQL,PostgreSQL,openGauss" scenario-types="encrypt">
         <assertion parameters="222222:String, 10:int" expected-data-file="update_user_table.xml" />
     </test-case>
     
-    <test-case sql="UPDATE t_user SET telephone = ? WHERE password = ?" db-types="H2,MySQL,PostgreSQL,openGauss" scenario-types="encrypt">
+    <test-case sql="UPDATE t_user SET telephone = ? WHERE password = ?" db-types="MySQL,PostgreSQL,openGauss" scenario-types="encrypt">
         <assertion parameters="12345678901:String, 111111:String" expected-data-file="update_user_table_by_pwd.xml" />
     </test-case>
     
diff --git a/test/e2e/sql/src/test/resources/cases/dql/cases/passthrough/e2e-dql-select-for-passthrough.xml b/test/e2e/sql/src/test/resources/cases/dql/cases/passthrough/e2e-dql-select-for-passthrough.xml
index 2bc1e9aa74a..0861d33dc61 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/cases/passthrough/e2e-dql-select-for-passthrough.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/cases/passthrough/e2e-dql-select-for-passthrough.xml
@@ -17,7 +17,7 @@
   -->
 
 <e2e-test-cases>
-    <test-case sql="SELECT 1 FROM dual" db-types="MySQL,H2" smoke="true" scenario-types="passthrough" >
+    <test-case sql="SELECT 1 FROM dual" db-types="MySQL" smoke="true" scenario-types="passthrough" >
         <assertion />
     </test-case>
 
diff --git a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-expression.xml b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-expression.xml
index 7e2255e11c6..476958e41d8 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-expression.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-expression.xml
@@ -30,11 +30,11 @@
     </test-case>
     
     <test-case sql="select t.*,o.item_id as item_id,(case when t.status = 'init' then '已启用' when t.status = 'failed' then '已停用' end) as stateName
-    from t_order t left join t_order_item as o on o.order_id =t.order_id where t.order_id=1000 limit 1" db-types="MySQL,H2" scenario-types="tbl,readwrite_splitting">
+    from t_order t left join t_order_item as o on o.order_id =t.order_id where t.order_id=1000 limit 1" db-types="MySQL" scenario-types="tbl,readwrite_splitting">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="select case when (select 1 from t_order t where exists (select 1 from t_order t where t.user_id = i.item_id)) = '1' then '已启用' else '已停用' end as status from t_order_item i" db-types="MySQL,H2" scenario-types="encrypt">
+    <test-case sql="select case when (select 1 from t_order t where exists (select 1 from t_order t where t.user_id = i.item_id)) = '1' then '已启用' else '已停用' end as status from t_order_item i" db-types="MySQL" scenario-types="encrypt">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
diff --git a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-group-by.xml b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-group-by.xml
index cdfeb080c99..6fb9e383ddb 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-group-by.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-group-by.xml
@@ -17,15 +17,15 @@
   -->
 
 <e2e-test-cases>
-    <test-case sql="SELECT user_id FROM t_order GROUP BY user_id ORDER BY user_id LIMIT ?" db-types="H2,MySQL,PostgreSQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT user_id FROM t_order GROUP BY user_id ORDER BY user_id LIMIT ?" db-types="MySQL,PostgreSQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion parameters="1:int" expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT user_id, SUM(order_id) AS orders_sum FROM t_order GROUP BY user_id ORDER BY SUM(order_id) LIMIT ?" db-types="H2,MySQL,PostgreSQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT user_id, SUM(order_id) AS orders_sum FROM t_order GROUP BY user_id ORDER BY SUM(order_id) LIMIT ?" db-types="MySQL,PostgreSQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion parameters="1:int" expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT o.user_id uid FROM t_order o GROUP BY o.user_id ORDER BY o.user_id" db-types="H2,MySQL,PostgreSQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT o.user_id uid FROM t_order o GROUP BY o.user_id ORDER BY o.user_id" db-types="MySQL,PostgreSQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
diff --git a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-join.xml b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-join.xml
index 27d13b0606a..7068867bc96 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-join.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-join.xml
@@ -46,7 +46,7 @@
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT i.*, o.* FROM t_order o JOIN t_order_item i ON o.user_id = i.user_id AND o.order_id = i.order_id ORDER BY item_id" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT i.*, o.* FROM t_order o JOIN t_order_item i ON o.user_id = i.user_id AND o.order_id = i.order_id ORDER BY item_id" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
@@ -54,7 +54,7 @@
         <assertion parameters="10:int, 11:int, 1000:int, 1909:int" expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON o.user_id = i.user_id AND o.order_id = i.order_id WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? ORDER BY i.item_id DESC LIMIT ?" db-types="MySQL,H2,PostgreSQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON o.user_id = i.user_id AND o.order_id = i.order_id WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? ORDER BY i.item_id DESC LIMIT ?" db-types="MySQL,PostgreSQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 2:int" expected-data-source-name="read_dataset" />
     </test-case>
     
@@ -74,7 +74,7 @@
         <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 2:int, 2:int" expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT i.user_id FROM t_order o JOIN t_order_item i ON o.user_id = i.user_id AND o.order_id = i.order_id WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? GROUP BY i.item_id ORDER BY i.item_id DESC LIMIT ?, ?" db-types="MySQL,H2" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT i.user_id FROM t_order o JOIN t_order_item i ON o.user_id = i.user_id AND o.order_id = i.order_id WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? GROUP BY i.item_id ORDER BY i.item_id DESC LIMIT ?, ?" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 1:int, 10:int" expected-data-source-name="read_dataset" />
     </test-case>
     
@@ -108,7 +108,7 @@
         <assertion expected-data-source-name="read_dataset" />
     </test-case>-->
     
-    <test-case sql="SELECT i.* FROM t_order o INNER JOIN t_order_item i ON o.order_id = i.order_id WHERE o.order_id = ?" db-types="MySQL,H2,PostgreSQL" scenario-types="tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT i.* FROM t_order o INNER JOIN t_order_item i ON o.order_id = i.order_id WHERE o.order_id = ?" db-types="MySQL,PostgreSQL" scenario-types="tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion parameters="1000:int" expected-data-source-name="read_dataset" />
     </test-case>
     
@@ -129,7 +129,7 @@
         <assertion expected-data-source-name="expected_dataset" />
     </test-case>
     
-    <test-case sql="SELECT * FROM t_order o LEFT JOIN t_order_item m ON o.order_id = m.order_id AND o.user_id = m.user_id order by o.order_id, m.item_id" db-types="MySQL,H2" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT * FROM t_order o LEFT JOIN t_order_item m ON o.order_id = m.order_id AND o.user_id = m.user_id order by o.order_id, m.item_id" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
 </e2e-test-cases>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-or.xml b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-or.xml
index c7add67f93d..83fe7ff5def 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-or.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-or.xml
@@ -26,7 +26,7 @@
     </test-case>
     
     <!-- TODO FIXED ME PostgreSQL default order by collate -->
-    <test-case sql="SELECT * FROM t_order WHERE order_id = ? OR status = ? ORDER BY order_id" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT * FROM t_order WHERE order_id = ? OR status = ? ORDER BY order_id" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion parameters="1000:int, init:String" expected-data-source-name="read_dataset" />
     </test-case>
     
diff --git a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-order-by.xml b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-order-by.xml
index 4e64b198555..0d82cc65254 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-order-by.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-order-by.xml
@@ -64,24 +64,24 @@
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT o.* FROM t_order o ORDER BY o.order_id" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT o.* FROM t_order o ORDER BY o.order_id" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
 
-    <test-case sql="SELECT * FROM t_order o ORDER BY order_id" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT * FROM t_order o ORDER BY order_id" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT t_order.* FROM t_order ORDER BY t_order.order_id" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT t_order.* FROM t_order ORDER BY t_order.order_id" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
     
     <!--TODO need to add later-->
-    <!--<test-case sql="SELECT * FROM t_order o ORDER BY ?" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">-->
+    <!--<test-case sql="SELECT * FROM t_order o ORDER BY ?" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">-->
     <!--<assertion parameters="order_id:String" expected-data-source-name="read_dataset" />-->
     <!--</test-case>-->
 
-    <test-case sql="SELECT * FROM t_order ORDER BY order_id" db-types="H2,MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT * FROM t_order ORDER BY order_id" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-source-name="read_dataset" />
     </test-case>
 
diff --git a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-projection.xml b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-projection.xml
index a13e3eff243..1e9269878dc 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-projection.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select-projection.xml
@@ -37,7 +37,7 @@
         <assertion parameters="10:int, 1000:int" expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT length.item_id password FROM t_order_item length where length.item_id = ?" db-types="MySQL,H2" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT length.item_id password FROM t_order_item length where length.item_id = ?" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion expected-data-source-name="read_dataset" parameters="100001:int" />
     </test-case>
     
diff --git a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select.xml b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select.xml
index f3ebe84e361..699e10b5e90 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/e2e-dql-select.xml
@@ -17,7 +17,7 @@
   -->
 
 <e2e-test-cases>
-    <test-case sql="SELECT 1 FROM dual" db-types="MySQL,H2" smoke="true" scenario-types="db,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,empty_rules,encrypt,encrypt_and_readwrite_splitting,encrypt_shadow,mask,mask_encrypt,mask_encrypt_sharding,mask_sharding,distsql_rdl,readwrite_splitting,readwrite_splitting_and_shadow,shadow,sharding_and_encrypt,sharding_and_shadow,sharding_encrypt_shadow,tbl" >
+    <test-case sql="SELECT 1 FROM dual" db-types="MySQL" smoke="true" scenario-types="db,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,empty_rules,encrypt,encrypt_and_readwrite_splitting,encrypt_shadow,mask,mask_encrypt,mask_encrypt_sharding,mask_sharding,distsql_rdl,readwrite_splitting,readwrite_splitting_and_shadow,shadow,sharding_and_encrypt,sharding_and_shadow,sharding_encrypt_shadow,tbl" >
         <assertion />
     </test-case>
 
@@ -30,7 +30,7 @@
         <assertion parameters="12:int, 1000:int" />
     </test-case>
 
-    <test-case sql="SELECT t_order.order_id,t_order.user_id,status FROM t_order t_order WHERE t_order.user_id = ? AND order_id = ?" db-types="MySQL,H2" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+    <test-case sql="SELECT t_order.order_id,t_order.user_id,status FROM t_order t_order WHERE t_order.user_id = ? AND order_id = ?" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
         <assertion parameters="10:int, 1000:int" expected-data-source-name="read_dataset" />
         <assertion parameters="12:int, 1000:int" expected-data-source-name="read_dataset" />
     </test-case>
diff --git a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index 79c02ec21a9..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,28 +0,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.
---
-
-DROP TABLE IF EXISTS t_order CASCADE;
-DROP TABLE IF EXISTS t_order_item CASCADE;
-DROP TABLE IF EXISTS t_product_category CASCADE;
-DROP TABLE IF EXISTS t_country CASCADE;
-
-CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-
-CREATE INDEX order_index ON t_order (order_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-db_0-init.sql b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-db_0-init.sql
deleted file mode 100644
index 4f4865dab06..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-db_0-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_user CASCADE;
-DROP TABLE IF EXISTS t_product CASCADE;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-db_1-init.sql b/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-db_1-init.sql
deleted file mode 100644
index fc910333566..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-db_1-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_merchant CASCADE;
-DROP TABLE IF EXISTS t_product_detail CASCADE;
-
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 98ff33c2e45..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,36 +0,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.
---
-
-DROP TABLE IF EXISTS t_order CASCADE;
-DROP TABLE IF EXISTS t_order_item CASCADE;
-DROP TABLE IF EXISTS t_user CASCADE;
-DROP TABLE IF EXISTS t_merchant CASCADE;
-DROP TABLE IF EXISTS t_product CASCADE;
-DROP TABLE IF EXISTS t_product_detail CASCADE;
-DROP TABLE IF EXISTS t_product_category CASCADE;
-DROP TABLE IF EXISTS t_country CASCADE;
-
-CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-
-CREATE INDEX order_index ON t_order (order_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index b4668bb2124..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,73 +0,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.
---
-
-DROP TABLE IF EXISTS t_order_0;
-DROP TABLE IF EXISTS t_order_item_0;
-DROP TABLE IF EXISTS t_order_1;
-DROP TABLE IF EXISTS t_order_item_1;
-DROP TABLE IF EXISTS t_order_2;
-DROP TABLE IF EXISTS t_order_item_2;
-DROP TABLE IF EXISTS t_order_3;
-DROP TABLE IF EXISTS t_order_item_3;
-DROP TABLE IF EXISTS t_order_4;
-DROP TABLE IF EXISTS t_order_item_4;
-DROP TABLE IF EXISTS t_order_5;
-DROP TABLE IF EXISTS t_order_item_5;
-DROP TABLE IF EXISTS t_order_6;
-DROP TABLE IF EXISTS t_order_item_6;
-DROP TABLE IF EXISTS t_order_7;
-DROP TABLE IF EXISTS t_order_item_7;
-DROP TABLE IF EXISTS t_order_8;
-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_product_category;
-DROP TABLE IF EXISTS t_country;
-
-CREATE TABLE t_order_0 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_0 (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_1 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_1 (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_2 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_2 (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_3 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_3 (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_4 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_4 (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_5 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_5 (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_6 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_6 (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_7 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_7 (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_8 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_8 (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_9 (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_9 (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_category( category_id INT PRIMARY KEY, category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_country (country_id INT PRIMARY KEY, country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-
-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);
-CREATE INDEX order_index_t_order_2 ON t_order_2 (order_id);
-CREATE INDEX order_index_t_order_3 ON t_order_3 (order_id);
-CREATE INDEX order_index_t_order_4 ON t_order_4 (order_id);
-CREATE INDEX order_index_t_order_5 ON t_order_5 (order_id);
-CREATE INDEX order_index_t_order_6 ON t_order_6 (order_id);
-CREATE INDEX order_index_t_order_7 ON t_order_7 (order_id);
-CREATE INDEX order_index_t_order_8 ON t_order_8 (order_id);
-CREATE INDEX order_index_t_order_9 ON t_order_9 (order_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-read_ds_0-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-read_ds_0-init.sql
deleted file mode 100644
index 5ecccd42c02..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-read_ds_0-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_user;
-DROP TABLE IF EXISTS t_product;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-read_ds_1-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-read_ds_1-init.sql
deleted file mode 100644
index 207449d6e2c..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-read_ds_1-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_merchant;
-DROP TABLE IF EXISTS t_product_detail;
-
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id INT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-write_ds_0-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-write_ds_0-init.sql
deleted file mode 100644
index 5ecccd42c02..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-write_ds_0-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_user;
-DROP TABLE IF EXISTS t_product;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-write_ds_1-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-write_ds_1-init.sql
deleted file mode 100644
index 207449d6e2c..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-write_ds_1-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_merchant;
-DROP TABLE IF EXISTS t_product_detail;
-
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id INT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index bc710dac558..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,36 +0,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.
---
-
-DROP TABLE IF EXISTS t_order;
-DROP TABLE IF EXISTS t_order_item;
-DROP TABLE IF EXISTS t_user;
-DROP TABLE IF EXISTS t_merchant;
-DROP TABLE IF EXISTS t_product;
-DROP TABLE IF EXISTS t_product_detail;
-DROP TABLE IF EXISTS t_product_category;
-DROP TABLE IF EXISTS t_country;
-
-CREATE TABLE t_order(order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item(item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id INT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_category( category_id INT PRIMARY KEY, category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_country (country_id INT PRIMARY KEY, country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-
-CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index ac595e7bb67..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,63 +0,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.
---
-DROP TABLE IF EXISTS t_order_0;
-DROP TABLE IF EXISTS t_order_item_0;
-DROP TABLE IF EXISTS t_order_1;
-DROP TABLE IF EXISTS t_order_item_1;
-DROP TABLE IF EXISTS t_order_2;
-DROP TABLE IF EXISTS t_order_item_2;
-DROP TABLE IF EXISTS t_order_3;
-DROP TABLE IF EXISTS t_order_item_3;
-DROP TABLE IF EXISTS t_order_4;
-DROP TABLE IF EXISTS t_order_item_4;
-DROP TABLE IF EXISTS t_order_5;
-DROP TABLE IF EXISTS t_order_item_5;
-DROP TABLE IF EXISTS t_order_6;
-DROP TABLE IF EXISTS t_order_item_6;
-DROP TABLE IF EXISTS t_order_7;
-DROP TABLE IF EXISTS t_order_item_7;
-DROP TABLE IF EXISTS t_order_8;
-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_product_category;
-DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_order_0 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_0 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_1 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_1 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_2 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_2 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_3 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_3 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_4 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_4 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_5 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_5 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_6 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_6 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_7 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_7 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_8 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_8 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_9 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_9 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_category( category_id INT PRIMARY KEY, category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_read_ds_0-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_read_ds_0-init.sql
deleted file mode 100644
index 0b9025f3f00..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_read_ds_0-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_product;
-
-CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_read_ds_1-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_read_ds_1-init.sql
deleted file mode 100644
index a4825e1b28d..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_read_ds_1-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_merchant;
-DROP TABLE IF EXISTS t_product_detail;
-
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_write_ds_0-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_write_ds_0-init.sql
deleted file mode 100644
index 0b9025f3f00..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_write_ds_0-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_product;
-
-CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_write_ds_1-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_write_ds_1-init.sql
deleted file mode 100644
index a4825e1b28d..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-encrypt_write_ds_1-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_merchant;
-DROP TABLE IF EXISTS t_product_detail;
-
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 5227db31ce6..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,36 +0,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.
---
-
-DROP TABLE IF EXISTS t_order;
-DROP TABLE IF EXISTS t_order_item;
-DROP TABLE IF EXISTS t_merchant;
-DROP TABLE IF EXISTS t_product;
-DROP TABLE IF EXISTS t_product_detail;
-DROP TABLE IF EXISTS t_product_category;
-DROP TABLE IF EXISTS t_country;
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-
-CREATE INDEX user_index_t_user ON t_user (user_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index e18a7b0eb36..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,28 +0,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.
---
-
-DROP TABLE IF EXISTS t_order;
-DROP TABLE IF EXISTS t_order_item;
-DROP TABLE IF EXISTS t_user;
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_order (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name_cipher VARCHAR(50) NOT NULL, user_name_like VARCHAR(50) NOT NULL, password_cipher VARCHAR(50) NOT NULL, email_cipher VARCHAR(50) NOT NULL, user_telephone_cipher CHAR(50) NOT NULL, user_telephone_like CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code_cipher VARCHAR(50) NOT NULL, business_code_like VARCHAR(50) NOT NULL, merchant_telephone_cipher CHAR(50) NOT NULL, merchant_telephone_like CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-
-CREATE INDEX user_index_t_user ON t_user (user_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index c61f6ff76da..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,28 +0,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.
---
-
-DROP TABLE IF EXISTS t_order;
-DROP TABLE IF EXISTS t_order_item;
-DROP TABLE IF EXISTS t_user;
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_order (order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item (item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-
-CREATE INDEX user_index_t_user ON t_user (user_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index b3f24205a69..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_user (user_id INT NOT NULL, address_id INT NOT NULL, pwd_cipher VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-
-CREATE INDEX user_index_t_user ON t_user (user_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/actual/init-sql/h2/actual-encrypt_read_ds-init.sql b/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/actual/init-sql/h2/actual-encrypt_read_ds-init.sql
deleted file mode 100644
index 90d753ac9d7..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/actual/init-sql/h2/actual-encrypt_read_ds-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/actual/init-sql/h2/actual-encrypt_write_ds-init.sql b/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/actual/init-sql/h2/actual-encrypt_write_ds-init.sql
deleted file mode 100644
index 90d753ac9d7..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/actual/init-sql/h2/actual-encrypt_write_ds-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 55f1f0c26c7..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/encrypt_and_readwrite_splitting/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,24 +0,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.
---
-
-DROP TABLE IF EXISTS t_user;
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_user (user_id INT NOT NULL, address_id INT NOT NULL, pwd VARCHAR(45) NULL, status VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-
-CREATE INDEX user_index_t_user ON t_user (user_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index 546dafd6c05..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,21 +0,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.
---
-DROP TABLE IF EXISTS t_shadow;
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_shadow (order_id BIGINT NOT NULL, user_id INT NOT NULL, order_name_cipher VARCHAR(200) 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));
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/actual/init-sql/h2/actual-db-init.sql b/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/actual/init-sql/h2/actual-db-init.sql
deleted file mode 100644
index e3b8a181bea..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/actual/init-sql/h2/actual-db-init.sql
+++ /dev/null
@@ -1,16 +0,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.
---
diff --git a/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/actual/init-sql/h2/actual-shadow_db-init.sql b/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/actual/init-sql/h2/actual-shadow_db-init.sql
deleted file mode 100644
index e3b8a181bea..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/actual/init-sql/h2/actual-shadow_db-init.sql
+++ /dev/null
@@ -1,16 +0,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.
---
diff --git a/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 83eb58faa14..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/encrypt_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_shadow;
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_shadow (order_id BIGINT NOT NULL, user_id INT NOT NULL, order_name VARCHAR(200) 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));
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/mask/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/mask/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index a96618c0f3e..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/mask/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,19 +0,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.
---
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/mask/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/mask/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 7472146bbf1..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/mask/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index 44b9b56bda2..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,19 +0,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.
---
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name_cipher VARCHAR(50) NOT NULL, password_cipher VARCHAR(50) NOT NULL, email_cipher VARCHAR(50) NOT NULL, telephone_cipher CHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 7472146bbf1..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt_sharding/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt_sharding/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index 44b9b56bda2..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt_sharding/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,19 +0,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.
---
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name_cipher VARCHAR(50) NOT NULL, password_cipher VARCHAR(50) NOT NULL, email_cipher VARCHAR(50) NOT NULL, telephone_cipher CHAR(50) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt_sharding/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt_sharding/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 7472146bbf1..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/mask_encrypt_sharding/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/mask_sharding/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/mask_sharding/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index 7472146bbf1..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/mask_sharding/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/mask_sharding/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/mask_sharding/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 7472146bbf1..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/mask_sharding/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_user;
-
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index 8b6c213811c..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,24 +0,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.
---
-
-DROP TABLE IF EXISTS t_order;
-DROP TABLE IF EXISTS t_order_item;
-
-CREATE TABLE t_order(order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item(item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-
-CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 8b6c213811c..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,24 +0,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.
---
-
-DROP TABLE IF EXISTS t_order;
-DROP TABLE IF EXISTS t_order_item;
-
-CREATE TABLE t_order(order_id INT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item(item_id INT PRIMARY KEY, order_id INT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-
-CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting_and_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting_and_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index 4a25798fce7..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting_and_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,21 +0,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.
---
-DROP TABLE IF EXISTS t_shadow;
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_shadow (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));
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting_and_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting_and_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index f7470ffebf0..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/readwrite_splitting_and_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,22 +0,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.
---
-
-DROP TABLE IF EXISTS t_shadow;
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_shadow (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));
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index 4a25798fce7..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,21 +0,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.
---
-DROP TABLE IF EXISTS t_shadow;
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_shadow (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));
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/sharding_and_encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index 00f00ea1e08..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_encrypt/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,70 +0,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.
---
-
-DROP TABLE IF EXISTS t_order_0;
-DROP TABLE IF EXISTS t_order_item_0;
-DROP TABLE IF EXISTS t_order_1;
-DROP TABLE IF EXISTS t_order_item_1;
-DROP TABLE IF EXISTS t_order_2;
-DROP TABLE IF EXISTS t_order_item_2;
-DROP TABLE IF EXISTS t_order_3;
-DROP TABLE IF EXISTS t_order_item_3;
-DROP TABLE IF EXISTS t_order_4;
-DROP TABLE IF EXISTS t_order_item_4;
-DROP TABLE IF EXISTS t_order_5;
-DROP TABLE IF EXISTS t_order_item_5;
-DROP TABLE IF EXISTS t_order_6;
-DROP TABLE IF EXISTS t_order_item_6;
-DROP TABLE IF EXISTS t_order_7;
-DROP TABLE IF EXISTS t_order_item_7;
-DROP TABLE IF EXISTS t_order_8;
-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_user;
-DROP TABLE IF EXISTS t_merchant;
-DROP TABLE IF EXISTS t_product;
-DROP TABLE IF EXISTS t_product_detail;
-DROP TABLE IF EXISTS t_product_category;
-DROP TABLE IF EXISTS t_country;
-
-CREATE TABLE t_order_0 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_0 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_1 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_1 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_2 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_2 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_3 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_3 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_4 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_4 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_5 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_5 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_6 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_6 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_7 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_7 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_8 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_8 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_9 (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_9 (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/sharding_and_encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 055d4c32774..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_encrypt/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,36 +0,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.
---
-
-DROP TABLE IF EXISTS t_order;
-DROP TABLE IF EXISTS t_order_item;
-DROP TABLE IF EXISTS t_user;
-DROP TABLE IF EXISTS t_merchant;
-DROP TABLE IF EXISTS t_product;
-DROP TABLE IF EXISTS t_product_detail;
-DROP TABLE IF EXISTS t_product_category;
-DROP TABLE IF EXISTS t_country;
-
-CREATE TABLE t_order (order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item (item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_user (user_id INT PRIMARY KEY, user_name VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product (product_id INT PRIMARY KEY, product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_detail (detail_id INT PRIMARY KEY, product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_product_category (category_id INT PRIMARY KEY, category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level SMALLINT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_country (country_id SMALLINT PRIMARY KEY, country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT NULL);
-
-CREATE INDEX user_index_t_user ON t_user (user_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/sharding_and_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index 0ccb7fa42e9..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,19 +0,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.
---
-DROP TABLE IF EXISTS t_shadow;
-
-CREATE TABLE t_shadow (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));
diff --git a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/sharding_and_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 5ea66a331fc..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/sharding_and_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_shadow;
-
-CREATE TABLE t_shadow (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));
diff --git a/test/e2e/sql/src/test/resources/env/scenario/sharding_encrypt_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/sharding_encrypt_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index efd2578e3ad..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/sharding_encrypt_shadow/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,19 +0,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.
---
-DROP TABLE IF EXISTS t_shadow;
-
-CREATE TABLE t_shadow (order_id BIGINT NOT NULL, user_id INT NOT NULL, order_name_cipher VARCHAR(200) 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));
diff --git a/test/e2e/sql/src/test/resources/env/scenario/sharding_encrypt_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/sharding_encrypt_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index 5a0798c11db..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/sharding_encrypt_shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,20 +0,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.
---
-
-DROP TABLE IF EXISTS t_shadow;
-
-CREATE TABLE t_shadow (order_id BIGINT NOT NULL, user_id INT NOT NULL, order_name VARCHAR(200) 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));
diff --git a/test/e2e/sql/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/50-scenario-actual-init.sql b/test/e2e/sql/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/50-scenario-actual-init.sql
deleted file mode 100644
index afefb856ec1..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/50-scenario-actual-init.sql
+++ /dev/null
@@ -1,77 +0,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.
---
-
-DROP TABLE IF EXISTS t_order_0;
-DROP TABLE IF EXISTS t_order_item_0;
-DROP TABLE IF EXISTS t_order_1;
-DROP TABLE IF EXISTS t_order_item_1;
-DROP TABLE IF EXISTS t_order_2;
-DROP TABLE IF EXISTS t_order_item_2;
-DROP TABLE IF EXISTS t_order_3;
-DROP TABLE IF EXISTS t_order_item_3;
-DROP TABLE IF EXISTS t_order_4;
-DROP TABLE IF EXISTS t_order_item_4;
-DROP TABLE IF EXISTS t_order_5;
-DROP TABLE IF EXISTS t_order_item_5;
-DROP TABLE IF EXISTS t_order_6;
-DROP TABLE IF EXISTS t_order_item_6;
-DROP TABLE IF EXISTS t_order_7;
-DROP TABLE IF EXISTS t_order_item_7;
-DROP TABLE IF EXISTS t_order_8;
-DROP TABLE IF EXISTS t_order_item_8;
-DROP TABLE IF EXISTS t_order_9;
-DROP TABLE IF EXISTS t_order_item_9;
-
-CREATE TABLE t_order_0(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_0(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE INDEX order_index ON t_order_0 (order_id);
-
-CREATE TABLE t_order_1(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_1(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE INDEX order_index ON t_order_1 (order_id);
-
-CREATE TABLE t_order_2(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_2(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE INDEX order_index ON t_order_2 (order_id);
-
-CREATE TABLE t_order_3(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_3(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE INDEX order_index ON t_order_3 (order_id);
-
-CREATE TABLE t_order_4(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_4(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE INDEX order_index ON t_order_4 (order_id);
-
-CREATE TABLE t_order_5(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_5(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE INDEX order_index ON t_order_5 (order_id);
-
-CREATE TABLE t_order_6(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_6(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE INDEX order_index ON t_order_6 (order_id);
-
-CREATE TABLE t_order_7(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_7(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE INDEX order_index ON t_order_7 (order_id);
-
-CREATE TABLE t_order_8(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_8(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE INDEX order_index ON t_order_8 (order_id);
-
-CREATE TABLE t_order_9(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item_9(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE INDEX order_index ON t_order_9 (order_id);
diff --git a/test/e2e/sql/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/60-scenario-expected-init.sql b/test/e2e/sql/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index be2b5dda9ad..00000000000
--- a/test/e2e/sql/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,24 +0,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.
---
-
-DROP TABLE IF EXISTS t_order;
-DROP TABLE IF EXISTS t_order_item;
-
-CREATE TABLE t_order(order_id BIGINT PRIMARY KEY, user_id INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT NOT NULL, remark VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE t_order_item(item_id BIGINT PRIMARY KEY, order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, quantity INT NOT NULL, creation_date DATE NOT NULL);
-
-CREATE INDEX order_index ON t_order (order_id);