[jira] [Created] (DRILL-5858) case expression using decimal expression causes Assignment conversion not possible

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created DRILL-5858:
---------------------------------

             Summary: case expression using decimal expression causes Assignment conversion not possible
                 Key: DRILL-5858
                 URL: https://issues.apache.org/jira/browse/DRILL-5858
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.11.0
         Environment: Drill 1.11 decimal type support enabled
            Reporter: N Campbell


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 





--
This message was sent by Atlassian JIRA
(v6.4.14#64029)