[
https://issues.apache.org/jira/browse/DRILL-3694?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-3694:
----------------------------------
Assignee: Daniel Barclay (Drill)
> SYSTEM ERROR for REGEXP_REPLACE match pattern format error
> ----------------------------------------------------------
>
> Key: DRILL-3694
> URL: https://issues.apache.org/jira/browse/DRILL-3694
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Daniel Barclay (Drill)
> Assignee: Daniel Barclay (Drill)
>
> Giving a bad regular expression as the match-pattern argument string to
> REGEXP_REPLACE yields a SYSTEM ERROR (apparently from a non-specific catch of
> PatternSyntaxException from the Java implementation) rather than a more
> specific error (FUNCTION ERROR?) from explicit validation (e.g., via a
> specific catch of PatternSyntaxException from the Java implementation).
> For example:
> {noformat}
> 0: jdbc:drill:drillbit=localhost>
> VALUES REGEXP_REPLACE( 'abc', '\', 'x');
> Error: SYSTEM ERROR: PatternSyntaxException: Unexpected internal error near
> index 1
> \
> ^
> [Error Id: 6a4dfb45-cd7b-4c24-b720-3813522254a4 on dev-linux2:31010]
> (state=,code=0)
> 0: jdbc:drill:drillbit=localhost>
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
