Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

set tidb_enable_global_index=true;
create table pt (
    a int, b int, c int, d int default 0, 
    primary key (a, b) clustered, 
    unique key uidx(c)) partition by range(a) ( 
        PARTITION p0 VALUES LESS THAN (3), 
        PARTITION p1 VALUES LESS THAN (6), 
        PARTITION p2 VALUES LESS THAN (9), 
        PARTITION p3 VALUES LESS THAN (20) 
);
insert into pt(a,b,c) values(1,1,1), (2,2,2), (3,3,3), (4,4,4), (5,5,5), (6,6,6), (7,7,7), (8,8,8), (9,9,9), (10,10,10);
analyze table pt;
select c from pt where c = 1;
select * from pt where c in (1,2,3);

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

for point get: 1,1,1;
for batch point get: 1,1,1;2,2,2;3,3,3;

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

mysql> select tidb_version();
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version() |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v7.6.0-alpha-629-g89fc4403f3
Edition: Community
Git Commit Hash: 89fc440
Git Branch: local/fix_global_index_under_clustered_index
UTC Build Time: 2024-01-03 02:59:45
GoVersion: go1.21.0
Race Enabled: false
Check Table Before Drop: false
Store: unistore |
+--------------------------------------------------------