You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2026/04/11 00:13:00 UTC
[jira] [Resolved] (IMPALA-14421) Calcite planner: case statement returning wrong types for char, varchar
[ 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org