[
https://issues.apache.org/jira/browse/DRILL-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14588412#comment-14588412
]
Steven Phillips commented on DRILL-3301:
----------------------------------------
Escape is supported, e.g.:
ilike(a, 'abc#t, '#')
I don't think we are planning on updating the syntax to support the "LIKE"
syntax, since that probably requires modifying Calcite, and ILIKE is not
standard SQL.
> ILIKE does not support escape characters.
> -----------------------------------------
>
> Key: DRILL-3301
> URL: https://issues.apache.org/jira/browse/DRILL-3301
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Patrick Toole
>
> The like operator properly supports escaping characters. Because the ILIKE is
> implemented as a function, it does not support escaping.
> The grammar needs to be updated to accept ILIKE in the same locations as LIKE.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
