diff options
author | Michael Widenius <monty@mariadb.org> | 2018-03-09 14:05:35 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
commit | a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch) | |
tree | 70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/gis-rt-precise.test | |
parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
download | mariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz |
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/t/gis-rt-precise.test')
-rw-r--r-- | mysql-test/t/gis-rt-precise.test | 86 |
1 files changed, 0 insertions, 86 deletions
diff --git a/mysql-test/t/gis-rt-precise.test b/mysql-test/t/gis-rt-precise.test deleted file mode 100644 index 9c26aa05598..00000000000 --- a/mysql-test/t/gis-rt-precise.test +++ /dev/null @@ -1,86 +0,0 @@ --- source include/have_geometry.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, - 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 (GeomFromText('LineString($1 $1, $2 $2)')); - dec $1; - inc $2; -} ---enable_query_log - -SELECT count(*) FROM t1; -EXPLAIN SELECT fid, AsText(g) FROM t1 WHERE ST_Within(g, GeomFromText('Polygon((140 140,160 140,160 160,140 140))')); -SELECT fid, AsText(g) FROM t1 WHERE ST_Within(g, 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 -) 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, AsText(g) FROM t1 WHERE ST_Within(g, - GeomFromText('Polygon((40 40,60 40,60 60,40 40))')); -SELECT fid, AsText(g) FROM t1 WHERE ST_Within(g, - GeomFromText('Polygon((40 40,60 40,60 60,40 40))')); - -DROP TABLE t1; - ---echo End of 5.5 tests. - -# -# MDEV-12078 Using spatial index changes type from point to geometry. -# -CREATE TABLE t1 ( - coordinate point NOT NULL, - SPATIAL KEY coordinate (coordinate) -) ENGINE=Aria DEFAULT CHARSET=ascii PAGE_CHECKSUM=1; - -SHOW COLUMNS FROM t1; - -INSERT INTO t1 (coordinate) VALUES(ST_PointFromText("POINT(0 0)")); -INSERT INTO t1 (coordinate) VALUES(ST_PointFromText("POINT(10 0)")); -INSERT INTO t1 (coordinate) VALUES(ST_PointFromText("POINT(10 10)")); -INSERT INTO t1 (coordinate) VALUES(ST_PointFromText("POINT(0 10)")); -INSERT INTO t1 (coordinate) VALUES(ST_PointFromText("POINT(5 5)")); - -SELECT astext(coordinate) FROM t1 WHERE ST_Intersects(ST_LineFromText("LINESTRING(0 0, 10 0, 10 10, 0 10)"), coordinate); - -SHOW COLUMNS FROM t1; - -DROP TABLE t1; |