Daniel Barclay (Drill) created DRILL-3694: ---------------------------------------------
Summary: SYSTEM ERROR for REGEXP_REPLACE regex 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)