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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
