Steve Carlin created IMPALA-14421:
-------------------------------------
Summary: 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
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: [email protected]
For additional commands, e-mail: [email protected]
