[
https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17806220#comment-17806220
]
Julian Hyde commented on CALCITE-6180:
--------------------------------------
I agree with you on the first part.
An example of the second part would be
{code}
'a#c' like 'a##c' escape '#' -> true
{code}
'#' is the escape character, and when followed by itself, it results in a
single copy of the escape character.
The third part (implicit) is that if '#' is followed by anything other than
'_', '%' or '#', it is an error. Calcite, Oracle, hsqldb throw in that case.
Postgres and SQLite ignore it. MySQL I'm not sure.
> Append possibility to escape backslash in LIKE expression
> ---------------------------------------------------------
>
> Key: CALCITE-6180
> URL: https://issues.apache.org/jira/browse/CALCITE-6180
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.36.0
> Reporter: Evgeny Stanilovsky
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: pull-request-available
>
> The expression below must be processed correctly and return positive result
> {noformat}
> select 'Dev\ops' like 'Dev#\ops' escape '#';
> {noformat}
> Insted it returns :
> Invalid escape sequence exception.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
