diff options
Diffstat (limited to 'mysql-test/suite/period/t/alter.test')
-rw-r--r-- | mysql-test/suite/period/t/alter.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/period/t/alter.test b/mysql-test/suite/period/t/alter.test index 3fa3c5c87d5..68d9adf476a 100644 --- a/mysql-test/suite/period/t/alter.test +++ b/mysql-test/suite/period/t/alter.test @@ -151,3 +151,19 @@ alter table t1 add system versioning; # cleanup drop table t1; + +--echo # +--echo # MDEV-21941 RENAME doesn't work for system time or period fields +--echo # +create or replace table t1 ( + a int, s date, e date, + period for mytime(s, e)); + +alter table t1 rename column s to x; +alter table t1 rename column e to y; + +show create table t1; +# cleanup +drop table t1; + +--echo # End of 10.5 tests |