diff options
author | Aleksey Midenkov <midenok@gmail.com> | 2019-03-20 20:45:54 +0300 |
---|---|---|
committer | Aleksey Midenkov <midenok@gmail.com> | 2019-08-11 12:32:08 +0300 |
commit | 638e78853f8d7c0e2c1cf580f3847c5789f165e1 (patch) | |
tree | 1b4141a1583d75eb56be85f3e8826758f2363896 /mysql-test/suite/versioning | |
parent | 5851e668d7a0d51034c7d74779c39ef0f7b8d002 (diff) | |
download | mariadb-git-638e78853f8d7c0e2c1cf580f3847c5789f165e1.tar.gz |
MDEV-18862 Unfortunate error message upon attempt to drop system versioning
Special case for DROP PERIOD when system fields are implicit.
Diffstat (limited to 'mysql-test/suite/versioning')
-rw-r--r-- | mysql-test/suite/versioning/r/alter.result | 13 | ||||
-rw-r--r-- | mysql-test/suite/versioning/t/alter.test | 14 |
2 files changed, 27 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; 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; |