github-actions[bot] commented on issue #1129: URL: https://github.com/apache/incubator-seata-go/issues/1129#issuecomment-4881839867
> Bot detected the issue body's language is not English, translate it automatically. # # # ✅ Validation Checklist - [x] 🔍 I've searched [existing issues] (https://github.com/apache/incubator-seata-go/issues) and I'm sure it's not a duplicate request - [x] 📋 I have reviewed the [release notes] (https://github.com/apache/incubator-seata-go/releases) and am confident that this feature has not been implemented - [] 🛠️ I am willing to take care of this on my own # # # 🎯 Function description AT mode currently has partial support for "multiple semicolon-separated statements in one SQL string" - there is already a dedicated "multi" executor for update and delete statements for groups.But the support is incomplete: - Multiple * * insert * * statements separated by semicolons are not yet supported; - Existing update/multi delete executors do not support `limit`/`order BY` clauses in grouped statements. This issue seeks to improve multi-statement SQL support in AT mode, including: - Identify and correctly route multiple semicolon-separated insert statements to correctly generate pre/post mirroring and rollback logs;- support (or at least explicitly and gracefully process) the `limit`/'order BY` clause in the packet update/delete statement; - To the extent feasible, handle a mix of multiple statement types within the same query string. # # # 📋 Usage scenarios - Applications, scripts or migration tools send multiple DML statements in a single query string separated by `;` to reduce the number of round-trips to the network; - ORM or batch frameworks generate combined multi-statement SQL not only for update/delete, but also for insert. # # # ⚖️ Complexity and risk assessment It is necessary to correctly split/parse the mixed-type statements, associate the respective front/back image and lock key for each statement, and ensure that the combined rollback log can correctly roll back each statement in the group (including the case of partial failure). # # # 🔗 External dependencies _No response_ # # # 📚 Additional information The existing multi-statement update/delete actuator implementation mode in AT mode can be referenced to extend it to insert and limit/order BY support. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
