MySQL Bugs: #110982: ODBC 8.0.33 cannot update MYSQL table from SQL SERVER 2019

Bug #110982	ODBC 8.0.33 cannot update MYSQL table from SQL SERVER 2019
Submitted:	10 May 2023 18:44	Modified:	11 Jun 2023 6:47
Reporter:	Russell Young	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	5.7.38	OS:	Windows (server 2019)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
This update statement is failing using a linked server called SWAMPFOX that points to an 64BIT ODBC connector

UPDATE ivr  
SET    ivr.exported = getdate()
FROM   OPENQUERY(SWAMPFOX, 'SELECT id, exported,phone_number,product_id FROM us_apikcmorg.ivr_request') as ivr 
where 1=1  
and ivr.id = '00000309-910c-11e9-bfc7-064464ea2ab8'

with this error message 

OLE DB provider "MSDASQL" for linked server "SWAMPFOX" returned message "Data provider or other service returned an E_FAIL status.".
Msg 7343, Level 16, State 4, Line 7
The OLE DB provider "MSDASQL" for linked server "SWAMPFOX" could not UPDATE table "[MSDASQL]". 

This started after upgrading from 8.0.32.  This state still works on another server with 8.0.32

How to repeat:
I ran this update from SSMS manually and it failed.  Switched to another server with the 8.0.32 driver and ran the update statement and it worked

Hi Russell,

I just wanted to clarify that MySQL ODBC driver 8.0.33 gave you the error whilst 8.0.32 worked. Is that correct?

Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".