[ https://issues.apache.org/jira/browse/DRILL-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14567866#comment-14567866 ]
Patrick Toole commented on DRILL-2658: -------------------------------------- This form breaks other downstream items: SELECT * FROM table_name WHERE column_name ilike '4\t' ESCAPE '\' > Add ilike and regex substring functions > --------------------------------------- > > Key: DRILL-2658 > URL: https://issues.apache.org/jira/browse/DRILL-2658 > Project: Apache Drill > Issue Type: New Feature > Components: Functions - Drill > Reporter: Steven Phillips > Assignee: Steven Phillips > Fix For: 1.0.0 > > Attachments: DRILL-2658.patch, DRILL-2658.patch > > > This will not modify the parser, so postgress syntax such as: > "... where c ILIKE '%ABC%'" > will not be currently supported. It will simply be a function: > "... where ILIKE(c, '%ABC%')" > Same for substring: > "select substr(c, 'abc')..." > will be equivalent to postgress > "select substr(c from 'abc')", > but 'abc' will be treated as a java regex pattern. -- This message was sent by Atlassian JIRA (v6.3.4#6332)