[jira] [Created] (DRILL-910) to_number returns a float when when integer is expected.

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

Krystal created DRILL-910:
-----------------------------

             Summary: to_number returns a float when when integer is expected.
                 Key: DRILL-910
                 URL: https://issues.apache.org/jira/browse/DRILL-910
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Krystal


git.commit.id.abbrev=8490d74
git.build.time=02.06.2014 @ 10\:11\:56 PDT

0: jdbc:drill:schema=dfs> select to_number('$987,966', '$###,###') from voter where voter_id=10;
+------------+
|   EXPR$0   |
+------------+
| 987966.0   |
+------------+

0: jdbc:drill:schema=dfs> select to_number('2,900.55', '#,###') from voter where voter_id=10;
+------------+
|   EXPR$0   |
+------------+
| 2901.0     |
+------------+

In the first example, an int is passed to_number so we expect an in to return.  In the second example, the format in the second argument is to return an int.
In both cases, postgres and oracle return an int. 



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