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 141f06d Add documents related to the default policy. (#14460)
141f06d is described below
commit 141f06df830e1f4d0abdeba26b7e474f282609ba
Author: lanchengx <[email protected]>
AuthorDate: Fri Dec 31 18:55:15 2021 +0800
Add documents related to the default policy. (#14460)
---
.../syntax/rdl/rule-definition/sharding.cn.md | 16 ++++++++---
.../syntax/rdl/rule-definition/sharding.en.md | 16 ++++++++---
.../distsql/syntax/rql/rule-query/sharding.cn.md | 26 ++++++++++++++++++
.../distsql/syntax/rql/rule-query/sharding.en.md | 31 ++++++++++++++++++++--
4 files changed, 81 insertions(+), 8 deletions(-)
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding.cn.md
index 5c2ed24..27bde2d 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding.cn.md
@@ -10,12 +10,16 @@ weight = 1
```sql
CREATE SHARDING TABLE RULE shardingTableRuleDefinition [,
shardingTableRuleDefinition] ...
-CREATE DEFAULT SHARDING shardingScope STRATEGY (shardingStrategy)
-
ALTER SHARDING TABLE RULE shardingTableRuleDefinition [,
shardingTableRuleDefinition] ...
DROP SHARDING TABLE RULE tableName [, tableName] ...
+CREATE DEFAULT SHARDING shardingScope STRATEGY (shardingStrategy)
+
+ALTER DEFAULT SHARDING shardingScope STRATEGY (shardingStrategy)
+
+DROP DEFAULT SHARDING shardingScope STRATEGY;
+
CREATE SHARDING ALGORITHM shardingAlgorithmDefinition [,
shardingAlgorithmDefinition] ...
ALTER SHARDING ALGORITHM shardingAlgorithmDefinition [,
shardingAlgorithmDefinition] ...
@@ -198,8 +202,14 @@ DROP SHARDING TABLE RULE t_order_item;
DROP SHARDING ALGORITHM database_inline;
CREATE DEFAULT SHARDING DATABASE STRATEGY (
-TYPE = standard,SHARDING_COLUMN=order_id,SHARDING_ALGORITHM=algorithmsName
+TYPE = standard,SHARDING_COLUMN=order_id,SHARDING_ALGORITHM=database_inline
+);
+
+ALTER DEFAULT SHARDING DATABASE STRATEGY (
+TYPE = standard,SHARDING_COLUMN=another_id,SHARDING_ALGORITHM=database_inline
);
+
+DROP DEFAULT SHARDING DATABASE STRATEGY;
```
### Sharding Binding Table Rule
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding.en.md
index 2d825b7..736e059 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding.en.md
@@ -10,12 +10,16 @@ weight = 1
```sql
CREATE SHARDING TABLE RULE shardingTableRuleDefinition [,
shardingTableRuleDefinition] ...
-CREATE DEFAULT SHARDING shardingScope STRATEGY (shardingStrategy)
-
ALTER SHARDING TABLE RULE shardingTableRuleDefinition [,
shardingTableRuleDefinition] ...
DROP SHARDING TABLE RULE tableName [, tableName] ...
+CREATE DEFAULT SHARDING shardingScope STRATEGY (shardingStrategy)
+
+ALTER DEFAULT SHARDING shardingScope STRATEGY (shardingStrategy)
+
+DROP DEFAULT SHARDING shardingScope STRATEGY;
+
CREATE SHARDING ALGORITHM shardingAlgorithmDefinition [,
shardingAlgorithmDefinition] ...
ALTER SHARDING ALGORITHM shardingAlgorithmDefinition [,
shardingAlgorithmDefinition] ...
@@ -198,8 +202,14 @@ DROP SHARDING TABLE RULE t_order_item;
DROP SHARDING ALGORITHM database_inline;
CREATE DEFAULT SHARDING DATABASE STRATEGY (
-TYPE = standard,SHARDING_COLUMN=order_id,SHARDING_ALGORITHM=algorithmsName
+TYPE = standard,SHARDING_COLUMN=order_id,SHARDING_ALGORITHM=database_inline
+);
+
+ALTER DEFAULT SHARDING DATABASE STRATEGY (
+TYPE = standard,SHARDING_COLUMN=another_id,SHARDING_ALGORITHM=database_inline
);
+
+DROP DEFAULT SHARDING DATABASE STRATEGY;
```
### Sharding Binding Table Rule
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding.cn.md
index c673cab..0d91f1e 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding.cn.md
@@ -12,6 +12,8 @@ SHOW SHARDING TABLE tableRule | RULES [FROM schemaName]
SHOW SHARDING ALGORITHMS [FROM schemaName]
+SHOW DEFAULT SHARDING STRATEGY
+
SHOW SHARDING TABLE NODES;
tableRule:
@@ -61,6 +63,17 @@ SHOW SHARDING BROADCAST TABLE RULES [FROM schemaName]
| type | 分片算法类型 |
| props | 分片算法参数 |
+### Default Sharding Strategy
+
+| 列 | 说明 |
+| --------------------------| -------------|
+| name | 策略名称 |
+| type | 分片策略类型 |
+| sharding_column | 分片键 |
+| sharding_algorithm_name | 分片算法名称 |
+| sharding_algorithm_type | 分片算法类型 |
+| sharding_algorithm_props | 分片算法参数 |
+
### Sharding Table Nodes
| 列 | 说明 |
@@ -120,6 +133,19 @@ mysql> show sharding algorithms;
2 row in set (0.01 sec)
```
+*SHOW DEFAULT SHARDING STRATEGY*
+```sql
+mysql> SHOW DEFAULT SHARDING STRATEGY ;
+
++----------+---------+--------------------+-------------------------+-------------------------+------------------------------------------+
+| name | type | sharding_column | sharding_algorithm_name |
sharding_algorithm_type | sharding_algorithm_props |
++----------+---------+--------------------+-------------------------+-------------------------+------------------------------------------+
+| TABLE | NONE | | |
| |
+| DATABASE | STANDARD| order_id | database_inline | INLINE
| {algorithm-expression=ds_${user_id % 2}} |
++----------+---------+--------------------+-------------------------+-------------------------+------------------------------------------+
+2 rows in set (0.07 sec)
+```
+
*SHOW SHARDING TABLE NODES*
```sql
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding.en.md
index 1c14333..b025b4e 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding.en.md
@@ -12,6 +12,8 @@ SHOW SHARDING TABLE tableRule | RULES [FROM schemaName]
SHOW SHARDING ALGORITHMS [FROM schemaName]
+SHOW DEFAULT SHARDING STRATEGY
+
SHOW SHARDING TABLE NODES;
tableRule:
@@ -47,8 +49,8 @@ SHOW SHARDING BROADCAST TABLE RULES [FROM schemaName]
| database_sharding_algorithm_props | Database sharding algorithm parameter
|
| table_strategy_type | Table sharding strategy type
|
| table_sharding_column | Table sharding column
|
-| table_sharding_algorithm_type | Database sharding algorithm type
|
-| table_sharding_algorithm_props | Database sharding algorithm parameter
|
+| table_sharding_algorithm_type | Table sharding algorithm type
|
+| table_sharding_algorithm_props | Table sharding algorithm parameter
|
| key_generate_column | Distributed primary key generation
column |
| key_generator_type | Distributed primary key generation type
|
| key_generator_props | Distributed primary key generation
parameter |
@@ -61,6 +63,18 @@ SHOW SHARDING BROADCAST TABLE RULES [FROM schemaName]
| type | Sharding algorithm type |
| props | Sharding algorithm parameters |
+
+### Default Sharding Strategy
+
+| Column | Description |
+| --------------------------| -------------------------------|
+| name | Strategy name |
+| type | Sharding strategy type |
+| sharding_column | Sharding column |
+| sharding_algorithm_name | Sharding algorithm name |
+| sharding_algorithm_type | Sharding algorithm type |
+| sharding_algorithm_props | Sharding algorithm properties |
+
### Sharding Table Nodes
| Column | Description |
@@ -120,6 +134,19 @@ mysql> show sharding algorithms;
2 row in set (0.01 sec)
```
+*SHOW DEFAULT SHARDING STRATEGY*
+```sql
+mysql> SHOW DEFAULT SHARDING STRATEGY ;
+
++----------+---------+--------------------+-------------------------+-------------------------+------------------------------------------+
+| name | type | sharding_column | sharding_algorithm_name |
sharding_algorithm_type | sharding_algorithm_props |
++----------+---------+--------------------+-------------------------+-------------------------+------------------------------------------+
+| TABLE | NONE | | |
| |
+| DATABASE | STANDARD| order_id | database_inline | INLINE
| {algorithm-expression=ds_${user_id % 2}} |
++----------+---------+--------------------+-------------------------+-------------------------+------------------------------------------+
+2 rows in set (0.07 sec)
+```
+
*SHOW SHARDING TABLE NODES*
```sql
