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

Log work

Agile Board

Rank to Top

Rank to Bottom

Bulk Copy Attachments

Bulk Move Attachments

Voters

Watch issue

Watchers

Create sub-task

Convert to sub-task

Move

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 4.0.0-alpha-2
Component/s: None
Labels:
- pull-request-available

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'));