diff options
Diffstat (limited to 'mysql-test/suite/versioning/r/alter.result')
-rw-r--r-- | mysql-test/suite/versioning/r/alter.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/r/alter.result b/mysql-test/suite/versioning/r/alter.result index d272d53f407..0c79e6d4a39 100644 --- a/mysql-test/suite/versioning/r/alter.result +++ b/mysql-test/suite/versioning/r/alter.result @@ -616,5 +616,18 @@ Warning 1906 The value specified for generated column 'e' in table 't1' has been Warning 1906 The value specified for generated column 'e' in table 't1' has been ignored alter table t1 force; set sql_mode= default; +# +# MDEV-18862 Unfortunate error message upon attempt to drop system versioning +# +set system_versioning_alter_history= keep; +create or replace table t1 (x int) with system versioning; +alter table t1 drop column `row_start`, drop column `row_end`, drop period for system_time, drop system versioning; +ERROR HY000: No 'PERIOD FOR SYSTEM_TIME' in system-versioned `t1` +alter table t1 drop period for system_time; +ERROR HY000: No 'PERIOD FOR SYSTEM_TIME' in system-versioned `t1` +alter table t1 drop column `row_start`, drop column `row_end`, drop system versioning; +ERROR 42000: Can't DROP COLUMN `row_start`; check that it exists +alter table t1 drop column `row_end`; +ERROR 42000: Can't DROP COLUMN `row_end`; check that it exists drop database test; create database test; |