[
https://issues.apache.org/jira/browse/DRILL-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14588037#comment-14588037
]
Patrick Toole commented on DRILL-3301:
--------------------------------------
See DRILL-2658 for a syntax description in the comments.
> 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)