Bug #110553 Contribution: Run inserts in batch command as one block
Submitted: 29 Mar 2023 18:17 Modified: 19 Dec 2024 1:29
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[29 Mar 2023 18:17] OCA Admin 
Description:
This bug tracks a contribution by Sebastian Schwarzhuber (Github user: cannero) as described in http://github.com/mysql/mysql-connector-net/pull/50

How to repeat:
See description

Suggested fix:
See contribution code attached
[29 Mar 2023 18:17] OCA Admin 
Contribution submitted via Github - Run inserts in batch command as one block 
(*) Contribution by Sebastian Schwarzhuber (Github cannero, mysql-connector-net/pull/50#issuecomment-1489037067): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_1293541369.txt (text/plain), 2.99 KiB.
[30 Mar 2023 13:48] MySQL Verification Team 
Hello,

Thank you for the bug report and contribution.

Regards,
Ashwini Patil
[18 Oct 2024 12:38] Filipe Silva 
Related to Bug#71832.
[19 Dec 2024 1:29] Philip Olson 
Posted by developer:
 
Fixed as of the upcoming MySQL Connector/NET 9.2.0 release, and here's the proposed changelog entry from the documentation team:

Added a new rewritebatchedstatements connection option that makes the
connector rewrite batched statements and execute them all at once in a
single block rather than one at a time, which is default behavior.

Note that this connection option impacts functions like
LAST_INSERT_ID().

Our thanks to Sebastian Schwarzhuber for the contribution.

Thank you for the bug report.