summaryrefslogtreecommitdiff
path: root/mysql-test/suite/versioning/t/alter.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/versioning/t/alter.test')
-rw-r--r--mysql-test/suite/versioning/t/alter.test10
1 files changed, 6 insertions, 4 deletions
diff --git a/mysql-test/suite/versioning/t/alter.test b/mysql-test/suite/versioning/t/alter.test
index 7ad3c97e399..ac6f4acc7d3 100644
--- a/mysql-test/suite/versioning/t/alter.test
+++ b/mysql-test/suite/versioning/t/alter.test
@@ -1,3 +1,6 @@
+--source include/default_charset.inc
+--source suite/versioning/common.inc
+
select @@system_versioning_alter_history;
create table t(
@@ -156,7 +159,6 @@ alter table t modify a int with system versioning;
show create table t;
# TODO: move TRX_ID cases to separate test
--- source suite/versioning/common.inc
create or replace table t(
a int
) engine=innodb;
@@ -451,7 +453,7 @@ use mysql;
create or replace table t (x int) with system versioning;
--error ER_VERS_DB_NOT_SUPPORTED
alter table user add system versioning;
-use test;
+use test2;
--echo # MDEV-15956 Strange ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN upon ALTER on versioning column
create or replace table t1 (i int, j int as (i), s timestamp(6) as row start, e timestamp(6) as row end, period for system_time(s,e)) with system versioning;
@@ -538,5 +540,5 @@ create or replace table t1 (f1 int) with system versioning;
--error ER_VERS_NOT_VERSIONED
alter table t1 drop system versioning, add f2 int with system versioning;
-drop database test;
-create database test;
+drop table t1;
+--source suite/versioning/common_finish.inc