| 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'),('2022-04-20 00:00:00.0', NULL); |
| 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'); |
| 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')); |
| select * from test_binary where binary_col in (unhex('61'), unhex('62')); |