[GitHub] [shardingsphere] jackyLqq opened a new issue #9235: Sql hint support

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu commented on issue #9235: Sql hint support

[GitBox <gi...@apache.org>]

terrymanu commented on issue #9235:
URL: https://github.com/apache/shardingsphere/issues/9235#issuecomment-927273595


   It is better to use native SQL and transport shading operation.
   The hint just in the opposite.
   I prefer do not add this feature.


-- 
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