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)
