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 : types.test

# WL#6455 GEOMETRY datatypes support
# In order to implement GIS indexing in InnoDB,
# InnoDB needs to support GEOMETRY datatypes,
# so that InnoDB stores them properly and understands them.

# Restarting is not supported in embedded
--source include/not_embedded.inc
--source include/have_innodb.inc
--source include/have_debug.inc

# Avoid CrashReporter popup on Mac
--source include/not_crashrep.inc

# Turn on the geometry data print.
SET SESSION debug="+d,row_print_geometry_data";

# Test GEOMETRY datatype.
CREATE TABLE t_wl6455 ( i INT, g GEOMETRY NOT NULL) ENGINE=InnoDB;
SHOW CREATE TABLE t_wl6455;

# Insert Point.
INSERT INTO t_wl6455 VALUES(1, POINT(1,1));

INSERT INTO t_wl6455 VALUES(2, POINT(2,2));

# Insert MultiPoint.
SET @mp = 'MULTIPOINT(0 0, 20 20, 60 60)';
INSERT INTO t_wl6455 VALUES(3, ST_GeomFromText(@mp));

# Insert LineString.
INSERT INTO t_wl6455 VALUES(4, LINESTRING(POINT(1,1), POINT(4, 4)));

INSERT INTO t_wl6455 VALUES(5, LINESTRING(POINT(2,2), POINT(5, 5)));

# Insert MultiLineString.
SET @mls = 'MultiLineString((1 1,2 2,3 3),(4 4,5 5))';
INSERT INTO t_wl6455 VALUES(6, ST_GeomFromText(@mls));

# Insert Polygon.
SET @poly = 'Polygon((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1 1))';
INSERT INTO t_wl6455 VALUES(7, ST_GeomFromText(@poly));

# Insert MultiPolygon.
SET @mpoly = 'MultiPolygon(((0 0,0 3,3 3,3 0,0 0),(1 1,1 2,2 2,2 1,1 1)))';
INSERT INTO t_wl6455 VALUES(8, ST_GeomFromText(@mpoly));

# Insert GeometryCollection.
SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))';
INSERT INTO t_wl6455 VALUES(9, ST_GeomFromText(@gc));

# Show result.
SELECT ST_AsText(g) FROM t_wl6455;

# Test create prefix index.
CREATE INDEX i_p ON t_wl6455 (g(10));

# Select on prefix index.
--replace_column 10 #
EXPLAIN SELECT ST_AsText(g) FROM t_wl6455 WHERE g = POINT(2,2);
SELECT ST_AsText(g) FROM t_wl6455 WHERE g = POINT(2,2);

# Test rollback/commit
SET AUTOCOMMIT = 0;
INSERT INTO t_wl6455 VALUES(10, POINT(10,10));
SELECT ST_AsText(g) FROM t_wl6455 WHERE g = POINT(10,10);
ROLLBACK;
SELECT ST_AsText(g) FROM t_wl6455 WHERE g = POINT(10,10);

INSERT INTO t_wl6455 VALUES(10, POINT(10,10));
COMMIT;

INSERT INTO t_wl6455 VALUES(11, POINT(11,11));
BEGIN;
INSERT INTO t_wl6455 VALUES(1, POINT(1,1));

--source include/kill_and_restart_mysqld.inc

CHECK TABLE t_wl6455;
SELECT ST_AsText(g) FROM t_wl6455;

# Check information_schema, the mtype of GEOMETRY datatype is 14.
SELECT sc.name, sc.pos, sc.mtype
FROM information_schema.innodb_sys_columns sc
INNER JOIN information_schema.innodb_sys_tables st
ON sc.TABLE_ID=st.TABLE_ID
WHERE st.NAME='test/t_wl6455' AND sc.NAME='g';

# Clean up
DROP TABLE t_wl6455;

${this.title}

Code Editor : types.test