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.test31
1 files changed, 18 insertions, 13 deletions
diff --git a/mysql-test/suite/versioning/t/alter.test b/mysql-test/suite/versioning/t/alter.test
index 83f8898c672..d570b6f4259 100644
--- a/mysql-test/suite/versioning/t/alter.test
+++ b/mysql-test/suite/versioning/t/alter.test
@@ -172,23 +172,23 @@ alter table t drop system versioning;
insert into t values(1);
-call verify_vtq;
+call verify_trt;
alter table t
add column trx_start bigint(20) unsigned as row start invisible,
add column trx_end bigint(20) unsigned as row end invisible,
add period for system_time(trx_start, trx_end),
add system versioning;
-call verify_vtq;
+call verify_trt;
show create table t;
alter table t drop column trx_start, drop column trx_end;
-call verify_vtq;
+call verify_trt;
alter table t drop system versioning, algorithm=copy;
-call verify_vtq;
+call verify_trt;
alter table t add system versioning, algorithm=copy;
-call verify_vtq;
+call verify_trt;
show create table t;
@@ -198,31 +198,31 @@ select * from t for system_time all;
alter table t add column b int, algorithm=copy;
show create table t;
select * from t;
-call verify_vtq;
+call verify_trt;
alter table t drop column b, algorithm=copy;
show create table t;
select * from t for system_time all;
-call verify_vtq;
+call verify_trt;
## FIXME: #414 IB: inplace for VERS_TIMESTAMP versioning
if (0)
{
alter table t drop system versioning, algorithm=inplace;
-call verify_vtq;
+call verify_trt;
alter table t add system versioning, algorithm=inplace;
-call verify_vtq;
+call verify_trt;
show create table t;
update t set a= 1;
select * from t for system_time all;
-call verify_vtq;
+call verify_trt;
alter table t add column b int, algorithm=inplace;
show create table t;
select * from t;
-call verify_vtq;
+call verify_trt;
alter table t drop column b, algorithm=inplace;
show create table t;
@@ -232,7 +232,7 @@ select * from t for system_time all;
alter table t drop system versioning, algorithm=copy;
show create table t;
-call verify_vtq;
+call verify_trt;
# nullable autoinc test w/o versioning
create or replace table t (a int);
@@ -341,7 +341,7 @@ select * from t;
show create table t;
-call verify_vtq;
+call verify_trt;
}
create or replace table t (a int) with system versioning;
@@ -449,5 +449,10 @@ create or replace table t (x int) with system versioning;
alter table user add system versioning;
use test;
+--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;
+--error ER_VERS_ALTER_SYSTEM_FIELD
+alter table t1 modify s timestamp(6) as row start;
+
drop database test;
create database test;