Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.27
-
None
-
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