[
https://issues.apache.org/jira/browse/FLINK-22921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu closed FLINK-22921.
---------------------------
Resolution: Not A Problem
In SQL, single quote is used to escape single quote. So if you want to specify
single quote in a string literal, you should use {{''}} two single quotes (not
double quotes). For example, in your case, you should use {{WHERE name like
'n''ame010'}}.
> SQL Client can't resolve the escape of " ' " correctly.
> -------------------------------------------------------
>
> Key: FLINK-22921
> URL: https://issues.apache.org/jira/browse/FLINK-22921
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Client
> Reporter: Roc Marshal
> Priority: Major
> Labels: SQL
> Attachments: escape1.jpeg, escape2.jpeg, escape3.jpeg, escape4.jpeg,
> escape5.jpeg
>
>
> Such as follows:
> where <column_name>=...
> or
> where <column_name> like ...
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
