Debian Codegraph @

mysql-test/suite/innodb_gis/r/rtree_rollback1.result

raw
1 create table t1 (c1 int, c2 geometry not null SRID 0, spatial index (c2))engine=innodb;
2 insert into t1 values(1, Point(1,1));
3 insert into t1 values(2, Point(2,2));
4 insert into t1 values(3, Point(3,3));
5 insert into t1 values(4, Point(4,4));
6 insert into t1 values(5, Point(5,5));
7 insert into t1 values(6, Point(6,6));
8 insert into t1 values(7, Point(7,7));
9 insert into t1 values(8, Point(8,8));
10 insert into t1 values(9, Point(9,9));
11 insert into t1 select * from t1;
12 insert into t1 select * from t1;
13 insert into t1 select * from t1;
14 insert into t1 select * from t1;
15 insert into t1 select * from t1;
16 insert into t1 select * from t1;
17 insert into t1 select * from t1;
18 insert into t1 select * from t1;
19 insert into t1 select * from t1;
20 insert into t1 select * from t1;
21 insert into t1 select * from t1;
22 insert into t1 select * from t1;
23 start transaction;
24 insert into t1 select * from t1;
25 select count(*) from t1;
26 count(*)
27 73728
28 rollback;
29 check table t1;
30 Table Op Msg_type Msg_text
31 test.t1 check status OK
32 select count(*) from t1;
33 count(*)
34 36864
35 set @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
36 select count(*) from t1 where MBRWithin(t1.c2, @g1);
37 count(*)
38 36864
39 set @g1 = ST_GeomFromText('Polygon((10 10,10 800,800 800,800 10,10 10))');
40 select count(*) from t1 where MBRWithin(t1.c2, @g1);
41 count(*)
42 0
43 drop table t1;