[ https://issues.apache.org/jira/browse/IMPALA-6405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Taras Bobrovytsky resolved IMPALA-6405. --------------------------------------- Resolution: Fixed Fix Version/s: Impala 3.0 {noformat} commit b0027575cbce7002ff867750e955ff3ecd3b1bcd Author: Taras Bobrovytsky <tbobrovyt...@cloudera.com> Date: Wed Jan 17 20:32:11 2018 -0800 IMPALA-6405: Error when string to decimal cast overflows Before this patch, when there was an error when converting a string to a decimal, a NULL was returned. In this patch, we change this behavior so that an error is returned if decimal_v2 is enabled. We also add a warning if there is an underflow. The reasoning is that we want stricter behavior in decimal_v2. Testing: - Added some EE tests. - Ran an exhaustive build, which passed. Change-Id: Icffccac1c1c2361447ae4b0de9b6c2ec7de071db Reviewed-on: http://gerrit.cloudera.org:8080/9339 Reviewed-by: Dan Hecht <dhe...@cloudera.com> Tested-by: Impala Public Jenkins{noformat} > There is no error under Decimal v2 when there is an overflow when casting > String to Decimal > ------------------------------------------------------------------------------------------- > > Key: IMPALA-6405 > URL: https://issues.apache.org/jira/browse/IMPALA-6405 > Project: IMPALA > Issue Type: Bug > Components: Backend > Affects Versions: Impala 2.11.0 > Reporter: Taras Bobrovytsky > Assignee: Taras Bobrovytsky > Priority: Blocker > Fix For: Impala 3.0 > > > The following query correctly returns an error when Decimal v2 is enabled: > {code:java} > select cast(123 as decimal(2, 0)); > ERROR: UDF ERROR: Decimal expression overflowed > {code} > However, this query incorrectly returns a NULL: > {code} > select cast("123" as decimal(2, 0)) > +-----------------------------+ > | cast('123' as decimal(2,0)) | > +-----------------------------+ > | NULL | > +-----------------------------+ > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)