Bug #54863 | Bug in MySqlDataAdapter update method | ||
---|---|---|---|
Submitted: | 28 Jun 2010 16:38 | Modified: | 13 Jul 2010 9:56 |
Reporter: | Attila Aszalos | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / NET | Severity: | S2 (Serious) |
Version: | 6.2.3 | OS: | Windows |
Assigned to: | Tony Bedford | CPU Architecture: | Any |
Tags: | MySqlDataAdapter; Update method; UpdatedRowSource.FirstReturnedRecord |
[28 Jun 2010 16:38]
Attila Aszalos
[1 Jul 2010 16:04]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/112698 821 Vladislav Vaintroub 2010-07-01 Bug#54863 : several datadapter.Update()s with DataTable changes in between can result into ConcurrencyException To fix, call DataTable.AcceptChanges() at the end of MySqlDataAdapter.Update() (this is the documented behavior which DBDataAdapter surprisingly does not implement)
[1 Jul 2010 22:59]
Vladislav Vaintroub
pushed to 6.0, 6.1, 6.2, 6.3
[2 Jul 2010 7:19]
Tonci Grgin
Thanks Attila for your report and Wlad for his quick fix.
[13 Jul 2010 9:56]
Tony Bedford
An entry has been added to the 6.0.7, 6.1.5, 6.2.4, and 6.3.3 changelogs: Several calls to datadapter.Update() with intervening changes to DataTable resulted in ConcurrencyException exceptions being generated.
[7 Aug 2010 23:56]
Pavel Bazanov
Hello, Despite what MSDN is saying I don't see that SqlDataAdapter and OleDbDataAdapter call AcceptChanges. Why did you decide to call it in MySqlDataAdapter? Also, this may be a breaking change for the users. For example, I don't need AcceptChanges() to be called. It breaks my code and I need to rewrite several methods...
[10 Dec 2010 8:13]
Tonci Grgin
Continued in Bug#58853.
[14 Dec 2010 20:49]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/126845 854 Reggie Burnett 2010-12-14 - removed extra call to Update in MySqlDataAdapter introduced with bug fix to bug #54863. It seems to not be necessary (bug #58853)