[IMPALA-2020] Rounding should be done instead of truncating when casting DECIMAL to DECIMAL, FLOAT/DOUBLE to DECIMAL, DECIMAL to INT

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.0
• Fix Version/s: Impala 2.9.0
• Component/s: Backend
• Labels: correctness downgraded ramp-up
• Target Version: Impala 2.9.0
• Assignee: Zach Amsden
• Reporter: casey
• Created: 19/May/15 19:51
• Updated: 14/Mar/17 18:36
• Resolved: 02/Mar/17 21:57

Description

The current behavior is to truncate which people don't expect and often differs from what other databases do (does any other system truncate?). We've had several questions from users that stem from the truncation.

Issue Links

• is related to: IMPALA-865 Impala will return incorrect result on int overflow without warning
• relates to: IMPALA-5014 DECIMAL V2 round when casting to/from DECIMAL, part 2