diff options
author | Aleksey Midenkov <midenok@gmail.com> | 2017-12-15 16:41:49 +0300 |
---|---|---|
committer | Aleksey Midenkov <midenok@gmail.com> | 2017-12-15 16:42:25 +0300 |
commit | 70d76723770529a9d89b0ec2fdcae4798f0c29a1 (patch) | |
tree | fe66b2e80b14e5331e058b1dc54a106854e44905 /mysql-test/suite | |
parent | 0e0f1126e6665a5f0277275929784a3081b23a22 (diff) | |
download | mariadb-git-70d76723770529a9d89b0ec2fdcae4798f0c29a1.tar.gz |
SQL: MDEV-14633 Assertion on TRT read [fixes #406]
Diffstat (limited to 'mysql-test/suite')
-rw-r--r-- | mysql-test/suite/versioning/r/select.result | 10 | ||||
-rw-r--r-- | mysql-test/suite/versioning/t/select.test | 10 |
2 files changed, 18 insertions, 2 deletions
diff --git a/mysql-test/suite/versioning/r/select.result b/mysql-test/suite/versioning/r/select.result index c7dab825c3d..ea7757b8160 100644 --- a/mysql-test/suite/versioning/r/select.result +++ b/mysql-test/suite/versioning/r/select.result @@ -368,9 +368,15 @@ create or replace table t2 (b int); create or replace view v1 as select a, sys_trx_start, sys_trx_end from t1 where a > round(rand()*1000); select * from v1 natural join t2; a b +### Issue #406, MDEV-14633 Assertion on TRT read +create or replace table t1 (pk int primary key, i int, t time, key (i)) with system versioning; +insert into t1 values (1, 10, '15:01:53'), (2, 20, '00:00:00'); +delete from t1; +select * from t1 where t = '00:00:00' and i > 0 and sys_trx_end <> '2012-12-12 00:00:00'; +pk i t drop view v1; drop table t1, t2; -call innodb_verify_vtq(32); +call innodb_verify_vtq(34); No A B C D 1 1 1 1 1 2 1 1 1 1 @@ -404,3 +410,5 @@ No A B C D 30 1 1 1 1 31 1 1 1 1 32 1 1 1 1 +33 1 1 1 1 +34 1 1 1 1 diff --git a/mysql-test/suite/versioning/t/select.test b/mysql-test/suite/versioning/t/select.test index b80be9590c5..3ec0451e214 100644 --- a/mysql-test/suite/versioning/t/select.test +++ b/mysql-test/suite/versioning/t/select.test @@ -254,9 +254,17 @@ create or replace table t2 (b int); create or replace view v1 as select a, sys_trx_start, sys_trx_end from t1 where a > round(rand()*1000); select * from v1 natural join t2; +--echo ### Issue #406, MDEV-14633 Assertion on TRT read +create or replace table t1 (pk int primary key, i int, t time, key (i)) with system versioning; +insert into t1 values (1, 10, '15:01:53'), (2, 20, '00:00:00'); +delete from t1; +--disable_warnings +select * from t1 where t = '00:00:00' and i > 0 and sys_trx_end <> '2012-12-12 00:00:00'; +--enable_warnings + drop view v1; drop table t1, t2; -call innodb_verify_vtq(32); +call innodb_verify_vtq(34); -- source suite/versioning/common_finish.inc |