[DRILL-5858] case expression using decimal expression causes Assignment conversion not possible

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Component/s: Server

Environment

Drill 1.11 decimal type support enabled

• Assignee: Vova Vysotskyi
• Reporter: N Campbell
• Created: 10/Oct/17 17:34
• Updated: 07/May/18 06:53
• Resolved: 07/May/18 06:53

Description

The error appears to be specific to an expression involving a decimal type within a case expression. If the math expressions are projected on their own the error is not thrown.

Assignment conversion not possible from type "org.apache.drill.exec.expr.holders.NullableDecimal28SparseHolder" to type "org.apache.drill.exec.expr.holders.NullableDecimal38SparseHolder"

select
CASE when 'A' = 'A' THEN FIN_FINANCE_FACT.AMOUNT_MONTH * - 1 ELSE FIN_FINANCE_FACT.AMOUNT_MONTH * 1 END AS STMT_MONTH,
CASE WHEN 'A' = 'A' THEN FIN_FINANCE_FACT.AMOUNT_YEAR_TO_DATE * - 1 ELSE FIN_FINANCE_FACT.AMOUNT_YEAR_TO_DATE * 1 END AS STMT_YEAR
FROM dfs.gosalesdw1021p.FIN_FINANCE_FACT

Issue Links

• relates to: DRILL-6094 Decimal data type enhancements