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

[apollodafoni]

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: 97e7b5c
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

[apollodafoni]

/severity moderate
/sig sql-infra
/label fuzz/comp

[ti-chi-bot]

@apollodafoni: The label(s) fuzz/comp cannot be applied. These labels are supported: fuzz/sqlancer, challenge-program, compatibility-breaker, first-time-contributor, contribution, good first issue, correctness, duplicate, proposal, security, needs-more-info, needs-cherry-pick-release-5.4, needs-cherry-pick-release-6.1, needs-cherry-pick-release-6.5, needs-cherry-pick-release-7.1, needs-cherry-pick-release-7.5, needs-cherry-pick-release-8.1, needs-cherry-pick-release-8.5, affects-5.4, affects-6.1, affects-6.5, affects-7.1, affects-7.5, affects-8.1, affects-8.4, affects-8.5, may-affects-5.4, may-affects-6.1, may-affects-6.5, may-affects-7.1, may-affects-7.5, may-affects-8.1, may-affects-8.5.

In response to this:

/severity moderate
/sig sql-infra
/label fuzz/comp

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.

[apollodafoni]

/found fuzz/comp

[ti-chi-bot]

@apollodafoni: The label(s) found/fuzz/comp cannot be applied, because the repository doesn't have them.

In response to this:

/found fuzz/comp

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.