You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/08/16 09:54:04 UTC

[GitHub] [shardingsphere] RaigorJiang opened a new pull request #11845: For #11677, update documents of RAL

RaigorJiang opened a new pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845


   For #11677, update documents of RAL
   
   Changes proposed in this pull request:
   - change SCTL to RAL
   - update documents content for new sytax
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on a change in pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on a change in pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#discussion_r689424890



##########
File path: docs/document/content/features/dist-sql/_index.cn.md
##########
@@ -16,11 +16,11 @@ DistSQL（Distributed SQL）是 Apache ShardingSphere 特有的内置 SQL 语言
 
 DistSQL 让用户可以像操作数据库一样操作 Apache ShardingSphere，使其从面向开发人员的框架和中间件转变为面向运维人员的基础设施产品。
 
-DistSQL 划分为 RDL、RQL 和 SCTL 这三种具体类型。
+DistSQL 划分为 RDL、RQL 和 RAL 这三种具体类型。
 
  - RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除；
  - RQL（Resource & Rule Query Language）负责资源和规则的查询和展现；
- - SCTL（ShardingSphere Control Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+ - RAL（Resource & Rule Administrate Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
 

Review comment:
       https://shardingsphere.apache.org/blog/cn/material/jul_26_an_introduction_to_distsql/




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on a change in pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on a change in pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#discussion_r689439199



##########
File path: docs/document/content/features/dist-sql/_index.cn.md
##########
@@ -16,11 +16,11 @@ DistSQL（Distributed SQL）是 Apache ShardingSphere 特有的内置 SQL 语言
 
 DistSQL 让用户可以像操作数据库一样操作 Apache ShardingSphere，使其从面向开发人员的框架和中间件转变为面向运维人员的基础设施产品。
 
-DistSQL 划分为 RDL、RQL 和 SCTL 这三种具体类型。
+DistSQL 划分为 RDL、RQL 和 RAL 这三种具体类型。
 
  - RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除；
  - RQL（Resource & Rule Query Language）负责资源和规则的查询和展现；
- - SCTL（ShardingSphere Control Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+ - RAL（Resource & Rule Administrate Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
 

Review comment:
       > `Administrate`? what's the exact definition of `DAL` acronym of MySQL?
   
   There is no definition of DAL in the mysql vocabulary. https://dev.mysql.com/doc/refman/8.0/en/glossary.html#glos_ddl




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on a change in pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on a change in pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#discussion_r689426860



##########
File path: docs/document/content/features/dist-sql/syntax/ral/ral.en.md
##########
@@ -0,0 +1,28 @@
++++
+title = "RAL"
+weight = 1
++++
+
+## Definition
+
+RAL (Resource & Rule Administrate Language) responsible for the added-on feature of hint, transaction type switch, sharding execute planning and so on.
+
+## Usage
+
+| Statement                                          | Function                                                                                                   | Example                                       |
+|:---------------------------------------------------|:-----------------------------------------------------------------------------------------------------------|:----------------------------------------------|
+|set variable transaction_type = xx                  | Modify transaction_type of the current connection, supports LOCAL, XA, BASE                                | set variable transaction_type = XA            |
+|show variable transaction_type                      | Query the transaction type of the current connection                                                       | show variable transaction_type                |
+|show variable cached_connections                    | Query the number of cached physical database connections in the current connection                         | show variable cached_connections              |
+|preview SQL                                         | Preview the actual SQL                                                                                     | preview select * from t_order                 |

Review comment:
       good suggestion




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on a change in pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on a change in pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#discussion_r689431512



##########
File path: docs/document/content/features/dist-sql/syntax/ral/ral.en.md
##########
@@ -0,0 +1,28 @@
++++
+title = "RAL"
+weight = 1
++++
+
+## Definition
+
+RAL (Resource & Rule Administrate Language) responsible for the added-on feature of hint, transaction type switch, sharding execute planning and so on.
+
+## Usage
+
+| Statement                                          | Function                                                                                                   | Example                                       |
+|:---------------------------------------------------|:-----------------------------------------------------------------------------------------------------------|:----------------------------------------------|
+|set variable transaction_type = xx                  | Modify transaction_type of the current connection, supports LOCAL, XA, BASE                                | set variable transaction_type = XA            |
+|show variable transaction_type                      | Query the transaction type of the current connection                                                       | show variable transaction_type                |
+|show variable cached_connections                    | Query the number of cached physical database connections in the current connection                         | show variable cached_connections              |
+|preview SQL                                         | Preview the actual SQL                                                                                     | preview select * from t_order                 |
+|set readwrite_splitting hint source = [auto / write]| For current connection, set readwrite splitting routing strategy (automatic or forced to write data source)| set readwrite_splitting hint source = write   |
+|set sharding hint database_value = yy               | For current connection, set sharding value for database sharding only, yy: sharding value                  | set sharding hint database_value = 100        |
+|add sharding hint database_value xx= yy             | For current connection, add sharding value for table, xx: logic table, yy: database sharding value         | add sharding hint database_value t_order= 100 |
+|add sharding hint table_value xx = yy               | For current connection, add sharding value for table, xx: logic table, yy: table sharding value            | add sharding hint table_value t_order = 100   |
+|clear hint                                          | For current connection, clear all hint settings                                                            | clear hint                                    |
+|clear [sharding hint / readwrite_splitting hint]    | For current connection, clear hint settings of sharding or readwrite splitting                             | clear readwrite_splitting hint                |

Review comment:
       Oh, this question is too timely, we really should not update the document before the #11838 merged.




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on a change in pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on a change in pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#discussion_r689424170



##########
File path: docs/document/content/features/dist-sql/_index.cn.md
##########
@@ -16,11 +16,11 @@ DistSQL（Distributed SQL）是 Apache ShardingSphere 特有的内置 SQL 语言
 
 DistSQL 让用户可以像操作数据库一样操作 Apache ShardingSphere，使其从面向开发人员的框架和中间件转变为面向运维人员的基础设施产品。
 
-DistSQL 划分为 RDL、RQL 和 SCTL 这三种具体类型。
+DistSQL 划分为 RDL、RQL 和 RAL 这三种具体类型。
 
  - RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除；
  - RQL（Resource & Rule Query Language）负责资源和规则的查询和展现；
- - SCTL（ShardingSphere Control Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+ - RAL（Resource & Rule Administrate Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
 

Review comment:
       Yes, 'Administrate', this explanation comes from our blog.




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero merged pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
tristaZero merged pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] codecov-commenter commented on pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
codecov-commenter commented on pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#issuecomment-899483826


   # [Codecov](https://codecov.io/gh/apache/shardingsphere/pull/11845?src=pr&el=h1&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation) Report
   > Merging [#11845](https://codecov.io/gh/apache/shardingsphere/pull/11845?src=pr&el=desc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation) (6b06515) into [master](https://codecov.io/gh/apache/shardingsphere/commit/183f3b85e3ccea9fc410c91f7f4488ed8cc85b3b?el=desc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation) (183f3b8) will **decrease** coverage by `0.04%`.
   > The diff coverage is `n/a`.
   
   [![Impacted file tree graph](https://codecov.io/gh/apache/shardingsphere/pull/11845/graphs/tree.svg?width=650&height=150&src=pr&token=ZvlXpWa7so&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation)](https://codecov.io/gh/apache/shardingsphere/pull/11845?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation)
   
   ```diff
   @@             Coverage Diff              @@
   ##             master   #11845      +/-   ##
   ============================================
   - Coverage     63.43%   63.38%   -0.05%     
   + Complexity     1202     1200       -2     
   ============================================
     Files          2308     2308              
     Lines         34939    34926      -13     
     Branches       6077     6070       -7     
   ============================================
   - Hits          22164    22139      -25     
   - Misses        10982    11002      +20     
   + Partials       1793     1785       -8     
   ```
   
   
   | [Impacted Files](https://codecov.io/gh/apache/shardingsphere/pull/11845?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation) | Coverage Δ | |
   |---|---|---|
   | [...tor/dml/impl/ShardingSelectStatementValidator.java](https://codecov.io/gh/apache/shardingsphere/pull/11845/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation#diff-c2hhcmRpbmdzcGhlcmUtZmVhdHVyZXMvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmcvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmctY29yZS9zcmMvbWFpbi9qYXZhL29yZy9hcGFjaGUvc2hhcmRpbmdzcGhlcmUvc2hhcmRpbmcvcm91dGUvZW5naW5lL3ZhbGlkYXRvci9kbWwvaW1wbC9TaGFyZGluZ1NlbGVjdFN0YXRlbWVudFZhbGlkYXRvci5qYXZh) | `33.33% <0.00%> (-44.45%)` | :arrow_down: |
   | [...e/validator/dml/ShardingDMLStatementValidator.java](https://codecov.io/gh/apache/shardingsphere/pull/11845/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation#diff-c2hhcmRpbmdzcGhlcmUtZmVhdHVyZXMvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmcvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmctY29yZS9zcmMvbWFpbi9qYXZhL29yZy9hcGFjaGUvc2hhcmRpbmdzcGhlcmUvc2hhcmRpbmcvcm91dGUvZW5naW5lL3ZhbGlkYXRvci9kbWwvU2hhcmRpbmdETUxTdGF0ZW1lbnRWYWxpZGF0b3IuamF2YQ==) | `33.33% <0.00%> (-34.53%)` | :arrow_down: |
   | [...e/validator/ShardingStatementValidatorFactory.java](https://codecov.io/gh/apache/shardingsphere/pull/11845/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation#diff-c2hhcmRpbmdzcGhlcmUtZmVhdHVyZXMvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmcvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmctY29yZS9zcmMvbWFpbi9qYXZhL29yZy9hcGFjaGUvc2hhcmRpbmdzcGhlcmUvc2hhcmRpbmcvcm91dGUvZW5naW5lL3ZhbGlkYXRvci9TaGFyZGluZ1N0YXRlbWVudFZhbGlkYXRvckZhY3RvcnkuamF2YQ==) | `10.81% <0.00%> (ø)` | |
   | [...ore/rule/FeaturedDistSQLStatementParserEngine.java](https://codecov.io/gh/apache/shardingsphere/pull/11845/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation#diff-c2hhcmRpbmdzcGhlcmUtZGlzdHNxbC1wYXJzZXIvc2hhcmRpbmdzcGhlcmUtZGlzdHNxbC1wYXJzZXItZW5naW5lL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9zaGFyZGluZ3NwaGVyZS9kaXN0c3FsL3BhcnNlci9jb3JlL3J1bGUvRmVhdHVyZWREaXN0U1FMU3RhdGVtZW50UGFyc2VyRW5naW5lLmphdmE=) | | |
   | [...featured/FeaturedDistSQLStatementParserEngine.java](https://codecov.io/gh/apache/shardingsphere/pull/11845/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation#diff-c2hhcmRpbmdzcGhlcmUtZGlzdHNxbC1wYXJzZXIvc2hhcmRpbmdzcGhlcmUtZGlzdHNxbC1wYXJzZXItZW5naW5lL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9zaGFyZGluZ3NwaGVyZS9kaXN0c3FsL3BhcnNlci9jb3JlL2ZlYXR1cmVkL0ZlYXR1cmVkRGlzdFNRTFN0YXRlbWVudFBhcnNlckVuZ2luZS5qYXZh) | `0.00% <0.00%> (ø)` | |
   | [...phere/sharding/route/engine/ShardingSQLRouter.java](https://codecov.io/gh/apache/shardingsphere/pull/11845/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation#diff-c2hhcmRpbmdzcGhlcmUtZmVhdHVyZXMvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmcvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmctY29yZS9zcmMvbWFpbi9qYXZhL29yZy9hcGFjaGUvc2hhcmRpbmdzcGhlcmUvc2hhcmRpbmcvcm91dGUvZW5naW5lL1NoYXJkaW5nU1FMUm91dGVyLmphdmE=) | `80.00% <0.00%> (+3.33%)` | :arrow_up: |
   | [...tor/dml/impl/ShardingInsertStatementValidator.java](https://codecov.io/gh/apache/shardingsphere/pull/11845/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation#diff-c2hhcmRpbmdzcGhlcmUtZmVhdHVyZXMvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmcvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmctY29yZS9zcmMvbWFpbi9qYXZhL29yZy9hcGFjaGUvc2hhcmRpbmdzcGhlcmUvc2hhcmRpbmcvcm91dGUvZW5naW5lL3ZhbGlkYXRvci9kbWwvaW1wbC9TaGFyZGluZ0luc2VydFN0YXRlbWVudFZhbGlkYXRvci5qYXZh) | `88.23% <0.00%> (+4.90%)` | :arrow_up: |
   | [...ing/route/engine/condition/ShardingConditions.java](https://codecov.io/gh/apache/shardingsphere/pull/11845/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation#diff-c2hhcmRpbmdzcGhlcmUtZmVhdHVyZXMvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmcvc2hhcmRpbmdzcGhlcmUtc2hhcmRpbmctY29yZS9zcmMvbWFpbi9qYXZhL29yZy9hcGFjaGUvc2hhcmRpbmdzcGhlcmUvc2hhcmRpbmcvcm91dGUvZW5naW5lL2NvbmRpdGlvbi9TaGFyZGluZ0NvbmRpdGlvbnMuamF2YQ==) | `65.00% <0.00%> (+22.14%)` | :arrow_up: |
   
   ------
   
   [Continue to review full report at Codecov](https://codecov.io/gh/apache/shardingsphere/pull/11845?src=pr&el=continue&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation).
   > **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation)
   > `Δ = absolute <relative> (impact)`, `ø = not affected`, `? = missing data`
   > Powered by [Codecov](https://codecov.io/gh/apache/shardingsphere/pull/11845?src=pr&el=footer&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation). Last update [183f3b8...6b06515](https://codecov.io/gh/apache/shardingsphere/pull/11845?src=pr&el=lastupdated&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation).
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on a change in pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
tristaZero commented on a change in pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#discussion_r690176291



##########
File path: docs/blog/content/material/solution.cn.md
##########
@@ -206,7 +206,7 @@ Apache ShardingSphere（Incubating）的目标是像使用一个数据库一样
 
 
 
-1.通过SCTL（sharding-ctl，即ShardingSphere提供的数据库管理命令）切换当前事务类型。以SQL执行的方式输入即可，适用于Sharding-JDBC和Sharding-Proxy。例如：SCTL:SET TRANSACTION_TYPE=BASE
+1.通过 RAL（Resource & Rule Administration Language）切换当前事务类型。以 SQL 执行的方式输入即可，适用于 Sharding-JDBC 和 Sharding-Proxy。例如：SET VARIABLE TRANSACTION_TYPE=BASE

Review comment:
       This feature is unsupported in JDBC, right?

##########
File path: docs/blog/content/material/solution.cn.md
##########
@@ -206,7 +206,7 @@ Apache ShardingSphere（Incubating）的目标是像使用一个数据库一样
 
 
 
-1.通过SCTL（sharding-ctl，即ShardingSphere提供的数据库管理命令）切换当前事务类型。以SQL执行的方式输入即可，适用于Sharding-JDBC和Sharding-Proxy。例如：SCTL:SET TRANSACTION_TYPE=BASE
+1.通过 RAL（Resource & Rule Administration Language）切换当前事务类型。以 SQL 执行的方式输入即可，适用于 Sharding-JDBC 和 Sharding-Proxy。例如：SET VARIABLE TRANSACTION_TYPE=BASE

Review comment:
       Sharding-JDBC(TODO)




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on a change in pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
tristaZero commented on a change in pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#discussion_r689420193



##########
File path: docs/document/content/features/dist-sql/syntax/ral/ral.cn.md
##########
@@ -0,0 +1,28 @@
++++
+title = "RAL"
+weight = 1
++++
+
+## 定义
+
+RAL (Resource & Rule Administrate Language) 为 Apache ShardingSphere 的管理语言，负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+
+## 使用实战
+
+| 语句                                                | 说明                                                           | 示例                                           |
+|:---------------------------------------------------|:--------------------------------------------------------------|:-----------------------------------------------|
+|set variable transaction_type = xx                  | 修改当前连接的事务类型, 支持LOCAL，XA，BASE                         | set variable transaction_type = XA            |  

Review comment:
       Do we have the default value?

##########
File path: docs/document/content/features/dist-sql/_index.cn.md
##########
@@ -16,11 +16,11 @@ DistSQL（Distributed SQL）是 Apache ShardingSphere 特有的内置 SQL 语言
 
 DistSQL 让用户可以像操作数据库一样操作 Apache ShardingSphere，使其从面向开发人员的框架和中间件转变为面向运维人员的基础设施产品。
 
-DistSQL 划分为 RDL、RQL 和 SCTL 这三种具体类型。
+DistSQL 划分为 RDL、RQL 和 RAL 这三种具体类型。
 
  - RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除；
  - RQL（Resource & Rule Query Language）负责资源和规则的查询和展现；
- - SCTL（ShardingSphere Control Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+ - RAL（Resource & Rule Administrate Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
 

Review comment:
       `Administrate`? what's the exact definition of `DAL` acronym of MySQL?

##########
File path: docs/document/content/features/dist-sql/_index.cn.md
##########
@@ -16,11 +16,11 @@ DistSQL（Distributed SQL）是 Apache ShardingSphere 特有的内置 SQL 语言
 
 DistSQL 让用户可以像操作数据库一样操作 Apache ShardingSphere，使其从面向开发人员的框架和中间件转变为面向运维人员的基础设施产品。
 
-DistSQL 划分为 RDL、RQL 和 SCTL 这三种具体类型。
+DistSQL 划分为 RDL、RQL 和 RAL 这三种具体类型。
 
  - RDL（Resource & Rule Definition Language）负责资源和规则的创建、修改和删除；
  - RQL（Resource & Rule Query Language）负责资源和规则的查询和展现；
- - SCTL（ShardingSphere Control Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+ - RAL（Resource & Rule Administrate Language）负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
 

Review comment:
       Administration? Administrator?

##########
File path: docs/document/content/features/dist-sql/syntax/ral/ral.en.md
##########
@@ -0,0 +1,28 @@
++++
+title = "RAL"
+weight = 1
++++
+
+## Definition
+
+RAL (Resource & Rule Administrate Language) responsible for the added-on feature of hint, transaction type switch, sharding execute planning and so on.
+
+## Usage
+
+| Statement                                          | Function                                                                                                   | Example                                       |
+|:---------------------------------------------------|:-----------------------------------------------------------------------------------------------------------|:----------------------------------------------|
+|set variable transaction_type = xx                  | Modify transaction_type of the current connection, supports LOCAL, XA, BASE                                | set variable transaction_type = XA            |
+|show variable transaction_type                      | Query the transaction type of the current connection                                                       | show variable transaction_type                |
+|show variable cached_connections                    | Query the number of cached physical database connections in the current connection                         | show variable cached_connections              |
+|preview SQL                                         | Preview the actual SQL                                                                                     | preview select * from t_order                 |

Review comment:
       actual SQL**s**

##########
File path: docs/document/content/features/dist-sql/syntax/ral/ral.en.md
##########
@@ -0,0 +1,28 @@
++++
+title = "RAL"
+weight = 1
++++
+
+## Definition
+
+RAL (Resource & Rule Administrate Language) responsible for the added-on feature of hint, transaction type switch, sharding execute planning and so on.
+
+## Usage
+
+| Statement                                          | Function                                                                                                   | Example                                       |
+|:---------------------------------------------------|:-----------------------------------------------------------------------------------------------------------|:----------------------------------------------|
+|set variable transaction_type = xx                  | Modify transaction_type of the current connection, supports LOCAL, XA, BASE                                | set variable transaction_type = XA            |
+|show variable transaction_type                      | Query the transaction type of the current connection                                                       | show variable transaction_type                |
+|show variable cached_connections                    | Query the number of cached physical database connections in the current connection                         | show variable cached_connections              |
+|preview SQL                                         | Preview the actual SQL                                                                                     | preview select * from t_order                 |
+|set readwrite_splitting hint source = [auto / write]| For current connection, set readwrite splitting routing strategy (automatic or forced to write data source)| set readwrite_splitting hint source = write   |
+|set sharding hint database_value = yy               | For current connection, set sharding value for database sharding only, yy: sharding value                  | set sharding hint database_value = 100        |
+|add sharding hint database_value xx= yy             | For current connection, add sharding value for table, xx: logic table, yy: database sharding value         | add sharding hint database_value t_order= 100 |
+|add sharding hint table_value xx = yy               | For current connection, add sharding value for table, xx: logic table, yy: table sharding value            | add sharding hint table_value t_order = 100   |
+|clear hint                                          | For current connection, clear all hint settings                                                            | clear hint                                    |
+|clear [sharding hint / readwrite_splitting hint]    | For current connection, clear hint settings of sharding or readwrite splitting                             | clear readwrite_splitting hint                |

Review comment:
       Are they new API and features? All these functions were developed?




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on a change in pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on a change in pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#discussion_r690149537



##########
File path: docs/blog/content/material/ss_5.0.0beta.en.md
##########
@@ -1,117 +1,117 @@
-+++
-title = "Following 6 months of development Apache ShardingSphere 5.0.0-beta has been officially released!"
-weight = 14
-chapter = true
-+++
-
++++
+title = "Following 6 months of development Apache ShardingSphere 5.0.0-beta has been officially released!"

Review comment:
       These are not the content that I changed, it may be caused by the different line breaks. It was not `CRLF` before?




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on a change in pull request #11845: For #11677, update documents of RAL

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on a change in pull request #11845:
URL: https://github.com/apache/shardingsphere/pull/11845#discussion_r689429288



##########
File path: docs/document/content/features/dist-sql/syntax/ral/ral.cn.md
##########
@@ -0,0 +1,28 @@
++++
+title = "RAL"
+weight = 1
++++
+
+## 定义
+
+RAL (Resource & Rule Administrate Language) 为 Apache ShardingSphere 的管理语言，负责Hint、事务类型切换、分片执行计划查询等增量功能的操作。
+
+## 使用实战
+
+| 语句                                                | 说明                                                           | 示例                                           |
+|:---------------------------------------------------|:--------------------------------------------------------------|:-----------------------------------------------|
+|set variable transaction_type = xx                  | 修改当前连接的事务类型, 支持LOCAL，XA，BASE                         | set variable transaction_type = XA            |  

Review comment:
       Default value is "LOCAL":
   PROXY_TRANSACTION_TYPE("proxy-transaction-type", "LOCAL", String.class),




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org