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

#
# BUG#21245805 HA_INNOBASE::RECORDS_IN_RANGE() RETURNS CONSTANT FOR SPATIAL INDEXES
#

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

CREATE TABLE t1 (
  g GEOMETRY NOT NULL
) ENGINE=InnoDB;

ALTER TABLE t1 ADD SPATIAL(g);

SET @g1 = ST_GeomFromText('POINT(10 10)');
SET @g2 = ST_GeomFromText('POLYGON((5 5, 20 5, 20 21, 5 21, 5 5))');
SET @g3 = ST_GeomFromText('POLYGON((1.79769e+308 1.79769e+308, 20 5, -1.79769e+308 -1.79769e+308, 1.79769e+308 1.79769e+308))');

# Test empty table
EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g1);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);

# Insert gis data
INSERT INTO t1 VALUES(@g1);
INSERT INTO t1 VALUES(@g2);
INSERT INTO t1 VALUES(@g3);

SELECT ST_AsText(g) FROM t1;

ANALYZE TABLE t1;

# Test g1
EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g1);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g1);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g1);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g1);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g1);

# Test g2
EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g2);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g2);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g2);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g2);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g2);

# Test g3
EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRContains(g, @g3);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRDisjoint(g, @g3);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBREquals(g, @g3);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRIntersects(g, @g3);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);

EXPLAIN SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);
SELECT ST_AsText(g) FROM t1 WHERE MBRWithin(g, @g3);

DROP TABLE t1;

${this.title}

Code Editor : rtree_estimate.test