[HIVE-26250] Fix GenericUDFIn for Binary type

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Peter Vary
• Created: 20/May/22 12:35
• Updated: 20/May/22 12:45
• Resolved: 20/May/22 12:45

Description

When we use IN, or the query optimizer converts our OR statements to IN then we get empty results.
One example is:

create table test_binary(datet timestamp, dip binary);
insert into test_binary values ('2022-04-20 00:00:00.0', 'a'),('2022-04-20 00:00:00.0', 'b'), ('2022-04-20 00:00:00.0', 'c') ;
select * from test_binary where dip = unhex('61') or dip = unhex('62') ; --empty result
select * from test_binary where dip = unhex('61'); -- correct result

Issue Links

• duplicates: HIVE-26235 OR Condition on binary column is returning empty result