https:create table test0831 (id string) partitioned by (cp string);
insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', '2022-08-23');
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-23' then 1 else 0 end)=0;
+--------------+--------------+
| test0830.id | test0830.cp |
+--------------+--------------+
| a | 2022-08-24 |
| b | 2022-08-24 |
+--------------+--------------+
Bug
Critical
