[ https://issues.apache.org/jira/browse/DRILL-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Phillips updated DRILL-2658: ----------------------------------- Component/s: Functions - Drill > Add ilike and regex substring functions > --------------------------------------- > > Key: DRILL-2658 > URL: https://issues.apache.org/jira/browse/DRILL-2658 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill > Reporter: Steven Phillips > Assignee: Steven Phillips > Fix For: 0.9.0 > > Attachments: 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)