-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1.18
-
Component/s: Storage Engine - Connect
-
Labels:None
-
Environment:centOS 7
In the following statements, any table that begins with rmt_ is a CONNECT table using JDBC table_type accessing a remote MySQL server v5.6.
This statement runs correctly:
delete from rmt_Clients where `Client_ID` = '5001' |
However this statement:
delete from `rmt_Clients` where `Client_ID` = '5001' |
produces this error:
Error Code: 1296. Got error 122 'ExecuteUpdate: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to u' from CONNECT |
Also very similar behavior with UPDATE statements... if you back tick the table name or a column name in the SET clause it produces the same error as above. Using back tick to enclose a column name in the WHERE clause does work.
Works:
UPDATE rmt_Clients SET Name = 'Sally' where `Client_ID` = '5000' |
Does not work:
UPDATE `rmt_Clients` SET `Name` = 'Sally' where `Client_ID` = '5000' |
produces error:
Error Code: 1296. Got error 122 'ExecuteUpdate: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to u' from CONNECT |