Krisztian Kasa created HIVE-28792:
-------------------------------------
Summary: 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
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)
