Bug #93204 Mysql Odbc cannot update an existing row using a server-side keyset cursor
Submitted: 15 Nov 2018 7:55 Modified: 1 Dec 2018 18:49
Reporter: Ciprian Anton Email Updates:
Status: Verified Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:8.0 (a) OS:Microsoft Windows
Assigned to: CPU Architecture:x86

[15 Nov 2018 7:55] Ciprian Anton
Description:
If we are trying to update an existing row, using a server side cursor and a cursor type different than adOpenForwardOnly, we get the following error:

Error:00205540
[MySQL][ODBC 8.0(a) Driver][mysqld-8.0.11]Build WHERE -> insert_fields() failed.

Is this limitation expected?

How to repeat:
Just run the attached visual studio project, you will see that the update in UpdateFirstRecord() will fail
[15 Nov 2018 7:57] Ciprian Anton
The Visual Studio project that will reproduce the problem

Attachment: MySqRecordsetUpdateFails.zip (application/x-zip-compressed, text), 11.33 KiB.

[1 Dec 2018 18:49] Miguel Solorzano
Thank you for the bug report.

D:\code\MySqRecordsetUpdateFails\Debug>MySqRecordsetUpdateFails.exe
Error:000B9790
[MySQL][ODBC 8.0(a) Driver][mysqld-8.0.13]Build WHERE -> insert_fields() failed.