| 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 |
|