diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2017-12-18 19:03:51 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-12-18 19:03:51 +0300 |
| commit | b55a149194e7f73b5ceb35a0a5d5fb575a8ba586 (patch) | |
| tree | 5586c3cbb6189f5823bb71e983eb381f6769fda8 /mysql-test/suite/versioning/r/commit_id.result | |
| parent | d5e37621cf1dd2fe1a1226992be05ca57d595b79 (diff) | |
| download | mariadb-git-b55a149194e7f73b5ceb35a0a5d5fb575a8ba586.tar.gz | |
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'
Diffstat (limited to 'mysql-test/suite/versioning/r/commit_id.result')
| -rw-r--r-- | mysql-test/suite/versioning/r/commit_id.result | 6 |
1 files changed, 5 insertions, 1 deletions
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 (); |