Bug #71626 | Extra SELECT@@sql_mode queries in batched INSERT | ||
---|---|---|---|
Submitted: | 7 Feb 2014 14:36 | Modified: | 24 Nov 2021 16:32 |
Reporter: | Trevor Samols | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / NET | Severity: | S2 (Serious) |
Version: | 6.8.3, 6.9.5 | OS: | Windows |
Assigned to: | CPU Architecture: | Any |
[7 Feb 2014 14:36]
Trevor Samols
[7 Feb 2014 14:39]
Trevor Samols
Correct connector version number
[9 Jan 2015 6:13]
Chiranjeevi Battula
Hello Trevor Samols, Thank you for the bug report. Verified this behavior on Visual Studio 2013 (C#.Net) with MySQL Connector/Net 6.9.5. Thanks, Chiranjeevi.
[24 Nov 2021 16:32]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL Connector/NET 8.0.28 release, and here's the proposed changelog entry from the documentation team: When performing a batched insert using MySqlDataAdapter, the MySqlCommand.GetCommandTextForBatching() method queried @@sql_mode for each insert. This fix eliminates the redundant actions and modifies the behavior to use the sql_mode property, which is obtained at the beginning of the connection. Thank you for the bug report.