Krystal created DRILL-572:
-----------------------------
Summary: regexp_replace function returns incorrect result
Key: DRILL-572
URL: https://issues.apache.org/jira/browse/DRILL-572
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.0.0
Reporter: Krystal
Ran the following query from drill:
select regexp_replace('408.123.4567',
'([[:digit:]]{3})\.([[:digit:]]{3})\.([[:digit:]]{4})','(\1) \2-\3') from voter
where voter_id=10;
The following result was returned:
+------------+
| EXPR$0 |
+------------+
| 408.123.4567 |
+------------+
The correct answer should be:
(408) 123-4567
--
This message was sent by Atlassian JIRA
(v6.2#6252)