This is an automated email from the ASF dual-hosted git repository.
zhangliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 522d336 add ral cases (#12721)
522d336 is described below
commit 522d3365a35588757d552ce798a99db0af274c6b
Author: Jieker <[email protected]>
AuthorDate: Sun Sep 26 14:53:00 2021 +0800
add ral cases (#12721)
---
.../test/integration/engine/it/ral/BaseRALIT.java | 6 +--
.../integration/engine/it/ral/GeneralRALIT.java | 3 +-
...action_type.xml => add_database_value_hint.xml} | 13 ++++-
...ansaction_type.xml => add_table_value_hint.xml} | 13 ++++-
...transaction_type.xml => cached_connections.xml} | 4 +-
...pe.xml => default_readwrite_splitting_hint.xml} | 4 +-
...nsaction_type.xml => default_sharding_hint.xml} | 13 ++++-
...ction_type.xml => default_transaction_type.xml} | 4 +-
.../cases/ral/dataset/empty_rules/preview_sql.xml | 63 ++++++++++++++++++++++
...action_type.xml => set_database_value_hint.xml} | 13 ++++-
...n_type.xml => set_readwrite_splitting_hint.xml} | 4 +-
.../ral/dataset/empty_rules/transaction_type.xml | 4 +-
.../cases/ral/ral-integration-test-cases.xml | 53 +++++++++++++++++-
.../empty_rules/mysql/proxy/conf/server.yaml | 2 +-
.../empty_rules/postgresql/proxy/conf/server.yaml | 2 +-
15 files changed, 174 insertions(+), 27 deletions(-)
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/it/ral/BaseRALIT.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/it/ral/BaseRALIT.java
index 2794599..d23f47e 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/it/ral/BaseRALIT.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/it/ral/BaseRALIT.java
@@ -114,7 +114,7 @@ public abstract class BaseRALIT extends SingleITCase {
private void assertRow(final ResultSet actual, final ResultSetMetaData
actualMetaData, final DataSetRow expected) throws SQLException {
int columnIndex = 1;
- for (String each : expected.splitValues(",")) {
+ for (String each : expected.splitValues("|")) {
String columnLabel = actualMetaData.getColumnLabel(columnIndex);
assertObjectValue(actual, columnIndex, columnLabel, each);
columnIndex++;
@@ -122,7 +122,7 @@ public abstract class BaseRALIT extends SingleITCase {
}
private void assertObjectValue(final ResultSet actual, final int
columnIndex, final String columnLabel, final String expected) throws
SQLException {
- assertThat(String.valueOf(actual.getObject(columnIndex)),
is(expected));
- assertThat(String.valueOf(actual.getObject(columnLabel)),
is(expected));
+ assertThat(String.valueOf(actual.getObject(columnIndex)).trim(),
is(expected));
+ assertThat(String.valueOf(actual.getObject(columnLabel)).trim(),
is(expected));
}
}
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/it/ral/GeneralRALIT.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/it/ral/GeneralRALIT.java
index 42cf069..10d02ae 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/it/ral/GeneralRALIT.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/java/org/apache/shardingsphere/test/integration/engine/it/ral/GeneralRALIT.java
@@ -19,7 +19,6 @@ package
org.apache.shardingsphere.test.integration.engine.it.ral;
import org.apache.shardingsphere.test.integration.cases.SQLCommandType;
import org.apache.shardingsphere.test.integration.common.SQLExecuteType;
-import org.apache.shardingsphere.test.integration.engine.it.rdl.BaseRDLIT;
import org.apache.shardingsphere.test.integration.junit.compose.ComposeManager;
import
org.apache.shardingsphere.test.integration.junit.compose.GovernanceContainerCompose;
import
org.apache.shardingsphere.test.integration.junit.param.ParameterizedArrayFactory;
@@ -41,7 +40,7 @@ import java.util.Collection;
import java.util.stream.Collectors;
@ParallelRuntimeStrategy(ParallelLevel.SCENARIO)
-public final class GeneralRALIT extends BaseRDLIT {
+public final class GeneralRALIT extends BaseRALIT {
@ClassRule
public static ComposeManager composeManager = new
ComposeManager("GeneralRALIT");
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/add_database_value_hint.xml
similarity index 61%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/add_database_value_hint.xml
index fa542c5..532b6c7 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/add_database_value_hint.xml
@@ -17,7 +17,16 @@
<dataset>
<metadata>
- <column name="transaction_type" />
+ <column name="table_name"/>
+ <column name="database_sharding_values"/>
+ <column name="table_sharding_values"/>
+ <column name="sharding_type"/>
</metadata>
- <row values="XA" />
+ <row values="t_single_table| | | databases_tables"/>
+ <row values="t_user_0| | | databases_tables"/>
+ <row values="t_user_item| 100| | databases_tables"/>
+ <row values="t_broadcast_table| | | databases_tables"/>
+ <row values="t_user_3| | | databases_tables"/>
+ <row values="t_user_2| | | databases_tables"/>
+ <row values="t_user_1| | | databases_tables"/>
</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/add_table_value_hint.xml
similarity index 61%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/add_table_value_hint.xml
index fa542c5..8baa936 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/add_table_value_hint.xml
@@ -17,7 +17,16 @@
<dataset>
<metadata>
- <column name="transaction_type" />
+ <column name="table_name"/>
+ <column name="database_sharding_values"/>
+ <column name="table_sharding_values"/>
+ <column name="sharding_type"/>
</metadata>
- <row values="XA" />
+ <row values="t_single_table| | | databases_tables"/>
+ <row values="t_user_0| | | databases_tables"/>
+ <row values="t_user_item| | 100| databases_tables"/>
+ <row values="t_broadcast_table| | | databases_tables"/>
+ <row values="t_user_3| | | databases_tables"/>
+ <row values="t_user_2| | | databases_tables"/>
+ <row values="t_user_1| | | databases_tables"/>
</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/cached_connections.xml
similarity index 92%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/cached_connections.xml
index fa542c5..e1709ca 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/cached_connections.xml
@@ -17,7 +17,7 @@
<dataset>
<metadata>
- <column name="transaction_type" />
+ <column name="cached_connections"/>
</metadata>
- <row values="XA" />
+ <row values="0"/>
</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/default_readwrite_splitting_hint.xml
similarity index 92%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/default_readwrite_splitting_hint.xml
index fa542c5..7bb2e95 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/default_readwrite_splitting_hint.xml
@@ -17,7 +17,7 @@
<dataset>
<metadata>
- <column name="transaction_type" />
+ <column name="source"/>
</metadata>
- <row values="XA" />
+ <row values="auto"/>
</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/default_sharding_hint.xml
similarity index 61%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/default_sharding_hint.xml
index fa542c5..35a6819 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/default_sharding_hint.xml
@@ -17,7 +17,16 @@
<dataset>
<metadata>
- <column name="transaction_type" />
+ <column name="table_name"/>
+ <column name="database_sharding_values"/>
+ <column name="table_sharding_values"/>
+ <column name="sharding_type"/>
</metadata>
- <row values="XA" />
+ <row values="t_single_table| | | databases_tables"/>
+ <row values="t_user_0| | | databases_tables"/>
+ <row values="t_user_item| | | databases_tables"/>
+ <row values="t_broadcast_table| | | databases_tables"/>
+ <row values="t_user_3| | | databases_tables"/>
+ <row values="t_user_2| | | databases_tables"/>
+ <row values="t_user_1| | | databases_tables"/>
</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/default_transaction_type.xml
similarity index 92%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/default_transaction_type.xml
index fa542c5..2a00a99 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/default_transaction_type.xml
@@ -17,7 +17,7 @@
<dataset>
<metadata>
- <column name="transaction_type" />
+ <column name="transaction_type"/>
</metadata>
- <row values="XA" />
+ <row values="LOCAL"/>
</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/preview_sql.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/preview_sql.xml
new file mode 100644
index 0000000..e188b0f
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/preview_sql.xml
@@ -0,0 +1,63 @@
+<!--
+ ~ 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>
+ <column name="data_source_name"/>
+ <column name="sql"/>
+ </metadata>
+ <row values="encrypt_write_ds_0| select * from t_user_item_0 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_0| select * from t_user_item_10 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_0| select * from t_user_item_20 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_0| select * from t_user_item_30 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_1| select * from t_user_item_1 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_1| select * from t_user_item_11 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_1| select * from t_user_item_21 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_1| select * from t_user_item_31 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_2| select * from t_user_item_2 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_2| select * from t_user_item_12 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_2| select * from t_user_item_22 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_2| select * from t_user_item_32 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_3| select * from t_user_item_3 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_3| select * from t_user_item_13 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_3| select * from t_user_item_23 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_3| select * from t_user_item_33 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_4| select * from t_user_item_4 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_4| select * from t_user_item_14 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_4| select * from t_user_item_24 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_4| select * from t_user_item_34 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_5| select * from t_user_item_5 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_5| select * from t_user_item_15 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_5| select * from t_user_item_25 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_5| select * from t_user_item_35 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_6| select * from t_user_item_6 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_6| select * from t_user_item_16 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_6| select * from t_user_item_26 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_6| select * from t_user_item_36 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_7| select * from t_user_item_7 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_7| select * from t_user_item_17 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_7| select * from t_user_item_27 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_7| select * from t_user_item_37 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_8| select * from t_user_item_8 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_8| select * from t_user_item_18 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_8| select * from t_user_item_28 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_8| select * from t_user_item_38 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_9| select * from t_user_item_9 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_9| select * from t_user_item_19 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_9| select * from t_user_item_29 ORDER BY
item_id ASC"/>
+ <row values="encrypt_write_ds_9| select * from t_user_item_39 ORDER BY
item_id ASC"/>
+</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/set_database_value_hint.xml
similarity index 61%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/set_database_value_hint.xml
index fa542c5..21fc34b 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/set_database_value_hint.xml
@@ -17,7 +17,16 @@
<dataset>
<metadata>
- <column name="transaction_type" />
+ <column name="table_name"/>
+ <column name="database_sharding_values"/>
+ <column name="table_sharding_values"/>
+ <column name="sharding_type"/>
</metadata>
- <row values="XA" />
+ <row values="t_single_table| 100| | databases_only"/>
+ <row values="t_user_0| 100| | databases_only"/>
+ <row values="t_user_item| 100| | databases_only"/>
+ <row values="t_broadcast_table| 100| | databases_only"/>
+ <row values="t_user_3| 100| | databases_only"/>
+ <row values="t_user_2| 100| | databases_only"/>
+ <row values="t_user_1| 100| | databases_only"/>
</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/set_readwrite_splitting_hint.xml
similarity index 92%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/set_readwrite_splitting_hint.xml
index fa542c5..a31e1ae 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/set_readwrite_splitting_hint.xml
@@ -17,7 +17,7 @@
<dataset>
<metadata>
- <column name="transaction_type" />
+ <column name="source"/>
</metadata>
- <row values="XA" />
+ <row values="write"/>
</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
index fa542c5..9b392d0 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/dataset/empty_rules/transaction_type.xml
@@ -17,7 +17,7 @@
<dataset>
<metadata>
- <column name="transaction_type" />
+ <column name="transaction_type"/>
</metadata>
- <row values="XA" />
+ <row values="XA"/>
</dataset>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/ral-integration-test-cases.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/ral-integration-test-cases.xml
index eeec47d..d7764f2 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/ral-integration-test-cases.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ral/ral-integration-test-cases.xml
@@ -16,9 +16,58 @@
-->
<integration-test-cases>
<test-case sql="show variable transaction_type">
+ <assertion expected-data-file="default_transaction_type.xml"/>
+ </test-case>
+
+ <test-case sql="show variable transaction_type">
<assertion expected-data-file="transaction_type.xml">
- <initial-sql sql="set variable transaction_type = XA" />
- <destroy-sql sql="set variable transaction_type = LOCAL" />
+ <initial-sql sql="set variable transaction_type = XA"/>
+ <destroy-sql sql="set variable transaction_type = LOCAL"/>
+ </assertion>
+ </test-case>
+
+ <test-case sql="show variable cached_connections">
+ <assertion expected-data-file="cached_connections.xml"/>
+ </test-case>
+
+ <test-case sql="preview select * from t_user_item">
+ <assertion expected-data-file="preview_sql.xml"/>
+ </test-case>
+
+ <test-case sql="show sharding hint status">
+ <assertion expected-data-file="default_sharding_hint.xml"/>
+ </test-case>
+
+ <test-case sql="show readwrite_splitting hint status">
+ <assertion expected-data-file="default_readwrite_splitting_hint.xml"/>
+ </test-case>
+
+ <test-case sql="show readwrite_splitting hint status">
+ <assertion expected-data-file="set_readwrite_splitting_hint.xml">
+ <initial-sql sql="set readwrite_splitting hint source = write"/>
+ <destroy-sql sql="clear readwrite_splitting hint"/>
+ </assertion>
+ </test-case>
+
+ <test-case sql="show sharding hint status">
+ <assertion expected-data-file="set_database_value_hint.xml">
+ <initial-sql sql="set sharding hint database_value = 100"/>
+ <destroy-sql sql="clear sharding hint"/>
+ </assertion>
+ </test-case>
+
+ <test-case sql="show sharding hint status">
+ <assertion expected-data-file="add_database_value_hint.xml">
+ <initial-sql sql="add sharding hint database_value t_user_item=
100"/>
+ <destroy-sql sql="clear sharding hint"/>
+ </assertion>
+ </test-case>
+
+
+ <test-case sql="show sharding hint status">
+ <assertion expected-data-file="add_table_value_hint.xml">
+ <initial-sql sql="add sharding hint table_value t_user_item= 100"/>
+ <destroy-sql sql="clear sharding hint"/>
</assertion>
</test-case>
</integration-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/mysql/proxy/conf/server.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/mysql/proxy/conf/server.yaml
index e663b56..5e8f38d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/mysql/proxy/conf/server.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/mysql/proxy/conf/server.yaml
@@ -40,5 +40,5 @@ props:
executor-size: 16 # Infinite by default.
proxy-frontend-flush-threshold: 128 # The default value is 128.
proxy-opentracing-enabled: false
- proxy-hint-enabled: false
+ proxy-hint-enabled: true
sql-show: false
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/postgresql/proxy/conf/server.yaml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/postgresql/proxy/conf/server.yaml
index e663b56..5e8f38d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/postgresql/proxy/conf/server.yaml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/postgresql/proxy/conf/server.yaml
@@ -40,5 +40,5 @@ props:
executor-size: 16 # Infinite by default.
proxy-frontend-flush-threshold: 128 # The default value is 128.
proxy-opentracing-enabled: false
- proxy-hint-enabled: false
+ proxy-hint-enabled: true
sql-show: false
