H-Jason

Deadlocks in multi DB when multi thread excute batchUpdate

2

## Bug Report ### Which version of ShardingSphere did you use? 5.1.2 ### Which project did you use? ShardingSphere-JDBC ### Expected behavior when i update table in multi mysql using...

Fixes #31118. Changes proposed in this pull request:  --- Before committing this PR, I'm sure that I have checked the following options: - [x] My code follows the [code...

SelectStatementContext#isSameGroupByAndOrderByItems has bug

3

https://github.com/apache/shardingsphere/blob/764c13f2f098d3f13911e31aa93a61f12d49a332/infra/binder/src/main/java/org/apache/shardingsphere/infra/binder/statement/dml/SelectStatementContext.java#L297 ### Bug Report the method SelectStatementContext#isSameGroupByAndOrderByItems is not right; OrderByItem in SelectStatementContext#groupByContext is default ASC，But OrderByItem in SelectStatementContext#orderByContext couild be ASC or DESC;So when my sql is desc, it...