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 9b4616568c8 Adding Hint-related syntax cases for RAL (#19589)
9b4616568c8 is described below
commit 9b4616568c8bdf8b0cef81664e88d4a52ecbf2a6
Author: Jieker <[email protected]>
AuthorDate: Wed Jul 27 21:09:58 2022 +0800
Adding Hint-related syntax cases for RAL (#19589)
---
.../cases/ral/ral-integration-test-cases.xml | 75 +++++++++++-----------
1 file changed, 38 insertions(+), 37 deletions(-)
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 a85ec8f2d99..47a9722b62c 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
@@ -15,6 +15,41 @@
~ limitations under the License.
-->
<integration-test-cases>
+ <test-case sql="SHOW READWRITE_SPLITTING HINT STATUS">
+ <assertion expected-data-file="default_readwrite_splitting_hint.xml"/>
+ <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>
+ <assertion expected-data-file="default_readwrite_splitting_hint.xml">
+ <initial-sql sql="SET READWRITE_SPLITTING HINT SOURCE =
write;CLEAR READWRITE_SPLITTING HINT"/>
+ </assertion>
+ <assertion expected-data-file="default_readwrite_splitting_hint.xml">
+ <initial-sql sql="SET READWRITE_SPLITTING HINT SOURCE =
write;CLEAR HINT"/>
+ </assertion>
+ </test-case>
+
+ <test-case sql="SHOW SHARDING HINT STATUS">
+ <assertion expected-data-file="default_sharding_hint.xml"/>
+ <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>
+ <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>
+ <assertion expected-data-file="add_table_value_hint.xml">
+ <initial-sql sql="ADD SHARDING HINT TABLE_VALUE t_user_item =
100"/>
+ </assertion>
+ <assertion expected-data-file="default_sharding_hint.xml">
+ <initial-sql sql="ADD SHARDING HINT TABLE_VALUE t_user_item=
100;CLEAR SHARDING HINT"/>
+ </assertion>
+ <assertion expected-data-file="default_sharding_hint.xml">
+ <initial-sql sql="ADD SHARDING HINT TABLE_VALUE t_user_item=
100;CLEAR HINT"/>
+ </assertion>
+ </test-case>
+
<test-case sql="show variable transaction_type">
<assertion expected-data-file="default_transaction_type.xml"/>
</test-case>
@@ -34,43 +69,9 @@
<assertion expected-data-file="preview_sql.xml"/>
</test-case>
- <test-case sql="PREVIEW SELECT * FROM t_single_table s INNER JOIN
t_user_item i ON s.single_id = i.item_id WHERE i.user_id = 1">
+ <test-case
+ sql="PREVIEW SELECT * FROM t_single_table s INNER JOIN t_user_item
i ON s.single_id = i.item_id WHERE i.user_id = 1">
<assertion expected-data-file="preview_federation_select.xml"/>
</test-case>
-
- <test-case sql="show sharding hint status">
- <assertion expected-data-file="default_sharding_hint.xml"/>
- </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>
-
- <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>
</integration-test-cases>
+
