You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Jark Wu (Jira)" <ji...@apache.org> on 2021/06/08 11:32:00 UTC

[jira] [Closed] (FLINK-22921) SQL Client can't resolve the escape of " ' " correctly.

     [ 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)