[DRILL-525] POWER function with integer base and exponent returns decimal result

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Information Provided
• Affects Version/s: Future
• Fix Version/s: Future
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Krystal
• Created: 15/Apr/14 21:37
• Updated: 02/Mar/23 08:55
• Resolved: 02/Mar/23 08:55

Description

Ran the following query in drill:
0: jdbc:drill:schema=dfs> select power(12, 5) from dfs.`student` where rownum = 10;
------------

EXPR$0

------------

248832.0

------------

Compared to postgres, mysql and oracle, they all returned an integer of 248832