[DRILL-1182] Decimal has an issue when used in case statement where the else expression contains a literal

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Execution - Data Types
• Assignee: Mehant Baid
• Reporter: Rahul Kumar Challapalli
• Created: 23/Jul/14 21:41
• Updated: 28/Jul/14 02:15
• Resolved: 28/Jul/14 02:15

Description

git.commit.id.abbrev=e5c2da0

The below query fails with an Assertion Error:

select
case
when l_linestatus = 'Success' then l_extendedprice
else 0
end
from lineitem;

The source 'lineitem' is a view on top of a txt file. While creating the view when we change the type of l_extendedprice from decimal to double, this issue goes away. Below is the original view definition:

create view lineitem as select cast(columns[0] as int) l_orderkey, cast(columns[1] as int) l_partkey, cast(columns[2] as int) l_suppkey, cast(columns[3] as int) l_linenumber, cast(columns[4] as decimal) l_quantity, cast(columns[5] as decimal) l_extendedprice, cast(columns[6] as decimal) l_discount, cast(columns[7] as decimal) l_tax, columns[8] l_returnflag, columns[9] l_linestatus, cast(columns[10] as date) l_shipdate, cast(columns[11] as date) l_commitdate, cast(columns[12] as date) l_receiptdate, columns[13] l_shipinstruct, columns[14] l_shipmode, columns[15] l_comment from `lineitem.tbl`;

I also attached the log file along with the source data. Let me know if you have any questions