diff options
Diffstat (limited to 'mysql-test/r/maria-mvcc.result')
| -rw-r--r-- | mysql-test/r/maria-mvcc.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/maria-mvcc.result b/mysql-test/r/maria-mvcc.result index b80f07cd9d2..0fec28697c2 100644 --- a/mysql-test/r/maria-mvcc.result +++ b/mysql-test/r/maria-mvcc.result @@ -138,3 +138,22 @@ select count(*) from t1; count(*) 7 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=maria; +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; |