1--- ./mysql-test/main/alter_table.result	2020-02-27 19:35:41.279992329 +0300
2+++ ./mysql-test/main/alter_table,heap.reject	2020-02-27 19:39:44.175998039 +0300
3@@ -2716,8 +2716,7 @@
4 t3	CREATE TABLE `t3` (
5   `a` int(11) DEFAULT NULL,
6   `b` int(11) DEFAULT NULL,
7-  KEY `b` (`b`),
8-  CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`b`) REFERENCES `t1` (`bb`)
9+  KEY `b` (`b`)
10 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=latin1
11 ALTER TABLE t1 RENAME COLUMN bb TO b;
12 SHOW CREATE TABLE t1;
13@@ -2733,8 +2732,7 @@
14 t3	CREATE TABLE `t3` (
15   `a` int(11) DEFAULT NULL,
16   `c` int(11) DEFAULT NULL,
17-  KEY `b` (`c`),
18-  CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`c`) REFERENCES `t1` (`b`)
19+  KEY `b` (`c`)
20 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=latin1
21 CREATE TABLE t4(a int);
22 ALTER TABLE t4 RENAME COLUMN a TO aa, ALGORITHM = INPLACE;
23@@ -2774,36 +2772,6 @@
24 ERROR 42S22: Unknown column 'd' in 'field list'
25 DROP TRIGGER trg1;
26 DROP PROCEDURE sp1;
27-CREATE TABLE t_gen(a INT, b DOUBLE GENERATED ALWAYS AS (SQRT(a)));
28-INSERT INTO t_gen(a) VALUES(4);
29-SELECT * FROM t_gen;
30-a	b
31-4	2
32-SHOW CREATE TABLE t_gen;
33-Table	Create Table
34-t_gen	CREATE TABLE `t_gen` (
35-  `a` int(11) DEFAULT NULL,
36-  `b` double GENERATED ALWAYS AS (sqrt(`a`)) VIRTUAL
37-) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=latin1
38-ALTER TABLE t_gen RENAME COLUMN a TO c, CHANGE COLUMN b b DOUBLE GENERATED ALWAYS AS (SQRT(c));
39-SELECT * FROM t_gen;
40-c	b
41-4	2
42-SHOW CREATE TABLE t_gen;
43-Table	Create Table
44-t_gen	CREATE TABLE `t_gen` (
45-  `c` int(11) DEFAULT NULL,
46-  `b` double GENERATED ALWAYS AS (sqrt(`c`)) VIRTUAL
47-) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=latin1
48-ALTER TABLE t_gen CHANGE COLUMN c x INT;
49-show create table t_gen;
50-Table	Create Table
51-t_gen	CREATE TABLE `t_gen` (
52-  `x` int(11) DEFAULT NULL,
53-  `b` double GENERATED ALWAYS AS (sqrt(`x`)) VIRTUAL
54-) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=latin1
55-ALTER TABLE t_gen RENAME COLUMN x TO a;
56-DROP TABLE t_gen;
57 SHOW CREATE TABLE t1;
58 Table	Create Table
59 t1	CREATE TABLE `t1` (
60