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/06/23 08:52:00 UTC
[GitHub] [shardingsphere] monkeymada opened a new issue #10940: Sharding-JDBC 4.1.1 sets the hint cast policy. Why is there still some SQL that does not support the hint cast policy
monkeymada opened a new issue #10940:
URL: https://github.com/apache/shardingsphere/issues/10940
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
Sharding-JDBC 4.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
With the ShardingJDBC hint policy, the official website description can skip parsing and overwriting, but some SQL still does not support, such as multi-table association updates
### Actual behavior
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
--
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] strongduanmu commented on issue #10940: Sharding-JDBC 4.1.1 sets the hint cast policy. Why is there still some SQL that does not support the hint cast policy
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #10940:
URL: https://github.com/apache/shardingsphere/issues/10940#issuecomment-867300024
@monkeymada Hint provides a way to specify the sharding value from outside, user does not need to specify the sharding value in SQL, except for this, it is no different from other routing algorithms. The logic of parsing, verification, and routing will be executed normally.
--
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] RaigorJiang closed issue #10940: Sharding-JDBC 4.1.1 sets the hint cast policy. Why is there still some SQL that does not support the hint cast policy
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #10940:
URL: https://github.com/apache/shardingsphere/issues/10940
--
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 issue #10940: Sharding-JDBC 4.1.1 sets the hint cast policy. Why is there still some SQL that does not support the hint cast policy
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #10940:
URL: https://github.com/apache/shardingsphere/issues/10940#issuecomment-924750626
Since this issue has been inactive for more than 30 days, we will close it.
If you still have related questions, please submit a new issue, thank you.
--
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] Yule-Momoko commented on issue #10940: Sharding-JDBC 4.1.1 sets the hint cast policy. Why is there still some SQL that does not support the hint cast policy
Posted by GitBox <gi...@apache.org>.
Yule-Momoko commented on issue #10940:
URL: https://github.com/apache/shardingsphere/issues/10940#issuecomment-868147882
Nested subqueries, such as: select count(*) from (select * from t_order d) c
--
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