INSERT & UPDATE do not support escape character \

[joooohnli]

Bug Report

For English only, other languages will not accept.

Before report a bug, make sure you have:

• Searched open and closed GitHub issues.
• Read documentation: Sharding-Sphere Doc.

Please pay attention on issues you submitted, because we maybe need more details.
If no response more than 7 days and we cannot reproduce it on current information, we will close it.

Please answer these questions before submitting your issue. Thanks!

Which version of Sharding-Sphere did you use?

3.1.0.M1

Which project did you use? Sharding-JDBC or Sharding-Proxy?

Sharding-Proxy

Expected behavior

INSERT & UPDATE support escape character \

Actual behavior

INSERT & UPDATE do not support escape character
while SELECT works well.

Reason analyze (If you can)

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

mysql> insert into test(name) values ('\'');
ERROR 3054 (HY000): Unknown exception: Illegal input, unterminated '''.
mysql> update test set name='\'' where id=1;
ERROR 3054 (HY000): Unknown exception: Illegal input, unterminated '''.

Example codes for reproduce this issue (such as a github link).

[codefairy08]

mismatch string with escape character

[codefairy08]

fixed at #2038