Debian Codegraph @

mysql-test/suite/innodb_gis/r/gis_split_nan.result

raw
1 # Creating the spatial objects
2 USE test;
3 CREATE TABLE gis_point (fid INTEGER NOT NULL PRIMARY KEY, g POINT);
4 CREATE TABLE gis_linestring (fid INTEGER NOT NULL PRIMARY KEY, g LINESTRING);
5 CREATE TABLE gis_polygon (fid INTEGER NOT NULL PRIMARY KEY, g POLYGON);
6 CREATE TABLE gis_multi_point (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOINT);
7 CREATE TABLE gis_multi_linestring (fid INTEGER NOT NULL PRIMARY KEY, g MULTILINESTRING);
8 CREATE TABLE gis_multi_polygon (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOLYGON);
9 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRYCOLLECTION);
10 # Inserting POINT Geometry Values
11 INSERT INTO gis_point VALUES
12 (101, ST_POINTFROMTEXT('POINT(0 0)')),
13 (102, ST_POINTFROMTEXT('POINT(1 0)')),
14 (103, ST_POINTFROMTEXT('POINT(0 1)')),
15 (104, ST_POINTFROMTEXT('POINT(1 1)')),
16 (105, ST_POINTFROMTEXT('POINT(-1 1)'));
17 INSERT INTO gis_point VALUES
18 (106, ST_POINTFROMWKB(ST_ASWKB(POINT(0,0)))),
19 (107, ST_POINTFROMWKB(ST_ASWKB(POINT(10,0)))),
20 (108, ST_POINTFROMWKB(ST_ASWKB(POINT(0,10)))),
21 (109, ST_POINTFROMWKB(ST_ASWKB(POINT(-10,0)))),
22 (110, ST_POINTFROMWKB(ST_ASWKB(POINT(0,-10))));
23 INSERT INTO gis_point VALUES
24 (111, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1 1)')))),
25 (112, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1e308 1e308)')))),
26 (113, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1e308 -1e308)')))),
27 (114, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(-1e308 1e308)')))),
28 (115, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(-1e308 -1e308)'))));
29 # Inserting LINESTRING Geometry Values
30 INSERT INTO gis_linestring VALUES
31 (201, ST_LINEFROMTEXT('LINESTRING(0 0,5 5)')),
32 (202, ST_LINEFROMTEXT('LINESTRING(0 0,2 2,4 4)')),
33 (203, ST_LINEFROMTEXT('LINESTRING(0 0,5 5,10 10)'));
34 INSERT INTO gis_linestring VALUES
35 (204, ST_LINESTRINGFROMTEXT('LINESTRING(10 10,5 5)')),
36 (205, ST_LINESTRINGFROMTEXT('LINESTRING(0 0,12 12,24 24)')),
37 (206, ST_LINESTRINGFROMTEXT('LINESTRING(0 0,50 50,100 100)'));
38 INSERT INTO gis_linestring VALUES
39 (207, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5))))),
40 (208, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,10))))),
41 (209, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)))));
42 INSERT INTO gis_linestring VALUES
43 (210, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5))))),
44 (211, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(-50,-50), POINT(10,-10))))),
45 (212, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(1e308,1e308), POINT(1e308,-1e308)))));
46 INSERT INTO gis_linestring VALUES
47 (213, ST_LINEFROMWKB(ST_ASWKB(ST_LINEFROMTEXT('LINESTRING(1e308 1e308,1e308 -1e308)')))),
48 (214, ST_LINEFROMWKB(ST_ASWKB(ST_LINEFROMTEXT('LINESTRING(1 1,2 2,3 3,4 4,5 5,6 6,7 7,8 8,9 9)')))),
49 (215, ST_LINESTRINGFROMWKB(ST_ASWKB(ST_LINESTRINGFROMTEXT('LINESTRING(10 10,10 -10,-10 -10,-10 10,10 10)'))));
50 # Inserting POLYGON Geometry Values
51 INSERT INTO gis_polygon VALUES
52 (301, ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,0 0))')),
53 (302, ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))')),
54 (303, ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
55 INSERT INTO gis_polygon VALUES
56 (304, ST_POLYGONFROMTEXT('POLYGON((0 0,0 50,50 50,50 0,0 0))')),
57 (305, ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4))')),
58 (306, ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'));
59 INSERT INTO gis_polygon VALUES
60 (307, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))),
61 (308, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)))))),
62 (309, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
63 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))));
64 INSERT INTO gis_polygon VALUES
65 (310, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))),
66 (311, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(10,10), POINT(10,15), POINT(15,15), POINT(15,10), POINT(10,10)))))),
67 (312, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(10,10), POINT(10,20), POINT(20,20), POINT(20,10), POINT(10,10)),
68 LINESTRING(POINT(14,14), POINT(14,16), POINT(16,16), POINT(16,14), POINT(14,14))))));
69 INSERT INTO gis_polygon VALUES
70 (313, ST_POLYFROMWKB(ST_ASWKB(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,5 5,0 0))')))),
71 (314, ST_POLYFROMWKB(ST_ASWKB(ST_POLYGONFROMTEXT('POLYGON((10 0,10 10,0 10,-10 10,-10 0,-10 -10,0 10,10 -10,10 0))')))),
72 (315, ST_POLYGONFROMWKB(ST_ASWKB(ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'))));
73 # Inserting MULTIPOINT Geometry Values
74 INSERT INTO gis_multi_point VALUES
75 (401, ST_GEOMFROMTEXT('MULTIPOINT(0 0)')),
76 (402, ST_GEOMFROMTEXT('MULTIPOINT(0 0,2 2,4 4)')),
77 (403, ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 5,10 10)'));
78 INSERT INTO gis_multi_point VALUES
79 (404, ST_GEOMFROMTEXT('MULTIPOINT(0 0,100 100)')),
80 (405, ST_GEOMFROMTEXT('MULTIPOINT(0 0,1e308 1e308)')),
81 (406, ST_GEOMFROMTEXT('MULTIPOINT(1e308 1e308,1e308 -1e308,-1e308 1e308,-1e308 -1e308)'));
82 INSERT INTO gis_multi_point VALUES
83 (407, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0))))),
84 (408, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(10,10))))),
85 (409, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)))));
86 INSERT INTO gis_multi_point VALUES
87 (410, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0))))),
88 (411, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(1e308,1e308))))),
89 (412, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308), POINT(-1e308,-1e308)))));
90 INSERT INTO gis_multi_point VALUES
91 (413, ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('MULTIPOINT(0 0)')))),
92 (414, ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('MULTIPOINT(0 0,1e308 1e308,-1e308 -1e308)')))),
93 (415, ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('MULTIPOINT(1e308 1e308,1e308 -1e308,-1e308 1e308,-1e308 -1e308,1e308 1e308)'))));
94 # Inserting MULTILINESTRING Geometry Values
95 INSERT INTO gis_multi_linestring VALUES
96 (501, ST_GEOMFROMTEXT('MULTILINESTRING((0 0,2 2))')),
97 (502, ST_GEOMFROMTEXT('MULTILINESTRING((0 0,2 2,4 4))')),
98 (503, ST_GEOMFROMTEXT('MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))'));
99 INSERT INTO gis_multi_linestring VALUES
100 (504, ST_GEOMFROMTEXT('MULTILINESTRING((0 0,100 100,-100 -100))')),
101 (505, ST_GEOMFROMTEXT('MULTILINESTRING((1e308 1e308,-1e308 -1e308))')),
102 (506, ST_GEOMFROMTEXT('MULTILINESTRING((1e308 1e308,-1e308 -1e308),(1e308 -1e308,-1e308 1e308))'));
103 INSERT INTO gis_multi_linestring VALUES
104 (507, ST_GEOMFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2)))))),
105 (508, ST_GEOMFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)))))),
106 (509, ST_GEOMFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4)),
107 LINESTRING(POINT(6,6), POINT(8,8), POINT(10,10))))));
108 INSERT INTO gis_multi_linestring VALUES
109 (510, ST_GEOMFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4)))))),
110 (511, ST_GEOMFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1,1), POINT(2,2)))))),
111 (512, ST_GEOMFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)),
112 LINESTRING(POINT(36,36), POINT(48,48), POINT(50,50))))));
113 INSERT INTO gis_multi_linestring VALUES
114 (513, ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10),(0 10,10 0))')))),
115 (514, ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10,-10 10,0 0),(0 0,-10 -10,10 -10,0 0))')))),
116 (515, ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 100),(0 0,100 0),(0 0,0 -100),(0 0,-100 0))'))));
117 # Inserting MULTIPOLGYON Geometry Values
118 INSERT INTO gis_multi_polygon VALUES
119 (601, ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))')),
120 (602, ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)),((5 5,5 10,10 10,5 5)))')),
121 (603, ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
122 INSERT INTO gis_multi_polygon VALUES
123 (604, ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))')),
124 (605, ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,0 -2,-2 -2,0 0)))')),
125 (606, ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,-5 5,0 0)),((0 0,-5 -5,5 -5,0 0)))'));
126 INSERT INTO gis_multi_polygon VALUES
127 (607, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))))))),
128 (608, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
129 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
130 (609, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))),
131 POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0)))))));
132 INSERT INTO gis_multi_polygon VALUES
133 (610, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0))))))),
134 (611, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(10,10), POINT(20,10), POINT(20,20), POINT(10,20), POINT(10,10)),
135 LINESTRING(POINT(14,14), POINT(14,16), POINT(16,16), POINT(16,14), POINT(14,14))))))),
136 (612, ST_GEOMFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
137 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
138 POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0)))))));
139 INSERT INTO gis_multi_polygon VALUES
140 (613, ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,5 -5,0 0)),((0 0,-5 5,-5 -5,0 0)))')))),
141 (614, ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))')))),
142 (615, ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,10 0,5 -5,0 0)))'))));
143 # Inserting GEOMETRYCOLLECTION Geometry Values
144 INSERT INTO gis_geometrycollection VALUES
145 (701, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))')),
146 (702, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),
147 (703, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5), POLYGON((0 0,0 10,10 10,10 0,0 0)))'));
148 INSERT INTO gis_geometrycollection VALUES
149 (704, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),
150 (705, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
151 'LINESTRING(0 0,10 10),'
152 'POLYGON((0 0,0 10,10 10,10 0,0 0,0 0, 0 0)))')),
153 (706, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),'
154 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
155 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),'
156 '((0 0,-10 0,-10 -10,0 -10,0 0))))'));
157 INSERT INTO gis_geometrycollection VALUES
158 (707, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0))))),
159 (708, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0),
160 LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
161 POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
162 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
163 (709, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(MULTIPOINT(POINT(0,0), POINT(5,5), POINT(10,10)),
164 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
165 LINESTRING(POINT(10,10), POINT(5,5), POINT(0,10))),
166 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
167 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
168 POLYGON(LINESTRING(POINT(0,0), POINT(-10,0), POINT(-10,-10), POINT(0,0))))))));
169 INSERT INTO gis_geometrycollection VALUES
170 (710, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0),
171 LINESTRING(POINT(0,0), POINT(100,100)))))),
172 (711, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(10,10),
173 LINESTRING(POINT(10,10), POINT(12,12), POINT(14,14), POINT(16,16), POINT(18,18)),
174 POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
175 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
176 (712, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(MULTIPOINT(POINT(10,10), POINT(15,15), POINT(20,20)),
177 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
178 LINESTRING(POINT(10,10), POINT(5,5), POINT(0,10))),
179 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
180 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
181 POLYGON(LINESTRING(POINT(0,0), POINT(-10,0), POINT(-10,-10), POINT(0,0))))))));
182 INSERT INTO gis_geometrycollection VALUES
183 (713, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
184 'POINT(0 0),'
185 'LINESTRING(0 0,10 10),'
186 'POLYGON((0 0,0 10,10 10,10 0,0 0)),'
187 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10),'
188 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
189 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))')))),
190 (714, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
191 'GEOMETRYCOLLECTION('
192 'POINT(0 0)),'
193 'GEOMETRYCOLLECTION('
194 'LINESTRING(0 0,10 10)),'
195 'GEOMETRYCOLLECTION('
196 'POLYGON((0 0,0 10,10 10,10 0,0 0))),'
197 'GEOMETRYCOLLECTION('
198 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10)),'
199 'GEOMETRYCOLLECTION('
200 'MULTILINESTRING((0 0,10 10),(0 10,10 0))),'
201 'GEOMETRYCOLLECTION('
202 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))))')))),
203 (715, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
204 'GEOMETRYCOLLECTION(),'
205 'POINT(0 0),'
206 'GEOMETRYCOLLECTION('
207 'LINESTRING(0 0,10 10),'
208 'GEOMETRYCOLLECTION('
209 'GEOMETRYCOLLECTION())),'
210 'GEOMETRYCOLLECTION(),'
211 'GEOMETRYCOLLECTION('
212 'GEOMETRYCOLLECTION()),'
213 'POLYGON((0 0,0 10,10 10,10 0,0 0)),'
214 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10),'
215 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
216 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))'))));
217 # Creating a table with spatial index column
218 CREATE TABLE geom_index (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY NOT NULL SRID 0, SPATIAL INDEX(g));
219 # Inserting geometry values
220 INSERT INTO geom_index SELECT * FROM gis_point;
221 INSERT INTO geom_index SELECT * FROM gis_linestring;
222 INSERT INTO geom_index SELECT * FROM gis_polygon;
223 INSERT INTO geom_index SELECT * FROM gis_multi_point;
224 INSERT INTO geom_index SELECT * FROM gis_multi_linestring;
225 INSERT INTO geom_index SELECT * FROM gis_multi_polygon;
226 INSERT INTO geom_index SELECT * FROM gis_geometrycollection;
227 check table geom_index;
228 Table Op Msg_type Msg_text
229 test.geom_index check status OK
230 # Final cleanup
231 DROP TABLE gis_point;
232 DROP TABLE gis_linestring;
233 DROP TABLE gis_polygon;
234 DROP TABLE gis_multi_point;
235 DROP TABLE gis_multi_linestring;
236 DROP TABLE gis_multi_polygon;
237 DROP TABLE gis_geometrycollection;
238 DROP TABLE geom_index;