Gecko [ www.jdcpatala.org ]

Name	Size	Permission
0.result	28.99 KB	-rw-r--r--
1.result	63.29 KB	-rw-r--r--
alter_spatial_index.result	35.42 KB	-rw-r--r--
bug16236208.result	2.78 KB	-rw-r--r--
bug16266012.result	614 B	-rw-r--r--
bug17057168.result	1.13 KB	-rw-r--r--
check_rtree.result	599 B	-rw-r--r--
create_spatial_index.result	91.58 KB	-rw-r--r--
geometry.result	47.01 KB	-rw-r--r--
gis.result	63.06 KB	-rw-r--r--
gis_split_inf.result	9.9 KB	-rw-r--r--
gis_split_nan.result	23.68 KB	-rw-r--r--
kill_server.result	997 B	-rw-r--r--
multi_pk.result	1.77 KB	-rw-r--r--
point_basic.result	49.9 KB	-rw-r--r--
point_big.result	20.09 KB	-rw-r--r--
precise.result	26.5 KB	-rw-r--r--
repeatable_spatial.result	6.96 KB	-rw-r--r--
rollback.result	224.48 KB	-rw-r--r--
row_format.result	78.11 KB	-rw-r--r--
rt_precise.result	2.08 KB	-rw-r--r--
rtree.result	103.72 KB	-rw-r--r--
rtree_compress.result	1.46 KB	-rw-r--r--
rtree_compress2.result	666 B	-rw-r--r--
rtree_concurrent_srch.result	11.67 KB	-rw-r--r--
rtree_concurrent_srch_2.result	1.02 KB	-rw-r--r--
rtree_crash.result	997 B	-rw-r--r--
rtree_create_inplace.result	1.78 KB	-rw-r--r--
rtree_debug.result	1.57 KB	-rw-r--r--
rtree_drop_index.result	140.8 KB	-rw-r--r--
rtree_estimate.result	8.19 KB	-rw-r--r--
rtree_multi_pk.result	6.98 KB	-rw-r--r--
rtree_old.result	102.68 KB	-rw-r--r--
rtree_purge.result	563 B	-rw-r--r--
rtree_recovery.result	1.48 KB	-rw-r--r--
rtree_rollback1.result	1.29 KB	-rw-r--r--
rtree_rollback2.result	406 B	-rw-r--r--
rtree_search.result	14.36 KB	-rw-r--r--
rtree_split.result	3.83 KB	-rw-r--r--
rtree_undo.result	1.72 MB	-rw-r--r--
types.result	2.96 KB	-rw-r--r--
update_root.result	481 B	-rw-r--r--

Code Editor : types.result

SET SESSION debug="+d,row_print_geometry_data";
CREATE TABLE t_wl6455 ( i INT, g GEOMETRY NOT NULL) ENGINE=InnoDB;
SHOW CREATE TABLE t_wl6455;
Table	Create Table
t_wl6455	CREATE TABLE `t_wl6455` (
  `i` int(11) DEFAULT NULL,
  `g` geometry NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
INSERT INTO t_wl6455 VALUES(1, POINT(1,1));
INSERT INTO t_wl6455 VALUES(2, POINT(2,2));
SET @mp = 'MULTIPOINT(0 0, 20 20, 60 60)';
INSERT INTO t_wl6455 VALUES(3, ST_GeomFromText(@mp));
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)));
SET @mls = 'MultiLineString((1 1,2 2,3 3),(4 4,5 5))';
INSERT INTO t_wl6455 VALUES(6, ST_GeomFromText(@mls));
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));
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));
SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))';
INSERT INTO t_wl6455 VALUES(9, ST_GeomFromText(@gc));
SELECT ST_AsText(g) FROM t_wl6455;
ST_AsText(g)
POINT(1 1)
POINT(2 2)
MULTIPOINT((0 0),(20 20),(60 60))
LINESTRING(1 1,4 4)
LINESTRING(2 2,5 5)
MULTILINESTRING((1 1,2 2,3 3),(4 4,5 5))
POLYGON((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1 1))
MULTIPOLYGON(((0 0,0 3,3 3,3 0,0 0),(1 1,1 2,2 2,2 1,1 1)))
GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(2 2,3 3))
CREATE INDEX i_p ON t_wl6455 (g(10));
EXPLAIN SELECT ST_AsText(g) FROM t_wl6455 WHERE g = POINT(2,2);
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t_wl6455	NULL	ref	i_p	i_p	12	const	#	100.00	Using where
Warnings:
Note	1003	/* select#1 */ select st_astext(`test`.`t_wl6455`.`g`) AS `ST_AsText(g)` from `test`.`t_wl6455` where (`test`.`t_wl6455`.`g` = <cache>(point(2,2)))
SELECT ST_AsText(g) FROM t_wl6455 WHERE g = POINT(2,2);
ST_AsText(g)
POINT(2 2)
SET AUTOCOMMIT = 0;
INSERT INTO t_wl6455 VALUES(10, POINT(10,10));
SELECT ST_AsText(g) FROM t_wl6455 WHERE g = POINT(10,10);
ST_AsText(g)
POINT(10 10)
ROLLBACK;
SELECT ST_AsText(g) FROM t_wl6455 WHERE g = POINT(10,10);
ST_AsText(g)
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));
# Kill and restart
CHECK TABLE t_wl6455;
Table	Op	Msg_type	Msg_text
test.t_wl6455	check	status	OK
SELECT ST_AsText(g) FROM t_wl6455;
ST_AsText(g)
POINT(1 1)
POINT(2 2)
MULTIPOINT((0 0),(20 20),(60 60))
LINESTRING(1 1,4 4)
LINESTRING(2 2,5 5)
MULTILINESTRING((1 1,2 2,3 3),(4 4,5 5))
POLYGON((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1 1))
MULTIPOLYGON(((0 0,0 3,3 3,3 0,0 0),(1 1,1 2,2 2,2 1,1 1)))
GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(2 2,3 3))
POINT(10 10)
POINT(11 11)
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';
name	pos	mtype
g	1	14
DROP TABLE t_wl6455;

${this.title}

Code Editor : types.result