diff options
| author | Eugene Kosov <claprix@yandex.ru> | 2017-09-12 16:27:44 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-09-12 16:27:44 +0300 |
| commit | 78d2430aa22eac6e6b6e24b8776290d4d939a236 (patch) | |
| tree | 036d619072caae83eb9a2aafa85bbd0afd5abadd | |
| parent | a49239b57a5e46f118a7ab46b8f298b4f596d6ec (diff) | |
| download | mariadb-git-78d2430aa22eac6e6b6e24b8776290d4d939a236.tar.gz | |
Tests: VTMD + modify column
| -rw-r--r-- | mysql-test/suite/versioning/r/vtmd.result | 10 | ||||
| -rw-r--r-- | mysql-test/suite/versioning/t/vtmd.test | 5 |
2 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/r/vtmd.result b/mysql-test/suite/versioning/r/vtmd.result index 910a937e9c5..ad72da94df3 100644 --- a/mysql-test/suite/versioning/r/vtmd.result +++ b/mysql-test/suite/versioning/r/vtmd.result @@ -265,6 +265,16 @@ A_start B_end name C_archive_name 1 0 other_name t1_ 1 0 t1 t1_ 1 1 t2 NULL +create or replace table t3 (x int) with system versioning; +alter table t3 change x x bigint; +alter table t3 change x x bigint after sys_trx_start; +call check_vtmd('t3_vtmd'); +@start > 0 and @start < @inf +1 +A_start B_end name C_archive_name +1 0 t3 t3_ +1 0 t3 t3_ +1 1 t3 NULL drop database db0; drop database db1; drop database test; diff --git a/mysql-test/suite/versioning/t/vtmd.test b/mysql-test/suite/versioning/t/vtmd.test index 2826c6fd2ff..8ff2f64dc73 100644 --- a/mysql-test/suite/versioning/t/vtmd.test +++ b/mysql-test/suite/versioning/t/vtmd.test @@ -155,6 +155,11 @@ use test; show tables; call check_vtmd('t2_vtmd'); +create or replace table t3 (x int) with system versioning; +alter table t3 change x x bigint; +alter table t3 change x x bigint after sys_trx_start; +call check_vtmd('t3_vtmd'); + drop database db0; drop database db1; drop database test; |