You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Yuming Wang (JIRA)" <ji...@apache.org> on 2019/06/17 15:48:00 UTC
[jira] [Created] (SPARK-28083) ANSI SQL: LIKE predicate: ESCAPE
clause
Yuming Wang created SPARK-28083:
-----------------------------------
Summary: ANSI SQL: LIKE predicate: ESCAPE clause
Key: SPARK-28083
URL: https://issues.apache.org/jira/browse/SPARK-28083
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 3.0.0
Reporter: Yuming Wang
Format:
{noformat}
<like predicate> ::=
<character like predicate>
| <octet like predicate>
<character like predicate> ::=
<row value predicand> <character like predicate part 2>
<character like predicate part 2> ::=
[ NOT ] LIKE <character pattern> [ ESCAPE <escape character> ]
<character pattern> ::=
<character value expression>
<escape character> ::=
<character value expression>
<octet like predicate> ::=
<row value predicand> <octet like predicate part 2>
<octet like predicate part 2> ::=
[ NOT ] LIKE <octet pattern> [ ESCAPE <escape octet> ]
<octet pattern> ::=
<binary value expression>
<escape octet> ::=
<binary value expression>
{noformat}
[https://www.postgresql.org/docs/11/functions-matching.html]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org