diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2020-04-04 00:53:37 +0300 |
|---|---|---|
| committer | Aleksey Midenkov <midenok@gmail.com> | 2020-04-04 00:53:37 +0300 |
| commit | 105b879d0f541f049a131a5c3b99d678fc7d3213 (patch) | |
| tree | 6aaffe72cdc15ec1a9786859bba2015ace001fe0 /mysql-test/suite/period/t/alter.test | |
| parent | 431a740815dc21d7daf00359b1764c41ff95bbdc (diff) | |
| download | mariadb-git-105b879d0f541f049a131a5c3b99d678fc7d3213.tar.gz | |
MDEV-21941 RENAME doesn't work for system time or period fields
- Ignore system-invisible fields (as well as for setting default value);
- Handle rename of system time and period fields.
Diffstat (limited to 'mysql-test/suite/period/t/alter.test')
| -rw-r--r-- | mysql-test/suite/period/t/alter.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/suite/period/t/alter.test b/mysql-test/suite/period/t/alter.test index 3f45d68cd61..d89b7c93574 100644 --- a/mysql-test/suite/period/t/alter.test +++ b/mysql-test/suite/period/t/alter.test @@ -131,3 +131,17 @@ alter table t add constraint mytime_1 check (x > 2); insert t values (3, @e, @s); 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; |