MySQL Bugs: #28245: Change Data to same value in ODBC-Linked Table in Access fails

Bug #28245	Change Data to same value in ODBC-Linked Table in Access fails
Submitted:	4 May 2007 15:26	Modified:	3 Jan 2008 3:37
Reporter:	Jess Balint	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Any
Assigned to:	Jess Balint	CPU Architecture:	Any
Tags:	ODBC5_RC

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The server normally reports 0 rows if the data isn't actually changed. Access interprets this as having the data changed since it was last read.

How to repeat:
Create a linked table, change the data to the same value (will be marked dirty), and "click away". The update statement will be sent to the server like UPDATE TABLE SET col = 'someval' WHERE col = 'someval'.

Suggested fix:
We need to allow settings CLIENT_FOUND_ROWS when connecting.

Works fine in Connector/ODBC 5.1. This was a Connector/ODBC 5.0 specific bug.