[ 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)