table schema is different for execute and select for update in transaction

[lcwangchao]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(id int primary key, v int);
insert into t values(1, 1);
prepare s from 'select * from t where id=1 for update';
begin;
             alter table t add column v2 int; -- in another session
select * from t where id=1 for update;
execute s;

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

The result schema should be the same.

mysql> execute s;
+----+------+
| id | v    |
+----+------+
|  1 |    1 |
+----+------+
1 row in set (0.00 sec)

mysql> select * from t where id=1 for update;
+----+------+
| id | v    |
+----+------+
|  1 |    1 |
+----+------+

3. What did you see instead (Required)

mysql> execute s;
+----+------+------+
| id | v    | v2   |
+----+------+------+
|  1 |    1 | NULL |
+----+------+------+
1 row in set (0.00 sec)

mysql> select * from t where id=1 for update;
+----+------+
| id | v    |
+----+------+
|  1 |    1 |
+----+------+

4. What is your TiDB version? (Required)

master

[lcwangchao]

#22381 and #26759 forces the execute statement in execute using the latest infoschema to avoid some problems in plancache. But it also caused the problem in this issue.

[lcwangchao]

dup with #34974