jackyLqq opened a new issue #9235:
URL: https://github.com/apache/shardingsphere/issues/9235
### database hint
Specify a data source to execute physical SQL
```sql
/* !databaseSharding(?)*/ actual sql
#example
/* !databaseSharding(ds_0)*/ select * from t_order_0
```
? mean datasourtceName
### sharding value hint
Route by sharding value,Only supports standard routing,Sharding conditions
will be ignored.
```sql
/* !shardingDatabaseValue(?..) shardingTableValue(?..) */ select * from
t_order
/* !shardingTableValue(?..) shardingDatabaseValue(?..) */ select * from
t_order
/* !shardingDatabaseValue(?..) */ select * from t_order
/* !shardingTableValue(?..) */ select * from t_order
#example
/* !shardingDatabaseValue(1) shardingTableValue(1) */ select * from t_order
/* !shardingDatabaseValue(1) shardingTableValue(1) */ select * from t_order
/* !shardingDatabaseValue(1,2) shardingTableValue(1,2) */ select * from
t_order
/* !shardingDatabaseValue(1) */ select * from t_order
/* !shardingTableValue(1) */ select * from t_order
```
? mean sharding value
### limitations
Single-line comments are not supported like /* */
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
