You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by pa...@apache.org on 2022/02/22 10:59:08 UTC
[shardingsphere] branch master updated: Use verification data source to assert metadata in DQL for sharding and rw-splitting (#15562)
This is an automated email from the ASF dual-hosted git repository.
panjuan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 6506bb8 Use verification data source to assert metadata in DQL for sharding and rw-splitting (#15562)
6506bb8 is described below
commit 6506bb816c96fafa1afdd52777717bebee277e1c
Author: Liang Zhang <zh...@apache.org>
AuthorDate: Tue Feb 22 18:57:27 2022 +0800
Use verification data source to assert metadata in DQL for sharding and rw-splitting (#15562)
* Fix typo of SQLCommandType
* try
* Add dataset verify for DQL
* Rename assertion_dataset to verification_dataset
* Add dataset verification for h2
* Add dataset verification for other databases
* Add dataset verification for other databases
* Update verification_dataset to each scenario
* Update verification_dataset to each scenario
* Update verification_dataset to each scenario
* Update verification_dataset to each scenario
* Fix sql-init
* Refactor BaseDQLIT
* Fix sql-init
* Fix sql-init
* Fix sql-init
* Fix sql-init
* Fix sql-init
* Fix sql-init
---
.../test/integration/engine/BaseITCase.java | 3 +
.../integration/engine/dql/AdditionalDQLIT.java | 163 ++++++---
.../test/integration/engine/dql/BaseDQLIT.java | 40 ++-
.../test/integration/engine/dql/GeneralDQLIT.java | 72 ++--
.../integration/env/scenario/ScenarioPath.java | 11 +
.../atomic/storage/DockerStorageContainer.java | 33 +-
.../atomic/storage/EmbeddedStorageContainer.java | 28 +-
.../container/atomic/storage/StorageContainer.java | 7 +
.../container/atomic/storage/impl/H2Container.java | 3 +
.../container/compose/ComposedContainer.java | 7 +
.../compose/mode/ClusterComposedContainer.java | 5 +
.../compose/mode/MemoryComposedContainer.java | 5 +
.../shadow/mysql/pro_insert_order_batch_value.xml | 16 +-
.../shadow/mysql/pro_insert_order_value.xml | 14 +-
.../shadow/mysql/pro_update_order_by_user_id.xml | 12 +-
.../mysql/shadow_insert_order_batch_value.xml | 16 +-
.../shadow/mysql/shadow_insert_order_value.xml | 14 +-
.../mysql/shadow_update_order_by_user_id.xml | 12 +-
.../postgresql/pro_insert_order_batch_value.xml | 16 +-
.../shadow/postgresql/pro_insert_order_value.xml | 14 +-
.../postgresql/pro_update_order_by_user_id.xml | 12 +-
.../postgresql/shadow_insert_order_batch_value.xml | 16 +-
.../postgresql/shadow_insert_order_value.xml | 14 +-
.../postgresql/shadow_update_order_by_user_id.xml | 12 +-
.../dataset/shadow/pro_delete_order_by_user_id.xml | 8 +-
.../shadow/shadow_delete_order_by_user_id.xml | 8 +-
.../cases/dml/dml-integration-test-cases.xml | 83 +++--
.../cases/dql/dql-integration-test-cases.xml | 17 +-
.../verification/init-sql/h2/verification-init.sql | 49 +++
.../init-sql/mysql/verification-init.sql | 44 +++
.../init-sql/oracle/verification-init.sql | 40 +++
.../init-sql/postgresql/verification-init.sql | 57 +++
.../init-sql/sqlserver/verification-init.sql | 40 +++
.../src/test/resources/env/it-env.properties | 4 +-
.../env/scenario/db/verification_dataset.xml | 202 +++++++++++
.../verification_dataset.xml | 391 +++++++++++++++++++++
.../init-sql/h2/init-encrypt_read_ds_1.sql | 2 +-
.../init-sql/h2/init-encrypt_write_ds_1.sql | 2 +-
.../init-sql/postgresql/init.sql | 4 +-
.../verification_dataset.xml | 310 ++++++++++++++++
.../env/scenario/encrypt/verification_dataset.xml | 64 ++++
.../readwrite_splitting/verification_dataset.xml | 165 +++++++++
.../test/resources/env/scenario/shadow/dataset.xml | 22 +-
.../env/scenario/shadow/init-sql/h2/init.sql | 4 +-
.../env/scenario/shadow/init-sql/mysql/init.sql | 4 +-
.../scenario/shadow/init-sql/postgresql/init.sql | 8 +-
.../shadow/proxy/conf/mysql/config-shadow.yaml | 2 +-
.../proxy/conf/postgresql/config-shadow.yaml | 2 +-
.../test/resources/env/scenario/shadow/rules.yaml | 2 +-
.../scenario/shadow/verification_dataset.xml} | 14 +-
.../env/scenario/tbl/verification_dataset.xml | 125 +++++++
51 files changed, 1943 insertions(+), 275 deletions(-)
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/BaseITCase.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/BaseITCase.java
index 479d86e..f3451db 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/BaseITCase.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/BaseITCase.java
@@ -59,6 +59,8 @@ public abstract class BaseITCase {
private DataSource targetDataSource;
+ private DataSource verificationDataSource;
+
public BaseITCase(final ParameterizedArray parameterizedArray) {
scenario = parameterizedArray.getScenario();
databaseType = parameterizedArray.getDatabaseType();
@@ -72,6 +74,7 @@ public abstract class BaseITCase {
composedContainer.start();
actualDataSourceMap = composedContainer.getActualDataSourceMap();
targetDataSource = composedContainer.getTargetDataSource();
+ verificationDataSource = composedContainer.getVerificationDataSource();
}
@AfterClass
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/AdditionalDQLIT.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/AdditionalDQLIT.java
index 4edaab5..895d8e3 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/AdditionalDQLIT.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/AdditionalDQLIT.java
@@ -48,134 +48,181 @@ public final class AdditionalDQLIT extends BaseDQLIT {
@Parameters(name = "{0}")
public static Collection<AssertionParameterizedArray> getParameters() {
- if (IntegrationTestEnvironment.getInstance().isRunAdditionalTestCases()) {
- return ParameterizedArrayFactory.getAssertionParameterized(SQLCommandType.DQL);
- }
- return Collections.emptyList();
+ return IntegrationTestEnvironment.getInstance().isRunAdditionalTestCases() ? ParameterizedArrayFactory.getAssertionParameterized(SQLCommandType.DQL) : Collections.emptyList();
}
@Test
public void assertExecuteQueryWithResultSetTypeAndResultSetConcurrency() throws SQLException, ParseException {
- try (Connection connection = getTargetDataSource().getConnection()) {
+ try (
+ Connection actualConnection = getTargetDataSource().getConnection();
+ Connection verificationConnection = getVerificationDataSource().getConnection()) {
if (SQLExecuteType.Literal == getSqlExecuteType()) {
- assertExecuteQueryForStatementWithResultSetTypeAndResultSetConcurrency(connection);
+ assertExecuteQueryForStatementWithResultSetTypeAndResultSetConcurrency(actualConnection, verificationConnection);
} else {
- assertExecuteQueryForPreparedStatementWithResultSetTypeAndResultSetConcurrency(connection);
+ assertExecuteQueryForPreparedStatementWithResultSetTypeAndResultSetConcurrency(actualConnection, verificationConnection);
}
}
}
- private void assertExecuteQueryForStatementWithResultSetTypeAndResultSetConcurrency(final Connection connection) throws SQLException, ParseException {
+ private void assertExecuteQueryForStatementWithResultSetTypeAndResultSetConcurrency(
+ final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
try (
- Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
- ResultSet resultSet = statement.executeQuery(String.format(getSQL(), getAssertion().getSQLValues().toArray()))) {
- assertResultSet(resultSet);
+ Statement actualStatement = actualConnection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
+ ResultSet actualResultSet = actualStatement.executeQuery(String.format(getSQL(), getAssertion().getSQLValues().toArray()));
+ Statement verificationStatement = verificationConnection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
+ ResultSet verificationResultSet = verificationStatement.executeQuery(String.format(getSQL(), getAssertion().getSQLValues().toArray()))) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
- private void assertExecuteQueryForPreparedStatementWithResultSetTypeAndResultSetConcurrency(final Connection connection) throws SQLException, ParseException {
- try (PreparedStatement preparedStatement = connection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)) {
+ private void assertExecuteQueryForPreparedStatementWithResultSetTypeAndResultSetConcurrency(
+ final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
+ try (
+ PreparedStatement actualPreparedStatement = actualConnection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
+ PreparedStatement verificationPreparedStatement = verificationConnection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)) {
for (SQLValue each : getAssertion().getSQLValues()) {
- preparedStatement.setObject(each.getIndex(), each.getValue());
+ actualPreparedStatement.setObject(each.getIndex(), each.getValue());
+ verificationPreparedStatement.setObject(each.getIndex(), each.getValue());
}
- try (ResultSet resultSet = preparedStatement.executeQuery()) {
- assertResultSet(resultSet);
+ try (
+ ResultSet actualResultSet = actualPreparedStatement.executeQuery();
+ ResultSet verificationResultSet = verificationPreparedStatement.executeQuery()) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
}
@Test
public void assertExecuteQueryWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability() throws SQLException, ParseException {
- try (Connection connection = getTargetDataSource().getConnection()) {
+ try (
+ Connection actualConnection = getTargetDataSource().getConnection();
+ Connection verificationConnection = getVerificationDataSource().getConnection()) {
if (SQLExecuteType.Literal == getSqlExecuteType()) {
- assertExecuteQueryForStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(connection);
+ assertExecuteQueryForStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(actualConnection, verificationConnection);
} else {
- assertExecuteQueryForPreparedStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(connection);
+ assertExecuteQueryForPreparedStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(actualConnection, verificationConnection);
}
}
}
- private void assertExecuteQueryForStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(final Connection connection)
- throws SQLException, ParseException {
+ private void assertExecuteQueryForStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(
+ final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
+ String sql = String.format(getSQL(), getAssertion().getSQLValues().toArray());
try (
- Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);
- ResultSet resultSet = statement.executeQuery(String.format(getSQL(), getAssertion().getSQLValues().toArray()))) {
- assertResultSet(resultSet);
+ Statement actualStatement = actualConnection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);
+ ResultSet actualResultSet = actualStatement.executeQuery(sql);
+ Statement verificationStatement = verificationConnection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);
+ ResultSet verificationResultSet = verificationStatement.executeQuery(sql)) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
- private void assertExecuteQueryForPreparedStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(final Connection connection)
- throws SQLException, ParseException {
- try (PreparedStatement preparedStatement = connection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT)) {
+ private void assertExecuteQueryForPreparedStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(
+ final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
+ try (
+ PreparedStatement actualPreparedStatement = actualConnection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);
+ PreparedStatement verificationPreparedStatement
+ = verificationConnection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT)) {
for (SQLValue each : getAssertion().getSQLValues()) {
- preparedStatement.setObject(each.getIndex(), each.getValue());
+ actualPreparedStatement.setObject(each.getIndex(), each.getValue());
+ verificationPreparedStatement.setObject(each.getIndex(), each.getValue());
}
- try (ResultSet resultSet = preparedStatement.executeQuery()) {
- assertResultSet(resultSet);
+ try (
+ ResultSet actualResultSet = actualPreparedStatement.executeQuery();
+ ResultSet verificationResultSet = verificationPreparedStatement.executeQuery()) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
}
@Test
public void assertExecuteWithResultSetTypeAndResultSetConcurrency() throws SQLException, ParseException {
- try (Connection connection = getTargetDataSource().getConnection()) {
+ try (
+ Connection actualConnection = getTargetDataSource().getConnection();
+ Connection verificationConnection = getVerificationDataSource().getConnection()) {
if (SQLExecuteType.Literal == getSqlExecuteType()) {
- assertExecuteForStatementWithResultSetTypeAndResultSetConcurrency(connection);
+ assertExecuteForStatementWithResultSetTypeAndResultSetConcurrency(actualConnection, verificationConnection);
} else {
- assertExecuteForPreparedStatementWithResultSetTypeAndResultSetConcurrency(connection);
+ assertExecuteForPreparedStatementWithResultSetTypeAndResultSetConcurrency(actualConnection, verificationConnection);
}
}
}
- private void assertExecuteForStatementWithResultSetTypeAndResultSetConcurrency(final Connection connection) throws SQLException, ParseException {
- try (Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)) {
- assertTrue("Not a query statement.", statement.execute(String.format(getSQL(), getAssertion().getSQLValues().toArray())));
- try (ResultSet resultSet = statement.getResultSet()) {
- assertResultSet(resultSet);
+ private void assertExecuteForStatementWithResultSetTypeAndResultSetConcurrency(final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
+ try (
+ Statement actualStatement = actualConnection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
+ Statement verificationStatement = verificationConnection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)) {
+ String sql = String.format(getSQL(), getAssertion().getSQLValues().toArray());
+ assertTrue("Not a query statement.", actualStatement.execute(sql) && verificationStatement.execute(sql));
+ try (
+ ResultSet actualResultSet = actualStatement.getResultSet();
+ ResultSet verificationResultSet = verificationStatement.getResultSet()) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
}
- private void assertExecuteForPreparedStatementWithResultSetTypeAndResultSetConcurrency(final Connection connection) throws SQLException, ParseException {
- try (PreparedStatement preparedStatement = connection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)) {
+ private void assertExecuteForPreparedStatementWithResultSetTypeAndResultSetConcurrency(
+ final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
+ try (
+ PreparedStatement actualPreparedStatement = actualConnection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
+ PreparedStatement verificationPreparedStatement = verificationConnection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)) {
for (SQLValue each : getAssertion().getSQLValues()) {
- preparedStatement.setObject(each.getIndex(), each.getValue());
+ actualPreparedStatement.setObject(each.getIndex(), each.getValue());
+ verificationPreparedStatement.setObject(each.getIndex(), each.getValue());
}
- assertTrue("Not a query statement.", preparedStatement.execute());
- try (ResultSet resultSet = preparedStatement.getResultSet()) {
- assertResultSet(resultSet);
+ assertTrue("Not a query statement.", actualPreparedStatement.execute() && verificationPreparedStatement.execute());
+ try (
+ ResultSet actualResultSet = actualPreparedStatement.getResultSet();
+ ResultSet verificationResultSet = verificationPreparedStatement.getResultSet()) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
}
@Test
public void assertExecuteWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability() throws SQLException, ParseException {
- try (Connection connection = getTargetDataSource().getConnection()) {
+ try (
+ Connection actualConnection = getTargetDataSource().getConnection();
+ Connection verificationConnection = getVerificationDataSource().getConnection()) {
if (SQLExecuteType.Literal == getSqlExecuteType()) {
- assertExecuteForStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(connection);
+ assertExecuteForStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(actualConnection, verificationConnection);
} else {
- assertExecuteForPreparedStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(connection);
+ assertExecuteForPreparedStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(actualConnection, verificationConnection);
}
}
}
- private void assertExecuteForStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(final Connection connection) throws SQLException, ParseException {
- try (Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT)) {
- assertTrue("Not a query statement.", statement.execute(String.format(getSQL(), getAssertion().getSQLValues().toArray())));
- try (ResultSet resultSet = statement.getResultSet()) {
- assertResultSet(resultSet);
+ private void assertExecuteForStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(
+ final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
+ try (
+ Statement actualStatement = actualConnection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);
+ Statement verificationStatement = verificationConnection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT)) {
+ String sql = String.format(getSQL(), getAssertion().getSQLValues().toArray());
+ assertTrue("Not a query statement.", actualStatement.execute(sql) && verificationStatement.execute(sql));
+ try (
+ ResultSet actualResultSet = actualStatement.getResultSet();
+ ResultSet verificationResultSet = verificationStatement.getResultSet()) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
}
- private void assertExecuteForPreparedStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(final Connection connection) throws SQLException, ParseException {
- try (PreparedStatement preparedStatement = connection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT)) {
+ private void assertExecuteForPreparedStatementWithResultSetTypeAndResultSetConcurrencyAndResultSetHoldability(
+ final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
+ try (
+ PreparedStatement actualPreparedStatement = actualConnection.prepareStatement(getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);
+ PreparedStatement verificationPreparedStatement = verificationConnection.prepareStatement(
+ getSQL(), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT)) {
for (SQLValue each : getAssertion().getSQLValues()) {
- preparedStatement.setObject(each.getIndex(), each.getValue());
+ actualPreparedStatement.setObject(each.getIndex(), each.getValue());
+ verificationPreparedStatement.setObject(each.getIndex(), each.getValue());
}
- assertTrue("Not a query statement.", preparedStatement.execute());
- try (ResultSet resultSet = preparedStatement.getResultSet()) {
- assertResultSet(resultSet);
+ assertTrue("Not a query statement.", actualPreparedStatement.execute() && verificationPreparedStatement.execute());
+ try (
+ ResultSet actualResultSet = actualPreparedStatement.getResultSet();
+ ResultSet verificationResultSet = verificationPreparedStatement.getResultSet()) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
}
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/BaseDQLIT.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/BaseDQLIT.java
index d164190..eaf395e 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/BaseDQLIT.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/BaseDQLIT.java
@@ -35,11 +35,13 @@ import java.sql.Types;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Collection;
+import java.util.Collections;
import java.util.HashSet;
import java.util.LinkedList;
import java.util.List;
import static org.hamcrest.CoreMatchers.is;
+import static org.hamcrest.CoreMatchers.startsWith;
import static org.junit.Assert.assertThat;
import static org.junit.Assert.assertTrue;
@@ -61,21 +63,49 @@ public abstract class BaseDQLIT extends SingleITCase {
synchronized (FILLED_SUITES) {
if (!FILLED_SUITES.contains(getScenario())) {
new DataSetEnvironmentManager(new ScenarioPath(getScenario()).getDataSetFile(), getActualDataSourceMap()).fillData();
+ new DataSetEnvironmentManager(
+ new ScenarioPath(getScenario()).getVerificationDataSetFile(), Collections.singletonMap("verification_dataset", getVerificationDataSource())).fillData();
FILLED_SUITES.add(getItKey());
}
}
}
}
- protected final void assertResultSet(final ResultSet resultSet) throws SQLException {
- assertMetaData(resultSet.getMetaData(), getExpectedColumns());
+ protected final void assertResultSet(final ResultSet actualResultSet, final ResultSet verificationResultSet) throws SQLException {
+ if (isAssertMetaDataByByDataSetFile()) {
+ assertMetaDataByDataSetFile(actualResultSet.getMetaData(), getExpectedColumns());
+ } else {
+ assertMetaData(actualResultSet.getMetaData(), verificationResultSet.getMetaData());
+ }
if (getDataSet().isIgnoreRowOrder()) {
- assertRowsIgnoreOrder(resultSet, getDataSet().getRows());
+ assertRowsIgnoreOrder(actualResultSet, getDataSet().getRows());
} else {
- assertRows(resultSet, getDataSet().getRows());
+ assertRows(actualResultSet, getDataSet().getRows());
}
}
+ private void assertMetaData(final ResultSetMetaData actualResultSetMetaData, final ResultSetMetaData verificationResultSetMetaData) throws SQLException {
+ assertThat(actualResultSetMetaData.getColumnCount(), is(verificationResultSetMetaData.getColumnCount()));
+ for (int i = 0; i < actualResultSetMetaData.getColumnCount(); i++) {
+ try {
+ assertThat(actualResultSetMetaData.getColumnLabel(i + 1).toLowerCase(), is(verificationResultSetMetaData.getColumnLabel(i + 1).toLowerCase()));
+ } catch (final AssertionError ex) {
+ // FIXME Expected: is "order_id", but: was "order_id0"
+ try {
+ assertThat(actualResultSetMetaData.getColumnLabel(i + 1).toLowerCase(), is(verificationResultSetMetaData.getColumnLabel(i + 1).toLowerCase() + "0"));
+ } catch (final AssertionError otherEx) {
+ // FIXME Expected: is "sum(order_id_sharding)0", but: was "expr$1"
+ assertThat(actualResultSetMetaData.getColumnLabel(i + 1).toLowerCase(), startsWith("expr$"));
+ }
+ }
+ }
+ }
+
+ // TODO should assert it with verification data source for all finally
+ private boolean isAssertMetaDataByByDataSetFile() {
+ return getScenario().equals("encrypt") || getScenario().equals("dbtbl_with_readwrite_splitting_and_encrypt") || getScenario().equals("shadow");
+ }
+
private Collection<DataSetColumn> getExpectedColumns() {
Collection<DataSetColumn> result = new LinkedList<>();
for (DataSetMetaData each : getDataSet().getMetaDataList()) {
@@ -84,7 +114,7 @@ public abstract class BaseDQLIT extends SingleITCase {
return result;
}
- private void assertMetaData(final ResultSetMetaData actual, final Collection<DataSetColumn> expected) throws SQLException {
+ private void assertMetaDataByDataSetFile(final ResultSetMetaData actual, final Collection<DataSetColumn> expected) throws SQLException {
assertThat(actual.getColumnCount(), is(expected.size()));
int index = 1;
for (DataSetColumn each : expected) {
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/GeneralDQLIT.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/GeneralDQLIT.java
index 8d1b17f..6d93442 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/GeneralDQLIT.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/dql/GeneralDQLIT.java
@@ -51,62 +51,82 @@ public final class GeneralDQLIT extends BaseDQLIT {
@Test
public void assertExecuteQuery() throws SQLException, ParseException {
- try (Connection connection = getTargetDataSource().getConnection()) {
+ try (
+ Connection actualConnection = getTargetDataSource().getConnection();
+ Connection verificationConnection = getVerificationDataSource().getConnection()) {
if (SQLExecuteType.Literal == getSqlExecuteType()) {
- assertExecuteQueryForStatement(connection);
+ assertExecuteQueryForStatement(actualConnection, verificationConnection);
} else {
- assertExecuteQueryForPreparedStatement(connection);
+ assertExecuteQueryForPreparedStatement(actualConnection, verificationConnection);
}
}
}
- private void assertExecuteQueryForStatement(final Connection connection) throws SQLException, ParseException {
+ private void assertExecuteQueryForStatement(final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
try (
- Statement statement = connection.createStatement();
- ResultSet resultSet = statement.executeQuery(getSQL())) {
- assertResultSet(resultSet);
+ Statement actualStatement = actualConnection.createStatement();
+ ResultSet actualResultSet = actualStatement.executeQuery(getSQL());
+ Statement verificationStatement = verificationConnection.createStatement();
+ ResultSet verificationResultSet = verificationStatement.executeQuery(getSQL())) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
- private void assertExecuteQueryForPreparedStatement(final Connection connection) throws SQLException, ParseException {
- try (PreparedStatement preparedStatement = connection.prepareStatement(getSQL())) {
+ private void assertExecuteQueryForPreparedStatement(final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
+ try (
+ PreparedStatement actualPreparedStatement = actualConnection.prepareStatement(getSQL());
+ PreparedStatement verificationPreparedStatement = verificationConnection.prepareStatement(getSQL())) {
for (SQLValue each : getAssertion().getSQLValues()) {
- preparedStatement.setObject(each.getIndex(), each.getValue());
+ actualPreparedStatement.setObject(each.getIndex(), each.getValue());
+ verificationPreparedStatement.setObject(each.getIndex(), each.getValue());
}
- try (ResultSet resultSet = preparedStatement.executeQuery()) {
- assertResultSet(resultSet);
+ try (
+ ResultSet actualResultSet = actualPreparedStatement.executeQuery();
+ ResultSet verificationResultSet = verificationPreparedStatement.executeQuery()) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
}
@Test
public void assertExecute() throws SQLException, ParseException {
- try (Connection connection = getTargetDataSource().getConnection()) {
+ try (
+ Connection actualConnection = getTargetDataSource().getConnection();
+ Connection verificationConnection = getVerificationDataSource().getConnection()) {
if (SQLExecuteType.Literal == getSqlExecuteType()) {
- assertExecuteForStatement(connection);
+ assertExecuteForStatement(actualConnection, verificationConnection);
} else {
- assertExecuteForPreparedStatement(connection);
+ assertExecuteForPreparedStatement(actualConnection, verificationConnection);
}
}
}
- private void assertExecuteForStatement(final Connection connection) throws SQLException, ParseException {
- try (Statement statement = connection.createStatement()) {
- assertTrue("Not a query statement.", statement.execute(getSQL()));
- try (ResultSet resultSet = statement.getResultSet()) {
- assertResultSet(resultSet);
+ private void assertExecuteForStatement(final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
+ try (
+ Statement actualStatement = actualConnection.createStatement();
+ Statement verificationStatement = verificationConnection.createStatement()) {
+ assertTrue("Not a query statement.", actualStatement.execute(getSQL()) && verificationStatement.execute(getSQL()));
+ try (
+ ResultSet actualResultSet = actualStatement.getResultSet();
+ ResultSet verificationResultSet = verificationStatement.getResultSet()) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
}
- private void assertExecuteForPreparedStatement(final Connection connection) throws SQLException, ParseException {
- try (PreparedStatement preparedStatement = connection.prepareStatement(getSQL())) {
+ private void assertExecuteForPreparedStatement(final Connection actualConnection, final Connection verificationConnection) throws SQLException, ParseException {
+ try (
+ PreparedStatement actualPreparedStatement = actualConnection.prepareStatement(getSQL());
+ PreparedStatement verificationPreparedStatement = verificationConnection.prepareStatement(getSQL())) {
for (SQLValue each : getAssertion().getSQLValues()) {
- preparedStatement.setObject(each.getIndex(), each.getValue());
+ actualPreparedStatement.setObject(each.getIndex(), each.getValue());
+ verificationPreparedStatement.setObject(each.getIndex(), each.getValue());
}
- assertTrue("Not a query statement.", preparedStatement.execute());
- try (ResultSet resultSet = preparedStatement.getResultSet()) {
- assertResultSet(resultSet);
+ assertTrue("Not a query statement.", actualPreparedStatement.execute() && verificationPreparedStatement.execute());
+ try (
+ ResultSet actualResultSet = actualPreparedStatement.getResultSet();
+ ResultSet verificationResultSet = verificationPreparedStatement.getResultSet()) {
+ assertResultSet(actualResultSet, verificationResultSet);
}
}
}
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/env/scenario/ScenarioPath.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/env/scenario/ScenarioPath.java
index 9908336..37d9c8e 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/env/scenario/ScenarioPath.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/env/scenario/ScenarioPath.java
@@ -42,6 +42,8 @@ public final class ScenarioPath {
private static final String DATASET_FILE = "dataset.xml";
+ private static final String VERIFICATION_DATASET_FILE = "verification_dataset.xml";
+
private static final String RULE_CONFIG_FILE = "rules.yaml";
private static final String AUTHORITY_FILE = "authority.xml";
@@ -117,6 +119,15 @@ public final class ScenarioPath {
}
/**
+ * Get verification data set file.
+ *
+ * @return verification data set file
+ */
+ public String getVerificationDataSetFile() {
+ return getFile(VERIFICATION_DATASET_FILE);
+ }
+
+ /**
* Get rule configuration file.
*
* @return rule configuration file
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/DockerStorageContainer.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/DockerStorageContainer.java
index fb576c8..3572746 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/DockerStorageContainer.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/DockerStorageContainer.java
@@ -26,7 +26,7 @@ import org.apache.shardingsphere.test.integration.env.DataSourceEnvironment;
import org.apache.shardingsphere.test.integration.env.scenario.ScenarioPath;
import org.apache.shardingsphere.test.integration.env.scenario.database.DatabaseEnvironmentManager;
import org.apache.shardingsphere.test.integration.framework.container.atomic.DockerITContainer;
-import org.testcontainers.containers.BindMode;
+import org.testcontainers.utility.MountableFile;
import javax.sql.DataSource;
import javax.xml.bind.JAXBException;
@@ -47,6 +47,8 @@ public abstract class DockerStorageContainer extends DockerITContainer implement
private Map<String, DataSource> actualDataSourceMap;
+ private DataSource verificationDataSource;
+
public DockerStorageContainer(final DatabaseType databaseType, final String dockerImageName, final String scenario) {
super(databaseType.getName().toLowerCase(), dockerImageName);
this.databaseType = databaseType;
@@ -55,18 +57,39 @@ public abstract class DockerStorageContainer extends DockerITContainer implement
@Override
protected void configure() {
- withClasspathResourceMapping(new ScenarioPath(scenario).getInitSQLResourcePath(databaseType), "/docker-entrypoint-initdb.d/", BindMode.READ_ONLY);
+ withCopyFileToContainer(MountableFile.forClasspathResource(new ScenarioPath(scenario).getInitSQLResourcePath(databaseType)), "/docker-entrypoint-initdb.d/");
+ withCopyFileToContainer(MountableFile.forClasspathResource("/env/common/verification/init-sql/" + databaseType.getName().toLowerCase()), "/docker-entrypoint-initdb.d/");
}
@Override
@SneakyThrows({IOException.class, JAXBException.class})
- public synchronized Map<String, DataSource> getActualDataSourceMap() {
- if (null == actualDataSourceMap) {
+ public final Map<String, DataSource> getActualDataSourceMap() {
+ if (null != actualDataSourceMap) {
+ return actualDataSourceMap;
+ }
+ synchronized (this) {
+ if (null != actualDataSourceMap) {
+ return actualDataSourceMap;
+ }
Collection<String> dataSourceNames = DatabaseEnvironmentManager.getDatabaseNames(scenario);
actualDataSourceMap = new LinkedHashMap<>(dataSourceNames.size(), 1);
dataSourceNames.forEach(each -> actualDataSourceMap.put(each, createDataSource(each)));
+ return actualDataSourceMap;
+ }
+ }
+
+ @Override
+ public final DataSource getVerificationDataSource() {
+ if (null != verificationDataSource) {
+ return verificationDataSource;
+ }
+ synchronized (this) {
+ if (null != verificationDataSource) {
+ return verificationDataSource;
+ }
+ verificationDataSource = createDataSource("verification_dataset");
+ return verificationDataSource;
}
- return actualDataSourceMap;
}
private DataSource createDataSource(final String dataSourceName) {
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/EmbeddedStorageContainer.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/EmbeddedStorageContainer.java
index 896f240..26f2fe7 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/EmbeddedStorageContainer.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/EmbeddedStorageContainer.java
@@ -47,15 +47,37 @@ public abstract class EmbeddedStorageContainer implements EmbeddedITContainer, S
private Map<String, DataSource> actualDataSourceMap;
+ private DataSource verificationDataSource;
+
@Override
@SneakyThrows({IOException.class, JAXBException.class})
- public synchronized Map<String, DataSource> getActualDataSourceMap() {
- if (null == actualDataSourceMap) {
+ public Map<String, DataSource> getActualDataSourceMap() {
+ if (null != actualDataSourceMap) {
+ return actualDataSourceMap;
+ }
+ synchronized (this) {
+ if (null != actualDataSourceMap) {
+ return actualDataSourceMap;
+ }
Collection<String> dataSourceNames = DatabaseEnvironmentManager.getDatabaseNames(scenario);
actualDataSourceMap = new LinkedHashMap<>(dataSourceNames.size(), 1);
dataSourceNames.forEach(each -> actualDataSourceMap.put(each, createDataSource(each)));
+ return actualDataSourceMap;
+ }
+ }
+
+ @Override
+ public final DataSource getVerificationDataSource() {
+ if (null != verificationDataSource) {
+ return verificationDataSource;
+ }
+ synchronized (this) {
+ if (null != verificationDataSource) {
+ return verificationDataSource;
+ }
+ verificationDataSource = createDataSource("verification_dataset");
+ return verificationDataSource;
}
- return actualDataSourceMap;
}
private DataSource createDataSource(final String dataSourceName) {
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/StorageContainer.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/StorageContainer.java
index 42c6d21..de0b863 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/StorageContainer.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/StorageContainer.java
@@ -33,4 +33,11 @@ public interface StorageContainer extends ITContainer {
* @return actual data source map
*/
Map<String, DataSource> getActualDataSourceMap();
+
+ /**
+ * Get verification data source.
+ *
+ * @return verification data source
+ */
+ DataSource getVerificationDataSource();
}
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/impl/H2Container.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/impl/H2Container.java
index 20086d4..4c0d289 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/impl/H2Container.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/atomic/storage/impl/H2Container.java
@@ -29,6 +29,7 @@ import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Map.Entry;
+import java.util.Objects;
/**
* H2 container.
@@ -50,6 +51,8 @@ public final class H2Container extends EmbeddedStorageContainer {
executeInitSQL(entry.getValue(), each);
}
}
+ executeInitSQL(getVerificationDataSource(), Objects.requireNonNull(
+ H2Container.class.getClassLoader().getResource("env/common/verification/init-sql/" + getDatabaseType().getName().toLowerCase() + "/verification-init.sql")).getFile());
}
private void executeInitSQL(final DataSource dataSource, final String initSQLFile) throws SQLException, IOException {
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/ComposedContainer.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/ComposedContainer.java
index 60d1b4d..0e8ff19 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/ComposedContainer.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/ComposedContainer.java
@@ -40,4 +40,11 @@ public interface ComposedContainer extends Startable {
* @return target data source
*/
DataSource getTargetDataSource();
+
+ /**
+ * Get verification data source.
+ *
+ * @return verification data source
+ */
+ DataSource getVerificationDataSource();
}
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/mode/ClusterComposedContainer.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/mode/ClusterComposedContainer.java
index d1fb02c..bca463a 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/mode/ClusterComposedContainer.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/mode/ClusterComposedContainer.java
@@ -73,6 +73,11 @@ public final class ClusterComposedContainer implements ComposedContainer {
}
@Override
+ public DataSource getVerificationDataSource() {
+ return storageContainer.getVerificationDataSource();
+ }
+
+ @Override
public void stop() {
containers.stop();
}
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/mode/MemoryComposedContainer.java b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/mode/MemoryComposedContainer.java
index 7954bc4..48b3d33 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/mode/MemoryComposedContainer.java
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/framework/container/compose/mode/MemoryComposedContainer.java
@@ -67,6 +67,11 @@ public final class MemoryComposedContainer implements ComposedContainer {
}
@Override
+ public DataSource getVerificationDataSource() {
+ return storageContainer.getVerificationDataSource();
+ }
+
+ @Override
public void stop() {
containers.stop();
}
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_insert_order_batch_value.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_insert_order_batch_value.xml
index a672be2..d9965e9 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_insert_order_batch_value.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_insert_order_batch_value.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="2">
- <metadata data-nodes="db.t_order">
+ <metadata data-nodes="db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,11 +29,11 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="db.t_order" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="7, 1, pro_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
- <row data-node="db.t_order" values="8, 1, pro_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="db.t_shadow" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="7, 1, pro_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="db.t_shadow" values="8, 1, pro_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_insert_order_value.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_insert_order_value.xml
index 8617cf8..43e7994 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_insert_order_value.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_insert_order_value.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="1">
- <metadata data-nodes="db.t_order">
+ <metadata data-nodes="db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,10 +29,10 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="db.t_order" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="6, 1, pro_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="db.t_shadow" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="6, 1, pro_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_update_order_by_user_id.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_update_order_by_user_id.xml
index 44dd575..a87ad4d 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_update_order_by_user_id.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_update_order_by_user_id.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="2">
- <metadata data-nodes="db.t_order">
+ <metadata data-nodes="db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,9 +29,9 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="db.t_order" values="1, 1, pro_order_update, F, false, 60, spring, 120.00, 2021-01-02, 13:30:30, 2021-01-02 13:30:30.0" />
- <row data-node="db.t_order" values="2, 1, pro_order_update, F, false, 60, spring, 120.00, 2021-01-02, 13:30:30, 2021-01-02 13:30:30.0" />
- <row data-node="db.t_order" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="1, 1, pro_order_update, F, false, 60, spring, 120.00, 2021-01-02, 13:30:30, 2021-01-02 13:30:30.0" />
+ <row data-node="db.t_shadow" values="2, 1, pro_order_update, F, false, 60, spring, 120.00, 2021-01-02, 13:30:30, 2021-01-02 13:30:30.0" />
+ <row data-node="db.t_shadow" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_insert_order_batch_value.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_insert_order_batch_value.xml
index 9fa27e7..275bee8 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_insert_order_batch_value.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_insert_order_batch_value.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="2">
- <metadata data-nodes="shadow_db.t_order">
+ <metadata data-nodes="shadow_db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,11 +29,11 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="shadow_db.t_order" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="7, 0, shadow_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
- <row data-node="shadow_db.t_order" values="8, 0, shadow_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="7, 0, shadow_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="8, 0, shadow_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_insert_order_value.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_insert_order_value.xml
index 248c76c..c6fc96c 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_insert_order_value.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_insert_order_value.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="1">
- <metadata data-nodes="shadow_db.t_order">
+ <metadata data-nodes="shadow_db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,10 +29,10 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="shadow_db.t_order" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="6, 0, shadow_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="6, 0, shadow_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_update_order_by_user_id.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_update_order_by_user_id.xml
index c00f288..19c9c35 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_update_order_by_user_id.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/shadow_update_order_by_user_id.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="2">
- <metadata data-nodes="shadow_db.t_order">
+ <metadata data-nodes="shadow_db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,9 +29,9 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="shadow_db.t_order" values="1, 0, shadow_order_update, F, false, 60, spring, 120.00, 2021-01-02, 13:30:30, 2021-01-02 13:30:30.0" />
- <row data-node="shadow_db.t_order" values="2, 0, shadow_order_update, F, false, 60, spring, 120.00, 2021-01-02, 13:30:30, 2021-01-02 13:30:30.0" />
- <row data-node="shadow_db.t_order" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="1, 0, shadow_order_update, F, false, 60, spring, 120.00, 2021-01-02, 13:30:30, 2021-01-02 13:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="2, 0, shadow_order_update, F, false, 60, spring, 120.00, 2021-01-02, 13:30:30, 2021-01-02 13:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_insert_order_batch_value.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_insert_order_batch_value.xml
index a672be2..d9965e9 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_insert_order_batch_value.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_insert_order_batch_value.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="2">
- <metadata data-nodes="db.t_order">
+ <metadata data-nodes="db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,11 +29,11 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="db.t_order" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="7, 1, pro_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
- <row data-node="db.t_order" values="8, 1, pro_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="db.t_shadow" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="7, 1, pro_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="db.t_shadow" values="8, 1, pro_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_insert_order_value.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_insert_order_value.xml
index 4a315c5..022ba5d 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_insert_order_value.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_insert_order_value.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="1">
- <metadata data-nodes="db.t_order">
+ <metadata data-nodes="db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,10 +29,10 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="db.t_order" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0 " />
- <row data-node="db.t_order" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="6, 1, pro_order, S, true, 50, summer, 120.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="db.t_shadow" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0 " />
+ <row data-node="db.t_shadow" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="6, 1, pro_order, S, true, 50, summer, 120.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_update_order_by_user_id.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_update_order_by_user_id.xml
index 9be10b1..14298c3 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_update_order_by_user_id.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/pro_update_order_by_user_id.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="2">
- <metadata data-nodes="db.t_order">
+ <metadata data-nodes="db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,9 +29,9 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="db.t_order" values="1, 1, pro_order_update, F, false, 60, spring, 120.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="2, 1, pro_order_update, F, false, 60, spring, 120.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="1, 1, pro_order_update, F, false, 60, spring, 120.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="2, 1, pro_order_update, F, false, 60, spring, 120.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_insert_order_batch_value.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_insert_order_batch_value.xml
index 9fa27e7..275bee8 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_insert_order_batch_value.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_insert_order_batch_value.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="2">
- <metadata data-nodes="shadow_db.t_order">
+ <metadata data-nodes="shadow_db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,11 +29,11 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="shadow_db.t_order" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="7, 0, shadow_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
- <row data-node="shadow_db.t_order" values="8, 0, shadow_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="7, 0, shadow_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="8, 0, shadow_order, S, true, 50, summer, 100.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_insert_order_value.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_insert_order_value.xml
index 80985e1..313e84f 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_insert_order_value.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_insert_order_value.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="1">
- <metadata data-nodes="shadow_db.t_order">
+ <metadata data-nodes="shadow_db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,10 +29,10 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="shadow_db.t_order" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="6, 0, shadow_order, S, true, 50, summer, 120.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="6, 0, shadow_order, S, true, 50, summer, 120.00, 2021-01-01, 12:30:30, 2021-01-01 12:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_update_order_by_user_id.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_update_order_by_user_id.xml
index b5d4e320..a20eb9b 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_update_order_by_user_id.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/postgresql/shadow_update_order_by_user_id.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="2">
- <metadata data-nodes="shadow_db.t_order">
+ <metadata data-nodes="shadow_db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,9 +29,9 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="shadow_db.t_order" values="1, 0, shadow_order_update, F, false, 60, spring, 120.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="2, 0, shadow_order_update, F, false, 60, spring, 120.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="1, 0, shadow_order_update, F, false, 60, spring, 120.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="2, 0, shadow_order_update, F, false, 60, spring, 120.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/pro_delete_order_by_user_id.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/pro_delete_order_by_user_id.xml
index 53fb161..0adff7e 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/pro_delete_order_by_user_id.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/pro_delete_order_by_user_id.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="2" >
- <metadata data-nodes="db.t_order">
+ <metadata data-nodes="db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,7 +29,7 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="db.t_order" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/shadow_delete_order_by_user_id.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/shadow_delete_order_by_user_id.xml
index 2e729b4..f2fcfe5 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/shadow_delete_order_by_user_id.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/shadow_delete_order_by_user_id.xml
@@ -16,7 +16,7 @@
-->
<dataset update-count="2">
- <metadata data-nodes="shadow_db.t_order">
+ <metadata data-nodes="shadow_db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,7 +29,7 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="shadow_db.t_order" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
index 1bb70b0..256f27f 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
@@ -81,7 +81,7 @@
<test-case sql="INSERT INTO t_order_item(order_id, user_id, status, creation_date) values (?, ?, 'insert', '2017-08-08')" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion parameters="1:int, 1:int" expected-data-file="insert_without_generate_key_column.xml" />
</test-case>
-
+
<test-case sql="INSERT INTO t_order_item SET order_id = ?, user_id = ?, status = 'insert', creation_date='2017-08-08'" db-types="MySQL,SQLServer,Oracle" scenario-types="db,tbl,dbtbl_with_readwrite_splitting">
<assertion parameters="1:int, 1:int" expected-data-file="insert_without_generate_key_column.xml" />
</test-case>
@@ -89,11 +89,11 @@
<test-case sql="INSERT INTO t_order (order_id, user_id, status) VALUES (?, ?, ?), (?, ?, ?)" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,sharding_governance">
<assertion parameters="1:int, 1:int, insert:String, 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 (?, 1, 'insert'), (?, ?, ?)" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,sharding_governance">
<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,sharding_governance">-->
<!--<assertion parameters="1:int, 1:int, insert:String, 2:int, 2:int, insert:String" expected-data-file="pro_insert_order_value.xml" />-->
<!--</test-case>-->
@@ -111,16 +111,16 @@
<test-case sql="INSERT INTO t_broadcast_table(id, status) values (?, 'insert'),(?, 'insert')" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion parameters="2:int, 3:int" expected-data-file="batch_insert_into_broadcast_table.xml" />
</test-case>
-
+
<!--fixme! issue #9769-->
<!-- <test-case sql="INSERT INTO t_single_table(single_id, id, status) values (?, ?, 'insert'),(?, ?, 'insert')" db-types="MySQL,SQLServer,PostgreSQL,Oracle" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt">-->
<!-- <assertion parameters="5:int, 5000:int, 6:int, 6000:int" expected-data-file="batch_insert_into_single_table.xml" />-->
<!-- </test-case>-->
-
+
<test-case sql="INSERT INTO t_user(user_id, address_id, pwd, status) values (?, ?, 'a100', 'init'),(?, ?, 'b101', 'init')" scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion parameters="100:int, 100000:int, 101:int, 101000:int" expected-data-file="batch_insert_into_user_table.xml" />
</test-case>
-
+
<test-case sql="INSERT INTO t_user(user_id, address_id, pwd, status) values (100, 100000, 'a100', 'init'),(101, 101000, 'b101', 'init')" scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion expected-data-file="batch_insert_into_user_table.xml" />
</test-case>
@@ -157,17 +157,17 @@
<test-case sql="UPDATE t_broadcast_table b SET b.status = 'finished'" db-types="H2,MySQL,SQLServer,Oracle" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion expected-data-file="update_broadcast_table.xml" />
</test-case>
-
+
<!--fixme! issue #9769-->
<!-- <test-case sql="UPDATE t_single_table s SET s.status = 'finished'" db-types="MySQL,SQLServer,PostgreSQL,Oracle" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt">-->
<!-- <assertion expected-data-file="update_single_table.xml" />-->
<!-- </test-case>-->
-
+
<!--fixme support encrypt scenario of PostgreSQL-->
<test-case sql="UPDATE t_user u SET u.pwd = 'abc' WHERE user_id = 10" db-types="H2,MySQL,SQLServer,Oracle" scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion expected-data-file="update_user_table.xml" />
</test-case>
-
+
<!--fixme support encrypt scenario of PostgreSQL-->
<test-case sql="UPDATE t_user u SET u.status = 'update' WHERE u.pwd = 'a10'" db-types="H2,MySQL,SQLServer,Oracle" scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion expected-data-file="update_user_table_by_pwd.xml" />
@@ -180,17 +180,17 @@
<test-case sql="DELETE FROM t_order WHERE status= ?" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,sharding_governance">
<assertion parameters="init:String" expected-data-file="delete_without_sharding_value.xml" />
</test-case>
-
+
<!--fixme support encrypt scenario of PostgreSQL-->
<test-case sql="DELETE FROM t_user WHERE user_id = 10" db-types="H2,MySQL,SQLServer,Oracle" scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion expected-data-file="delete_user_table.xml" />
</test-case>
-
+
<!--fixme support encrypt scenario of PostgreSQL-->
<test-case sql="DELETE FROM t_user WHERE pwd = 'a10'" db-types="H2,MySQL,SQLServer,Oracle" scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion expected-data-file="delete_user_table.xml" />
</test-case>
-
+
<!--fixme! issue #9769-->
<!-- <test-case sql="DELETE FROM t_single_table WHERE single_id = 1" db-types="MySQL,SQLServer,PostgreSQL,Oracle" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt">-->
<!-- <assertion expected-data-file="delete_single_table_by_id.xml" />-->
@@ -203,87 +203,86 @@
<test-case sql="DELETE /*+ index(status) */ ONLY (t_order) WHERE status=1 RETURNING *" db-types="Oracle" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,sharding_governance">
<assertion expected-data-file="delete_with_special_comments_returning_without_sharding_value.xml" />
</test-case>
-
+
<!-- Can't support delete multiple tables-->
<!--<test-case sql="DELETE o FROM t_order AS o WHERE status=?" db-types="MySQL,SQLServer,PostgreSQL,Oracle" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,sharding_governance">-->
<!--<assertion parameters="init:String" expected-data-file="delete_with_alias.xml" />-->
<!--</test-case>-->
-
- <test-case sql="INSERT INTO t_order (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time, type_timestamp)
+
+ <test-case sql="INSERT INTO t_shadow (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time, type_timestamp)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);" db-types="MySQL" scenario-types="shadow">
<assertion parameters="6:long, 1:int, pro_order:String, S:char, true:boolean, 50:smallint, summer:enum#season, 100.00:decimal, 2021-01-01:Date, 12:30:30:time, 2021-01-01 12:30:30:timestamp"
expected-data-file="pro_insert_order_value.xml" />
</test-case>
-
- <test-case sql="INSERT INTO t_order (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time, type_timestamp)
+
+ <test-case sql="INSERT INTO t_shadow (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time, type_timestamp)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);" db-types="MySQL" scenario-types="shadow">
<assertion parameters="6:long, 0:int, shadow_order:String, S:char, true:boolean, 50:smallint, summer:enum#season, 100.00:decimal, 2021-01-01:Date, 12:30:30:time, 2021-01-01 12:30:30:timestamp"
expected-data-file="shadow_insert_order_value.xml" />
</test-case>
-
- <test-case sql="INSERT INTO t_order (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time, type_timestamp)
+
+ <test-case sql="INSERT INTO t_shadow (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time, type_timestamp)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);" db-types="MySQL" scenario-types="shadow">
<assertion parameters="7:long, 1:int, pro_order:String, S:char, true:boolean, 50:smallint, summer:enum#season, 100.00:decimal, 2021-01-01:Date, 12:30:30:time, 2021-01-01 12:30:30:timestamp, 8:long, 1:int, pro_order:String, S:char, true:boolean, 50:smallint, summer:enum#season, 100.00:decimal, 2021-01-01:Date, 12:30:30:time, 2021-01-01 12:30:30:timestamp"
expected-data-file="pro_insert_order_batch_value.xml" />
</test-case>
-
- <test-case sql="INSERT INTO t_order (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time, type_timestamp)
+
+ <test-case sql="INSERT INTO t_shadow (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time, type_timestamp)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);" db-types="MySQL" scenario-types="shadow">
<assertion parameters="7:long, 0:int, shadow_order:String, S:char, true:boolean, 50:smallint, summer:enum#season, 100.00:decimal, 2021-01-01:Date, 12:30:30:time, 2021-01-01 12:30:30:timestamp, 8:long, 0:int, shadow_order:String, S:char, true:boolean, 50:smallint, summer:enum#season, 100.00:decimal, 2021-01-01:Date, 12:30:30:time, 2021-01-01 12:30:30:timestamp"
expected-data-file="shadow_insert_order_batch_value.xml" />
</test-case>
-
- <test-case sql="UPDATE t_order SET order_name = ?, type_char = ?, type_boolean = ?, type_smallint = ?, type_enum = ?, type_decimal = ?, type_date = ?, type_time = ?, type_timestamp = ?
+
+ <test-case sql="UPDATE t_shadow SET order_name = ?, type_char = ?, type_boolean = ?, type_smallint = ?, type_enum = ?, type_decimal = ?, type_date = ?, type_time = ?, type_timestamp = ?
WHERE user_id = ? and order_id in (?, ?)" db-types="MySQL" scenario-types="shadow">
<assertion parameters="pro_order_update:String, F:char, false:boolean, 60:smallint, spring:enum#season, 120.00:decimal, 2021-01-02:Date, 13:30:30:time, 2021-01-02 13:30:30:timestamp, 1:int, 1:long, 2:long"
expected-data-file="pro_update_order_by_user_id.xml" />
</test-case>
-
- <test-case sql="UPDATE t_order SET order_name = ?, type_char = ?, type_boolean = ?, type_smallint = ?, type_enum = ?, type_decimal = ?, type_date = ?, type_time = ?, type_timestamp = ?
+
+ <test-case sql="UPDATE t_shadow SET order_name = ?, type_char = ?, type_boolean = ?, type_smallint = ?, type_enum = ?, type_decimal = ?, type_date = ?, type_time = ?, type_timestamp = ?
WHERE user_id = ? and order_id in (?, ?)" db-types="MySQL" scenario-types="shadow">
<assertion parameters="shadow_order_update:String, F:char, false:boolean, 60:smallint, spring:enum#season, 120.00:decimal, 2021-01-02:Date, 13:30:30:time, 2021-01-02 13:30:30:timestamp, 0:int, 1:long, 2:long"
expected-data-file="shadow_update_order_by_user_id.xml" />
</test-case>
-
- <test-case sql="DELETE FROM t_order WHERE user_id = ? and order_id in (?, ?)" db-types="MySQL" scenario-types="shadow">
+
+ <test-case sql="DELETE FROM t_shadow WHERE user_id = ? and order_id in (?, ?)" db-types="MySQL" scenario-types="shadow">
<assertion parameters="1:int, 4:long, 5:long" expected-data-file="pro_delete_order_by_user_id.xml" />
</test-case>
-
- <test-case sql="DELETE FROM t_order WHERE user_id = ? and order_id in (?, ?)" db-types="MySQL" scenario-types="shadow">
+
+ <test-case sql="DELETE FROM t_shadow WHERE user_id = ? and order_id in (?, ?)" db-types="MySQL" scenario-types="shadow">
<assertion parameters="0:int, 4:long, 5:long" expected-data-file="shadow_delete_order_by_user_id.xml" />
</test-case>
-
+
<!-- FIXME Support enum types for PostgreSQL -->
- <test-case sql="INSERT INTO t_order (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_decimal, type_date, type_time, type_timestamp)
+ <test-case sql="INSERT INTO t_shadow (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_decimal, type_date, type_time, type_timestamp)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);" db-types="PostgreSQL" scenario-types="shadow">
<assertion parameters="6:long, 1:int, pro_order:String, S:char, true:boolean, 50:smallint, 120.00:decimal, 2021-01-01:Date, 12:30:30:time, 2021-01-01 12:30:30:timestamp"
expected-data-file="pro_insert_order_value.xml" />
</test-case>
-
- <test-case sql="INSERT INTO t_order (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_decimal, type_date, type_time, type_timestamp)
+
+ <test-case sql="INSERT INTO t_shadow (order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_decimal, type_date, type_time, type_timestamp)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);" db-types="PostgreSQL" scenario-types="shadow">
<assertion parameters="6:long, 0:int, shadow_order:String, S:char, true:boolean, 50:smallint, 120.00:decimal, 2021-01-01:Date, 12:30:30:time, 2021-01-01 12:30:30:timestamp"
expected-data-file="shadow_insert_order_value.xml" />
</test-case>
-
- <test-case sql="UPDATE t_order SET order_name = ?, type_char = ?, type_boolean = ?, type_smallint = ?, type_decimal = ?, type_enum = ?::season
+
+ <test-case sql="UPDATE t_shadow SET order_name = ?, type_char = ?, type_boolean = ?, type_smallint = ?, type_decimal = ?, type_enum = ?::season
WHERE user_id = ? and order_id in (?, ?)" db-types="PostgreSQL" scenario-types="shadow">
<assertion parameters="pro_order_update:String, F:char, false:boolean, 60:smallint, 120.00:decimal, spring:enum#season, 1:int, 1:long, 2:long"
expected-data-file="pro_update_order_by_user_id.xml" />
</test-case>
-
- <test-case sql="UPDATE t_order SET order_name = ?, type_char = ?, type_boolean = ?, type_smallint = ?, type_decimal = ?, type_enum = ?::season
+
+ <test-case sql="UPDATE t_shadow SET order_name = ?, type_char = ?, type_boolean = ?, type_smallint = ?, type_decimal = ?, type_enum = ?::season
WHERE user_id = ? and order_id in (?, ?)" db-types="PostgreSQL" scenario-types="shadow">
<assertion parameters="shadow_order_update:String, F:char, false:boolean, 60:smallint, 120.00:decimal, spring:enum#season, 0:int, 1:long, 2:long"
expected-data-file="shadow_update_order_by_user_id.xml" />
</test-case>
-
- <test-case sql="DELETE FROM t_order WHERE user_id = ? and order_id in (?, ?)" db-types="PostgreSQL" scenario-types="shadow">
+
+ <test-case sql="DELETE FROM t_shadow WHERE user_id = ? and order_id in (?, ?)" db-types="PostgreSQL" scenario-types="shadow">
<assertion parameters="1:int, 4:long, 5:long" expected-data-file="pro_delete_order_by_user_id.xml" />
</test-case>
-
- <test-case sql="DELETE FROM t_order WHERE user_id = ? and order_id in (?, ?)" db-types="PostgreSQL" scenario-types="shadow">
+
+ <test-case sql="DELETE FROM t_shadow WHERE user_id = ? and order_id in (?, ?)" db-types="PostgreSQL" scenario-types="shadow">
<assertion parameters="0:int, 4:long, 5:long" expected-data-file="shadow_delete_order_by_user_id.xml" />
</test-case>
-
</integration-test-cases>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
index f5d0b3c..a8121ec 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
@@ -454,9 +454,10 @@
<assertion expected-data-file="select_distinct_function.xml" />
</test-case>
- <test-case sql="SELECT COUNT(DISTINCT order_id), SUM(DISTINCT order_id) FROM t_order WHERE order_id < 1100" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
- <assertion expected-data-file="select_distinct_with_count_sum.xml" />
- </test-case>
+ <!-- FIXME Expected: is "count(distinct order_id)", but: was "aggregation_distinct_derived_0"-->
+<!-- <test-case sql="SELECT COUNT(DISTINCT order_id), SUM(DISTINCT order_id) FROM t_order WHERE order_id < 1100" db-types="MySQL" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">-->
+<!-- <assertion expected-data-file="select_distinct_with_count_sum.xml" />-->
+<!-- </test-case>-->
<test-case sql="SELECT COUNT(DISTINCT user_id + order_id) c FROM t_order WHERE order_id < 1100" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion expected-data-file="select_distinct_with_count_calculation.xml" />
@@ -529,7 +530,7 @@
<!-- <test-case sql="SELECT * FROM t_single_table s INNER JOIN t_user o ON s.id = o.user_id" db-types="MySQL,Oracle,SQLServer" scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">-->
<!-- <assertion expected-data-file="select_from_single_join_order.xml"/>-->
<!-- </test-case>-->
-
+
<test-case sql="SELECT o.*, i.* FROM t_order_federate o, t_order_item_federate i WHERE o.order_id = ? AND i.item_id = ?" scenario-types="db,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion parameters="1000:int, 100000:int" expected-data-file="select_across_single_tables_with_federate.xml" />
</test-case>
@@ -627,11 +628,9 @@
</test-case>
<!-- TODO complete test type -->
- <test-case
- sql="SELECT order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time, type_timestamp FROM t_order WHERE user_id = ?"
- db-types="MySQL,PostgreSQL" scenario-types="shadow">
- <assertion parameters="1:int" expected-data-file="pro_select_order_by_user_id.xml"/>
- <assertion parameters="0:int" expected-data-file="shadow_select_order_by_user_id.xml"/>
+ <test-case sql="SELECT order_id, user_id, order_name, type_char, type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time, type_timestamp FROM t_shadow WHERE user_id = ?" db-types="MySQL,PostgreSQL" scenario-types="shadow">
+ <assertion parameters="1:int" expected-data-file="pro_select_order_by_user_id.xml" />
+ <assertion parameters="0:int" expected-data-file="shadow_select_order_by_user_id.xml" />
</test-case>
</integration-test-cases>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/h2/verification-init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/h2/verification-init.sql
new file mode 100644
index 0000000..1429587
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/h2/verification-init.sql
@@ -0,0 +1,49 @@
+--
+-- 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_single_table;
+DROP TABLE IF EXISTS t_broadcast_table;
+DROP TABLE IF EXISTS t_order_federate;
+DROP TABLE IF EXISTS t_order_item_federate;
+DROP TABLE IF EXISTS t_order_federate_sharding;
+DROP TABLE IF EXISTS t_order_item_federate_sharding;
+DROP TABLE IF EXISTS t_user;
+DROP TABLE IF EXISTS t_user_item;
+DROP TABLE IF EXISTS t_user_encrypt_federate;
+DROP TABLE IF EXISTS t_user_encrypt_federate_sharding;
+DROP TABLE IF EXISTS t_user_info;
+DROP TABLE IF EXISTS t_shadow;
+
+CREATE TABLE t_order (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
+CREATE TABLE t_order_item (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
+CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
+CREATE TABLE t_order_federate (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
+CREATE TABLE t_order_item_federate (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (item_id));
+CREATE TABLE t_order_federate_sharding (order_id_sharding INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id_sharding));
+CREATE TABLE t_order_item_federate_sharding (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, remarks VARCHAR(45) NULL, PRIMARY KEY (item_id));
+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_user_item (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE t_user_encrypt_federate (user_id INT NOT NULL, pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE t_user_encrypt_federate_sharding (user_id INT NOT NULL, pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
+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 INDEX user_index_t_user ON t_user (user_id);
+CREATE INDEX order_index_t_order ON t_order (order_id);
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/mysql/verification-init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/mysql/verification-init.sql
new file mode 100644
index 0000000..4902295
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/mysql/verification-init.sql
@@ -0,0 +1,44 @@
+--
+-- 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.
+--
+
+CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'root';
+GRANT All privileges ON *.* TO 'root'@'%';
+
+SET character_set_database='utf8';
+SET character_set_server='utf8';
+
+DROP DATABASE IF EXISTS verification_dataset;
+
+CREATE DATABASE verification_dataset;
+
+CREATE TABLE verification_dataset.t_order (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
+CREATE TABLE verification_dataset.t_order_item (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
+CREATE TABLE verification_dataset.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
+CREATE TABLE verification_dataset.t_order_federate (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
+CREATE TABLE verification_dataset.t_order_item_federate (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.t_order_federate_sharding (order_id_sharding INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id_sharding));
+CREATE TABLE verification_dataset.t_order_item_federate_sharding (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, remarks VARCHAR(45) NULL, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.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 verification_dataset.t_user_item (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.t_user_encrypt_federate (user_id INT NOT NULL, pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE verification_dataset.t_user_encrypt_federate_sharding (user_id INT NOT NULL, pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE verification_dataset.t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE verification_dataset.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 INDEX order_index_t_order ON verification_dataset.t_order (order_id);
+CREATE INDEX user_index_t_user ON encrypt.t_user (user_id);
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/oracle/verification-init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/oracle/verification-init.sql
new file mode 100644
index 0000000..7406f02
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/oracle/verification-init.sql
@@ -0,0 +1,40 @@
+--
+-- 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.
+--
+
+CREATE USER 'root'@'%' IDENTIFIED BY '';
+GRANT All privileges ON *.* TO 'root'@'%';
+
+DROP SCHEMA verification_dataset;
+
+CREATE SCHEMA verification_dataset;
+
+CREATE TABLE verification_dataset.t_order (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
+CREATE TABLE verification_dataset.t_order_item (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
+CREATE TABLE verification_dataset.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
+CREATE TABLE verification_dataset.t_order_federate (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
+CREATE TABLE verification_dataset.t_order_item_federate (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.t_order_federate_sharding (order_id_sharding INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id_sharding));
+CREATE TABLE verification_dataset.t_order_item_federate_sharding (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, remarks VARCHAR(45) NULL, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.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 verification_dataset.t_user_item (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.t_user_encrypt_federate (user_id INT NOT NULL, pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE verification_dataset.t_user_encrypt_federate_sharding (user_id INT NOT NULL, pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE verification_dataset.t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
+
+CREATE INDEX order_index_t_order ON verification_dataset.t_order (order_id);
+CREATE INDEX user_index_t_user ON encrypt.t_user (user_id);
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/postgresql/verification-init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/postgresql/verification-init.sql
new file mode 100644
index 0000000..e575b48
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/postgresql/verification-init.sql
@@ -0,0 +1,57 @@
+--
+-- 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.
+--
+
+CREATE DATABASE verification_dataset;
+
+GRANT ALL PRIVILEGES ON DATABASE verification_dataset TO root;
+
+\c verification_dataset;
+
+DROP TABLE IF EXISTS t_order;
+DROP TABLE IF EXISTS t_order_item;
+DROP TABLE IF EXISTS t_single_table;
+DROP TABLE IF EXISTS t_broadcast_table;
+DROP TABLE IF EXISTS t_order_federate;
+DROP TABLE IF EXISTS t_order_item_federate;
+DROP TABLE IF EXISTS t_order_federate_sharding;
+DROP TABLE IF EXISTS t_order_item_federate_sharding;
+DROP TABLE IF EXISTS t_user;
+DROP TABLE IF EXISTS t_user_item;
+DROP TABLE IF EXISTS t_user_encrypt_federate;
+DROP TABLE IF EXISTS t_user_encrypt_federate_sharding;
+DROP TABLE IF EXISTS t_user_info;
+DROP TABLE IF EXISTS t_shadow;
+
+CREATE TABLE t_order (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
+CREATE TABLE t_order_item (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
+CREATE TABLE t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
+CREATE TABLE t_order_federate (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
+CREATE TABLE t_order_item_federate (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (item_id));
+CREATE TABLE t_order_federate_sharding (order_id_sharding INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id_sharding));
+CREATE TABLE t_order_item_federate_sharding (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, remarks VARCHAR(45) NULL, PRIMARY KEY (item_id));
+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_user_item (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE t_user_encrypt_federate (user_id INT NOT NULL, pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE t_user_encrypt_federate_sharding (user_id INT NOT NULL, pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
+
+CREATE TYPE season AS ENUM ('spring', 'summer', 'autumn', 'winter');
+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 season DEFAULT 'summer', type_decimal NUMERIC(18,2) DEFAULT NULL, type_date DATE DEFAULT NULL, type_time TIME DEFAULT NULL, type_timestamp TIMESTAMP DEFAULT NULL, PRIMARY KEY (order_id));
+
+CREATE INDEX order_index_t_order ON t_order (order_id);
+CREATE INDEX user_index_t_user ON t_user (user_id);
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/sqlserver/verification-init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/sqlserver/verification-init.sql
new file mode 100644
index 0000000..5b173cf
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/common/verification/init-sql/sqlserver/verification-init.sql
@@ -0,0 +1,40 @@
+--
+-- 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.
+--
+
+CREATE USER 'root'@'%' IDENTIFIED BY '';
+GRANT All privileges ON *.* TO 'root'@'%';
+
+DROP DATABASE IF EXISTS verification_dataset;
+
+CREATE DATABASE verification_dataset;
+
+CREATE TABLE verification_dataset.t_order (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
+CREATE TABLE verification_dataset.t_order_item (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.t_single_table (single_id INT NOT NULL, id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
+CREATE TABLE verification_dataset.t_broadcast_table (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
+CREATE TABLE verification_dataset.t_order_federate (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
+CREATE TABLE verification_dataset.t_order_item_federate (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.t_order_federate_sharding (order_id_sharding INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id_sharding));
+CREATE TABLE verification_dataset.t_order_item_federate_sharding (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, remarks VARCHAR(45) NULL, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.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 verification_dataset.t_user_item (item_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY (item_id));
+CREATE TABLE verification_dataset.t_user_encrypt_federate (user_id INT NOT NULL, pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE verification_dataset.t_user_encrypt_federate_sharding (user_id INT NOT NULL, pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE verification_dataset.t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
+
+CREATE INDEX order_index_t_order ON verification_dataset.t_order (order_id);
+CREATE INDEX user_index_t_user ON encrypt.t_user (user_id);
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/it-env.properties b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/it-env.properties
index ea945c3..784f008 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/it-env.properties
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/it-env.properties
@@ -19,8 +19,8 @@
it.run.modes=Memory
it.run.additional.cases=false
-#it.scenarios=db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,shadow
-it.scenarios=db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,shadow
+#it.scenarios=db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,shadow,empty_rules
+it.scenarios=db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,encrypt,dbtbl_with_readwrite_splitting_and_encrypt,shadow,empty_rules
# it.cluster.env.type=DOCKER,NATIVE
it.cluster.env.type=DOCKER
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/verification_dataset.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/verification_dataset.xml
new file mode 100644
index 0000000..d5cf0c1
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/verification_dataset.xml
@@ -0,0 +1,202 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata data-nodes="verification_dataset.t_order">
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ <column name="creation_date" type="datetime" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_single_table">
+ <column name="single_id" type="numeric" />
+ <column name="id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_broadcast_table">
+ <column name="id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_federate">
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item_federate">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_federate_sharding">
+ <column name="order_id_sharding" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item_federate_sharding">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ <column name="remarks" type="varchar" />
+ </metadata>
+ <row data-node="verification_dataset.t_single_table" values="1, 1000, init" />
+ <row data-node="verification_dataset.t_single_table" values="2, 1101, init" />
+ <row data-node="verification_dataset.t_single_table" values="3, 2300, init" />
+ <row data-node="verification_dataset.t_single_table" values="4, 2401, init" />
+ <row data-node="verification_dataset.t_order" values="1000, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1001, 10, init" />
+ <row data-node="verification_dataset.t_order" values="2000, 20, init" />
+ <row data-node="verification_dataset.t_order" values="2001, 20, init" />
+ <row data-node="verification_dataset.t_order" values="1100, 11, init" />
+ <row data-node="verification_dataset.t_order" values="1101, 11, init" />
+ <row data-node="verification_dataset.t_order" values="2100, 21, init" />
+ <row data-node="verification_dataset.t_order" values="2101, 21, init" />
+ <row data-node="verification_dataset.t_order" values="1200, 12, init" />
+ <row data-node="verification_dataset.t_order" values="1201, 12, init" />
+ <row data-node="verification_dataset.t_order" values="2200, 22, init" />
+ <row data-node="verification_dataset.t_order" values="2201, 22, init" />
+ <row data-node="verification_dataset.t_order" values="1300, 13, init" />
+ <row data-node="verification_dataset.t_order" values="1301, 13, init" />
+ <row data-node="verification_dataset.t_order" values="2300, 23, init" />
+ <row data-node="verification_dataset.t_order" values="2301, 23, init" />
+ <row data-node="verification_dataset.t_order" values="1400, 14, init" />
+ <row data-node="verification_dataset.t_order" values="1401, 14, init" />
+ <row data-node="verification_dataset.t_order" values="2400, 24, init" />
+ <row data-node="verification_dataset.t_order" values="2401, 24, init" />
+ <row data-node="verification_dataset.t_order" values="1500, 15, init" />
+ <row data-node="verification_dataset.t_order" values="1501, 15, init" />
+ <row data-node="verification_dataset.t_order" values="2500, 25, init" />
+ <row data-node="verification_dataset.t_order" values="2501, 25, init" />
+ <row data-node="verification_dataset.t_order" values="1600, 16, init" />
+ <row data-node="verification_dataset.t_order" values="1601, 16, init" />
+ <row data-node="verification_dataset.t_order" values="2600, 26, init" />
+ <row data-node="verification_dataset.t_order" values="2601, 26, init" />
+ <row data-node="verification_dataset.t_order" values="1700, 17, init" />
+ <row data-node="verification_dataset.t_order" values="1701, 17, init" />
+ <row data-node="verification_dataset.t_order" values="2700, 27, init" />
+ <row data-node="verification_dataset.t_order" values="2701, 27, init" />
+ <row data-node="verification_dataset.t_order" values="1800, 18, init" />
+ <row data-node="verification_dataset.t_order" values="1801, 18, init" />
+ <row data-node="verification_dataset.t_order" values="2800, 28, init" />
+ <row data-node="verification_dataset.t_order" values="2801, 28, init" />
+ <row data-node="verification_dataset.t_order" values="1900, 19, init" />
+ <row data-node="verification_dataset.t_order" values="1901, 19, init" />
+ <row data-node="verification_dataset.t_order" values="2900, 29, init" />
+ <row data-node="verification_dataset.t_order" values="2901, 29, init" />
+ <row data-node="verification_dataset.t_order_item" values="100001, 1000, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100002, 1000, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100101, 1001, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100102, 1001, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="200001, 2000, 20, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="200002, 2000, 20, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="200101, 2001, 20, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="200102, 2001, 20, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110001, 1100, 11, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110002, 1100, 11, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110101, 1101, 11, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110102, 1101, 11, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="210001, 2100, 21, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="210002, 2100, 21, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="210101, 2101, 21, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="210102, 2101, 21, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120001, 1200, 12, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120002, 1200, 12, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120101, 1201, 12, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120102, 1201, 12, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="220001, 2200, 22, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="220002, 2200, 22, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="220101, 2201, 22, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="220102, 2201, 22, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130001, 1300, 13, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130002, 1300, 13, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130101, 1301, 13, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130102, 1301, 13, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="230001, 2300, 23, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="230002, 2300, 23, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="230101, 2301, 23, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="230102, 2301, 23, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140001, 1400, 14, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140002, 1400, 14, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140101, 1401, 14, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140102, 1401, 14, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="240001, 2400, 24, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="240002, 2400, 24, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="240101, 2401, 24, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="240102, 2401, 24, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150001, 1500, 15, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150002, 1500, 15, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150101, 1501, 15, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150102, 1501, 15, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="250001, 2500, 25, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="250002, 2500, 25, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="250101, 2501, 25, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="250102, 2501, 25, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160001, 1600, 16, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160002, 1600, 16, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160101, 1601, 16, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160102, 1601, 16, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="260001, 2600, 26, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="260002, 2600, 26, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="260101, 2601, 26, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="260102, 2601, 26, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170001, 1700, 17, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170002, 1700, 17, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170101, 1701, 17, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170102, 1701, 17, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="270001, 2700, 27, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="270002, 2700, 27, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="270101, 2701, 27, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="270102, 2701, 27, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180001, 1800, 18, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180002, 1800, 18, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180101, 1801, 18, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180102, 1801, 18, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="280001, 2800, 28, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="280002, 2800, 28, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="280101, 2801, 28, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="280102, 2801, 28, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190001, 1900, 19, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190002, 1900, 19, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190101, 1901, 19, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190102, 1901, 19, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="290001, 2900, 29, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="290002, 2900, 29, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="290101, 2901, 29, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="290102, 2901, 29, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init" />
+ <row data-node="verification_dataset.t_order_federate" values="1000, 10, init" />
+ <row data-node="verification_dataset.t_order_federate" values="1001, 11, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100000, 1000, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100001, 1000, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100100, 1001, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100101, 1001, 10, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1010, 10, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1100, 10, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1011, 11, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1101, 11, init" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1000, 10000, 10, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1010, 10001, 10, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1001, 10001, 11, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1011, 10001, 10, init, t_order_item_federate_sharding" />
+</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/verification_dataset.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/verification_dataset.xml
new file mode 100644
index 0000000..891f189
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/verification_dataset.xml
@@ -0,0 +1,391 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata data-nodes="verification_dataset.t_order">
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ <column name="creation_date" type="datetime" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_single_table">
+ <column name="single_id" type="numeric" />
+ <column name="id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_broadcast_table">
+ <column name="id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_federate">
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item_federate">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item_federate_sharding,">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ <column name="remarks" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_federate_sharding">
+ <column name="order_id_sharding" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <row data-node="verification_dataset.t_single_table" values="1, 1000, init_read" />
+ <row data-node="verification_dataset.t_single_table" values="2, 1101, init_read" />
+ <row data-node="verification_dataset.t_single_table" values="3, 1202, init_read" />
+ <row data-node="verification_dataset.t_single_table" values="4, 1303, init_read" />
+ <row data-node="verification_dataset.t_order" values="1000, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1001, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1002, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1003, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1004, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1005, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1006, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1007, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1008, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1009, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1100, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1101, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1102, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1103, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1104, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1105, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1106, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1107, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1108, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1109, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1200, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1201, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1202, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1203, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1204, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1205, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1206, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1207, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1208, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1209, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1300, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1301, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1302, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1303, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1304, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1305, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1306, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1307, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1308, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1309, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1400, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1401, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1402, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1403, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1404, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1405, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1406, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1407, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1408, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1409, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1500, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1501, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1502, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1503, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1504, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1505, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1506, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1507, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1508, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1509, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1600, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1601, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1602, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1603, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1604, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1605, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1606, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1607, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1608, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1609, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1700, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1701, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1702, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1703, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1704, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1705, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1706, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1707, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1708, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1709, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1800, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1801, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1802, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1803, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1804, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1805, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1806, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1807, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1808, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1809, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1900, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="1901, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="1902, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="1903, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="1904, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="1905, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="1906, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="1907, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="1908, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="1909, 19, init_read" />
+ <row data-node="verification_dataset.t_order_item" values="100000, 1000, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100001, 1000, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100100, 1001, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100101, 1001, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100200, 1002, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100201, 1002, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100300, 1003, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100301, 1003, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100400, 1004, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100401, 1004, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100500, 1005, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100501, 1005, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100600, 1006, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100601, 1006, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100700, 1007, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100701, 1007, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100800, 1008, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100801, 1008, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100900, 1009, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100901, 1009, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110000, 1100, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110001, 1100, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110100, 1101, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110101, 1101, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110200, 1102, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110201, 1102, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110300, 1103, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110301, 1103, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110400, 1104, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110401, 1104, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110500, 1105, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110501, 1105, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110600, 1106, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110601, 1106, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110700, 1107, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110701, 1107, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110800, 1108, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110801, 1108, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110900, 1109, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110901, 1109, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120000, 1200, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120001, 1200, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120100, 1201, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120101, 1201, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120200, 1202, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120201, 1202, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120300, 1203, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120301, 1203, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120400, 1204, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120401, 1204, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120500, 1205, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120501, 1205, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120600, 1206, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120601, 1206, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120700, 1207, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120701, 1207, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120800, 1208, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120801, 1208, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120900, 1209, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120901, 1209, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130000, 1300, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130001, 1300, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130100, 1301, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130101, 1301, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130200, 1302, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130201, 1302, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130300, 1303, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130301, 1303, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130400, 1304, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130401, 1304, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130500, 1305, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130501, 1305, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130600, 1306, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130601, 1306, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130700, 1307, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130701, 1307, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130800, 1308, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130801, 1308, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130900, 1309, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130901, 1309, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140000, 1400, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140001, 1400, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140100, 1401, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140101, 1401, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140200, 1402, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140201, 1402, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140300, 1403, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140301, 1403, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140400, 1404, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140401, 1404, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140500, 1405, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140501, 1405, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140600, 1406, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140601, 1406, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140700, 1407, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140701, 1407, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140800, 1408, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140801, 1408, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140900, 1409, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140901, 1409, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150000, 1500, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150001, 1500, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150100, 1501, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150101, 1501, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150200, 1502, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150201, 1502, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150300, 1503, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150301, 1503, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150400, 1504, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150401, 1504, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150500, 1505, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150501, 1505, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150600, 1506, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150601, 1506, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150700, 1507, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150701, 1507, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150800, 1508, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150801, 1508, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150900, 1509, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150901, 1509, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160000, 1600, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160001, 1600, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160100, 1601, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160101, 1601, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160200, 1602, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160201, 1602, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160300, 1603, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160301, 1603, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160400, 1604, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160401, 1604, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160500, 1605, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160501, 1605, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160600, 1606, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160601, 1606, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160700, 1607, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160701, 1607, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160800, 1608, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160801, 1608, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160900, 1609, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160901, 1609, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170000, 1700, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170001, 1700, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170100, 1701, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170101, 1701, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170200, 1702, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170201, 1702, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170300, 1703, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170301, 1703, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170400, 1704, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170401, 1704, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170500, 1705, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170501, 1705, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170600, 1706, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170601, 1706, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170700, 1707, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170701, 1707, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170800, 1708, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170801, 1708, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170900, 1709, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170901, 1709, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180000, 1800, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180001, 1800, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180100, 1801, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180101, 1801, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180200, 1802, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180201, 1802, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180300, 1803, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180301, 1803, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180400, 1804, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180401, 1804, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180500, 1805, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180501, 1805, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180600, 1806, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180601, 1806, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180700, 1807, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180701, 1807, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180800, 1808, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180801, 1808, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180900, 1809, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180901, 1809, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190000, 1900, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190001, 1900, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190100, 1901, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190101, 1901, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190200, 1902, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190201, 1902, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190300, 1903, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190301, 1903, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190400, 1904, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190401, 1904, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190500, 1905, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190501, 1905, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190600, 1906, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190601, 1906, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190700, 1907, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190701, 1907, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190800, 1908, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190801, 1908, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190900, 1909, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190901, 1909, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+ <row data-node="verification_dataset.t_order_federate" values="1000, 10, init" />
+ <row data-node="verification_dataset.t_order_federate" values="1001, 11, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100000, 1000, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100001, 1000, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100100, 1001, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100101, 1001, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1000, 10000, 10, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1010, 10001, 10, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1001, 10001, 11, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1011, 10001, 10, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1010, 10, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1100, 10, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1011, 11, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1101, 11, init" />
+</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/h2/init-encrypt_read_ds_1.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/h2/init-encrypt_read_ds_1.sql
index 947799f..6c27841 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/h2/init-encrypt_read_ds_1.sql
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/h2/init-encrypt_read_ds_1.sql
@@ -33,4 +33,4 @@ CREATE TABLE t_order_federate_sharding_1 (order_id_sharding INT NOT NULL, user_i
CREATE TABLE t_user_encrypt_federate_sharding_0 (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
CREATE TABLE t_user_encrypt_federate_sharding_1 (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
CREATE TABLE t_user_encrypt_federate (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/h2/init-encrypt_write_ds_1.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/h2/init-encrypt_write_ds_1.sql
index 947799f..6c27841 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/h2/init-encrypt_write_ds_1.sql
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/h2/init-encrypt_write_ds_1.sql
@@ -33,4 +33,4 @@ CREATE TABLE t_order_federate_sharding_1 (order_id_sharding INT NOT NULL, user_i
CREATE TABLE t_user_encrypt_federate_sharding_0 (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
CREATE TABLE t_user_encrypt_federate_sharding_1 (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
CREATE TABLE t_user_encrypt_federate (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/postgresql/init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/postgresql/init.sql
index 60ce846..f1fa5b6 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/postgresql/init.sql
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/init-sql/postgresql/init.sql
@@ -175,7 +175,7 @@ CREATE TABLE t_order_federate_sharding_1 (order_id_sharding INT NOT NULL, user_i
CREATE TABLE t_user_encrypt_federate_sharding_0 (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
CREATE TABLE t_user_encrypt_federate_sharding_1 (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
CREATE TABLE t_user_encrypt_federate (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
CREATE INDEX user_index_t_user_0 ON t_user_0 (user_id);
CREATE INDEX user_index_t_user_1 ON t_user_1 (user_id);
CREATE INDEX user_index_t_user_2 ON t_user_2 (user_id);
@@ -738,7 +738,7 @@ CREATE TABLE t_order_federate_sharding_1 (order_id_sharding INT NOT NULL, user_i
CREATE TABLE t_user_encrypt_federate_sharding_0 (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
CREATE TABLE t_user_encrypt_federate_sharding_1 (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
CREATE TABLE t_user_encrypt_federate (user_id INT NOT NULL, plain_pwd VARCHAR(45) NULL, cipher_pwd VARCHAR(45) NULL, username VARCHAR(45) NULL, PRIMARY KEY (user_id));
-CREATE TABLE t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
+CREATE TABLE t_user_info (user_id INT NOT NULL, information VARCHAR(45) NULL, PRIMARY KEY (user_id));
CREATE INDEX user_index_t_user_0 ON t_user_0 (user_id);
CREATE INDEX user_index_t_user_1 ON t_user_1 (user_id);
CREATE INDEX user_index_t_user_2 ON t_user_2 (user_id);
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/verification_dataset.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/verification_dataset.xml
new file mode 100644
index 0000000..ef6cb70
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/verification_dataset.xml
@@ -0,0 +1,310 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata data-nodes="verification_dataset.t_user">
+ <column name="user_id" type="numeric" />
+ <column name="address_id" type="numeric" />
+ <column name="pwd_plain" type="varchar" />
+ <column name="pwd_cipher" type="varchar" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_user_item">
+ <column name="item_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ <column name="creation_date" type="datetime" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_single_table">
+ <column name="single_id" type="numeric" />
+ <column name="id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_federate">
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item_federate">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item_federate_sharding">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ <column name="remarks" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_federate_sharding">
+ <column name="order_id_sharding" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_user_encrypt_federate_sharding">
+ <column name="user_id" type="numeric" />
+ <column name="plain_pwd" type="varchar" />
+ <column name="cipher_pwd" type="varchar" />
+ <column name="username" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_user_encrypt_federate">
+ <column name="user_id" type="numeric" />
+ <column name="plain_pwd" type="varchar" />
+ <column name="cipher_pwd" type="varchar" />
+ <column name="username" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_user_info">
+ <column name="user_id" type="numeric" />
+ <column name="information" type="varchar" />
+ </metadata>
+ <row data-node="verification_dataset.t_single_table" values="1, 0, init_read" />
+ <row data-node="verification_dataset.t_single_table" values="2, 11, init_read" />
+ <row data-node="verification_dataset.t_single_table" values="3, 22, init_read" />
+ <row data-node="verification_dataset.t_single_table" values="4, 33, init_read" />
+ <row data-node="verification_dataset.t_user" values="0, 10000, null, dL/JAiR/3cVG8lt6DMDa/A==, init_read" />
+ <row data-node="verification_dataset.t_user" values="1, 11000, null, wPc6WYJBzQIt4i4T0KhqXA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="2, 12000, null, HbV7OHLF4nBuOMVCLV5Cbg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="3, 13000, null, avls/J9bHV4A8V4VdPjfig==, init_read" />
+ <row data-node="verification_dataset.t_user" values="4, 14000, null, EPMV29wqL8k6Uow+Xrx3tg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="5, 15000, null, GxjyN54a5qsP5UDx7z98jw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="6, 16000, null, myfeu/O6o4D9RqILA5c2xA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="7, 17000, null, bnHlhR5STgfqDncGsILMMQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="8, 18000, null, Rlu0LF0Cud3Fdu+ZL7Uq7A==, init_read" />
+ <row data-node="verification_dataset.t_user" values="9, 19000, null, mOF/2EcSlRCZ0VQeZHlAhQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="10, 10001, null, yK+tn8E43EyCEgbqNOrJ4w==, init_read" />
+ <row data-node="verification_dataset.t_user" values="11, 11001, null, CIbxTwI742pGwxb18lQLkQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="12, 12001, null, VCHpNlwod9AiuS1V+7DSLw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="13, 13001, null, 8uxRFhW4c2rtSOoesudk/A==, init_read" />
+ <row data-node="verification_dataset.t_user" values="14, 14001, null, rcbF9ehMWzEUSzD9iw6miQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="15, 15001, null, +bC4X57KuvsqvTooe9sKmA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="16, 16001, null, /mkWl9noJDYqsTA0grvpEA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="17, 17001, null, 6XyVADMq3I6ikHX4V/FVxg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="18, 18001, null, 5sN2iooTz+7tWjqwJsCumQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="19, 19001, null, C91nCZHDOw4wvEnUNVicGw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="20, 10002, null, CsW4MD6vPLjo8+hGL0Bo4w==, init_read" />
+ <row data-node="verification_dataset.t_user" values="21, 11002, null, PVA6mbMm1kkSMHSjsArNMg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="22, 12002, null, k2NWLEtJ6ZZFpnxh5Va5DA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="23, 13002, null, 8EPPc+b2XMq9YSvOcEEing==, init_read" />
+ <row data-node="verification_dataset.t_user" values="24, 14002, null, zAaiW1TwDTujcIEdhVLXlg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="25, 15002, null, y3M+uxIBPPqxewV/sQCzlw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="26, 16002, null, TDUjigcYh2VVd/RYWRDaWg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="27, 17002, null, yhTlcXGbfBeEM/7PK3f5pQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="28, 18002, null, auRfbGy1FVUPOxL/RFxBQA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="29, 19002, null, aFMSknQG8p6wTGIhKNqJWg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="30, 10003, null, ZcI0/2rZRwtl8CkoWnyNYg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="31, 11003, null, Yz0R+SlE3AlO7jiOXOORog==, init_read" />
+ <row data-node="verification_dataset.t_user" values="32, 12003, null, I05miGKGMDNM5c7b+ibkng==, init_read" />
+ <row data-node="verification_dataset.t_user" values="33, 13003, null, GZmRSNc3jADLc9ca7MHHUQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="34, 14003, null, OCQD6nAXGxKym6ERLT8Ocg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="35, 15003, null, 43zyfbMMwczKlyyhhyo4DA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="36, 16003, null, 5UttfMTwhqlMif3YKOOh7Q==, init_read" />
+ <row data-node="verification_dataset.t_user" values="37, 17003, null, Iwh3hT6Kff/xYsyXNGtf8A==, init_read" />
+ <row data-node="verification_dataset.t_user" values="38, 18003, null, QFyiP7og+19ijdQBLO91TA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="39, 19003, null, g+dSiuA7EsW3tDs+20j4yQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="40, 10004, null, vu7rg5Fx+p4sf7PY3F/XkA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="41, 11004, null, R2jShanHkB8vL+3PWVtGCw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="42, 12004, null, lVWyZQPlVdUhiPRjdVTQXg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="43, 13004, null, 77bOsjoqDkWSiv7+Ij6n2Q==, init_read" />
+ <row data-node="verification_dataset.t_user" values="44, 14004, null, wVwIeANTfyuYr271gpk0sQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="45, 15004, null, foDB+Gm5QYUYokwTfxTsCw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="46, 16004, null, F2m3crkR88VuM/HEbO7j+A==, init_read" />
+ <row data-node="verification_dataset.t_user" values="47, 17004, null, t7PvURIBPbs5zGoLqrBtFQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="48, 18004, null, +pK5nh/SWW33b6pNK3YvCQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="49, 19004, null, uB2f4cc9dGRLuuWXYFsZQg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="50, 10005, null, SdNz2ZEWqomcNqmrjV5CLg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="51, 11005, null, 7j2sicl9fY79dgvDjoVQ6A==, init_read" />
+ <row data-node="verification_dataset.t_user" values="52, 12005, null, OQQ0iVzwLd3wAyiEagRb1w==, init_read" />
+ <row data-node="verification_dataset.t_user" values="53, 13005, null, kGUn2kRm9f1pd5lRNTLV4w==, init_read" />
+ <row data-node="verification_dataset.t_user" values="54, 14005, null, PKmA/7slVN/2HNhKLj0XoQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="55, 15005, null, aG1YPC3uDNgH1gzlUrn21g==, init_read" />
+ <row data-node="verification_dataset.t_user" values="56, 16005, null, qQmnX5II/jxrQWKBpDpCrg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="57, 17005, null, icdC0wx8+ftXLQYScnrdPA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="58, 18005, null, 9B8R0rlykQDYUKJN2iF5TQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="59, 19005, null, QBp/kRwtb9FMDJS9p/QJRw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="60, 10006, null, rJO2CWjwyQRPN1Z8ubPT+g==, init_read" />
+ <row data-node="verification_dataset.t_user" values="61, 11006, null, g0EzKaaNKrAN/SY0ZHgiPA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="62, 12006, null, g3P579hpR4nHHN740FwEPw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="63, 13006, null, /EST/RbrI3KpinjQljr5lQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="64, 14006, null, 8LJsk/W05nOpqZ2LTNaR9g==, init_read" />
+ <row data-node="verification_dataset.t_user" values="65, 15006, null, 081QjmH+mVkoYLdFkrQUdw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="66, 16006, null, HFrbbKF6I2PWR2XFUl5aoQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="67, 17006, null, ckb4oY9Bgo3T3HadoIJBHQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="68, 18006, null, r6JhpT0Uu3iv2TrijQ+4dw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="69, 19006, null, 0W0/tHYJxu/+suDfkhwBUA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="70, 10007, null, qewDwKyvX2y1mrPOAjvnJw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="71, 11007, null, ZaeVy/q9wyUCBzjEGqMAOw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="72, 12007, null, gHRriIh3YL7E+r/vJhF1BA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="73, 13007, null, oz+WFVBXdigh4pYhLQIqMQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="74, 14007, null, NAaO2Q6gWHXMjSY4MhtOBw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="75, 15007, null, zngftEpibgSVznPpdW+Iww==, init_read" />
+ <row data-node="verification_dataset.t_user" values="76, 16007, null, pcIWo58GiXizmF9XoUFi5Q==, init_read" />
+ <row data-node="verification_dataset.t_user" values="77, 17007, null, OrZ0BTU9guaRAsvlllMP2A==, init_read" />
+ <row data-node="verification_dataset.t_user" values="78, 18007, null, ICGcSjYHEC/UUHBiDEZ3Ig==, init_read" />
+ <row data-node="verification_dataset.t_user" values="79, 19007, null, JhZvTKXmZbgSV8f0Il+hfA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="80, 10008, null, t50lbUWg9IG0DUK3wvsuVQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="81, 11008, null, GFbH0x9bKgNjca82L6LQ8g==, init_read" />
+ <row data-node="verification_dataset.t_user" values="82, 12008, null, ZgTchBeCBGjrRUhFa+N8fg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="83, 13008, null, 4AO+TW07gsDFrhfhKH56Og==, init_read" />
+ <row data-node="verification_dataset.t_user" values="84, 14008, null, lQ93gD5gVKromV64BHAomw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="85, 15008, null, 3n887cFYFd7u7hWpguDAdQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="86, 16008, null, uHlcR+ZUiDqhdJkqKAjxnQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="87, 17008, null, 3qhS1Leu2nDv/QZ2Agw4iQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="88, 18008, null, G/HK36BIpcVXvfkF3gjjcA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="89, 19008, null, TF60AIoPWjR9SFb4y26a0w==, init_read" />
+ <row data-node="verification_dataset.t_user" values="90, 10009, null, BtkhhvF5z6PGgkS7+3X7lw==, init_read" />
+ <row data-node="verification_dataset.t_user" values="91, 11009, null, 72yl4Zn7/SUBTForYmkdRg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="92, 12009, null, qQkkak2if+eUUuomqvcjpA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="93, 13009, null, Voj+XVu4Qmr5CyUWOouK+w==, init_read" />
+ <row data-node="verification_dataset.t_user" values="94, 14009, null, gGEW0Da+8FKpiRnBnfSUmA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="95, 15009, null, 8psHAH0NJ5fdK5ZGmdP/wQ==, init_read" />
+ <row data-node="verification_dataset.t_user" values="96, 16009, null, 654WkfIPBEv2nfyhmgHP8A==, init_read" />
+ <row data-node="verification_dataset.t_user" values="97, 17009, null, 4cs88JOZMhtFn6C04H+rxA==, init_read" />
+ <row data-node="verification_dataset.t_user" values="98, 18009, null, bjkyDftrAIaEJSlibxiVkg==, init_read" />
+ <row data-node="verification_dataset.t_user" values="99, 19009, null, Ou8qESKecbqmABoIo+5Kpg==, init_read" />
+ <row data-node="verification_dataset.t_user_item" values="100000, 0, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="100001, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="100002, 20, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="100003, 30, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="100004, 40, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="100005, 50, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="100006, 60, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="100007, 70, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="100008, 80, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="100009, 90, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110000, 1, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110001, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110002, 21, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110003, 31, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110004, 41, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110005, 51, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110006, 61, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110007, 71, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110008, 81, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110009, 91, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120000, 2, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120001, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120002, 22, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120003, 32, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120004, 42, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120005, 52, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120006, 62, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120007, 72, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120008, 82, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120009, 92, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130000, 3, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130001, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130002, 23, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130003, 33, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130004, 43, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130005, 53, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130006, 63, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130007, 73, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130008, 83, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130009, 93, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140000, 4, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140001, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140002, 24, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140003, 34, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140004, 44, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140005, 54, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140006, 64, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140007, 74, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140008, 84, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140009, 94, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150000, 5, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150001, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150002, 25, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150003, 35, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150004, 45, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150005, 55, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150006, 65, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150007, 75, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150008, 85, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150009, 95, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160000, 6, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160001, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160002, 26, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160003, 36, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160004, 46, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160005, 56, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160006, 66, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160007, 76, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160008, 86, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160009, 96, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170000, 7, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170001, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170002, 27, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170003, 37, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170004, 47, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170005, 57, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170006, 67, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170007, 77, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170008, 87, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170009, 97, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180000, 8, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180001, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180002, 28, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180003, 38, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180004, 48, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180005, 58, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180006, 68, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180007, 78, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180008, 88, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180009, 98, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190000, 9, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190001, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190002, 29, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190003, 39, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190004, 49, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190005, 59, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190006, 69, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190007, 79, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190008, 89, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190009, 99, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_federate" values="1000, 10, init" />
+ <row data-node="verification_dataset.t_order_federate" values="1001, 11, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100000, 1000, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100001, 1000, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100100, 1001, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate" values="100101, 1001, 10, init" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1000, 10000, 10, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1010, 10001, 10, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1001, 10001, 11, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1011, 10001, 10, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1010, 10, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1100, 10, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1011, 11, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1101, 11, init" />
+ <row data-node="verification_dataset.t_user_encrypt_federate_sharding" values="0, plain passwordA, uqObdVp9XTGZ4Mnw0LolHg==, Rachel" />
+ <row data-node="verification_dataset.t_user_encrypt_federate_sharding" values="1, plain passwordB, uqObdVp9XTGZ4Mnw0LolHg==, Monica" />
+ <row data-node="verification_dataset.t_user_encrypt_federate_sharding" values="2, plain passwordC, uqObdVp9XTGZ4Mnw0LolHg==, Phoebe" />
+ <row data-node="verification_dataset.t_user_encrypt_federate_sharding" values="3, plain passwordD, uqObdVp9XTGZ4Mnw0LolHg==, Ross" />
+ <row data-node="verification_dataset.t_user_encrypt_federate_sharding" values="4, plain passwordE, uqObdVp9XTGZ4Mnw0LolHg==, Chandler" />
+ <row data-node="verification_dataset.t_user_encrypt_federate_sharding" values="5, plain passwordF, uqObdVp9XTGZ4Mnw0LolHg==, Joey" />
+ <row data-node="verification_dataset.t_user_info" values="0, description0" />
+ <row data-node="verification_dataset.t_user_info" values="1, description1" />
+ <row data-node="verification_dataset.t_user_info" values="2, description2" />
+ <row data-node="verification_dataset.t_user_info" values="3, description3" />
+ <row data-node="verification_dataset.t_user_encrypt_federate" values="0, plain password1, uqObdVp9XTGZ4Mnw0LolHg==, Rachel" />
+ <row data-node="verification_dataset.t_user_encrypt_federate" values="1, plain password2, uqObdVp9XTGZ4Mnw0LolHg==, Monica" />
+ <row data-node="verification_dataset.t_user_encrypt_federate" values="2, plain password3, uqObdVp9XTGZ4Mnw0LolHg==, Phoebe" />
+ <row data-node="verification_dataset.t_user_encrypt_federate" values="3, plain password4, uqObdVp9XTGZ4Mnw0LolHg==, Ross" />
+ <row data-node="verification_dataset.t_user_encrypt_federate" values="4, plain password5, uqObdVp9XTGZ4Mnw0LolHg==, Chandler" />
+ <row data-node="verification_dataset.t_user_encrypt_federate" values="5, plain password6, uqObdVp9XTGZ4Mnw0LolHg==, Joey" />
+</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/verification_dataset.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/verification_dataset.xml
new file mode 100644
index 0000000..0072325
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/verification_dataset.xml
@@ -0,0 +1,64 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata data-nodes="verification_dataset.t_user">
+ <column name="user_id" type="numeric" />
+ <column name="address_id" type="numeric" />
+ <column name="pwd" type="varchar" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_user_item">
+ <column name="item_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ <column name="creation_date" type="datetime" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_single_table">
+ <column name="single_id" type="numeric" />
+ <column name="id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <row data-node="verification_dataset.t_single_table" values="1, 10, init" />
+ <row data-node="verification_dataset.t_single_table" values="2, 11, init" />
+ <row data-node="verification_dataset.t_single_table" values="3, 12, init" />
+ <row data-node="verification_dataset.t_single_table" values="4, 13, init" />
+ <row data-node="verification_dataset.t_user" values="10, 10000, yK+tn8E43EyCEgbqNOrJ4w==, init" />
+ <row data-node="verification_dataset.t_user" values="11, 11000, CIbxTwI742pGwxb18lQLkQ==, init" />
+ <row data-node="verification_dataset.t_user" values="12, 12000, VCHpNlwod9AiuS1V+7DSLw==, init" />
+ <row data-node="verification_dataset.t_user" values="13, 13000, 8uxRFhW4c2rtSOoesudk/A==, init" />
+ <row data-node="verification_dataset.t_user_item" values="100000, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="110000, 11, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="120000, 12, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="130000, 13, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="140000, 14, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="150000, 15, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="160000, 16, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="170000, 17, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="180000, 18, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="190000, 19, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="200000, 20, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="210000, 21, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="220000, 22, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="230000, 23, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="240000, 24, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="250000, 25, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="260000, 26, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="270000, 27, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="280000, 28, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_user_item" values="290000, 29, init, 2017-08-08" />
+</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/verification_dataset.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/verification_dataset.xml
new file mode 100644
index 0000000..9feee6a
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/verification_dataset.xml
@@ -0,0 +1,165 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata data-nodes="verification_dataset.t_order">
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ <column name="creation_date" type="datetime" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_broadcast_table">
+ <column name="id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_single_table">
+ <column name="single_id" type="numeric" />
+ <column name="id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <row data-node="verification_dataset.t_single_table" values="1, 1000, init_read" />
+ <row data-node="verification_dataset.t_single_table" values="2, 1100, init_read" />
+ <row data-node="verification_dataset.t_single_table" values="3, 1200, init_read" />
+ <row data-node="verification_dataset.t_single_table" values="4, 1300, init_read" />
+ <row data-node="verification_dataset.t_order" values="1000, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1001, 10, init_read" />
+ <row data-node="verification_dataset.t_order" values="1100, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1101, 11, init_read" />
+ <row data-node="verification_dataset.t_order" values="1200, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1201, 12, init_read" />
+ <row data-node="verification_dataset.t_order" values="1300, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1301, 13, init_read" />
+ <row data-node="verification_dataset.t_order" values="1400, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1401, 14, init_read" />
+ <row data-node="verification_dataset.t_order" values="1500, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1501, 15, init_read" />
+ <row data-node="verification_dataset.t_order" values="1600, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1601, 16, init_read" />
+ <row data-node="verification_dataset.t_order" values="1700, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1701, 17, init_read" />
+ <row data-node="verification_dataset.t_order" values="1800, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1801, 18, init_read" />
+ <row data-node="verification_dataset.t_order" values="1900, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="1901, 19, init_read" />
+ <row data-node="verification_dataset.t_order" values="2000, 20, init_read" />
+ <row data-node="verification_dataset.t_order" values="2001, 20, init_read" />
+ <row data-node="verification_dataset.t_order" values="2100, 21, init_read" />
+ <row data-node="verification_dataset.t_order" values="2101, 21, init_read" />
+ <row data-node="verification_dataset.t_order" values="2200, 22, init_read" />
+ <row data-node="verification_dataset.t_order" values="2201, 22, init_read" />
+ <row data-node="verification_dataset.t_order" values="2300, 23, init_read" />
+ <row data-node="verification_dataset.t_order" values="2301, 23, init_read" />
+ <row data-node="verification_dataset.t_order" values="2400, 24, init_read" />
+ <row data-node="verification_dataset.t_order" values="2401, 24, init_read" />
+ <row data-node="verification_dataset.t_order" values="2500, 25, init_read" />
+ <row data-node="verification_dataset.t_order" values="2501, 25, init_read" />
+ <row data-node="verification_dataset.t_order" values="2600, 26, init_read" />
+ <row data-node="verification_dataset.t_order" values="2601, 26, init_read" />
+ <row data-node="verification_dataset.t_order" values="2700, 27, init_read" />
+ <row data-node="verification_dataset.t_order" values="2701, 27, init_read" />
+ <row data-node="verification_dataset.t_order" values="2800, 28, init_read" />
+ <row data-node="verification_dataset.t_order" values="2801, 28, init_read" />
+ <row data-node="verification_dataset.t_order" values="2900, 29, init_read" />
+ <row data-node="verification_dataset.t_order" values="2901, 29, init_read" />
+ <row data-node="verification_dataset.t_order_item" values="100001, 1000, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100002, 1000, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100101, 1001, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100102, 1001, 10, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110001, 1100, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110002, 1100, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110101, 1101, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="110102, 1101, 11, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120001, 1200, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120002, 1200, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120101, 1201, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="120102, 1201, 12, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130001, 1300, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130002, 1300, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130101, 1301, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="130102, 1301, 13, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140001, 1400, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140002, 1400, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140101, 1401, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="140102, 1401, 14, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150001, 1500, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150002, 1500, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150101, 1501, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="150102, 1501, 15, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160001, 1600, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160002, 1600, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160101, 1601, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="160102, 1601, 16, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170001, 1700, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170002, 1700, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170101, 1701, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="170102, 1701, 17, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180001, 1800, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180002, 1800, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180101, 1801, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="180102, 1801, 18, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190001, 1900, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190002, 1900, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190101, 1901, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="190102, 1901, 19, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="200001, 2000, 20, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="200002, 2000, 20, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="200101, 2001, 20, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="200102, 2001, 20, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="210001, 2100, 21, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="210002, 2100, 21, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="210101, 2101, 21, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="210102, 2101, 21, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="220001, 2200, 22, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="220002, 2200, 22, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="220101, 2201, 22, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="220102, 2201, 22, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="230001, 2300, 23, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="230002, 2300, 23, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="230101, 2301, 23, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="230102, 2301, 23, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="240001, 2400, 24, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="240002, 2400, 24, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="240101, 2401, 24, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="240102, 2401, 24, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="250001, 2500, 25, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="250002, 2500, 25, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="250101, 2501, 25, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="250102, 2501, 25, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="260001, 2600, 26, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="260002, 2600, 26, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="260101, 2601, 26, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="260102, 2601, 26, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="270001, 2700, 27, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="270002, 2700, 27, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="270101, 2701, 27, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="270102, 2701, 27, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="280001, 2800, 28, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="280002, 2800, 28, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="280101, 2801, 28, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="280102, 2801, 28, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="290001, 2900, 29, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="290002, 2900, 29, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="290101, 2901, 29, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="290102, 2901, 29, init_read, 2017-08-08" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init_read" />
+</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/dataset.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/dataset.xml
index 740f83d..5a65cab 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/dataset.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/dataset.xml
@@ -16,7 +16,7 @@
-->
<dataset>
- <metadata data-nodes="db.t_order,shadow_db.t_order">
+ <metadata data-nodes="db.t_shadow,shadow_db.t_shadow">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,14 +29,14 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="db.t_order" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="shadow_db.t_order" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="db.t_shadow" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="1, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="2, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="3, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="4, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="shadow_db.t_shadow" values="5, 0, shadow_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/h2/init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/h2/init.sql
index 9d7b1b9..c41b6c3 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/h2/init.sql
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/h2/init.sql
@@ -14,8 +14,8 @@
-- 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_shadow;
-CREATE TABLE t_order (order_id BIGINT NOT NULL, user_id INT NOT NULL, order_name VARCHAR(32) NOT NULL, type_char CHAR(1) NOT NULL, type_boolean BOOLEAN NOT NULL, type_smallint SMALLINT NOT NULL,
+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/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/mysql/init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/mysql/init.sql
index c246d84..6f7bcf1 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/mysql/init.sql
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/mysql/init.sql
@@ -25,7 +25,7 @@ DROP DATABASE IF EXISTS db;
CREATE DATABASE db;
-CREATE TABLE db.t_order (order_id BIGINT NOT NULL, user_id INT NOT NULL, order_name VARCHAR(32) NOT NULL, type_char CHAR(1) NOT NULL, type_boolean BOOLEAN NOT NULL, type_smallint SMALLINT NOT NULL,
+CREATE TABLE db.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));
@@ -33,6 +33,6 @@ DROP DATABASE IF EXISTS shadow_db;
CREATE DATABASE shadow_db;
-CREATE TABLE shadow_db.t_order (order_id BIGINT NOT NULL, user_id INT NOT NULL, order_name VARCHAR(32) NOT NULL, type_char CHAR(1) NOT NULL, type_boolean BOOLEAN NOT NULL, type_smallint SMALLINT NOT NULL,
+CREATE TABLE shadow_db.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/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/postgresql/init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/postgresql/init.sql
index ec42c1a..ebd2040 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/postgresql/init.sql
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/init-sql/postgresql/init.sql
@@ -23,20 +23,20 @@ GRANT ALL PRIVILEGES ON DATABASE shadow_db TO root;
\c db
-DROP TABLE IF EXISTS t_order;
+DROP TABLE IF EXISTS t_shadow;
CREATE TYPE season AS ENUM ('spring', 'summer', 'autumn', 'winter');
-CREATE TABLE t_order (order_id BIGINT NOT NULL, user_id INT NOT NULL, order_name VARCHAR(32) NOT NULL, type_char CHAR(1) NOT NULL, type_boolean BOOLEAN NOT NULL, type_smallint SMALLINT NOT NULL,
+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 season DEFAULT 'summer', type_decimal NUMERIC(18,2) DEFAULT NULL, type_date DATE DEFAULT NULL, type_time TIME DEFAULT NULL, type_timestamp TIMESTAMP DEFAULT NULL,
PRIMARY KEY (order_id));
\c shadow_db
-DROP TABLE IF EXISTS t_order;
+DROP TABLE IF EXISTS t_shadow;
CREATE TYPE season AS ENUM ('spring', 'summer', 'autumn', 'winter');
-CREATE TABLE t_order (order_id BIGINT NOT NULL, user_id INT NOT NULL, order_name VARCHAR(32) NOT NULL, type_char CHAR(1) NOT NULL, type_boolean BOOLEAN NOT NULL, type_smallint SMALLINT NOT NULL,
+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 season DEFAULT 'summer', type_decimal NUMERIC(18,2) DEFAULT NULL, type_date DATE DEFAULT NULL, type_time TIME DEFAULT NULL, type_timestamp TIMESTAMP DEFAULT NULL,
PRIMARY KEY (order_id));
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
index d73fef6..d217895 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/mysql/config-shadow.yaml
@@ -44,7 +44,7 @@ rules:
sourceDataSourceName: db
shadowDataSourceName: shadow_db
tables:
- t_order:
+ t_shadow:
dataSourceNames:
- shadowDataSource
shadowAlgorithmNames:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/postgresql/config-shadow.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/postgresql/config-shadow.yaml
index 353d7a4..5a82cbc 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/postgresql/config-shadow.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/proxy/conf/postgresql/config-shadow.yaml
@@ -44,7 +44,7 @@ rules:
sourceDataSourceName: db
shadowDataSourceName: shadow_db
tables:
- t_order:
+ t_shadow:
dataSourceNames:
- shadowDataSource
shadowAlgorithmNames:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/rules.yaml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/rules.yaml
index 8ed0daa..5936411 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/rules.yaml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/rules.yaml
@@ -22,7 +22,7 @@ rules:
sourceDataSourceName: db
shadowDataSourceName: shadow_db
tables:
- t_order:
+ t_shadow:
dataSourceNames:
- shadowDataSource
shadowAlgorithmNames:
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_update_order_by_user_id.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/verification_dataset.xml
similarity index 63%
copy from shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_update_order_by_user_id.xml
copy to shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/verification_dataset.xml
index 44dd575..fd2e04e 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dataset/shadow/mysql/pro_update_order_by_user_id.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/verification_dataset.xml
@@ -15,8 +15,8 @@
~ limitations under the License.
-->
-<dataset update-count="2">
- <metadata data-nodes="db.t_order">
+<dataset>
+ <metadata data-nodes="verification_dataset.t_order">
<column name="order_id" type="long" />
<column name="user_id" type="int" />
<column name="order_name" type="varchar" />
@@ -29,9 +29,9 @@
<column name="type_time" type="time" />
<column name="type_timestamp" type="timestamp"/>
</metadata>
- <row data-node="db.t_order" values="1, 1, pro_order_update, F, false, 60, spring, 120.00, 2021-01-02, 13:30:30, 2021-01-02 13:30:30.0" />
- <row data-node="db.t_order" values="2, 1, pro_order_update, F, false, 60, spring, 120.00, 2021-01-02, 13:30:30, 2021-01-02 13:30:30.0" />
- <row data-node="db.t_order" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
- <row data-node="db.t_order" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="verification_dataset.t_order" values="1, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="verification_dataset.t_order" values="2, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="verification_dataset.t_order" values="3, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="verification_dataset.t_order" values="4, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
+ <row data-node="verification_dataset.t_order" values="5, 1, pro_order, S, true, 5, summer, 10.00, 2017-08-08, 18:30:30, 2017-08-08 18:30:30.0" />
</dataset>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/verification_dataset.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/verification_dataset.xml
new file mode 100644
index 0000000..55a53ab
--- /dev/null
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/verification_dataset.xml
@@ -0,0 +1,125 @@
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<dataset>
+ <metadata data-nodes="verification_dataset.t_order">
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ <column name="creation_date" type="datetime" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_single_table">
+ <column name="single_id" type="numeric" />
+ <column name="id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_broadcast_table">
+ <column name="id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_federate_sharding">
+ <column name="order_id_sharding" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ </metadata>
+ <metadata data-nodes="verification_dataset.t_order_item_federate_sharding">
+ <column name="item_id" type="numeric" />
+ <column name="order_id" type="numeric" />
+ <column name="user_id" type="numeric" />
+ <column name="status" type="varchar" />
+ <column name="remarks" type="varchar" />
+ </metadata>
+ <row data-node="verification_dataset.t_single_table" values="1, 1000, init" />
+ <row data-node="verification_dataset.t_single_table" values="2, 1001, init" />
+ <row data-node="verification_dataset.t_single_table" values="3, 1002, init" />
+ <row data-node="verification_dataset.t_single_table" values="4, 1003, init" />
+ <row data-node="verification_dataset.t_order" values="1000, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1001, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1002, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1003, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1004, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1005, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1006, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1007, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1008, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1009, 10, init" />
+ <row data-node="verification_dataset.t_order" values="1100, 11, init" />
+ <row data-node="verification_dataset.t_order" values="1101, 11, init" />
+ <row data-node="verification_dataset.t_order" values="1102, 11, init" />
+ <row data-node="verification_dataset.t_order" values="1103, 11, init" />
+ <row data-node="verification_dataset.t_order" values="1104, 11, init" />
+ <row data-node="verification_dataset.t_order" values="1105, 11, init" />
+ <row data-node="verification_dataset.t_order" values="1106, 11, init" />
+ <row data-node="verification_dataset.t_order" values="1107, 11, init" />
+ <row data-node="verification_dataset.t_order" values="1108, 11, init" />
+ <row data-node="verification_dataset.t_order" values="1109, 11, init" />
+ <row data-node="verification_dataset.t_order_item" values="100000, 1000, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100001, 1000, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100100, 1001, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100101, 1001, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100200, 1002, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100201, 1002, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100300, 1003, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100301, 1003, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100400, 1004, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100401, 1004, 10, init, 2017-08-08" />
+ <row data-node="verification_dataset.t_order_item" values="100500, 1005, 10, init, 2017-08-09" />
+ <row data-node="verification_dataset.t_order_item" values="100501, 1005, 10, init, 2017-08-09" />
+ <row data-node="verification_dataset.t_order_item" values="100600, 1006, 10, init, 2017-08-09" />
+ <row data-node="verification_dataset.t_order_item" values="100601, 1006, 10, init, 2017-08-09" />
+ <row data-node="verification_dataset.t_order_item" values="100700, 1007, 10, init, 2017-08-09" />
+ <row data-node="verification_dataset.t_order_item" values="100701, 1007, 10, init, 2017-08-09" />
+ <row data-node="verification_dataset.t_order_item" values="100800, 1008, 10, init, 2017-08-09" />
+ <row data-node="verification_dataset.t_order_item" values="100801, 1008, 10, init, 2017-08-09" />
+ <row data-node="verification_dataset.t_order_item" values="100900, 1009, 10, init, 2017-08-09" />
+ <row data-node="verification_dataset.t_order_item" values="100901, 1009, 10, init, 2017-08-09" />
+ <row data-node="verification_dataset.t_order_item" values="110000, 1100, 11, init, 2017-08-18" />
+ <row data-node="verification_dataset.t_order_item" values="110001, 1100, 11, init, 2017-08-18" />
+ <row data-node="verification_dataset.t_order_item" values="110100, 1101, 11, init, 2017-08-18" />
+ <row data-node="verification_dataset.t_order_item" values="110101, 1101, 11, init, 2017-08-18" />
+ <row data-node="verification_dataset.t_order_item" values="110200, 1102, 11, init, 2017-08-18" />
+ <row data-node="verification_dataset.t_order_item" values="110201, 1102, 11, init, 2017-08-18" />
+ <row data-node="verification_dataset.t_order_item" values="110300, 1103, 11, init, 2017-08-18" />
+ <row data-node="verification_dataset.t_order_item" values="110301, 1103, 11, init, 2017-08-18" />
+ <row data-node="verification_dataset.t_order_item" values="110400, 1104, 11, init, 2017-08-18" />
+ <row data-node="verification_dataset.t_order_item" values="110401, 1104, 11, init, 2017-08-18" />
+ <row data-node="verification_dataset.t_order_item" values="110500, 1105, 11, init, 2017-08-19" />
+ <row data-node="verification_dataset.t_order_item" values="110501, 1105, 11, init, 2017-08-19" />
+ <row data-node="verification_dataset.t_order_item" values="110600, 1106, 11, init, 2017-08-19" />
+ <row data-node="verification_dataset.t_order_item" values="110601, 1106, 11, init, 2017-08-19" />
+ <row data-node="verification_dataset.t_order_item" values="110700, 1107, 11, init, 2017-08-19" />
+ <row data-node="verification_dataset.t_order_item" values="110701, 1107, 11, init, 2017-08-19" />
+ <row data-node="verification_dataset.t_order_item" values="110800, 1108, 11, init, 2017-08-19" />
+ <row data-node="verification_dataset.t_order_item" values="110801, 1108, 11, init, 2017-08-19" />
+ <row data-node="verification_dataset.t_order_item" values="110900, 1109, 11, init, 2017-08-19" />
+ <row data-node="verification_dataset.t_order_item" values="110901, 1109, 11, init, 2017-08-19" />
+ <row data-node="verification_dataset.t_broadcast_table" values="1, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1010, 10, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1100, 10, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1011, 11, init" />
+ <row data-node="verification_dataset.t_order_federate_sharding" values="1101, 11, init" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1000, 10000, 10, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1010, 10001, 10, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1001, 10001, 11, init, t_order_item_federate_sharding" />
+ <row data-node="verification_dataset.t_order_item_federate_sharding" values="1011, 10001, 10, init, t_order_item_federate_sharding" />
+</dataset>