You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/04/25 17:34:22 UTC

[jira] [Created] (DRILL-572) regexp_replace function returns incorrect result

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)