github-actions[bot] commented on issue #1130: URL: https://github.com/apache/incubator-seata-go/issues/1130#issuecomment-4881842798
> 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 MySQL supports inserting multiple lines through an insert statement, that is, a multivalued form: `insert into t (a, b) values (1,2), (3,4)`.AT mode currently supports part of this mode (it is possible to extract the primary key values of all rows and calculate the self-incrementing primary key values of each row by `last_insert_ID` + `auto_increment_increment` for a single self-incrementing primary key column).However, in this multi-valued insert format, the support of other primary key scenarios is incomplete, especially: - Composite (multi-column) primary key; - Some primary key columns are explicitly assigned, and some need to be automatically generated for hybrid scenarios.This Issue hopes to improve the support of multi-value insert values, so that under all primary key configurations, each line can correctly build front/back image and rollback logs. # # # 📋 Usage scenarios - Batch insertion using a single multi-valued insert statement constructed to improve efficiency (common in data import tasks, batch insertion aids for ORM); - Use tables with composite primary keys, but also need to support efficient batch insertion. # # # ⚖️ Complexity and risk assessment _No response_ # # # 🔗 External dependencies _No response_ # # # 📚 Additional information _No response_ -- 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]
