Description:
I'm running the following:
set @pid = 1234;
update partner
set config = '{"NewConfig": "xyz"}',
version = version + 1,
last_update = NOW()
where id = @id and pid = @pid;
Prior to updating to Big Sur Version 11.5 (20G71) it worked as expected. Now that I've updated the iOS, I'm getting the following error when I run the UPDATE statement:
Error Code: 1064. 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 '' at line 1
I'm using the latest version of Workbench and have tried using older versions as well. I have also tried using other SQL tools and getting the same error. Other users that have not updated their iOS can run the SQL without issues. This looks to be an issue with the Big Sur Version 11.5 update. Does anyone know how to fix this?
How to repeat:
NA
Description: I'm running the following: set @pid = 1234; update partner set config = '{"NewConfig": "xyz"}', version = version + 1, last_update = NOW() where id = @id and pid = @pid; Prior to updating to Big Sur Version 11.5 (20G71) it worked as expected. Now that I've updated the iOS, I'm getting the following error when I run the UPDATE statement: Error Code: 1064. 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 '' at line 1 I'm using the latest version of Workbench and have tried using older versions as well. I have also tried using other SQL tools and getting the same error. Other users that have not updated their iOS can run the SQL without issues. This looks to be an issue with the Big Sur Version 11.5 update. Does anyone know how to fix this? How to repeat: NA