You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Qilong Wang (Jira)" <ji...@apache.org> on 2026/04/12 14:50:00 UTC
[jira] [Created] (FLINK-39424) Setting LIKE does not support default escape characters.
Qilong Wang created FLINK-39424:
-----------------------------------
Summary: Setting LIKE does not support default escape characters.
Key: FLINK-39424
URL: https://issues.apache.org/jira/browse/FLINK-39424
Project: Flink
Issue Type: Bug
Components: Table SQL / Planner
Affects Versions: 2.3.0
Reporter: Qilong Wang
Fix For: 2.3.0
In standard SQL, the LIKE clause does not have default escape characters, such as the following:
* MySQL and PostgreSQL: These systems typically default to using backslashes as string literals and escape characters in Like clauses. However, it is generally not recommended to rely on this default setting as it can be changed through server configuration (such as NOACKSLASH-ESCAPES in MySQL or standard_comforming_strings in Postgres).
* SQL Server (MS-DOS): There are no default escape characters. You must use the ESCAPE clause. Alternatively, SQL Server allows you to escape wildcard characters by enclosing them in square brackets (e.g. LIKE'20 [_]% ').
* Oracle and SQLite: There are no default escape characters. If you need to escape wildcard characters, you must explicitly define an escape character using the ESCAPE clause.
Considering that our string literal also does not support backslashes, and default escape characters may cause confusion, we have chosen to set it to not support default escape characters.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)