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 2022/11/04 06:49:17 UTC
[GitHub] [shardingsphere] doveylovey opened a new issue, #21953: Insert statement does not support sharding table routing to multiple data nodes.
doveylovey opened a new issue, #21953:
URL: https://github.com/apache/shardingsphere/issues/21953
## 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?
5.2.1 (5.2.2-SNAPSHOT has the same problem)
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
### Actual behavior
1. Why do we have ds_1 here?
2. Why do we have ds_0 here?
3. An insert error occurred
### 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).
https://github.com/apache/shardingsphere/blob/5.2.1/examples/shardingsphere-jdbc-example/single-feature-example/sharding-example/sharding-raw-jdbc-example/src/main/java/org/apache/shardingsphere/example/sharding/raw/jdbc/ShardingSQLCommentHintRawExample.java
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #21953: Insert statement does not support sharding table routing to multiple data nodes.
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #21953:
URL: https://github.com/apache/shardingsphere/issues/21953#issuecomment-1407550691
This is because the comment API of hint sql have been adjusted, resulting in the hint not taking effect.
Now #23189 restores this ability, please try the latest version.
--
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] strongduanmu commented on issue #21953: Insert statement does not support sharding table routing to multiple data nodes.
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #21953:
URL: https://github.com/apache/shardingsphere/issues/21953#issuecomment-1303053440
@doveylovey Please refer this issue #18620.
--
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 closed issue #21953: Insert statement does not support sharding table routing to multiple data nodes.
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #21953: Insert statement does not support sharding table routing to multiple data nodes.
URL: https://github.com/apache/shardingsphere/issues/21953
--
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] linghengqian commented on issue #21953: Insert statement does not support sharding table routing to multiple data nodes.
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #21953:
URL: https://github.com/apache/shardingsphere/issues/21953#issuecomment-1328774245
- It seems that for the keyGenerators of the primary key of the table is the example of SNOWFLAKE, the capabilities provided by https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/sharding/hint/ cannot handle it.
- So, what should be the direction of change for this example?
--
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