[
https://issues.apache.org/jira/browse/HIVE-28792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krisztian Kasa resolved HIVE-28792.
-----------------------------------
Fix Version/s: 4.1.0
Resolution: Fixed
Merged #5681 to master. Thanks [~zabetak] for the review.
> 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
> Fix For: 4.1.0
>
>
> 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)
