[ https://issues.apache.org/jira/browse/HIVE-26235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Peter Vary resolved HIVE-26235. ------------------------------- Fix Version/s: 4.0.0 Resolution: Fixed Pushed to master. Thanks for the review [~abstractdog] > OR Condition on binary column is returning empty result > ------------------------------------------------------- > > Key: HIVE-26235 > URL: https://issues.apache.org/jira/browse/HIVE-26235 > Project: Hive > Issue Type: Bug > Reporter: Naresh P R > Assignee: Peter Vary > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Time Spent: 40m > Remaining Estimate: 0h > > Repro steps > {code:java} > 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')); > {code} -- This message was sent by Atlassian Jira (v8.20.7#820007)