query key Partition table get panic while Partition Key is not first column

[aytrack]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

drop table if exists t1;
create table t1(a int, id bigint primary key, name varchar(20)) partition by key(id) partitions 4;
select * from t1 where id = 'a';

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

query success

3. What did you see instead (Required)

get panic

[16:46:38]TiDB root:test>  select * from t1 where id = 'a';
(1105, 'runtime error: index out of range [1] with length 1')
[16:46:38]TiDB root:test>

4. What is your TiDB version? (Required)

all tidb versions

[16:47:07]TiDB root:test> select tidb_version();
+-----------------------------------------------------------+
| tidb_version()                                            |
+-----------------------------------------------------------+
| Release Version: v7.6.0                                   |
| Edition: Community                                        |
| Git Commit Hash: 6701bf1527c7386a82396a1ecfb5322872daa2b3 |
| Git Branch: heads/refs/tags/v7.6.0                        |
| UTC Build Time: 2024-01-08 12:51:43                       |
| GoVersion: go1.21.5                                       |
| Race Enabled: false                                       |
| Check Table Before Drop: false                            |
| Store: unistore                                           |
+-----------------------------------------------------------+

[kennedy8312]

/type regression

[kennedy8312]

The same operation didn't trigger the error on v6.5.0.
mysql> use test;
Database changed
mysql> drop table if exists t1;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> create table t1(a int, id bigint primary key, name varchar(20)) partition by key(id) partitions 4;
Query OK, 0 rows affected, 1 warning (0.10 sec)

mysql> select * from t1 where id = 'a';
Empty set, 2 warnings (0.01 sec)

mysql> select tidb_version();
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version() |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v6.5.0
Edition: Community
Git Commit Hash: 706c3fa
Git Branch: heads/refs/tags/v6.5.0
UTC Build Time: 2022-12-27 03:42:38
GoVersion: go1.19.3
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: tikv |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

[Defined2014]

dup with #50206

[seiya-annie]

/found community