diff options
Diffstat (limited to 'mysql-test/suite/versioning/r/partition.result')
| -rw-r--r-- | mysql-test/suite/versioning/r/partition.result | 31 |
1 files changed, 26 insertions, 5 deletions
diff --git a/mysql-test/suite/versioning/r/partition.result b/mysql-test/suite/versioning/r/partition.result index f5106e03a14..9b6f2201c22 100644 --- a/mysql-test/suite/versioning/r/partition.result +++ b/mysql-test/suite/versioning/r/partition.result @@ -1,6 +1,10 @@ set system_versioning_alter_history=keep; # Check conventional partitioning on temporal tables -create table t1 (x int) +create or replace table t1 ( +x int, +row_start SYS_DATATYPE as row start invisible, +row_end SYS_DATATYPE as row end invisible, +period for system_time(row_start, row_end)) with system versioning partition by range columns (x) ( partition p0 values less than (100), @@ -34,7 +38,13 @@ select * from t1 partition (p1) for system_time all; x 300 # Engine change native <-> non-native versioning prohibited -create or replace table t1 (i int) engine=DEFAULT_ENGINE with system versioning partition by hash(i); +create or replace table t1 ( +i int, +row_start SYS_DATATYPE as row start invisible, +row_end SYS_DATATYPE as row end invisible, +period for system_time(row_start, row_end)) +engine=DEFAULT_ENGINE +with system versioning partition by hash(i); alter table t1 engine=NON_DEFAULT_ENGINE; ERROR HY000: Not allowed for system-versioned `test`.`t1`. Change to/from native system versioning engine is not supported. ## CREATE TABLE @@ -334,14 +344,21 @@ select * from t1 partition (p1sp0); x select * from t1 partition (p1sp1); x -create or replace table t1 (a bigint) +create or replace table t1 ( +a bigint, +row_start SYS_DATATYPE as row start invisible, +row_end SYS_DATATYPE as row end invisible, +period for system_time(row_start, row_end)) with system versioning partition by range (a) (partition p0 values less than (20) engine innodb, partition p1 values less than maxvalue engine innodb); insert into t1 values (1); create or replace table t1 ( -f_int1 integer default 0 +f_int1 integer default 0, +row_start SYS_DATATYPE as row start invisible, +row_end SYS_DATATYPE as row end invisible, +period for system_time(row_start, row_end) ) with system versioning partition by range(f_int1) subpartition by hash(f_int1) @@ -350,7 +367,11 @@ subpartition by hash(f_int1) subpartition subpart12 storage engine = 'innodb')); insert into t1 values (1); create or replace table t1 (i int) engine=innodb partition by key(i); -alter table t1 add system versioning; +alter table t1 +add column row_start SYS_DATATYPE as row start invisible, +add column row_end SYS_DATATYPE as row end invisible, +add period for system_time(row_start, row_end), +add system versioning; insert into t1 values(); # MDEV-14722 Assertion in ha_commit_trans for sub-statement create or replace table t1 (i int) with system versioning |