diff options
Diffstat (limited to 'mysql-test/suite/maria/maria-mvcc.result')
-rw-r--r-- | mysql-test/suite/maria/maria-mvcc.result | 183 |
1 files changed, 183 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/maria-mvcc.result b/mysql-test/suite/maria/maria-mvcc.result new file mode 100644 index 00000000..796c446d --- /dev/null +++ b/mysql-test/suite/maria/maria-mvcc.result @@ -0,0 +1,183 @@ +set global aria_page_checksum=1; +drop table if exists t1; +connect con1,localhost,root,,; +connection con1; +create table t1 (i int) engine=aria; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `i` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 +insert into t1 values (0); +lock tables t1 write concurrent; +insert into t1 values (1); +insert into t1 values (2); +/* should see 0, 1 and 2 */ +select i from t1; +i +0 +1 +2 +select count(*) from t1; +count(*) +3 +connect con2,localhost,root,,; +connection con2; +/* should see 0 */ +select i from t1; +i +0 +select count(*) from t1; +count(*) +1 +lock tables t1 write concurrent; +insert into t1 values (3); +insert into t1 values (4); +/* should see 0, 3 and 4 */ +select i from t1; +i +0 +3 +4 +select count(*) from t1; +count(*) +3 +unlock tables; +lock tables t1 write concurrent; +insert into t1 values (5); +/* should see 0, 3, 4 and 5 */ +select i from t1; +i +0 +3 +4 +5 +select count(*) from t1; +count(*) +4 +connect con3,localhost,root,,; +connection con3; +lock tables t1 write concurrent; +/* should see 0, 3, 4 */ +select i from t1; +i +0 +3 +4 +select count(*) from t1; +count(*) +3 +connection con1; +insert into t1 values (6); +/* Should see 0, 1, 2, 6 */ +select i from t1; +i +0 +1 +2 +6 +select count(*) from t1; +count(*) +4 +unlock tables; +lock tables t1 write concurrent; +/* Should see 0, 1, 2, 3, 4 and 6 */ +select i from t1; +i +0 +1 +2 +3 +4 +6 +select count(*) from t1; +count(*) +6 +connection con2; +/* should see 0, 3, 4, 5 */ +select i from t1; +i +0 +3 +4 +5 +select count(*) from t1; +count(*) +4 +unlock tables; +/* should see 0, 1, 2, 3, 4, 5, 6 */ +select i from t1; +i +0 +1 +2 +3 +4 +5 +6 +select count(*) from t1; +count(*) +7 +connection con1; +unlock tables; +/* should see 0, 1, 2, 3, 4, 5, 6 */ +select i from t1; +i +0 +1 +2 +3 +4 +5 +6 +select count(*) from t1; +count(*) +7 +connection con3; +insert into t1 values (7); +/* should see 0, 3, 4, 7 */ +select i from t1; +i +0 +3 +4 +7 +select count(*) from t1; +count(*) +4 +unlock tables; +/* should see 0, 1, 2, 3, 4, 5, 6, 7 */ +select i from t1; +i +0 +1 +2 +3 +4 +5 +6 +7 +select count(*) from t1; +count(*) +8 +connection default; +drop table t1; +CREATE TABLE t1 (fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, g GEOMETRY NOT NULL, SPATIAL KEY(g) ) transactional=1 row_format=page engine=aria; +lock tables t1 write concurrent, t1 as t2 write concurrent; +insert into t1 (fid,g) values (NULL,GeomFromText('LineString(0 0,1 1)')); +select fid from t1 as t2; +fid +1 +select count(*) from t1 as t2; +count(*) +1 +insert into t1 (fid,g) values (NULL,GeomFromText('LineString(0 0,1 1)')); +select fid from t1 as t2; +fid +1 +2 +select count(*) from t1 as t2; +count(*) +2 +unlock tables; +drop table t1; |