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/11/04 00:23:31 UTC
[GitHub] [shardingsphere] 5661954 opened a new issue #13430: batch Update statement use case statement get shardingvalue error
5661954 opened a new issue #13430:
URL: https://github.com/apache/shardingsphere/issues/13430
## Bug Report
### Which version of ShardingSphere did you use?
4.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
shardingsphere-jdbc
when i use the batch update sql like next:
update test
set a =case when id=? then ?
when id=? then ? end,
b =case when id=? then ?
when id=? then ? end,
c =case when id=? then ?
when id=? then ? end
where shard_id = ? AND id in (?, ?)
the parameters: 123832998204264448, ddab501493484145b23f1fefb5aadce0, 123824723966533632, d21eee1fa36a45a88b75c7ddce899918, 123832998204264448, 123832999030517760, 123824723966533632, 123824724314648576, 123832998204264448, BP320276354, 123824723966533632, BP320276352, 79ffca0e081a43f899486ef67148db77, 123832998204264448, 123824723966533632
the sharding column shard_id=79ffca0e081a43f899486ef67148db77 but actualy the sharding column value
is 123832998204264448
### Reason analyze (If you can)
the index of shard column pos should be 12,but the parse engine get the error index is 0
--
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] tuichenchuxin commented on issue #13430: batch Update statement use case statement get shardingvalue error
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #13430:
URL: https://github.com/apache/shardingsphere/issues/13430#issuecomment-961583610
@5661954 I have tested this issue on master branch, It's ok now.
Can you try 5.x version, we have optimized a lot.
--
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] tuichenchuxin commented on issue #13430: batch Update statement use case statement get shardingvalue error
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #13430:
URL: https://github.com/apache/shardingsphere/issues/13430#issuecomment-961583610
@5661954 I have tested this issue on master branch, It's ok now.
Can you try 5.x version, we have optimized a lot.
--
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] tuichenchuxin commented on issue #13430: batch Update statement use case statement get shardingvalue error
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #13430:
URL: https://github.com/apache/shardingsphere/issues/13430#issuecomment-960424260
@strongduanmu OK, I'll check it.
--
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] tuichenchuxin closed issue #13430: batch Update statement use case statement get shardingvalue error
Posted by GitBox <gi...@apache.org>.
tuichenchuxin closed issue #13430:
URL: https://github.com/apache/shardingsphere/issues/13430
--
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 #13430: batch Update statement use case statement get shardingvalue error
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13430:
URL: https://github.com/apache/shardingsphere/issues/13430#issuecomment-960424075
@tuichenchuxin Can you help check this issue?
--
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] tuichenchuxin commented on issue #13430: batch Update statement use case statement get shardingvalue error
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #13430:
URL: https://github.com/apache/shardingsphere/issues/13430#issuecomment-961583610
@5661954 I have tested this issue on master branch, It's ok now.
Can you try 5.x version, we have optimized a lot.
--
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] tuichenchuxin commented on issue #13430: batch Update statement use case statement get shardingvalue error
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #13430:
URL: https://github.com/apache/shardingsphere/issues/13430#issuecomment-1086566178
Closed due to long time no reply.
--
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