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_search.test

# WL#6968 InnoDB R-tree cursor support

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

--source include/have_innodb.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.
delimiter |;
create procedure insert_t1(IN total int)
begin
	declare i int default 1;
	while (i <= total) DO
		insert into t1 values (i, Point(i, i));
		set i = i + 1;
	end while;
end|
delimiter ;|

# Test level 1 rtree.
CALL insert_t1(1000);
select count(*) from t1;

set @g1 = ST_GeomFromText('Polygon((0 0,0 1000,1000 1000,1000 0,0 0))');

select count(*) from t1 where MBRWithin(t1.c2, @g1);

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);

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

#SET DEBUG='+d, rtr_pessimistic_position';
#select count(*) from t1 where MBRWithin(t1.c2, @g1);
#SET DEBUG='-d, rtr_pessimistic_position';

# Equality search
set @g1 =  ST_GeomFromText('Point(1 1)');
select count(*) from t1 where MBRequals(t1.c2, @g1);

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

# Clean up.
DROP PROCEDURE insert_t1;

truncate t1;

let $1=150;
let $2=150;
while ($1)
{
  eval INSERT INTO t1  VALUES ($1, ST_GeomFromText('LineString($1 $1, $2 $2)'));
  dec $1;
  inc $2;
}

select count(*) from t1;

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

INSERT INTO t1  VALUES (1, ST_GeomFromText('LineString(2 2, 150 150)'));
INSERT INTO t1  VALUES (1, ST_GeomFromText('LineString(3 3, 160 160)'));
INSERT INTO t1  VALUES (1, ST_GeomFromText('LineString(4 4, 170 170)'));
INSERT INTO t1  VALUES (1, ST_GeomFromText('LineString(5 5, 180 180)'));
INSERT INTO t1  VALUES (1, ST_GeomFromText('LineString(6 6, 190 190)'));
INSERT INTO t1  VALUES (1, ST_GeomFromText('LineString(7 7, 200 200)'));
INSERT INTO t1  VALUES (1, ST_GeomFromText('LineString(8 8, 210 210)'));

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;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;

# Testing "MBRtouches"
# This is apparently now treated as "intersects"
set @g1 = ST_GeomFromText('Polygon((0 0,0 2, 2 2, 2 0, 0 0))');
select count(*) from t1 where MBRtouches(t1.c2, @g1);

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

# Test MBRequals
set @g1 = ST_GeomFromText('LineString(2 2, 150 150)');
select count(*) from t1 where MBRequals(t1.c2, @g1);

# Test store procedure with open cursor
set @g1 = ST_GeomFromText('Polygon((0 0,0 200,200 200,200 0,0 0))');
create table t3 (a int) engine = innodb;

delimiter |;

CREATE PROCEDURE curdemo()
BEGIN
  DECLARE done INT DEFAULT FALSE;
  DECLARE a INT;

DECLARE cur1 CURSOR FOR SELECT c1 from t1 where  MBRWithin(t1.c2, @g1);
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

OPEN cur1;
  read_loop: LOOP
    FETCH cur1 INTO a;
   IF done THEN
      LEAVE read_loop;
   END IF;
  INSERT INTO test.t3 VALUES (a);
END LOOP;

CLOSE cur1;
END|

delimiter ;|

call curdemo();

select count(*) from t3;

drop procedure curdemo;
drop table t3;
drop table t1;

${this.title}

Code Editor : rtree_search.test