[IMPALA-6340] There is no error when inserting an invalid value into a decimal column under decimal_v2

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.11.0
• Fix Version/s: Impala 3.0, Impala 2.13.0
• Component/s: Backend
• Labels: correctness
• Target Version: Impala 3.0
• Epic Color: ghx-label-6
• Assignee: Taras Bobrovytsky
• Reporter: Taras Bobrovytsky
• Created: 18/Dec/17 23:42
• Updated: 24/Mar/21 19:00
• Resolved: 30/Apr/18 19:23

Description

The following series of commands does not result in an error or a warning when decimal_v2 is enabled.

set decimal_v2=1;
create table t1 (c1 decimal(38,37));
insert into t1 select 11.11;

We end up inserting a NULL into the column without any warnings.

If these commands are executed with decimal_v2 disabled, we get the following warning:

WARNINGS: UDF WARNING: Decimal expression overflowed, returning NULL

Issue Links

• breaks: IMPALA-7211 Query with a decimal between predicate needlessly fails