#
# Test STORED generated column and RENAME COLUMN statement
#   https://bugs.mysql.com/bug.php?id=92727
#

CREATE TABLE t1 (a int, b int, gcol int AS (a + 1) STORED);

INSERT INTO t1 (a, b) VALUES (1, 2);
SELECT * FROM t1;

ALTER TABLE t1 RENAME COLUMN a TO b, RENAME COLUMN b TO a;

INSERT INTO t1 (a, b) VALUES (1, 2);
SELECT * FROM t1;

DROP TABLE t1;