Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.27
-
None
-
centos7
Description
CONNECT with JDBC is trying to escape the backslash character when doing an UPDATE on a connect table.
So when I update a row and set the value to
here is my \ backslash character
it returns from a query as
here is my
baclslash character
It appears CONNECT in 10.1.27 for UPDATE statements is trying to escape characters in strings that it doesn't need to escape; previous bug reports about double quote char and single quote char. It seems CONNECT should not escape ANY characters in a string except the single quote char itself, which is escaped per the SQL standard by doubling up the single quote not using a backslash.
Attachments
Issue Links
- is duplicated by
-
MDEV-13621 CONNECT engine table_type=JDBC UPDATE containing single or double quote chars produces wrong result
- Closed