--echo # Creating geometry objects and parameters. USE test; CREATE TABLE gis_geometries (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY); --echo # INSERT into table --disable_warnings INSERT INTO gis_geometries VALUES (119,ST_GEOMFROMTEXT('POINT(0 179)', 4326)), (120,ST_GEOMFROMTEXT('POINT(0 -179)', 4326)); --enable_warnings --echo # Checking the integrity of above create/insert statements --echo # 2 rows. SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometries; # SRID=4326, long=0, lat=-91. SET @pt_lat_minus_91 = x'E6100000010100000000000000000000000000000000C056C0'; # SRID=4326, long=0, lat=91. SET @pt_lat_plus_91 = x'E6100000010100000000000000000000000000000000C05640'; # SRID=4326, long=-181, lat=0. SET @pt_long_minus_181 = x'E610000001010000000000000000A066C00000000000000000'; # SRID=4326, long=181, lat=0. SET @pt_long_plus_181 = x'E610000001010000000000000000A066400000000000000000'; SET @p_square = ST_BUFFER_STRATEGY('point_square'); SET @p_circle = ST_BUFFER_STRATEGY('point_circle', 42); SET @e_flat = ST_BUFFER_STRATEGY('end_flat'); SET @e_round = ST_BUFFER_STRATEGY('end_round', 42); SET @j_miter = ST_BUFFER_STRATEGY('join_miter', 3.3); SET @j_round = ST_BUFFER_STRATEGY('join_round', 42); SET @geo_pt = ST_GEOMFROMTEXT('POINT(0 0)', 4326); SET @cart_pt = ST_GEOMFROMTEXT('POINT(0 0)'); SET @cart_ls = ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1, 2 0)'); SET @cart_py = ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))'); SET @cart_mpt = ST_GEOMFROMTEXT('MULTIPOINT((0 0), (2 2))'); SET @cart_mls = ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 1, 2 0), (3 0, 4 1, 5 0))'); 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)))'); 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)))'); --echo ##################################################################################### --echo # ST_BUFFER(geometry, distance, [strategy1, strategy2, strategy3]) --echo ##################################################################################### SELECT ST_ASTEXT(ST_BUFFER(@cart_pt, 2, ST_BUFFER_STRATEGY('point_square'))); SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 2, @p_square)); --replace_numeric_round 12 SELECT ST_ASTEXT(ST_BUFFER(g, 200000)) FROM gis_geometries WHERE fid=119; --replace_numeric_round 12 SELECT ST_ASTEXT(ST_BUFFER(g, 200000)) FROM gis_geometries WHERE fid=120; DROP TABLE gis_geometries; --echo ##################################################################################### --echo # Invalid function calls --echo ##################################################################################### SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'), 20)); SELECT ST_ASTEXT(ST_BUFFER(NULL, 1)); # Invalid arguments: strategy X not compatible with geometry Y. -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_pt, 1, @e_flat)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_pt, 1, @j_round)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_pt, -1)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_ls, 2, @p_square)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_ls, -2)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_py, 3, @p_square)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_py, 3, @e_flat)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_mpt, 4, @e_flat)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_mpt, 4, @j_round)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_mpt, -4)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_mls, 5, @p_square)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_mls, -5)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_mpy, 6, @p_square)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_mpy, 6, @e_flat)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_gc, -7)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@geo_pt, 2000, @p_square)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@geo_pt, 2000, @e_flat)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@geo_pt, 2000, @j_round)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@geo_pt, -2000)); # Invalid arguments: cannot set several strategies of same type. -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_pt, 1, @p_square, @p_circle)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_pt, 1, @p_circle, @p_square)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_ls, 2, @e_flat, @e_round)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_ls, 2, @e_round, @e_flat)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_py, 2, @j_miter, @j_round)); -- error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_py, 2, @j_round, @j_miter)); --error ER_WRONG_ARGUMENTS DO ST_ASTEXT(ST_BUFFER(@cart_pt, 2, 2)); --error ER_GIS_INVALID_DATA DO ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(12,34 0)'), 1)); --error ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS DO ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0, 2 0, 2 2, 2 0, 1 1)', 4326), 100)); --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE DO ST_BUFFER(@pt_lat_minus_91, 20000); --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE DO ST_BUFFER(@pt_lat_plus_91, 20000); --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE DO ST_BUFFER(@pt_long_minus_181, 20000); --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE DO ST_BUFFER(@pt_long_plus_181, 20000); --echo # Assume SRID 10 is not defined. --error ER_SRS_NOT_FOUND DO ST_BUFFER(x'0A000000010100000000000000000000000000000000000000', 10);