[HIVE-26235] OR Condition on binary column is returning empty result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-2
• Labels: pull-request-available
• Assignee: Peter Vary
• Reporter: Naresh P R
• Created: 17/May/22 19:45
• Updated: 16/Nov/22 13:50
• Resolved: 26/May/22 04:43

Description

Repro steps

create table test_binary(data_col timestamp, binary_col binary) partitioned by (ts string);
insert into test_binary partition(ts='202204200000') 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');
// Works
select * from test_binary where ts='202204200000' and binary_col = unhex('61');
select * from test_binary where ts='202204200000' and binary_col between unhex('61') and unhex('62');
//Returns empty result
select * from test_binary where binary_col = unhex('61') or binary_col = unhex('62');
select * from test_binary where ts='202204200000' and (binary_col = unhex('61') or binary_col = unhex('62'));

Issue Links

• is duplicated by: HIVE-26250 Fix GenericUDFIn for Binary type
• links to: GitHub Pull Request #3305