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 "Noémi Pap-Takács (Jira)" <ji...@apache.org> on 2026/10/19 13:14:00 UTC
[jira] [Updated] (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 ]
Noémi Pap-Takács updated IMPALA-14421:
--------------------------------------
Fix Version/s: Impala 5.0.0
> 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
> Fix For: Impala 5.0.0
>
>
> 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