[IMPALA-7243] width_bucket() returns an incorrect result

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 3.1.0
• Fix Version/s: Impala 3.1.0
• Component/s: Backend
• Target Version: Impala 3.1.0
• Epic Color: ghx-label-8
• Assignee: Anuj Phadke
• Reporter: Taras Bobrovytsky
• Created: 03/Jul/18 21:22
• Updated: 07/Aug/18 23:09
• Resolved: 07/Aug/18 23:09

Description

The following query returns an incorrect result:

select width_bucket(cast(9 as decimal(10,7)), cast(-60000 as decimal(11,6)), cast(10 as decimal(7,5)), 249895273);

Result:

1

Since 9 is slightly less than the upper bound, which is 10, the result should be the number of buckets.

Issue Links

• blocks: IMPALA-7202 Add WIDTH_BUCKET() function to the decimal fuzz test