diff options
Diffstat (limited to 'mysql-test/suite/versioning/t/alter.test')
-rw-r--r-- | mysql-test/suite/versioning/t/alter.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/t/alter.test b/mysql-test/suite/versioning/t/alter.test index f11eee59641..ea699104eac 100644 --- a/mysql-test/suite/versioning/t/alter.test +++ b/mysql-test/suite/versioning/t/alter.test @@ -514,5 +514,19 @@ update t1 set e= 1; alter table t1 force; set sql_mode= default; +--echo # +--echo # MDEV-18862 Unfortunate error message upon attempt to drop system versioning +--echo # +set system_versioning_alter_history= keep; +create or replace table t1 (x int) with system versioning; +--error ER_VERS_NO_PERIOD +alter table t1 drop column `row_start`, drop column `row_end`, drop period for system_time, drop system versioning; +--error ER_VERS_NO_PERIOD +alter table t1 drop period for system_time; +--error ER_CANT_DROP_FIELD_OR_KEY +alter table t1 drop column `row_start`, drop column `row_end`, drop system versioning; +--error ER_CANT_DROP_FIELD_OR_KEY +alter table t1 drop column `row_end`; + drop database test; create database test; |