change column hang the ddl

[aytrack]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

drop table if exists t;
create table t (a char(5), b char(10)) partition by list columns (a) (
    partition p0 values in ('0'),
    partition p1 values in ('a'),
    partition p2 values in ('az')
);

alter table t change a a varchar(10);
alter table t change a a int;

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

change column a from varchar(10) to int success or report unsupport error.

3. What did you see instead (Required)

the session is hang and other ddl can dot execute

-- another session 
TiDB root@127.0.0.1:test> create table t0(a int);
(8027, 'Information schema is out of date: schema failed to update in 1 lease, please make sure TiDB can connect to TiKV')

4. What is your TiDB version? (Required)

TiDB root@127.0.0.1:(none)> select * from information_schema.cluster_info;
+------+-----------------+-----------------+-------------+------------------------------------------+---------------------------+--------------+-----------+
| TYPE | INSTANCE        | STATUS_ADDRESS  | VERSION     | GIT_HASH                                 | START_TIME                | UPTIME       | SERVER_ID |
+------+-----------------+-----------------+-------------+------------------------------------------+---------------------------+--------------+-----------+
| tidb | 127.0.0.1:4000  | 127.0.0.1:10080 | 6.4.0-alpha | 17fac8bc2883dd287481a60f019beae948191a47 | 2022-10-18T19:17:36+08:00 | 4m59.524443s | 3482832   |
| pd   | 127.0.0.1:2379  | 127.0.0.1:2379  | 6.4.0-alpha | bc2019e0c4a0eea1a9559f03a2f9de88511f793e | 2022-10-18T19:17:16+08:00 | 5m19.524447s | 0         |
| tikv | 127.0.0.1:20160 | 127.0.0.1:20180 | 6.4.0-alpha | 26b6c3cfccb386af50b1592ae4583dfb0003d7c1 | 2022-10-18T19:17:20+08:00 | 5m15.52445s  | 0         |
+------+-----------------+-----------------+-------------+------------------------------------------+---------------------------+--------------+-----------+

[mjonss]

I don't think this is a critical bug, since the support of change/modify a column on a partitioned table was just added in #38302
So it should not affect any released version.

[aytrack]

Functionally, this issue will cause other DDLs to fail. So I think it is a critical issue. For features under development, we can add the feature/developing tag.