[DRILL-910] to_number returns a float when when integer is expected.

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Krystal
• Created: 05/Jun/14 16:19
• Updated: 12/Feb/23 21:05

Description

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.