Debian Codegraph @

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

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