[
https://issues.apache.org/jira/browse/DRILL-3695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-3695:
----------------------------------
Assignee: Daniel Barclay (Drill)
> 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)
> Assignee: 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)
