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

["Taras Bobrovytsky (JIRA)" <ji...@apache.org>]

Taras Bobrovytsky created IMPALA-7243:
-----------------------------------------

             Summary: width_bucket() returns an incorrect result
                 Key: IMPALA-7243
                 URL: https://issues.apache.org/jira/browse/IMPALA-7243
             Project: IMPALA
          Issue Type: Bug
          Components: Backend
    Affects Versions: Impala 3.1.0
            Reporter: Taras Bobrovytsky


The following query returns an incorrect result:
{code:java}
select width_bucket(cast(9 as decimal(10,7)), cast(-60000 as decimal(11,6)), cast(10 as decimal(7,5)), 249895273);{code}
Result:
{code:java}
1{code}
Since 9 is slightly less than the upper bound, which is 10, the result should be the number of buckets.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org