You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
65 lines
1.5 KiB
65 lines
1.5 KiB
5 months ago
|
--source include/force_myisam_default.inc
|
||
|
|
--source include/have_myisam.inc
|
||
|
|
#
|
||
|
|
# test of rtree (using with spatial data)
|
||
|
|
#
|
||
|
|
--disable_warnings
|
||
|
|
DROP TABLE IF EXISTS t1;
|
||
|
|
--enable_warnings
|
||
|
|
|
||
|
|
CREATE TABLE t1 (
|
||
|
|
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
|
||
|
|
g GEOMETRY NOT NULL SRID 0,
|
||
|
|
SPATIAL KEY(g)
|
||
|
|
) ENGINE=MyISAM;
|
||
|
|
|
||
|
|
SHOW CREATE TABLE t1;
|
||
|
|
|
||
|
|
--disable_query_log
|
||
|
|
let $1=150;
|
||
|
|
let $2=150;
|
||
|
|
while ($1)
|
||
|
|
{
|
||
|
|
eval INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString($1 $1, $2 $2)'));
|
||
|
|
dec $1;
|
||
|
|
inc $2;
|
||
|
|
}
|
||
|
|
--enable_query_log
|
||
|
|
|
||
|
|
SELECT count(*) FROM t1;
|
||
|
|
EXPLAIN SELECT fid, ST_AsText(g) FROM t1 WHERE ST_Within(g, ST_GeomFromText('Polygon((140 140,160 140,160 160,140 140))'));
|
||
|
|
SELECT fid, ST_AsText(g) FROM t1 WHERE ST_Within(g, ST_GeomFromText('Polygon((140 140,160 140,160 160,140 160,140 140))'));
|
||
|
|
|
||
|
|
DROP TABLE t1;
|
||
|
|
|
||
|
|
CREATE TABLE t1 (
|
||
|
|
fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
|
||
|
|
g GEOMETRY NOT NULL SRID 0
|
||
|
|
) ENGINE=MyISAM;
|
||
|
|
|
||
|
|
--disable_query_log
|
||
|
|
let $1=10;
|
||
|
|
while ($1)
|
||
|
|
{
|
||
|
|
let $2=10;
|
||
|
|
while ($2)
|
||
|
|
{
|
||
|
|
eval INSERT INTO t1 (g) VALUES (LineString(Point($1 * 10 - 9, $2 * 10 - 9), Point($1 * 10, $2 * 10)));
|
||
|
|
dec $2;
|
||
|
|
}
|
||
|
|
dec $1;
|
||
|
|
}
|
||
|
|
--enable_query_log
|
||
|
|
|
||
|
|
ALTER TABLE t1 ADD SPATIAL KEY(g);
|
||
|
|
SHOW CREATE TABLE t1;
|
||
|
|
SELECT count(*) FROM t1;
|
||
|
|
EXPLAIN SELECT fid, ST_AsText(g) FROM t1 WHERE ST_Within(g,
|
||
|
|
ST_GeomFromText('Polygon((40 40,60 40,60 60,40 40))'));
|
||
|
|
SELECT fid, ST_AsText(g) FROM t1 WHERE ST_Within(g,
|
||
|
|
ST_GeomFromText('Polygon((40 40,60 40,60 60,40 40))'));
|
||
|
|
|
||
|
|
DROP TABLE t1;
|
||
|
|
|
||
|
|
--echo End of 5.5 tests.
|