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