[jira] [Updated] (DRILL-3694) SYSTEM ERROR for REGEXP_REPLACE match pattern format error

["Daniel Barclay (Drill) (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-3694?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Barclay (Drill) updated DRILL-3694:
------------------------------------------
    Summary: SYSTEM ERROR for REGEXP_REPLACE match pattern format error  (was: SYSTEM ERROR for REGEXP_REPLACE regex format error)

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