Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.1.27
-
Fix Version/s: 10.1
-
Component/s: Storage Engine - Connect
-
Labels:None
-
Environment:centos7
Description
UPDATING a connect row with a string like this:
My fence is 24" high
results in the following when queried:
My fence is 24\" high
However INSERT of the same value results in the CORRECT behavior.
Note this behavior is consistent between Microsoft SQL driver and Postgres driver.
Further, in a string, I do not thing a double quote needs to be escaped at all in the SQL standard.
Attachments
Issue Links
- is duplicated by
-
MDEV-13621 CONNECT engine table_type=JDBC UPDATE containing single or double quote chars produces wrong result
-
- Closed
-