ERROR 1105 (HY000): other error: [components/tidb_query_expr/src/impl_compare_in.rs:68]: Unexpected ExprType MysqlBit and EvalType Int

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

```
create table lrr_test(`COL1` bit(28));
insert into lrr_test values(0x00000009);
select col1 from lrr_test t1 where (select count(*) from lrr_test t2 where t2.col1 in (t1.col1, -45828324)) = 1;
```

### 2. What did you expect to see? (Required)
Mysql:
+------------+
| col1 |
+------------+
| 0x00000009 |
+------------+

### 3. What did you see instead (Required)
ERROR 1105 (HY000): other error: [components/tidb_query_expr/src/impl_compare_in.rs:68]: Unexpected ExprType MysqlBit and EvalType Int

### 4. What is your TiDB version? (Required)

Release Version: v8.5.0-alpha-114-g97e7b5c268
Edition: Community
Git Commit Hash: 97e7b5c268bd7f66824ac18355f3212775593c23
Git Branch: HEAD
UTC Build Time: 2024-11-13 16:20:23
GoVersion: go1.23.3
Race Enabled: false
Check Table Before Drop: false
Store: tikv