This is an automated email from the ASF dual-hosted git repository.
jianglongtao 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 3d9f4a803d3 Fix algorithm type in ENCRYPT test cases (#28377)
3d9f4a803d3 is described below
commit 3d9f4a803d39286aa8f9179efb95fb7095dc481f
Author: yx9o <[email protected]>
AuthorDate: Thu Sep 7 22:46:13 2023 +0800
Fix algorithm type in ENCRYPT test cases (#28377)
---
.../parser/src/main/resources/case/rdl/alter.xml | 16 +++++++++----
.../parser/src/main/resources/case/rdl/create.xml | 24 +++++++++++++++-----
.../src/main/resources/sql/supported/rdl/alter.xml | 14 ++++++------
.../main/resources/sql/supported/rdl/create.xml | 26 +++++++++++-----------
4 files changed, 50 insertions(+), 30 deletions(-)
diff --git a/test/it/parser/src/main/resources/case/rdl/alter.xml
b/test/it/parser/src/main/resources/case/rdl/alter.xml
index 73cf6b5ccad..49f2cc02b2e 100644
--- a/test/it/parser/src/main/resources/case/rdl/alter.xml
+++ b/test/it/parser/src/main/resources/case/rdl/alter.xml
@@ -209,7 +209,9 @@
</column>
<column name="order_id">
<cipher name="order_cipher">
- <encryptor algorithm-name="MD5" />
+ <encryptor algorithm-name="RC4">
+ <property key="rc4-key-value" value="123456abc" />
+ </encryptor>
</cipher>
</column>
</rule>
@@ -229,7 +231,9 @@
</column>
<column name="order_id">
<cipher name="order_cipher">
- <encryptor algorithm-name="MD5" />
+ <encryptor algorithm-name="RC4">
+ <property key="rc4-key-value" value="123456abc" />
+ </encryptor>
</cipher>
</column>
</rule>
@@ -249,7 +253,9 @@
</column>
<column name="order_id">
<cipher name="order_cipher">
- <encryptor algorithm-name="MD5" />
+ <encryptor algorithm-name="RC4">
+ <property key="rc4-key-value" value="123456abc" />
+ </encryptor>
</cipher>
</column>
</rule>
@@ -266,7 +272,9 @@
</column>
<column name="order_id">
<cipher name="order_cipher">
- <encryptor algorithm-name="MD5" />
+ <encryptor algorithm-name="RC4">
+ <property key="rc4-key-value" value="123456abc" />
+ </encryptor>
</cipher>
</column>
</rule>
diff --git a/test/it/parser/src/main/resources/case/rdl/create.xml
b/test/it/parser/src/main/resources/case/rdl/create.xml
index 377cb397e0a..3a7c1639140 100644
--- a/test/it/parser/src/main/resources/case/rdl/create.xml
+++ b/test/it/parser/src/main/resources/case/rdl/create.xml
@@ -381,7 +381,9 @@
</column>
<column name="order_id">
<cipher name="order_cipher">
- <encryptor algorithm-name="MD5" />
+ <encryptor algorithm-name="RC4">
+ <property key="rc4-key-value" value="123456abc" />
+ </encryptor>
</cipher>
</column>
</rule>
@@ -398,7 +400,9 @@
</column>
<column name="order_id">
<cipher name="order_cipher">
- <encryptor algorithm-name="MD5" />
+ <encryptor algorithm-name="RC4">
+ <property key="rc4-key-value" value="123456abc" />
+ </encryptor>
</cipher>
</column>
</rule>
@@ -415,7 +419,9 @@
</column>
<column name="order_id">
<cipher name="order_cipher">
- <encryptor algorithm-name="MD5" />
+ <encryptor algorithm-name="RC4">
+ <property key="rc4-key-value" value="123456abc" />
+ </encryptor>
</cipher>
</column>
</rule>
@@ -435,7 +441,9 @@
</column>
<column name="order_id">
<cipher name="order_cipher">
- <encryptor algorithm-name="MD5" />
+ <encryptor algorithm-name="RC4">
+ <property key="rc4-key-value" value="123456abc" />
+ </encryptor>
</cipher>
</column>
</rule>
@@ -455,7 +463,9 @@
</column>
<column name="order_id">
<cipher name="order_cipher">
- <encryptor algorithm-name="MD5" />
+ <encryptor algorithm-name="RC4">
+ <property key="rc4-key-value" value="123456abc" />
+ </encryptor>
</cipher>
</column>
</rule>
@@ -670,7 +680,9 @@
</encryptor>
</column>
<column name="order_id" cipher-column="order_cipher">
- <encryptor algorithm-name="MD5" />
+ <encryptor algorithm-name="RC4">
+ <property key="rc4-key-value" value="123456abc" />
+ </encryptor>
</column>
</rule>
</create-encrypt-rule>
diff --git a/test/it/parser/src/main/resources/sql/supported/rdl/alter.xml
b/test/it/parser/src/main/resources/sql/supported/rdl/alter.xml
index c8dc5cf0b81..caf39b60324 100644
--- a/test/it/parser/src/main/resources/sql/supported/rdl/alter.xml
+++ b/test/it/parser/src/main/resources/sql/supported/rdl/alter.xml
@@ -26,19 +26,19 @@
<sql-case id="alter-storage-unit-single-with-properties" value="ALTER
STORAGE UNIT
ds_0(HOST='127.0.0.1',PORT=3306,DB='test0',USER='ROOT',PASSWORD='123456',PROPERTIES('maxPoolSize'='30'));"
db-types="ShardingSphere" />
<sql-case id="alter-storage-unit-url-single-with-empty-properties"
value="ALTER STORAGE UNIT
ds_0(URL='jdbc:mysql://127.0.0.1:3306/test0',USER='ROOT',PROPERTIES())"
db-types="ShardingSphere" />
<sql-case id="alter-storage-unit-url-single-with-properties" value="ALTER
STORAGE UNIT
ds_0(URL='jdbc:mysql://127.0.0.1:3306/test0',USER='ROOT',PASSWORD='123456',PROPERTIES('maxPoolSize'='30'))"
db-types="ShardingSphere" />
- <sql-case id="alter-encrypt-rule" value="ALTER ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc')))),
(NAME=order_id, CIPHER =order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))))"
db-types="ShardingSphere" />
- <sql-case id="alter-encrypt-rule-with-assisted-query-column" value="ALTER
ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ASSISTED_QUERY_COLUMN=assisted_column,
ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
ASSISTED_QUERY_ALGORITHM(TYPE(NAME='MD5'))), (NAME=order_id, CIPHER
=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))))" db-types="ShardingSphere"
/>
- <sql-case id="alter-encrypt-rule-with-like-query-column" value="ALTER
ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,LIKE_QUERY_COLUMN=like_column,
ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
LIKE_QUERY_ALGORITHM(TYPE(NAME='CHAR_DIGEST_LIKE'))), (NAME=order_id, CIPHER
=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))))" db-types="ShardingSphere"
/>
- <sql-case id="alter-encrypt-rule-with-query-with-cipher-column"
value="ALTER ENCRYPT RULE t_encrypt (COLUMNS((NAME=user_id,CIPHER=user_cipher,
ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc')))),
(NAME=order_id, CIPHER =order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))))"
db-types="ShardingSphere" />
+ <sql-case id="alter-encrypt-rule" value="ALTER ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc')))),
(NAME=order_id,
CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='RC4',PROPERTIES('rc4-key-value'='123456abc'))))))"
db-types="ShardingSphere" />
+ <sql-case id="alter-encrypt-rule-with-assisted-query-column" value="ALTER
ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ASSISTED_QUERY_COLUMN=assisted_column,
ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
ASSISTED_QUERY_ALGORITHM(TYPE(NAME='MD5'))), (NAME=order_id,
CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='RC4',PROPERTIES('rc4-key-value'='123456abc'))))))"
db-types="ShardingSphere" />
+ <sql-case id="alter-encrypt-rule-with-like-query-column" value="ALTER
ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,LIKE_QUERY_COLUMN=like_column,
ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
LIKE_QUERY_ALGORITHM(TYPE(NAME='CHAR_DIGEST_LIKE'))), (NAME=order_id,
CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='RC4',PROPERTIES('rc4-key-value'='123456abc'))))))"
db-types="ShardingSphere" />
+ <sql-case id="alter-encrypt-rule-with-query-with-cipher-column"
value="ALTER ENCRYPT RULE t_encrypt (COLUMNS((NAME=user_id,CIPHER=user_cipher,
ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc')))),
(NAME=order_id,
CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='RC4',PROPERTIES('rc4-key-value'='123456abc'))))))"
db-types="ShardingSphere" />
<sql-case id="alter-default-shadow-algorithm" value="ALTER DEFAULT SHADOW
ALGORITHM TYPE(NAME='SQL_HINT')" db-types="ShardingSphere" />
<sql-case id="alter-shadow-rule" value="ALTER SHADOW RULE
shadow_rule(SOURCE=demo_ds,SHADOW=demo_ds_shadow,t_order(TYPE(NAME='REGEX_MATCH',PROPERTIES('operation'='insert','column'='user_id','regex'='[1]')),TYPE(NAME='SQL_HINT')))"
db-types="ShardingSphere" />
<sql-case id="alter-sharding-auto-table-rule" value="ALTER SHARDING TABLE
RULE t_order (STORAGE_UNITS(ms_group_0,ms_group_1), SHARDING_COLUMN=order_id,
TYPE(NAME='hash_mod',PROPERTIES('sharding-count'='4')),KEY_GENERATE_STRATEGY(COLUMN=another_id,TYPE(NAME='snowflake')))"
db-types="ShardingSphere" />
<sql-case id="alter-sharding-auto-table-rule-with-inline-expression"
value="ALTER SHARDING TABLE RULE t_order (STORAGE_UNITS('ms_group_${0..1}'),
SHARDING_COLUMN=order_id,
TYPE(NAME='hash_mod',PROPERTIES('sharding-count'='4')),KEY_GENERATE_STRATEGY(COLUMN=another_id,TYPE(NAME='snowflake')))"
db-types="ShardingSphere" />
<sql-case id="alter-sharding-auto-table-rule-with-auditor" value="ALTER
SHARDING TABLE RULE t_order (STORAGE_UNITS('ms_group_${0..1}'),
SHARDING_COLUMN=order_id,
TYPE(NAME='hash_mod',PROPERTIES('sharding-count'='4')),KEY_GENERATE_STRATEGY(COLUMN=another_id,TYPE(NAME='snowflake')),AUDIT_STRATEGY(TYPE(NAME='DML_SHARDING_CONDITIONS'),ALLOW_HINT_DISABLE=true))"
db-types="ShardingSphere" />
<sql-case id="alter-sharding-table-reference-rule" value="ALTER SHARDING
TABLE REFERENCE RULE reference_0 (t_order,t_order_item), reference_1 (t_1,t_2)"
db-types="ShardingSphere" />
- <sql-case id="alter-sharding-table-rule" value="ALTER SHARDING TABLE RULE
t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column
=
order_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column =
user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),KEY_GENERATE_STRATEGY(COLUMN=another_ [...]
- <sql-case id="alter-sharding-table-rule-complex" value="ALTER SHARDING
TABLE RULE t_order
(DATANODES('ms_group_${0..1}_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='complex',sharding_columns
= order_id,user_id,
sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}_${user_id % 2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column =
user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')) [...]
- <sql-case id="alter-sharding-table-rule-with-auditor" value="ALTER
SHARDING TABLE RULE t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column
=
order_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column =
user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),KEY_GENERATE_STRATEGY(CO [...]
+ <sql-case id="alter-sharding-table-rule" value="ALTER SHARDING TABLE RULE
t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column=order_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
%
2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column=user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),KEY_GENERATE_STRATEGY(COLUMN=another_id,T [...]
+ <sql-case id="alter-sharding-table-rule-complex" value="ALTER SHARDING
TABLE RULE t_order
(DATANODES('ms_group_${0..1}_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='complex',sharding_columns=order_id,user_id,
sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}_${user_id %
2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column=user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),K [...]
+ <sql-case id="alter-sharding-table-rule-with-auditor" value="ALTER
SHARDING TABLE RULE t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column=order_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
%
2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column=user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),KEY_GENERATE_STRATEGY(COLUMN [...]
<sql-case
id="alter-sharding-table-rule-with-complex-table-strategy-and-standard-database-strategy"
value="ALTER SHARDING TABLE RULE t_order_item
(DATANODES('ds_${0..1}.t_order_item_${0..1}'),
DATABASE_STRATEGY(TYPE='standard',SHARDING_COLUMN=user_id,SHARDING_ALGORITHM(TYPE(NAME='inline',PROPERTIES('algorithm-expression'='ds_${user_id
% 2}')))),
TABLE_STRATEGY(TYPE='complex',SHARDING_COLUMNS=user_id,order_id,SHARDING_ALGORITHM(TYPE(NAME='complex_inline',PROPERTIES('algorithm-expressi
[...]
<sql-case
id="alter-sharding-table-rule-with-none-table-strategy-and-hint-database-strategy"
value="ALTER SHARDING TABLE RULE t_order_item
(DATANODES('ds_${0..1}.t_order_item_${0..1}'),
DATABASE_STRATEGY(TYPE='hint',SHARDING_COLUMN=user_id,SHARDING_ALGORITHM(TYPE(NAME='hint_inline',PROPERTIES('algorithm-expression'='ds_${user_id
% 2}')))), TABLE_STRATEGY(TYPE='none'));" db-types="ShardingSphere" />
<sql-case id="alter-default-sharding-strategy" value="ALTER DEFAULT
SHARDING TABLE STRATEGY(TYPE='standard', SHARDING_COLUMN=order_id,
SHARDING_ALGORITHM(TYPE(NAME='INLINE',PROPERTIES('algorithm-expression'='t_order_${order_id
% 2}'))))" db-types="ShardingSphere" />
diff --git a/test/it/parser/src/main/resources/sql/supported/rdl/create.xml
b/test/it/parser/src/main/resources/sql/supported/rdl/create.xml
index 7ba52f0ccef..a81cbdecad8 100644
--- a/test/it/parser/src/main/resources/sql/supported/rdl/create.xml
+++ b/test/it/parser/src/main/resources/sql/supported/rdl/create.xml
@@ -39,10 +39,10 @@
<sql-case id="create-readwrite-splitting-rule" value="CREATE
READWRITE_SPLITTING RULE ms_group_0 (WRITE_STORAGE_UNIT=primary_ds,
READ_STORAGE_UNITS(replica_ds_0,replica_ds_1), TYPE(NAME='random'))"
db-types="ShardingSphere" />
<sql-case id="create-readwrite-splitting-rule-if-not-exists" value="CREATE
READWRITE_SPLITTING RULE IF NOT EXISTS ms_group_0
(WRITE_STORAGE_UNIT=primary_ds, READ_STORAGE_UNITS(replica_ds_0,replica_ds_1),
TYPE(NAME='random'))" db-types="ShardingSphere" />
<sql-case
id="create-readwrite-splitting-rule-with-transactional-read-query-strategy"
value="CREATE READWRITE_SPLITTING RULE ms_group_0
(WRITE_STORAGE_UNIT=primary_ds, READ_STORAGE_UNITS(replica_ds_0,replica_ds_1),
TRANSACTIONAL_READ_QUERY_STRATEGY='DYNAMIC', TYPE(NAME='random'))"
db-types="ShardingSphere" />
- <sql-case id="create-encrypt-rule" value="CREATE ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc')))),
(NAME=order_id, CIPHER =order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))))"
db-types="ShardingSphere" />
- <sql-case id="create-encrypt-rule-if-not-exists" value="CREATE ENCRYPT
RULE IF NOT EXISTS t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc')))),
(NAME=order_id, CIPHER =order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))))"
db-types="ShardingSphere" />
- <sql-case id="create-encrypt-rule-with-assisted-query-column"
value="CREATE ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ASSISTED_QUERY_COLUMN=assisted_column,
ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
ASSISTED_QUERY_ALGORITHM(TYPE(NAME='MD5'))), (NAME=order_id, CIPHER
=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))))" db-types="ShardingSphere"
/>
- <sql-case id="create-encrypt-rule-with-like-query-column" value="CREATE
ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,LIKE_QUERY_COLUMN=like_column,
ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
LIKE_QUERY_ALGORITHM(TYPE(NAME='CHAR_DIGEST_LIKE'))), (NAME=order_id, CIPHER
=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))))" db-types="ShardingSphere"
/>
+ <sql-case id="create-encrypt-rule" value="CREATE ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc')))),
(NAME=order_id,
CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='RC4',PROPERTIES('rc4-key-value'='123456abc'))))))"
db-types="ShardingSphere" />
+ <sql-case id="create-encrypt-rule-if-not-exists" value="CREATE ENCRYPT
RULE IF NOT EXISTS t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc')))),
(NAME=order_id,
CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='RC4',PROPERTIES('rc4-key-value'='123456abc'))))))"
db-types="ShardingSphere" />
+ <sql-case id="create-encrypt-rule-with-assisted-query-column"
value="CREATE ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ASSISTED_QUERY_COLUMN=assisted_column,
ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
ASSISTED_QUERY_ALGORITHM(TYPE(NAME='MD5'))), (NAME=order_id,
CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='RC4',PROPERTIES('rc4-key-value'='123456abc'))))))"
db-types="ShardingSphere" />
+ <sql-case id="create-encrypt-rule-with-like-query-column" value="CREATE
ENCRYPT RULE t_encrypt
(COLUMNS((NAME=user_id,CIPHER=user_cipher,LIKE_QUERY_COLUMN=like_column,
ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
LIKE_QUERY_ALGORITHM(TYPE(NAME='CHAR_DIGEST_LIKE'))), (NAME=order_id,
CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='RC4',PROPERTIES('rc4-key-value'='123456abc'))))))"
db-types="ShardingSphere" />
<sql-case id="create-shadow-rule" value="CREATE SHADOW RULE
shadow_rule(SOURCE=demo_ds,SHADOW=demo_ds_shadow,t_order(TYPE(NAME='REGEX_MATCH',PROPERTIES('operation'='insert','column'='user_id','regex'='[1]')),TYPE(NAME='SQL_HINT')))"
db-types="ShardingSphere" />
<sql-case id="create-shadow-rule-if-not-exists" value="CREATE SHADOW RULE
IF NOT EXISTS
shadow_rule(SOURCE=demo_ds,SHADOW=demo_ds_shadow,t_order(TYPE(NAME='REGEX_MATCH',PROPERTIES('operation'='insert','column'='user_id','regex'='[1]')),TYPE(NAME='SQL_HINT')))"
db-types="ShardingSphere" />
<sql-case id="create-default-sharding-table-strategy-with-lower-case"
value="create default sharding table strategy(type='standard',
sharding_column=order_id,
SHARDING_ALGORITHM(TYPE(NAME='INLINE',PROPERTIES('algorithm-expression'='t_order_${order_id
% 2}'))))" db-types="ShardingSphere" />
@@ -55,23 +55,23 @@
<sql-case
id="create-default-sharding-database-strategy-with-none-strategy-type"
value="CREATE DEFAULT SHARDING DATABASE STRATEGY (TYPE='none');"
db-types="ShardingSphere" />
<sql-case id="create-default-sharding-database-strategy" value="CREATE
DEFAULT SHARDING DATABASE STRATEGY(TYPE='STANDARD', SHARDING_COLUMN=ORDER_ID,
SHARDING_ALGORITHM(TYPE(NAME='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}'))))" db-types="ShardingSphere" />
<sql-case id="create-default-sharding-database-strategy-if-not-exists"
value="CREATE DEFAULT SHARDING DATABASE STRATEGY IF NOT EXISTS
(TYPE='STANDARD', SHARDING_COLUMN=ORDER_ID,
SHARDING_ALGORITHM(TYPE(NAME='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}'))))" db-types="ShardingSphere" />
- <sql-case id="create-sharding-table-rule" value="CREATE SHARDING TABLE
RULE t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column
=
order_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column =
user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),KEY_GENERATE_STRATEGY(COLUMN=anothe [...]
- <sql-case id="create-sharding-table-rule-with-enum-inline-expression"
value="CREATE SHARDING TABLE RULE t_order
(DATANODES("ms_group_${['abc','ac']}.t_order_${0..1}"),DATABASE_STRATEGY(TYPE='standard',sharding_column
=
order_name,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_{order_name}')))),TABLE_STRATEGY(TYPE='standard',sharding_column
=
user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
[...]
- <sql-case id="create-sharding-table-rule-complex" value="CREATE SHARDING
TABLE RULE t_order
(DATANODES('ms_group_${0..1}_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='complex',sharding_columns
=
order_id,user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}_${user_id % 2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column =
user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}') [...]
+ <sql-case id="create-sharding-table-rule" value="CREATE SHARDING TABLE
RULE t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column=order_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
%
2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column=user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),KEY_GENERATE_STRATEGY(COLUMN=another_id [...]
+ <sql-case id="create-sharding-table-rule-with-enum-inline-expression"
value="CREATE SHARDING TABLE RULE t_order
(DATANODES("ms_group_${['abc','ac']}.t_order_${0..1}"),DATABASE_STRATEGY(TYPE='standard',sharding_column=order_name,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_{order_name}')))),TABLE_STRATEGY(TYPE='standard',sharding_column=user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2} [...]
+ <sql-case id="create-sharding-table-rule-complex" value="CREATE SHARDING
TABLE RULE t_order
(DATANODES('ms_group_${0..1}_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='complex',sharding_columns=order_id,user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}_${user_id %
2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column=user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))), [...]
<sql-case
id="create-sharding-table-rule-with-complex-table-strategy-and-standard-database-strategy"
value="CREATE SHARDING TABLE RULE t_order_item
(DATANODES('ds_${0..1}.t_order_item_${0..1}'),
DATABASE_STRATEGY(TYPE='standard',SHARDING_COLUMN=user_id,SHARDING_ALGORITHM(TYPE(NAME='inline',PROPERTIES('algorithm-expression'='ds_${user_id
% 2}')))),
TABLE_STRATEGY(TYPE='complex',SHARDING_COLUMNS=user_id,order_id,SHARDING_ALGORITHM(TYPE(NAME='complex_inline',PROPERTIES('algorithm-expres
[...]
<sql-case
id="create-sharding-table-rule-with-none-table-strategy-and-hint-database-strategy"
value="CREATE SHARDING TABLE RULE t_order_item
(DATANODES('ds_${0..1}.t_order_item_${0..1}'),
DATABASE_STRATEGY(TYPE='hint',SHARDING_COLUMN=user_id,SHARDING_ALGORITHM(TYPE(NAME='hint_inline',PROPERTIES('algorithm-expression'='ds_${user_id
% 2}')))), TABLE_STRATEGY(TYPE='none'));" db-types="ShardingSphere" />
- <sql-case id="create-sharding-table-rule-with-auto-create-algorithm"
value="CREATE SHARDING TABLE RULE t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column
=
order_id,sharding_algorithm(TYPE(NAME='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column =
user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),KEY_GENE [...]
- <sql-case id="create-sharding-table-rule-with-auditor" value="CREATE
SHARDING TABLE RULE t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column
=
order_id,sharding_algorithm(TYPE(NAME='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column =
user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),KEY_GENERATE_STRATEGY( [...]
- <sql-case id="create-sharding-table-rule-with-auditor-if-not-exists"
value="CREATE SHARDING TABLE RULE IF NOT EXISTS t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column
=
order_id,sharding_algorithm(TYPE(NAME='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
% 2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column =
user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2} [...]
+ <sql-case id="create-sharding-table-rule-with-auto-create-algorithm"
value="CREATE SHARDING TABLE RULE t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column=order_id,sharding_algorithm(TYPE(NAME='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
%
2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column=user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),KEY_GENERATE [...]
+ <sql-case id="create-sharding-table-rule-with-auditor" value="CREATE
SHARDING TABLE RULE t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column=order_id,sharding_algorithm(TYPE(NAME='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
%
2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column=user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}')))),KEY_GENERATE_STRATEGY(COLU [...]
+ <sql-case id="create-sharding-table-rule-with-auditor-if-not-exists"
value="CREATE SHARDING TABLE RULE IF NOT EXISTS t_order
(DATANODES('ms_group_${0..1}.t_order_${0..1}'),DATABASE_STRATEGY(TYPE='standard',sharding_column=order_id,sharding_algorithm(TYPE(NAME='INLINE',PROPERTIES('algorithm-expression'='ms_group_${order_id
%
2}')))),TABLE_STRATEGY(TYPE='standard',sharding_column=user_id,sharding_algorithm(type(name='INLINE',PROPERTIES('algorithm-expression'='t_order_${user_id
% 2}'))) [...]
<sql-case id="create-default-shadow-algorithm" value="CREATE DEFAULT
SHADOW ALGORITHM TYPE(NAME='HINT', PROPERTIES('shadow'='true', 'foo'='bar'))"
db-types="ShardingSphere" />
<sql-case id="create-default-shadow-algorithm-if-not-exists" value="CREATE
DEFAULT SHADOW ALGORITHM IF NOT EXISTS TYPE(NAME='HINT',
PROPERTIES('shadow'='true', 'foo'='bar'))" db-types="ShardingSphere" />
- <sql-case id="set-default-single-table-storage-unit" value="SET DEFAULT
SINGLE TABLE STORAGE UNIT = ds_0" db-types="ShardingSphere" />
- <sql-case id="set-default-single-table-storage-unit-random" value="SET
DEFAULT SINGLE TABLE STORAGE UNIT = RANDOM" db-types="ShardingSphere" />
+ <sql-case id="set-default-single-table-storage-unit" value="SET DEFAULT
SINGLE TABLE STORAGE UNIT=ds_0" db-types="ShardingSphere" />
+ <sql-case id="set-default-single-table-storage-unit-random" value="SET
DEFAULT SINGLE TABLE STORAGE UNIT=RANDOM" db-types="ShardingSphere" />
<sql-case id="register-storage-unit-with-quota" value="REGISTER STORAGE
UNIT `ds_0`(HOST='127.0.0.1',PORT=3306,DB='test0',USER='ROOT');"
db-types="ShardingSphere" />
<sql-case id="create-sharding-auto-table-rule-with-quota" value="CREATE
SHARDING TABLE RULE `t_order` (STORAGE_UNITS(ms_group_0,ms_group_1),
SHARDING_COLUMN=order_id,TYPE(NAME='hash_mod',PROPERTIES('sharding-count'='4')),
KEY_GENERATE_STRATEGY(COLUMN=another_id,TYPE(NAME='snowflake')))"
db-types="ShardingSphere" />
<sql-case id="create-broadcast-table-rule-with-quota" value="CREATE
BROADCAST TABLE RULE `t_1`,`t_2` " db-types="ShardingSphere" />
<sql-case id="create-readwrite-splitting-rule-with-quota" value="CREATE
READWRITE_SPLITTING RULE `ms_group_0` (WRITE_STORAGE_UNIT=primary_ds,
READ_STORAGE_UNITS(replica_ds_0,replica_ds_1), TYPE(NAME='random'))"
db-types="ShardingSphere" />
- <sql-case id="create-encrypt-rule-with-quota" value="CREATE ENCRYPT RULE
`encrypt`
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc')))),
(NAME=order_id, CIPHER =order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))))"
db-types="ShardingSphere" />
+ <sql-case id="create-encrypt-rule-with-quota" value="CREATE ENCRYPT RULE
`encrypt`
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc')))),
(NAME=order_id,
CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='RC4',PROPERTIES('rc4-key-value'='123456abc'))))))"
db-types="ShardingSphere" />
<sql-case id="create-encrypt-rule-with-query-with-cipher-column"
value="CREATE ENCRYPT RULE `encrypt`
(COLUMNS((NAME=user_id,CIPHER=user_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))))))"
db-types="ShardingSphere" />
<sql-case id="create-shadow-rule-with-quota" value="CREATE SHADOW RULE
`shadow_rule`(SOURCE=demo_ds,SHADOW=demo_ds_shadow,t_order(TYPE(NAME='REGEX_MATCH',PROPERTIES('operation'='insert','column'='user_id','regex'='[1]')),TYPE(NAME='SQL_HINT')))"
db-types="ShardingSphere" />
<sql-case id="single-register-migration-source-storage-unit"
value="REGISTER MIGRATION SOURCE STORAGE UNIT ds_0
(URL='jdbc:mysql://127.0.0.1:3306/test0',USER='ROOT',PASSWORD='123456');"
db-types="ShardingSphere" />
