GuangMing Lu created HIVE-26505: ----------------------------------- Summary: Case When Some result data is lost when there are common column conditions and partitioned column conditions Key: HIVE-26505 URL: https://issues.apache.org/jira/browse/HIVE-26505 Project: Hive Issue Type: Bug Components: Hive Affects Versions: 4.0.0-alpha-1, 3.1.0 Reporter: GuangMing Lu
insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-24'),('d', '2022-08-244'); insert into test0831 values ('a', '2022-08-24'),('b', '2022-08-24'); select * from test0831; +-------------+--------------+ | test0831.id | test0831.cp | +-------------+--------------+ | a | 2022-08-23 | | b | 2022-08-23 | | a | 2022-08-23 | | c | 2022-08-24 | | d | 2022-08-24 | +-------------+--------------+ select * from test0831 where (case when id='a' and cp='2022-08-24' then 1 else 0 end)=0; +--------------+--------------+ | test0830.id | test0830.cp | +--------------+--------------+ | a | 2022-08-23 | | c | 2022-08-23 | | d | 2022-08-23 | +--------------+--------------+ -- This message was sent by Atlassian Jira (v8.20.10#820010)