Result wrong with utf8mb4_unicode_ci #62808
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
mysql> select count(*) from t where b > 'F';
+----------+
| count(*) |
+----------+
| 536 |
+----------+
1 row in set (0.05 sec)
mysql> insert into mysql.expr_pushdown_blacklist(name) values('>');
Query OK, 1 row affected (0.05 sec)
mysql> admin reload expr_pushdown_blacklist;
Query OK, 0 rows affected (0.05 sec)
mysql> select count(*) from t where b > 'F';
+----------+
| count(*) |
+----------+
| 537 |
+----------+
1 row in set (0.06 sec)the wrong row is
mysql> select a, b from t where b > 'F' and a=642;
+-----+------+
| a | b |
+-----+------+
| 642 | ʩ |
+-----+------+The related pr is tikv/tikv#18611
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
Release Version: v9.0.0-beta.2.pre-254-ge34dbae
Edition: Community
Git Commit Hash: e34dbae
Git Branch: HEAD
UTC Build Time: 2025-08-04 08:43:28
GoVersion: go1.23.11
Race Enabled: false
Check Table Before Drop: false
Store: tikv
Kernel Type: Classic