Gecko [ www.jdcpatala.org ]

Name	Size	Permission
0.test	911 B	-rw-r--r--
1.test	49.62 KB	-rw-r--r--
alter_spatial_index.test	24.38 KB	-rw-r--r--
bug16236208.test	3.07 KB	-rw-r--r--
bug16266012.test	873 B	-rw-r--r--
bug17057168.test	1.15 KB	-rw-r--r--
check_rtree.test	781 B	-rw-r--r--
create_spatial_index.test	42.08 KB	-rw-r--r--
geometry.test	25.68 KB	-rw-r--r--
gis.test	48.77 KB	-rw-r--r--
gis_split_inf.test	9.81 KB	-rw-r--r--
gis_split_nan.test	19.28 KB	-rw-r--r--
kill_server.test	1.2 KB	-rw-r--r--
multi_pk.test	2.38 KB	-rw-r--r--
point_basic.test	34.66 KB	-rw-r--r--
point_big.test	14.58 KB	-rw-r--r--
precise.test	9.13 KB	-rw-r--r--
repeatable_spatial.test	6.75 KB	-rw-r--r--
rollback.test	226.33 KB	-rw-r--r--
row_format.test	749 B	-rw-r--r--
rt_precise.test	1.71 KB	-rw-r--r--
rtree.test	100.99 KB	-rw-r--r--
rtree_compress.test	1.84 KB	-rw-r--r--
rtree_compress2.test	1.25 KB	-rw-r--r--
rtree_concurrent_srch.test	13.26 KB	-rw-r--r--
rtree_concurrent_srch_2.test	1.52 KB	-rw-r--r--
rtree_create_inplace.test	2.01 KB	-rw-r--r--
rtree_debug.test	1.5 KB	-rw-r--r--
rtree_drop_index.test	140.96 KB	-rw-r--r--
rtree_estimate.test	2.51 KB	-rw-r--r--
rtree_multi_pk.test	4.79 KB	-rw-r--r--
rtree_old.test	46.97 KB	-rw-r--r--
rtree_purge.test	1.31 KB	-rw-r--r--
rtree_recovery.test	1.74 KB	-rw-r--r--
rtree_rollback1.test	1.54 KB	-rw-r--r--
rtree_rollback2.test	717 B	-rw-r--r--
rtree_search.test	3.76 KB	-rw-r--r--
rtree_split.test	4.19 KB	-rw-r--r--
rtree_undo.test	847 B	-rw-r--r--
types.test	2.58 KB	-rw-r--r--
update_root.test	862 B	-rw-r--r--

Code Editor : rtree_split.test

# WL#6745 InnoDB R-tree support
# This test case will test R-tree split, mostly on duplciate records.

# Not supported in embedded
--source include/not_embedded.inc

--source include/have_innodb.inc
--source include/big_test.inc
--source include/not_valgrind.inc
--source include/have_debug.inc

# Create table with R-tree index.
create table t1 (c1 int, c2 geometry not null, spatial index (c2))engine=innodb;

# Insert enough values to let R-tree split.
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;

#Check second round spliting.
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;
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;

select count(*) from t1;

set @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
select count(*) from t1 where MBRWithin(t1.c2, @g1);

set @g1 = ST_GeomFromText('Polygon((10 10,10 800,800 800,800 10,10 10))');
select count(*) from t1 where MBRWithin(t1.c2, @g1);

drop index c2 on t1;

# Test create index with algorithm=inplace
create spatial index idx2 on t1(c2);

show create table t1;

set @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
select count(*) from t1 where MBRWithin(t1.c2, @g1);

# test read only case
let $restart_parameters = restart: --innodb-read-only;
--source include/restart_mysqld.inc
set @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
select count(*) from t1 where MBRWithin(t1.c2, @g1);

set @g1 = ST_GeomFromText('Polygon((2 2,2 800,800 800,800 2,2 2))');
select count(*) from t1 where MBRWithin(t1.c2, @g1);

let $restart_parameters = restart;
--source include/restart_mysqld.inc

# Clean up.
drop table t1;

--echo #
--echo # Bug #29465567 INNODB: RTREE SPLIT ASSERTION FAILURE
--echo #

# Create table with R-tree index.
create table t1 (c1 int, c2 geometry not null, spatial index (c2))engine=innodb;

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;
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 first round spliting.
SET SESSION debug="+d, rtr_page_need_first_split";
insert into t1 select * from t1;
SET SESSION debug="-d, rtr_page_need_first_split";

# Clean up.
drop table t1;

${this.title}

Code Editor : rtree_split.test