Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Mon, 9 Jun 2014 07:17:07 +0000 (UTC)
From: "Jacques Nadeau (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12718662.1401985168893.92826.1402298227867@arcas>
In-Reply-To: <JIRA.12718662.1401985168893@arcas>
References: <JIRA.12718662.1401985168893@arcas>
Subject: [jira] [Updated] (DRILL-910) to_number returns a float when when
 integer is expected.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Jacques Nadeau updated DRILL-910:
---------------------------------

    Assignee: Mehant Baid

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