diff options
Diffstat (limited to 'mysql-test/suite/versioning/t/alter.test')
-rw-r--r-- | mysql-test/suite/versioning/t/alter.test | 10 |
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 |