[jira] [Created] (HIVE-27264) Literals in conjunction of two in expression are considered not equals if type precision is different

[Krisztian Kasa (Jira)]

Krisztian Kasa created HIVE-27264:
-------------------------------------

             Summary: Literals in conjunction of two in expression are 
considered not equals if type precision is different
                 Key: HIVE-27264
                 URL: https://issues.apache.org/jira/browse/HIVE-27264
             Project: Hive
          Issue Type: Bug
          Components: CBO
            Reporter: Krisztian Kasa
            Assignee: Krisztian Kasa


{code}
create table r_table (
  string_col varchar(30)
);


create table l_table (
  string_col varchar(14)
);

insert into r_table VALUES ('AAA111');
insert into l_table VALUES ('AAA111');
SELECT l_table.string_col from l_table, r_table
WHERE r_table.string_col = l_table.string_col AND l_table.string_col IN 
('AAA111', 'BBB222') AND r_table.string_col IN ('AAA111', 'BBB222');
{code}
Should give one row
{code}
AAA111
{code}
but it returns empty rs

Workaround
{code}
set hive.optimize.point.lookup=false;
{code}





--
This message was sent by Atlassian Jira
(v8.20.10#820010)