[ https://issues.apache.org/jira/browse/IMPALA-7255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-7255. ----------------------------------- Resolution: Duplicate > Incorrect result rounding midpoint negative numbers to negative precision > ------------------------------------------------------------------------- > > Key: IMPALA-7255 > URL: https://issues.apache.org/jira/browse/IMPALA-7255 > Project: IMPALA > Issue Type: Bug > Reporter: Ian Cook > Priority: Major > > Based on the Impala docs and on the behavior of other SQL engines, it's > evident that: > {{round(-15, -1)}} should return {{-20}} > {{round(-150, -2)}} should return {{-200}} > and so on, because negative values at the midpoint between the upper and > lower rounded values are supposed to round to the value farther from zero. > However, in Impala: > {{round(-15, -1)}} returns {{-10}} > {{round(-150, -2)}} returns {{-100}} > and so on. This issue affects cases where both arguments are negative and the > number being rounded is at the midpoint. I believe this issue affects cases > where the first argument has any of the integer data types or the {{FLOAT}} > or {{DOUBLE}} type, but not when it has a {{DECIMAL}} type. This issue seems > to occur regardless of whether the numbers being rounded are specified as > literals, column references, or expressions. > To reproduce this, execute queries like: > {{SELECT round(-15, -1);}} > {{SELECT round(-150, -2);}} > {{SELECT round(cast(-150 AS BIGINT), -2);}} > {{SELECT round(cast(-150 AS DOUBLE), -2);}} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org