diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2018-03-29 20:24:29 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2018-04-10 13:12:36 +0200 |
| commit | 689f83d0ce2c949718246fc8244f7c6dfa6cc78f (patch) | |
| tree | a1595da2a1845090da7827a89cfe64b4961db3dc /mysql-test/suite/versioning/t/alter.test | |
| parent | dba43f4bec72362bbb0959328a5b80847ae97a86 (diff) | |
| download | mariadb-git-689f83d0ce2c949718246fc8244f7c6dfa6cc78f.tar.gz | |
MDEV-14790 System versioning for system tables does not work as expected
disallow system versioning for tables in mysql database
Diffstat (limited to 'mysql-test/suite/versioning/t/alter.test')
| -rw-r--r-- | mysql-test/suite/versioning/t/alter.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/t/alter.test b/mysql-test/suite/versioning/t/alter.test index 128397b6cc8..83f8898c672 100644 --- a/mysql-test/suite/versioning/t/alter.test +++ b/mysql-test/suite/versioning/t/alter.test @@ -439,5 +439,15 @@ alter table t drop column sys_trx_end, drop period for system_time; --error ER_VERS_ALREADY_VERSIONED alter table t add period for system_time(sys_trx_start, sys_trx_end); +--echo # +--echo # MDEV-14790 System versioning for system tables does not work as expected +--echo # +use mysql; +--error ER_VERS_DB_NOT_SUPPORTED +create or replace table t (x int) with system versioning; +--error ER_VERS_DB_NOT_SUPPORTED +alter table user add system versioning; +use test; + drop database test; create database test; |