[jira] [Created] (DRILL-741) TO_CHAR function is not returning expected results

["Krystal (JIRA)" <ji...@apache.org>]

Krystal created DRILL-741:
-----------------------------

             Summary: TO_CHAR function is not returning expected results
                 Key: DRILL-741
                 URL: https://issues.apache.org/jira/browse/DRILL-741
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Krystal


Some to_char functions from drill are not returning expected result.  Below are the examples:

select to_char(485.8, '"Pre:"999" Post:" .999') from voter where voter_id=10;
drill: "Pre:"999" Post:" 486.999
expected: Pre: 485 Post: .800

select to_char(1234.6789,'9999999D99999') from voter where voter_id=10;
drill:  9999999D999991235
expected:   1234.67890

select to_char(123456789, '999G999G999D99') from voter where voter_id=10;
drill:     999G999G999D99123456789
expected:   123,456,789.00

select to_char(-485, '999PR') from voter where voter_id=10;
drill:   -999PR485
expected:   <485>

select to_char(0.0004859, '9.99EEEE') from voter where voter_id=10;
drill:   90.99EEEE
expected:   4.86e-04

select to_char(485, '9 9 9') from voter where voter_id=10;
drill:   9 9 9485
expected:   4 8 5



--
This message was sent by Atlassian JIRA
(v6.2#6252)