Bug #115004 Windows
Submitted: 14 May 2024 22:24 Modified: 15 May 2024 20:30
Reporter: Shane Green Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:8.0.37 OS:Windows
Assigned to: CPU Architecture:x86
Tags: ODBC failure after upgrade

[14 May 2024 22:24] Shane Green
Description:
After upgrading the Windows x86 version of the ODBC connector from 8.0.33 to 8.0.37 we are getting errors whenever a Stored Procedure is called.

15/05/2024 9:34:38 am - SQLDatabase:DropTmpTables : Error #-2147217900:Error:[MySQL][ODBC 8.0(a) Driver][mysqld-8.3.0]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{ call drop_all_work_tables(?) }' at line 1

I have managed to downgrade my machine again to 8.0.33 and it works again, however our clients have their own IT department and we limited access to correct.

How to repeat:
Have your application call any Stored Procedure with parameters.
[15 May 2024 12:28] MySQL Verification Team
Hello Shane Green,

Thank you for the bug report.
Imho this is duplicate of Bug #112285, please see Bug #112285 which is fixed as of the upcoming MySQL Connector/ODBC 8.4.0 release.

Regards,
Ashwini Patil
[15 May 2024 20:30] Shane Green
There is only a x64 version of 8.4.0 - this is for the x86 version.