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: [email protected]
For additional commands, e-mail: [email protected]
