[
https://issues.apache.org/jira/browse/HIVE-28792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on HIVE-28792 started by Krisztian Kasa.
---------------------------------------------
> Wrong results when query has function call with char parameter type in case
> expression
> --------------------------------------------------------------------------------------
>
> Key: HIVE-28792
> URL: https://issues.apache.org/jira/browse/HIVE-28792
> Project: Hive
> Issue Type: Bug
> Components: CBO
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available
>
> Repro
> {code:java}
> CREATE EXTERNAL TABLE testchar (col1 char(3));
> INSERT INTO testchar VALUES ('A'),('B');
> select col1, case upper(col1) when 'A' then 'OK' else 'N/A' end as col2 from
> testchar;
> {code}
> The query should return
> {code:java}
> A OK
> B N/A
> {code}
> but it returns
> {code:java}
> A N/A
> B N/A
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
