The result of in multiple values expression is not correct

[lilinghai]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t2(a int primary key);
insert into t2 values(0),(1);
alter table t2 set tiflash replica 2;
set tidb_enforce_mpp=on;
select a, avg(a or 1) in (0,0) from t2 group by a;
/*
+---------------------------+---------+--------------+---------------+-----------------------------------------------------------------------------------------+
| id                        | estRows | task         | access object | operator info                                                                           |
+---------------------------+---------+--------------+---------------+-----------------------------------------------------------------------------------------+
| TableReader_11            | 2.00    | root         |               | data:ExchangeSender_10                                                                  |
| └─ExchangeSender_10       | 2.00    | cop[tiflash] |               | ExchangeType: PassThrough                                                               |
|   └─Projection_6          | 2.00    | cop[tiflash] |               | collation2.t2.a, in(cast(or(collation2.t2.a, 1), decimal(24,4) BINARY), 0, 0)->Column#3 |
|     └─TableFullScan_9     | 2.00    | cop[tiflash] | table:t2      | keep order:false, stats:pseudo                                                          |
+---------------------------+---------+--------------+---------------+-----------------------------------------------------------------------------------------+
*/

2. What did you expect to see? (Required)

+---+----------------------+
| a | avg(a or 1) in (0,0) |
+---+----------------------+
| 0 |                    0 |
| 1 |                    0 |
+---+----------------------+

3. What did you see instead (Required)

+---+----------------------+
| a | avg(a or 1) in (0,0) |
+---+----------------------+
| 0 |                 NULL |
| 1 |                 NULL |
+---+----------------------+

4. What is your TiFlash version? (Required)

v5.1.4 release test

[VelocityLight]

update