Taras Bobrovytsky created IMPALA-6518:

             Summary: Fix the output type of a decimal union for decimal_v2
                 Key: IMPALA-6518
                 URL: https://issues.apache.org/jira/browse/IMPALA-6518
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 3.0
            Reporter: Taras Bobrovytsky

In the following query, the type of c1 is decimal(38, 38) for both decimal v1 
and v2.
select c1 from (
select cast(1 as decimal(38, 0)) as c1
union all
select cast(0.1 as decimal(38, 38)) as c1) t{code}
This means that we are truncating from the front. It would make more sense to 
truncate from the back and round when decimal v2 is enabled. The output type 
should be (38, 6). This is what we do for other mathematical operations, such 
as addition.

This message was sent by Atlassian JIRA

Reply via email to