You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Taras Bobrovytsky (JIRA)" <ji...@apache.org> on 2018/04/30 19:24:00 UTC

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

     [ https://issues.apache.org/jira/browse/IMPALA-6340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Taras Bobrovytsky resolved IMPALA-6340.
---------------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 3.0

> There is no error when inserting an invalid value into a decimal column under decimal_v2
> ----------------------------------------------------------------------------------------
>
>                 Key: IMPALA-6340
>                 URL: https://issues.apache.org/jira/browse/IMPALA-6340
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 2.11.0
>            Reporter: Taras Bobrovytsky
>            Assignee: Taras Bobrovytsky
>            Priority: Blocker
>              Labels: correctness
>             Fix For: Impala 3.0
>
>
> The following series of commands does not result in an error or a warning when decimal_v2 is enabled.
> {code}
> set decimal_v2=1;
> create table t1 (c1 decimal(38,37));
> insert into t1 select 11.11;
> {code}
> 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:
> {code}
> WARNINGS: UDF WARNING: Decimal expression overflowed, returning NULL
> {code}



--
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