Debian Codegraph @

mysql-test/suite/innodb_gis/t/gis_split_nan.test

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