[
https://issues.apache.org/jira/browse/IMPALA-14421?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin resolved IMPALA-14421.
-----------------------------------
Resolution: Fixed
> Calcite planner: case statement returning wrong types for char, varchar
> -----------------------------------------------------------------------
>
> Key: IMPALA-14421
> URL: https://issues.apache.org/jira/browse/IMPALA-14421
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Steve Carlin
> Assignee: Steve Carlin
> Priority: Major
>
> The following case statement in chars.test is returning the wrong types (all
> STRING)
> WITH numbered AS (
> SELECT *, row_number() over (order by cs) as rn
> FROM chars_tiny)
> SELECT *
> FROM (
> SELECT CASE WHEN rn % 2 = 0 THEN cs END cs,
> CASE WHEN rn % 2 = 1 THEN cl END cl,
> CASE WHEN rn % 3 = 0 THEN vc END vc
> FROM numbered
> UNION ALL
> SELECT CASE WHEN rn % 2 = 1 THEN cs END cs,
> CASE WHEN rn % 2 = 0 THEN cl END cl,
> CASE WHEN rn % 3 = 1 THEN vc END vc
> FROM numbered) v
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
