[HIVE-15325] Scale is greater than decimal values trunc(d,s) returns wrong results

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Component/s: UDF
• Assignee: Chinna Rao Lalam
• Reporter: Chinna Rao Lalam
• Created: 01/Dec/16 06:49
• Updated: 26/Dec/16 16:26

Description

Scale is greater than decimal values trunc(d,s) returns wrong results.

select trunc(1234567891.1234567891,15), trunc(1234567891.1234567891,25), trunc(1234567891.1234567891,20), trunc(1234567891.1234567891,50) FROM src tablesample (1 rows);

Add tests with negative numbers as well as no-op (e.g. select trunc (12.34, 100))