[
https://issues.apache.org/jira/browse/DRILL-910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel Barclay reassigned DRILL-910:
------------------------------------
Assignee: (was: Daniel Barclay)
> 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
> Priority: Critical
> Fix For: Future
>
>
> 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
(v8.20.10#820010)
