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 2a82f74b670..fab933eca87 100644 --- a/mysql-test/suite/period/t/alter.test +++ b/mysql-test/suite/period/t/alter.test @@ -174,3 +174,19 @@ alter table t add period if not exists for ` ` (s,e); --error ER_WRONG_COLUMN_NAME create table t2 (period for `` (s,e)) select * from t; drop table t; + +--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 |