issue of multi-schema change on same column

[crazycs520]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t (a int, b int);
alter table t change b bb int, add index idx(bb);

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

execute successful:

mysql>create table t (a int, b int);
Query OK, 0 rows affected
mysql>alter table t change b bb int, add index idx(bb);
Query OK, 0 rows affected

3. What did you see instead (Required)

execute failed:

mysql>create table t (a int, b int);
Query OK, 0 rows affected
mysql>alter table t change b bb int, add index idx(bb);
(1072, 'column does not exist: bb')

4. What is your TiDB version? (Required)

select tidb_version()\G
***************************[ 1. row ]***************************
tidb_version() | Release Version: v6.4.0-alpha-241-gde568beb4a
Edition: Community
Git Commit Hash: de568beb4aac3989053f5c45f4614f8297792d52
Git Branch: master
UTC Build Time: 2022-11-04 08:19:05
GoVersion: go1.19.3
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: unistore

[crazycs520]

@tangenta PTAL

[tangenta]

This limitation is documented in https://docs.pingcap.com/tidb/dev/sql-statement-alter-table#mysql-compatibility.