Daniel Barclay (Drill) created DRILL-3695:
---------------------------------------------

             Summary: SYSTEM ERROR for REGEXP_REPLACE replacement pattern 
format error
                 Key: DRILL-3695
                 URL: https://issues.apache.org/jira/browse/DRILL-3695
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Daniel Barclay (Drill)


Similar to the problem with REGEXP_REPLACE match patterns reported in 
DRILL-3694, REGEXP_REPLACE reports "SYSTEM ERROR" errors rather than specific 
("FUNCTION ERROR") errors for bad replacement pattern strings:

0: jdbc:drill:drillbit=localhost> VALUES REGEXP_REPLACE( 'abc', 'b', '\');
Error: SYSTEM ERROR: StringIndexOutOfBoundsException: String index out of 
range: 1

{noformat}
[Error Id: 12f09e63-8dcb-4ab8-bfe6-183d81617c1e on dev-linux2:31010] 
(state=,code=0)
0: jdbc:drill:drillbit=localhost> VALUES REGEXP_REPLACE( 'abc', 'b', '$');
Error: SYSTEM ERROR: StringIndexOutOfBoundsException: String index out of 
range: 1


[Error Id: 084ce8ce-8c11-4d53-82a4-be19aa9140b2 on dev-linux2:31010] 
(state=,code=0)
0: jdbc:drill:drillbit=localhost> VALUES REGEXP_REPLACE( 'abc', 'b', '$2');
Error: SYSTEM ERROR: IndexOutOfBoundsException: No group 2


[Error Id: 04d5e101-1f94-46df-8590-6f94aac9201c on dev-linux2:31010] 
(state=,code=0)
0: jdbc:drill:drillbit=localhost> 
{noformat}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to