Debian Codegraph @

mysql-test/suite/gis/t/st_buffer.test

raw
1 --echo # Creating geometry objects and parameters.
2 USE test;
3
4 CREATE TABLE gis_geometries (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
5
6 --echo # INSERT into table
7 --disable_warnings
8 INSERT INTO gis_geometries VALUES
9 (119,ST_GEOMFROMTEXT('POINT(0 179)', 4326)),
10 (120,ST_GEOMFROMTEXT('POINT(0 -179)', 4326));
11 --enable_warnings
12
13 --echo # Checking the integrity of above create/insert statements
14 --echo # 2 rows.
15 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometries;
16
17
18 # SRID=4326, long=0, lat=-91.
19 SET @pt_lat_minus_91 = x'E6100000010100000000000000000000000000000000C056C0';
20 # SRID=4326, long=0, lat=91.
21 SET @pt_lat_plus_91 = x'E6100000010100000000000000000000000000000000C05640';
22 # SRID=4326, long=-181, lat=0.
23 SET @pt_long_minus_181 = x'E610000001010000000000000000A066C00000000000000000';
24 # SRID=4326, long=181, lat=0.
25 SET @pt_long_plus_181 = x'E610000001010000000000000000A066400000000000000000';
26
27
28 SET @p_square = ST_BUFFER_STRATEGY('point_square');
29 SET @p_circle = ST_BUFFER_STRATEGY('point_circle', 42);
30 SET @e_flat = ST_BUFFER_STRATEGY('end_flat');
31 SET @e_round = ST_BUFFER_STRATEGY('end_round', 42);
32 SET @j_miter = ST_BUFFER_STRATEGY('join_miter', 3.3);
33 SET @j_round = ST_BUFFER_STRATEGY('join_round', 42);
34
35 SET @geo_pt = ST_GEOMFROMTEXT('POINT(0 0)', 4326);
36 SET @cart_pt = ST_GEOMFROMTEXT('POINT(0 0)');
37 SET @cart_ls = ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1, 2 0)');
38 SET @cart_py = ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))');
39 SET @cart_mpt = ST_GEOMFROMTEXT('MULTIPOINT((0 0), (2 2))');
40 SET @cart_mls = ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 1, 2 0), (3 0, 4 1, 5 0))');
41 SET @cart_mpy = ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)), ((3 0, 3 1, 4 1, 4 0, 3 0)))');
42 SET @cart_gc = ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0, 1 1, 2 0), POLYGON((0 0, 0 1, 1 1, 1 0, 0 0)))');
43
44
45 --echo #####################################################################################
46 --echo # ST_BUFFER(geometry, distance, [strategy1, strategy2, strategy3])
47 --echo #####################################################################################
48
49 SELECT ST_ASTEXT(ST_BUFFER(@cart_pt, 2, ST_BUFFER_STRATEGY('point_square')));
50 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 2, @p_square));
51
52 --replace_numeric_round 12
53 SELECT ST_ASTEXT(ST_BUFFER(g, 200000)) FROM gis_geometries WHERE fid=119;
54 --replace_numeric_round 12
55 SELECT ST_ASTEXT(ST_BUFFER(g, 200000)) FROM gis_geometries WHERE fid=120;
56 DROP TABLE gis_geometries;
57
58
59 --echo #####################################################################################
60 --echo # Invalid function calls
61 --echo #####################################################################################
62
63 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'), 20));
64 SELECT ST_ASTEXT(ST_BUFFER(NULL, 1));
65
66 # Invalid arguments: strategy X not compatible with geometry Y.
67 -- error ER_WRONG_ARGUMENTS
68 DO ST_ASTEXT(ST_BUFFER(@cart_pt, 1, @e_flat));
69 -- error ER_WRONG_ARGUMENTS
70 DO ST_ASTEXT(ST_BUFFER(@cart_pt, 1, @j_round));
71 -- error ER_WRONG_ARGUMENTS
72 DO ST_ASTEXT(ST_BUFFER(@cart_pt, -1));
73 -- error ER_WRONG_ARGUMENTS
74 DO ST_ASTEXT(ST_BUFFER(@cart_ls, 2, @p_square));
75 -- error ER_WRONG_ARGUMENTS
76 DO ST_ASTEXT(ST_BUFFER(@cart_ls, -2));
77 -- error ER_WRONG_ARGUMENTS
78 DO ST_ASTEXT(ST_BUFFER(@cart_py, 3, @p_square));
79 -- error ER_WRONG_ARGUMENTS
80 DO ST_ASTEXT(ST_BUFFER(@cart_py, 3, @e_flat));
81 -- error ER_WRONG_ARGUMENTS
82 DO ST_ASTEXT(ST_BUFFER(@cart_mpt, 4, @e_flat));
83 -- error ER_WRONG_ARGUMENTS
84 DO ST_ASTEXT(ST_BUFFER(@cart_mpt, 4, @j_round));
85 -- error ER_WRONG_ARGUMENTS
86 DO ST_ASTEXT(ST_BUFFER(@cart_mpt, -4));
87 -- error ER_WRONG_ARGUMENTS
88 DO ST_ASTEXT(ST_BUFFER(@cart_mls, 5, @p_square));
89 -- error ER_WRONG_ARGUMENTS
90 DO ST_ASTEXT(ST_BUFFER(@cart_mls, -5));
91 -- error ER_WRONG_ARGUMENTS
92 DO ST_ASTEXT(ST_BUFFER(@cart_mpy, 6, @p_square));
93 -- error ER_WRONG_ARGUMENTS
94 DO ST_ASTEXT(ST_BUFFER(@cart_mpy, 6, @e_flat));
95 -- error ER_WRONG_ARGUMENTS
96 DO ST_ASTEXT(ST_BUFFER(@cart_gc, -7));
97 -- error ER_WRONG_ARGUMENTS
98 DO ST_ASTEXT(ST_BUFFER(@geo_pt, 2000, @p_square));
99 -- error ER_WRONG_ARGUMENTS
100 DO ST_ASTEXT(ST_BUFFER(@geo_pt, 2000, @e_flat));
101 -- error ER_WRONG_ARGUMENTS
102 DO ST_ASTEXT(ST_BUFFER(@geo_pt, 2000, @j_round));
103 -- error ER_WRONG_ARGUMENTS
104 DO ST_ASTEXT(ST_BUFFER(@geo_pt, -2000));
105
106 # Invalid arguments: cannot set several strategies of same type.
107 -- error ER_WRONG_ARGUMENTS
108 DO ST_ASTEXT(ST_BUFFER(@cart_pt, 1, @p_square, @p_circle));
109 -- error ER_WRONG_ARGUMENTS
110 DO ST_ASTEXT(ST_BUFFER(@cart_pt, 1, @p_circle, @p_square));
111 -- error ER_WRONG_ARGUMENTS
112 DO ST_ASTEXT(ST_BUFFER(@cart_ls, 2, @e_flat, @e_round));
113 -- error ER_WRONG_ARGUMENTS
114 DO ST_ASTEXT(ST_BUFFER(@cart_ls, 2, @e_round, @e_flat));
115 -- error ER_WRONG_ARGUMENTS
116 DO ST_ASTEXT(ST_BUFFER(@cart_py, 2, @j_miter, @j_round));
117 -- error ER_WRONG_ARGUMENTS
118 DO ST_ASTEXT(ST_BUFFER(@cart_py, 2, @j_round, @j_miter));
119
120
121 --error ER_WRONG_ARGUMENTS
122 DO ST_ASTEXT(ST_BUFFER(@cart_pt, 2, 2));
123
124 --error ER_GIS_INVALID_DATA
125 DO ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(12,34 0)'), 1));
126
127 --error ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS
128 DO ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0, 2 0, 2 2, 2 0, 1 1)', 4326), 100));
129
130 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
131 DO ST_BUFFER(@pt_lat_minus_91, 20000);
132 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
133 DO ST_BUFFER(@pt_lat_plus_91, 20000);
134 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
135 DO ST_BUFFER(@pt_long_minus_181, 20000);
136 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
137 DO ST_BUFFER(@pt_long_plus_181, 20000);
138
139 --echo # Assume SRID 10 is not defined.
140 --error ER_SRS_NOT_FOUND
141 DO ST_BUFFER(x'0A000000010100000000000000000000000000000000000000', 10);
142