From b55a149194e7f73b5ceb35a0a5d5fb575a8ba586 Mon Sep 17 00:00:00 2001 From: Aleksey Midenkov Date: Mon, 18 Dec 2017 19:03:51 +0300 Subject: Timestamp-based versioning for InnoDB [closes #209] * Removed integer_fields check * Reworked Vers_parse_info::check_sys_fields() * Misc renames * versioned as vers_sys_type_t * Removed versioned_by_sql(), versioned_by_engine() versioned() works as before; versioned(VERS_TIMESTAMP) is versioned_by_sql(); versioned(VERS_TRX_ID) is versioned_by_engine(). * create_tmp_table() fix * Foreign constraints for timestamp-based * Range auto-specifier fix * SQL: 1-row partition rotation fix [fixes #260] * Fix 'drop system versioning, algorithm=inplace' --- mysql-test/suite/versioning/r/commit_id.result | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'mysql-test/suite/versioning/r/commit_id.result') diff --git a/mysql-test/suite/versioning/r/commit_id.result b/mysql-test/suite/versioning/r/commit_id.result index 3e4bac10790..d6cdb0182ff 100644 --- a/mysql-test/suite/versioning/r/commit_id.result +++ b/mysql-test/suite/versioning/r/commit_id.result @@ -1,5 +1,9 @@ create table t1( -id int auto_increment primary key) +id int auto_increment primary key, +sys_trx_start bigint unsigned generated always as row start, +sys_trx_end bigint unsigned generated always as row end, +period for system_time (sys_trx_start, sys_trx_end) +) with system versioning engine innodb; insert into t1 values (); -- cgit v1.2.1