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

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

     [ https://issues.apache.org/jira/browse/DRILL-741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mehant Baid updated DRILL-741:
------------------------------

    Assignee: Krystal

> 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
>            Assignee: 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)