Gecko [ www.jdcpatala.org ]

Name	Size	Permission
0.result	28.99 KB	-rw-r--r--
1.result	63.29 KB	-rw-r--r--
alter_spatial_index.result	35.42 KB	-rw-r--r--
bug16236208.result	2.78 KB	-rw-r--r--
bug16266012.result	614 B	-rw-r--r--
bug17057168.result	1.13 KB	-rw-r--r--
check_rtree.result	599 B	-rw-r--r--
create_spatial_index.result	91.58 KB	-rw-r--r--
geometry.result	47.01 KB	-rw-r--r--
gis.result	63.06 KB	-rw-r--r--
gis_split_inf.result	9.9 KB	-rw-r--r--
gis_split_nan.result	23.68 KB	-rw-r--r--
kill_server.result	997 B	-rw-r--r--
multi_pk.result	1.77 KB	-rw-r--r--
point_basic.result	49.9 KB	-rw-r--r--
point_big.result	20.09 KB	-rw-r--r--
precise.result	26.5 KB	-rw-r--r--
repeatable_spatial.result	6.96 KB	-rw-r--r--
rollback.result	224.48 KB	-rw-r--r--
row_format.result	78.11 KB	-rw-r--r--
rt_precise.result	2.08 KB	-rw-r--r--
rtree.result	103.72 KB	-rw-r--r--
rtree_compress.result	1.46 KB	-rw-r--r--
rtree_compress2.result	666 B	-rw-r--r--
rtree_concurrent_srch.result	11.67 KB	-rw-r--r--
rtree_concurrent_srch_2.result	1.02 KB	-rw-r--r--
rtree_crash.result	997 B	-rw-r--r--
rtree_create_inplace.result	1.78 KB	-rw-r--r--
rtree_debug.result	1.57 KB	-rw-r--r--
rtree_drop_index.result	140.8 KB	-rw-r--r--
rtree_estimate.result	8.19 KB	-rw-r--r--
rtree_multi_pk.result	6.98 KB	-rw-r--r--
rtree_old.result	102.68 KB	-rw-r--r--
rtree_purge.result	563 B	-rw-r--r--
rtree_recovery.result	1.48 KB	-rw-r--r--
rtree_rollback1.result	1.29 KB	-rw-r--r--
rtree_rollback2.result	406 B	-rw-r--r--
rtree_search.result	14.36 KB	-rw-r--r--
rtree_split.result	3.83 KB	-rw-r--r--
rtree_undo.result	1.72 MB	-rw-r--r--
types.result	2.96 KB	-rw-r--r--
update_root.result	481 B	-rw-r--r--

Code Editor : rtree_split.result

create table t1 (c1 int, c2 geometry not null, spatial index (c2))engine=innodb;
insert into t1 values(1, Point(1,1));
insert into t1 values(2, Point(2,2));
insert into t1 values(3, Point(3,3));
insert into t1 values(4, Point(4,4));
insert into t1 values(5, Point(5,5));
insert into t1 values(6, Point(6,6));
insert into t1 values(7, Point(7,7));
insert into t1 values(8, Point(8,8));
insert into t1 values(9, Point(9,9));
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
SET SESSION debug="+d, rtr_page_need_second_split";
insert into t1 select * from t1;
SET SESSION debug="-d, rtr_page_need_second_split";
delete from t1;
insert into t1 values(1, Point(1,1));
insert into t1 values(2, Point(2,2));
insert into t1 values(3, Point(3,3));
insert into t1 values(4, Point(4,4));
insert into t1 values(5, Point(5,5));
insert into t1 values(6, Point(6,6));
insert into t1 values(7, Point(7,7));
insert into t1 values(8, Point(8,8));
insert into t1 values(9, Point(9,9));
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
start transaction;
insert into t1 select * from t1;
rollback;
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
select count(*) from t1;
count(*)
73728
set @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
select count(*) from t1 where MBRWithin(t1.c2, @g1);
count(*)
73728
set @g1 = ST_GeomFromText('Polygon((10 10,10 800,800 800,800 10,10 10))');
select count(*) from t1 where MBRWithin(t1.c2, @g1);
count(*)
0
drop index c2 on t1;
create spatial index idx2 on t1(c2);
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` geometry NOT NULL,
  SPATIAL KEY `idx2` (`c2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
set @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
select count(*) from t1 where MBRWithin(t1.c2, @g1);
count(*)
73728
# restart: --innodb-read-only
set @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
select count(*) from t1 where MBRWithin(t1.c2, @g1);
count(*)
73728
set @g1 = ST_GeomFromText('Polygon((2 2,2 800,800 800,800 2,2 2))');
select count(*) from t1 where MBRWithin(t1.c2, @g1);
count(*)
57344
# restart
drop table t1;
#
# Bug #29465567 INNODB: RTREE SPLIT ASSERTION FAILURE
#
create table t1 (c1 int, c2 geometry not null, spatial index (c2))engine=innodb;
insert into t1 values(1, Point(1,1));
insert into t1 values(2, Point(2,2));
insert into t1 values(3, Point(3,3));
insert into t1 values(4, Point(4,4));
insert into t1 values(5, Point(5,5));
insert into t1 values(6, Point(6,6));
insert into t1 values(7, Point(7,7));
insert into t1 values(8, Point(8,8));
insert into t1 values(9, Point(9,9));
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
start transaction;
insert into t1 select * from t1;
rollback;
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
SET SESSION debug="+d, rtr_page_need_first_split";
insert into t1 select * from t1;
SET SESSION debug="-d, rtr_page_need_first_split";
drop table t1;

${this.title}

Code Editor : rtree_split.result