drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehant Baid (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2199) Wrong results while using case expression with decimal data type
Date Tue, 10 Feb 2015 08:28:34 GMT
Mehant Baid created DRILL-2199:
----------------------------------

             Summary: Wrong results while using case expression with decimal data type
                 Key: DRILL-2199
                 URL: https://issues.apache.org/jira/browse/DRILL-2199
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Mehant Baid
            Assignee: Mehant Baid


Consider the below SQL statement:

"select 
case when true then cast(employee_id as decimal(15, 5)) else cast('0.0' as decimal(5, 2))
end 
from cp.`employee.json` where employee_id = 1"

This should return 1.00000 instead Drill returns 100000. In the case statement the first expression
(condition expression) is nullable and the else expression is non-nullable. For our codegen
to work correctly we make the non-nullable expression also nullable using convertToNullableXHolder()
functions. These functions however do not preserve the scale and precision of the input, hence
the output we get is the unscaled value of the decimal.

Fix is to make the converToNullableDecimalHolder() functions preserve the scale and precision
by returning the correct major type.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message