Debian Codegraph @

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

raw
1 create table t1 (c1 int, c2 geometry not null, spatial index (c2))engine=innodb ROW_FORMAT=COMPRESSED STATS_PERSISTENT=0;
2 lock tables t1 write;
3 start transaction;
4 insert into t1 values(1, Point(1,1));
5 insert into t1 values(2, Point(2,2));
6 insert into t1 values(3, Point(3,3));
7 insert into t1 values(4, Point(4,4));
8 insert into t1 values(5, Point(5,5));
9 insert into t1 values(6, Point(6,6));
10 insert into t1 values(7, Point(7,7));
11 insert into t1 values(8, Point(8,8));
12 insert into t1 values(9, Point(9,9));
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 commit;
24 unlock tables;
25 start transaction;
26 insert into t1 select * from t1;
27 select count(*) from t1;
28 count(*)
29 18432
30 rollback;
31 check table t1;
32 Table Op Msg_type Msg_text
33 test.t1 check status OK
34 select count(*) from t1;
35 count(*)
36 9216
37 set @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
38 select count(*) from t1 where MBRWithin(t1.c2, @g1);
39 count(*)
40 9216
41 set @g1 = ST_GeomFromText('Polygon((10 10,10 800,800 800,800 10,10 10))');
42 select count(*) from t1 where MBRWithin(t1.c2, @g1);
43 count(*)
44 0
45 SET @saved_dbug = @@SESSION.debug_dbug;
46 SET DEBUG_DBUG='+d,page_copy_rec_list_start_compress_fail';
47 delete from t1;
48 select count(*) from t1 where MBRWithin(t1.c2, @g1);
49 count(*)
50 0
51 SET debug_dbug = @saved_dbug;
52 InnoDB 0 transactions not purged
53 drop table t1;