Debian Codegraph @

mysql-test/suite/gis/r/spatial_analysis_functions_buffer.result

raw
1 # Creating the spatial Geometry object
2 USE test;
3 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
4 SET @star_elem_vertical= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
5 SET @star_elem_horizontal= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
6 SET @star_center= 'POINT(15 10)';
7 SET @star_top= 'POINT(15 25)';
8 SET @star_bottom_left= 'POINT(5 0)';
9 SET @star_bottom_right= 'POINT(25 0)';
10 SET @star_bottom_points= 'MULTIPOINT(5 0,25 0)';
11 SET @star_all_points= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
12 SET @star_line_horizontal= 'LINESTRING(10 15,20 15)';
13 SET @star_line_vertical= 'LINESTRING(15 5,15 25)';
14 SET @star_top_to_center= 'LINESTRING(15 25,15 10)';
15 SET @star_lines_near_horizontal= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
16 SET @star_lines_near_vertical= 'MULTILINESTRING((0 5,15 25,0 25))';
17 SET @star= 'POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))';
18 SET @star_elem_vertical_val= '((5 0,15 25,25 0,15 5,5 0))';
19 SET @star_elem_horizontal_val= '((25 0,0 15,30 15,22 10,25 0))';
20 SET @star_of_elems='MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0)))';
21 SET @star_collection_elems='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
22 SET @star_collection_multilinestr='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),MULTILINESTRING((25 0,0 15,15 30,0 5)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
23 # INSERT base star
24 INSERT INTO gis_geometrycollection VALUES
25 (100,ST_GEOMFROMTEXT(@star)),
26 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
27 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
28 (103,ST_GEOMFROMTEXT(@star_of_elems)),
29 (104,ST_GEOMFROMTEXT(@star_top)),
30 (105,ST_GEOMFROMTEXT(@star_center)),
31 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
32 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
33 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
34 (109,ST_GEOMFROMTEXT(@star_all_points)),
35 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
36 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
37 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
38 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
39 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
40 (115,ST_GEOMFROMTEXT(@star_collection_elems)),
41 (116,ST_GEOMFROMTEXT(@star_collection_multilinestr));
42 # Checking the integrity of the above create/insert statements
43 # 17 rows.
44 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection;
45 count(ST_ASTEXT(g) != 'NULL')
46 17
47 #####################################################################################
48 # ST_BUFFER(point, distance)
49 #####################################################################################
50 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_center), 0));
51 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_center), 0))
52 POINT(15 10)
53 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_top), 1));
54 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_top), 1))
55 POLYGON((16 25,15.98078528040323 25.195090322016124,15.923879532511288 25.382683432365088,15.831469612302547 25.555570233019598,15.70710678118655 25.707106781186546,15.555570233019605 25.831469612302545,15.382683432365093 25.923879532511286,15.195090322016132 25.98078528040323,15.000000000000002 26,14.804909677983874 25.980785280403232,14.617316567634912 25.923879532511286,14.444429766980399 25.831469612302545,14.292893218813454 25.70710678118655,14.168530387697455 25.555570233019605,14.076120467488714 25.38268343236509,14.01921471959677 25.195090322016128,14 25,14.01921471959677 24.804909677983872,14.076120467488714 24.617316567634912,14.168530387697455 24.4444297669804,14.292893218813452 24.292893218813454,14.444429766980399 24.168530387697455,14.61731656763491 24.076120467488714,14.804909677983872 24.019214719596768,15 24,15.195090322016128 24.019214719596768,15.38268343236509 24.076120467488714,15.555570233019603 24.168530387697455,15.707106781186548 24.292893218813454,15.831469612302545 24.4444297669804,15.923879532511286 24.61731656763491,15.98078528040323 24.804909677983872,16 25))
56 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(-0 0)'), 2));
57 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(-0 0)'), 2))
58 POLYGON((2 0,1.9616 0.3902,1.8478 0.7654,1.6629 1.1111,1.4142 1.4142,1.1111 1.6629,0.7654 1.8478,0.3902 1.9616,0 2,-0.3902 1.9616,-0.7654 1.8478,-1.1111 1.6629,-1.4142 1.4142,-1.6629 1.1111,-1.8478 0.7654,-1.9616 0.3902,-2 0,-1.9616 -0.3902,-1.8478 -0.7654,-1.6629 -1.1111,-1.4142 -1.4142,-1.1111 -1.6629,-0.7654 -1.8478,-0.3902 -1.9616,0 -2,0.3902 -1.9616,0.7654 -1.8478,1.1111 -1.6629,1.4142 -1.4142,1.6629 -1.1111,1.8478 -0.7654,1.9616 -0.3902,2 0))
59 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(2.34 -2.34)'), 3));
60 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(2.34 -2.34)'), 3))
61 POLYGON((5.34 -2.34,5.2824 -1.7547,5.1116 -1.1919,4.8344 -0.6733,4.4613 -0.2187,4.0067 0.1544,3.4881 0.4316,2.9253 0.6024,2.34 0.66,1.7547 0.6024,1.1919 0.4316,0.6733 0.1544,0.2187 -0.2187,-0.1544 -0.6733,-0.4316 -1.1919,-0.6024 -1.7547,-0.66 -2.34,-0.6024 -2.9253,-0.4316 -3.4881,-0.1544 -4.0067,0.2187 -4.4613,0.6733 -4.8344,1.1919 -5.1116,1.7547 -5.2824,2.34 -5.34,2.9253 -5.2824,3.4881 -5.1116,4.0067 -4.8344,4.4613 -4.4613,4.8344 -4.0067,5.1116 -3.4881,5.2824 -2.9253,5.34 -2.34))
62 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1000 -1000)'), 5));
63 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1000 -1000)'), 5))
64 POLYGON((1005 -1000,1004.9039264020162 -999.0245483899193,1004.6193976625565 -998.0865828381745,1004.1573480615127 -997.222148834902,1003.5355339059328 -996.4644660940672,1002.777851165098 -995.8426519384873,1001.9134171618255 -995.3806023374435,1000.9754516100807 -995.0960735979838,1000 -995,999.0245483899193 -995.0960735979838,998.0865828381745 -995.3806023374435,997.222148834902 -995.8426519384873,996.4644660940672 -996.4644660940672,995.8426519384873 -997.222148834902,995.3806023374435 -998.0865828381745,995.0960735979838 -999.0245483899193,995 -1000,995.0960735979838 -1000.9754516100807,995.3806023374435 -1001.9134171618255,995.8426519384873 -1002.777851165098,996.4644660940672 -1003.5355339059328,997.222148834902 -1004.1573480615127,998.0865828381745 -1004.6193976625565,999.0245483899193 -1004.9039264020162,1000 -1005,1000.9754516100807 -1004.9039264020162,1001.9134171618255 -1004.6193976625565,1002.777851165098 -1004.1573480615127,1003.5355339059328 -1003.5355339059328,1004.1573480615127 -1002.777851165098,1004.6193976625565 -1001.9134171618255,1004.9039264020162 -1000.9754516100807,1005 -1000))
65 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(-0 0)'), 10));
66 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(-0 0)'), 10))
67 POLYGON((10 0,9.8079 1.9509,9.2388 3.8268,8.3147 5.5557,7.0711 7.0711,5.5557 8.3147,3.8268 9.2388,1.9509 9.8079,0 10,-1.9509 9.8079,-3.8268 9.2388,-5.5557 8.3147,-7.0711 7.0711,-8.3147 5.5557,-9.2388 3.8268,-9.8079 1.9509,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,8.3147 -5.5557,9.2388 -3.8268,9.8079 -1.9509,10 0))
68 SELECT ST_ASTEXT(ST_BUFFER(g, 100)) FROM gis_geometrycollection WHERE fid=105;
69 ST_ASTEXT(ST_BUFFER(g, 100))
70 POLYGON((115 10,113.0785 29.509,107.388 48.2683,98.147 65.557,85.7107 80.7107,70.557 93.147,53.2683 102.388,34.509 108.0785,15 110,-4.509 108.0785,-23.2683 102.388,-40.557 93.147,-55.7107 80.7107,-68.147 65.557,-77.388 48.2683,-83.0785 29.509,-85 10,-83.0785 -9.509,-77.388 -28.2683,-68.147 -45.557,-55.7107 -60.7107,-40.557 -73.147,-23.2683 -82.388,-4.509 -88.0785,15 -90,34.509 -88.0785,53.2683 -82.388,70.557 -73.147,85.7107 -60.7107,98.147 -45.557,107.388 -28.2683,113.0785 -9.509,115 10))
71 #####################################################################################
72 # ST_BUFFER(multipoint, distance)
73 #####################################################################################
74 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_all_points), 0));
75 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_all_points), 0))
76 MULTIPOINT((5 0),(25 0),(15 10),(15 25))
77 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_bottom_points), 2));
78 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_bottom_points), 2))
79 MULTIPOLYGON(((7 0,6.9616 0.3902,6.8478 0.7654,6.6629 1.1111,6.4142 1.4142,6.1111 1.6629,5.7654 1.8478,5.3902 1.9616,5 2,4.6098 1.9616,4.2346 1.8478,3.8889 1.6629,3.5858 1.4142,3.3371 1.1111,3.1522 0.7654,3.0384 0.3902,3 0,3.0384 -0.3902,3.1522 -0.7654,3.3371 -1.1111,3.5858 -1.4142,3.8889 -1.6629,4.2346 -1.8478,4.6098 -1.9616,5 -2,5.3902 -1.9616,5.7654 -1.8478,6.1111 -1.6629,6.4142 -1.4142,6.6629 -1.1111,6.8478 -0.7654,6.9616 -0.3902,7 0)),((27 0,26.9616 0.3902,26.8478 0.7654,26.6629 1.1111,26.4142 1.4142,26.1111 1.6629,25.7654 1.8478,25.3902 1.9616,25 2,24.6098 1.9616,24.2346 1.8478,23.8889 1.6629,23.5858 1.4142,23.3371 1.1111,23.1522 0.7654,23.0384 0.3902,23 0,23.0384 -0.3902,23.1522 -0.7654,23.3371 -1.1111,23.5858 -1.4142,23.8889 -1.6629,24.2346 -1.8478,24.6098 -1.9616,25 -2,25.3902 -1.9616,25.7654 -1.8478,26.1111 -1.6629,26.4142 -1.4142,26.6629 -1.1111,26.8478 -0.7654,26.9616 -0.3902,27 0)))
80 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)'), 5));
81 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)'), 5))
82 POLYGON((4.9039 -0.9754,5 0,4.9039 0.9754,4.6193 1.9134,4.1573 2.7778,3.5355 3.5355,2.7778 4.1573,1.9134 4.6193,0.9754 4.9039,1.24e-14 5,-0.9754 4.9039,-1.9134 4.6193,-2.7778 4.1573,-3.5355 3.5355,-4.1573 2.7778,-4.6193 1.9134,-4.9039 0.9754,-5 3.82e-15,-4.9039 -0.9754,-4.6193 -1.9134,-4.1573 -2.7778,-3.5355 -3.5355,-2.7778 -4.1573,-1.9134 -4.6193,-0.9754 -4.9039,3.06e-16 -5,0.9754 -4.9039,1.9134 -4.6193,2.7778 -4.1573,3.5355 -3.5355,4.1573 -2.7778,4.6193 -1.9134,4.9039 -0.9754))
83 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 5,5 5,5 0,0 0)'), 5));
84 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 5,5 5,5 0,0 0)'), 5))
85 POLYGON((2.5 -4.3059,3.0866 -4.6194,4.0245 -4.9039,5 -5,5.9755 -4.9039,6.9134 -4.6194,7.7779 -4.1573,8.5355 -3.5355,9.1573 -2.7779,9.6194 -1.9134,9.9039 -0.9755,10 0,9.9039 0.9755,9.6194 1.9134,9.3059 2.5,9.6194 3.0866,9.9039 4.0245,10 5,9.9039 5.9755,9.6194 6.9134,9.1573 7.7779,8.5355 8.5355,7.7779 9.1573,6.9134 9.6194,5.9755 9.9039,5 10,4.0245 9.9039,3.0866 9.6194,2.5 9.3059,1.9134 9.6194,0.9755 9.9039,0 10,-0.9755 9.9039,-1.9134 9.6194,-2.7779 9.1573,-3.5355 8.5355,-4.1573 7.7779,-4.6194 6.9134,-4.9039 5.9755,-5 5,-4.9039 4.0245,-4.6194 3.0866,-4.3059 2.5,-4.6194 1.9134,-4.9039 0.9755,-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,0.9755 -4.9039,1.9134 -4.6194,2.5 -4.3059))
86 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1000 -1000,0 0)'), 100));
87 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1000 -1000,0 0)'), 100))
88 MULTIPOLYGON(((1100 -1000,1098.079 -980.491,1092.388 -961.732,1083.147 -944.443,1070.711 -929.289,1055.557 -916.853,1038.268 -907.612,1019.509 -901.921,1000 -900,980.491 -901.921,961.732 -907.612,944.443 -916.853,929.289 -929.289,916.853 -944.443,907.612 -961.732,901.921 -980.491,900 -1000,901.921 -1019.509,907.612 -1038.268,916.853 -1055.557,929.289 -1070.711,944.443 -1083.147,961.732 -1092.388,980.491 -1098.079,1000 -1100,1019.509 -1098.079,1038.268 -1092.388,1055.557 -1083.147,1070.711 -1070.711,1083.147 -1055.557,1092.388 -1038.268,1098.079 -1019.509,1100 -1000)),((-70.162 -71.161,-69.711 -71.711,-54.557 -84.147,-37.268 -93.388,-18.509 -99.079,1 -101,20.509 -99.079,39.268 -93.388,56.557 -84.147,71.711 -71.711,84.147 -56.557,93.388 -39.268,99.079 -20.509,101 -1,99.079 18.509,93.388 37.268,84.147 54.557,71.711 69.711,71.162 70.161,70.711 70.711,55.557 83.147,38.268 92.388,19.509 98.079,0 100,-19.509 98.079,-38.268 92.388,-55.557 83.147,-70.711 70.711,-83.147 55.557,-92.388 38.268,-98.078 19.509,-100 0,-98.078 -19.509,-92.388 -38.268,-83.147 -55.557,-70.711 -70.711,-70.162 -71.161)))
89 SELECT ST_ASTEXT(ST_BUFFER(g, 20)) FROM gis_geometrycollection WHERE fid=108;
90 ST_ASTEXT(ST_BUFFER(g, 20))
91 POLYGON((15 -17.2234,17.3463 -18.4776,21.0982 -19.6157,25 -20,28.9018 -19.6157,32.6537 -18.4776,36.1114 -16.6294,39.1421 -14.1421,41.6294 -11.1114,43.4776 -7.6537,44.6157 -3.9018,45 0,44.6157 3.9018,43.4776 7.6537,41.6294 11.1114,39.1421 14.1421,36.1114 16.6294,32.6537 18.4776,28.9018 19.6157,25 20,21.0982 19.6157,17.3463 18.4776,15 17.2234,12.6537 18.4776,8.9018 19.6157,5 20,1.0982 19.6157,-2.6537 18.4776,-6.1114 16.6294,-9.1421 14.1421,-11.6294 11.1114,-13.4776 7.6537,-14.6157 3.9018,-15 0,-14.6157 -3.9018,-13.4776 -7.6537,-11.6294 -11.1114,-9.1421 -14.1421,-6.1114 -16.6294,-2.6537 -18.4776,1.0982 -19.6157,5 -20,8.9018 -19.6157,12.6537 -18.4776,15 -17.2234))
92 #####################################################################################
93 # ST_BUFFER(linestring, distance)
94 #####################################################################################
95 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_top_to_center), 0));
96 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_top_to_center), 0))
97 LINESTRING(15 25,15 10)
98 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_line_horizontal), 1));
99 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_line_horizontal), 1))
100 POLYGON((10 16,9.804909677983874 15.98078528040323,9.617316567634912 15.923879532511288,9.444429766980399 15.831469612302547,9.292893218813454 15.707106781186548,9.168530387697455 15.555570233019603,9.076120467488714 15.382683432365091,9.01921471959677 15.19509032201613,9 15,9.01921471959677 14.804909677983872,9.076120467488714 14.61731656763491,9.168530387697455 14.444429766980399,9.292893218813452 14.292893218813452,9.444429766980399 14.168530387697455,9.61731656763491 14.076120467488714,9.804909677983872 14.01921471959677,10 14,20 14,20 14,20.195090322016128 14.01921471959677,20.38268343236509 14.076120467488714,20.5555702330196 14.168530387697455,20.707106781186546 14.292893218813452,20.831469612302545 14.444429766980399,20.923879532511286 14.61731656763491,20.980785280403232 14.804909677983872,21 15,20.980785280403232 15.195090322016128,20.923879532511286 15.38268343236509,20.831469612302545 15.555570233019601,20.707106781186546 15.707106781186548,20.5555702330196 15.831469612302545,20.38268343236509 15.923879532511286,20.195090322016128 15.98078528040323,20 16,10 16))
101 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,-0 0,0 0)'), 5));
102 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,-0 0,0 0)'), 5))
103 POLYGON((5 0,4.9039 0.9755,4.6194 1.9134,4.1573 2.7779,3.5355 3.5355,2.7779 4.1573,1.9134 4.6194,0.9755 4.9039,0 5,-0.9755 4.9039,-1.9134 4.6194,-2.7779 4.1573,-3.5355 3.5355,-4.1573 2.7779,-4.6194 1.9134,-4.9039 0.9755,-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,0.9755 -4.9039,1.9134 -4.6194,2.7779 -4.1573,3.5355 -3.5355,4.1573 -2.7779,4.6194 -1.9134,4.9039 -0.9755,5 0))
104 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(10 10,10 15,15 15,15 10,10 10)'), 10));
105 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(10 10,10 15,15 15,15 10,10 10)'), 10))
106 POLYGON((8.0491 0.1921,10 0,15 0,16.9509 0.1921,18.8268 0.7612,20.5557 1.6853,22.0711 2.9289,23.3147 4.4443,24.2388 6.1732,24.8079 8.0491,25 10,25 15,24.8079 16.9509,24.2388 18.8268,23.3147 20.5557,22.0711 22.0711,20.5557 23.3147,18.8268 24.2388,16.9509 24.8079,15 25,10 25,8.0491 24.8079,6.1732 24.2388,4.4443 23.3147,2.9289 22.0711,1.6853 20.5557,0.7612 18.8268,0.1921 16.9509,0 15,0 10,0.1921 8.0491,0.7612 6.1732,1.6853 4.4443,2.9289 2.9289,4.4443 1.6853,6.1732 0.7612,8.0491 0.1921))
107 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0)'), 1000));
108 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0)'), 1000))
109 POLYGON((1707.1068 -292.8932,707.1069 707.1067,555.5704 831.4696,382.6836 923.8795,195.0905 980.7853,0.0002 1000,-195.0902 980.7853,-382.6833 923.8796,-555.5701 831.4696,-707.1066 707.1068,-831.4695 555.5703,-923.8794 382.6835,-980.7852 195.0904,-999.9999 0.0001,-980.7852 -195.0903,-923.8795 -382.6834,-831.4695 -555.5702,-707.1067 -707.1067,-706.1068 -708.1068,292.8932 -1707.1067,444.4298 -1831.4696,617.3166 -1923.8795,804.9097 -1980.7853,1000 -2000,1195.0903 -1980.7853,1382.6834 -1923.8795,1555.5702 -1831.4696,1707.1068 -1707.1068,1831.4696 -1555.5703,1923.8795 -1382.6835,1980.7853 -1195.0904,2000 -1000,1980.7853 -804.9097,1923.8795 -617.3166,1831.4696 -444.4298,1707.1068 -292.8932))
110 SELECT ST_ASTEXT(ST_BUFFER(g, 20)) FROM gis_geometrycollection WHERE fid=110;
111 ST_ASTEXT(ST_BUFFER(g, 20))
112 POLYGON((10 35,6.0982 34.6157,2.3463 33.4776,-1.1114 31.6294,-4.1421 29.1421,-6.6294 26.1114,-8.4776 22.6537,-9.6157 18.9018,-10 15,-9.6157 11.0982,-8.4776 7.3463,-6.6294 3.8886,-4.1421 0.8579,-1.1114 -1.6294,2.3463 -3.4776,6.0982 -4.6157,10 -5,20 -5,20 -5,23.9018 -4.6157,27.6537 -3.4776,31.1114 -1.6294,34.1421 0.8579,36.6294 3.8886,38.4776 7.3463,39.6157 11.0982,40 15,39.6157 18.9018,38.4776 22.6537,36.6294 26.1114,34.1421 29.1421,31.1114 31.6294,27.6537 33.4776,23.9018 34.6157,20 35,10 35))
113 #####################################################################################
114 # ST_BUFFER(multilinestring, distance)
115 #####################################################################################
116 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_lines_near_vertical), 0));
117 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_lines_near_vertical), 0))
118 MULTILINESTRING((0 5,15 25,0 25))
119 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_lines_near_horizontal), 2));
120 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_lines_near_horizontal), 2))
121 POLYGON((5.0978 9.609,23.971 -1.715,24.3254 -1.8828,24.7056 -1.9782,25.0972 -1.9976,25.4851 -1.9403,25.8543 -1.8084,26.1907 -1.607,26.4813 -1.3438,26.715 -1.029,26.8828 -0.6746,26.9782 -0.2944,26.9976 0.0972,26.9403 0.4851,26.8084 0.8543,26.607 1.1907,26.3438 1.4813,26.029 1.715,7.1557 13.0389,16.715 28.971,16.8806 29.3193,16.9763 29.6928,16.9985 30.0778,16.9464 30.4599,16.822 30.8249,16.6298 31.1592,16.3771 31.4504,16.0731 31.6877,15.7293 31.8623,15.3583 31.9676,14.9741 31.9998,14.5908 31.9577,14.2227 31.8428,13.8835 31.6593,13.5858 31.4142,-1.4142 16.4142,-1.6463 16.1356,-1.8243 15.8196,-1.9424 15.4767,-1.9965 15.1181,-1.985 14.7556,-1.9083 14.4012,-1.7687 14.0664,-1.5711 13.7624,-1.3218 13.499,-1.029 13.285,1.6678 11.6669,-1.715 6.029,-1.8828 5.6746,-1.9782 5.2944,-1.9976 4.9028,-1.9403 4.5149,-1.8084 4.1457,-1.607 3.8093,-1.3438 3.5187,-1.029 3.285,-0.6746 3.1172,-0.2944 3.0218,0.0972 3.0024,0.4851 3.0597,0.8543 3.1916,1.1907 3.393,1.4813 3.6562,1.715 3.971,5.0978 9.609),(4.9264 17.098,3.7258 15.0969,3.2255 15.3971,4.9264 17.098))
122 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0 0),(0 0,0 -0))'), 10));
123 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0 0),(0 0,0 -0))'), 10))
124 POLYGON((9.8079 -1.9509,10 0,9.8079 1.9509,9.2388 3.8268,8.3147 5.5557,7.0711 7.0711,5.5557 8.3147,3.8268 9.2388,1.9509 9.8079,0 10,-1.9509 9.8079,-3.8268 9.2388,-5.5557 8.3147,-7.0711 7.0711,-8.3147 5.5557,-9.2388 3.8268,-9.8079 1.9509,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,8.3147 -5.5557,9.2388 -3.8268,9.8079 -1.9509))
125 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'), 50));
126 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'), 50))
127 POLYGON((-9.7545 -49.0393,0 -50,5 -50,14.7545 -49.0393,24.1342 -46.194,32.7785 -41.5735,40.3553 -35.3553,46.5735 -27.7785,51.194 -19.1342,54.0393 -9.7545,55 0,55 5,54.0393 14.7545,51.194 24.1342,46.5735 32.7785,40.3553 40.3553,32.7785 46.5735,24.1342 51.194,14.7545 54.0393,5 55,0 55,-9.7545 54.0393,-19.1342 51.194,-27.7785 46.5735,-35.3553 40.3553,-41.5735 32.7785,-46.194 24.1342,-49.0393 14.7545,-50 5,-50 0,-49.0393 -9.7545,-46.194 -19.1342,-41.5735 -27.7785,-35.3553 -35.3553,-27.7785 -41.5735,-19.1342 -46.194,-9.7545 -49.0393))
128 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'), 100));
129 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'), 100))
130 POLYGON((5 109.5075,0 110,-19.509 108.0785,-38.2683 102.388,-55.557 93.147,-70.7107 80.7107,-83.147 65.557,-92.388 48.2683,-98.0785 29.509,-100 10,-99.5075 5,-100 0,-98.0785 -19.509,-92.388 -38.2683,-83.147 -55.557,-70.7107 -70.7107,-55.557 -83.147,-38.2683 -92.388,-19.509 -98.0785,0 -100,10 -100,29.509 -98.0785,48.2683 -92.388,65.557 -83.147,80.7107 -70.7107,93.147 -55.557,102.388 -38.2683,108.0785 -19.509,110 0,109.5075 5,110 10,108.0785 29.509,102.388 48.2683,93.147 65.557,80.7107 80.7107,65.557 93.147,48.2683 102.388,29.509 108.0785,10 110,5 109.5075))
131 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0 0),(2 2,4 -9))'), 1000));
132 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0 0),(2 2,4 -9))'), 1000))
133 POLYGON((292.89 -1707.11,444.43 -1831.47,617.32 -1923.88,804.91 -1980.79,1000 -2000,1195.09 -1980.79,1382.68 -1923.88,1555.57 -1831.47,1707.11 -1707.11,1831.47 -1555.57,1923.88 -1382.68,1980.79 -1195.09,2000 -1000,1980.79 -804.91,1923.88 -617.32,1831.47 -444.43,1707.11 -292.89,735.31 678.9,720.7 697.32,571.24 824.17,399.9 919.43,213.27 979.43,18.53 1001.86,-176.85 985.88,-194.48 980.85,-195.09 980.79,-201.44 978.86,-365.36 932.08,-379.37 924.88,-382.68 923.88,-415.68 906.24,-539.75 842.54,-549.85 834.53,-555.57 831.47,-609.84 786.93,-693.32 720.7,-699.7 713.19,-707.11 707.11,-772.93 626.91,-820.17 571.24,-823.45 565.34,-831.47 555.57,-895.94 434.96,-915.43 399.9,-916.56 396.37,-923.88 382.68,-972.63 221.96,-975.43 213.27,-975.52 212.44,-980.79 195.09,-1000 0,-980.79 -195.09,-930.55 -360.69,-926.08 -376.36,-925.39 -377.7,-923.88 -382.68,-897.34 -432.34,-836.54 -550.75,-714.7 -704.33,-682.91 -731.3,292.89 -1707.11))
134 SELECT ST_ASTEXT(ST_BUFFER(g, 20)) FROM gis_geometrycollection WHERE fid=114;
135 ST_ASTEXT(ST_BUFFER(g, 20))
136 POLYGON((-17.2187 14.9912,-18.0336 13.648,-19.3743 9.9636,-19.9704 6.0885,-19.799 2.1716,-18.8668 -1.6367,-17.2095 -5.1899,-14.8909 -8.3515,-12 -11,-8.648 -13.0336,-4.9636 -14.3743,-1.0885 -14.9704,2.8284 -14.799,6.6367 -13.8668,10.1899 -12.2095,13.3515 -9.8909,16 -7,31 13,32.9301 16.1394,34.2515 19.5796,34.9192 23.2039,34.9106 26.8891,34.2259 30.5103,32.8885 33.9443,30.9438 37.0746,28.4577 39.795,25.5146 42.013,22.2146 43.6534,18.6696 44.6605,15 45,0 45,-3.9018 44.6157,-7.6537 43.4776,-11.1114 41.6294,-14.1421 39.1421,-16.6294 36.1114,-18.4776 32.6537,-19.6157 28.9018,-20 25,-19.6157 21.0982,-18.4776 17.3463,-17.2187 14.9912))
137 #####################################################################################
138 # ST_BUFFER(polygon, distance)
139 #####################################################################################
140 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star), 0));
141 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star), 0))
142 POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))
143 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_elem_vertical), 0.5));
144 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_elem_vertical), 0.5))
145 POLYGON((15 4.441,24.7764 -0.4472,24.8628 -0.4808,24.954 -0.4979,25.0468 -0.4978,25.1379 -0.4806,25.2243 -0.4469,25.303 -0.3978,25.3712 -0.335,25.4267 -0.2606,25.4675 -0.1773,25.4922 -0.0879,25.5 0.0045,25.4905 0.0968,25.4642 0.1857,15.4642 25.1857,15.4227 25.2671,15.367 25.3396,15.299 25.4008,15.221 25.4485,15.1356 25.4813,15.0457 25.4979,14.9543 25.4979,14.8644 25.4813,14.779 25.4485,14.701 25.4008,14.633 25.3396,14.5773 25.2671,14.5358 25.1857,4.5358 0.1857,4.5095 0.0968,4.5 0.0045,4.5078 -0.0879,4.5325 -0.1773,4.5733 -0.2606,4.6288 -0.335,4.697 -0.3978,4.7757 -0.4469,4.8621 -0.4806,4.9532 -0.4978,5.046 -0.4979,5.1372 -0.4808,5.2236 -0.4472,15 4.441))
146 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((3 3,5 5,7 3,3 3))'), 1));
147 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((3 3,5 5,7 3,3 3))'), 1))
148 POLYGON((2.2929 3.7071,2.1685 3.5556,2.0761 3.3827,2.0192 3.1951,2 3,2.0192 2.8049,2.0761 2.6173,2.1685 2.4444,2.2929 2.2929,2.4444 2.1685,2.6173 2.0761,2.8049 2.0192,3 2,7 2,7.1951 2.0192,7.3827 2.0761,7.5556 2.1685,7.7071 2.2929,7.8315 2.4444,7.9239 2.6173,7.9808 2.8049,8 3,7.9808 3.1951,7.9239 3.3827,7.8315 3.5556,7.7071 3.7071,5.7071 5.7071,5.5556 5.8315,5.3827 5.9239,5.1951 5.9808,5 6,4.8049 5.9808,4.6173 5.9239,4.4444 5.8315,4.2929 5.7071,2.2929 3.7071))
149 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 5));
150 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 5))
151 POLYGON((-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,10 -5,10.9755 -4.9039,11.9134 -4.6194,12.7779 -4.1573,13.5355 -3.5355,14.1573 -2.7779,14.6194 -1.9134,14.9039 -0.9755,15 0,15 10,14.9039 10.9755,14.6194 11.9134,14.1573 12.7779,13.5355 13.5355,12.7779 14.1573,11.9134 14.6194,10.9755 14.9039,10 15,0 15,-0.9755 14.9039,-1.9134 14.6194,-2.7779 14.1573,-3.5355 13.5355,-4.1573 12.7779,-4.6194 11.9134,-4.9039 10.9755,-5 10,-5 0))
152 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 10,10 20,20 20,20 10,10 10))'), 10));
153 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 10,10 20,20 20,20 10,10 10))'), 10))
154 POLYGON((0 10,0.1921 8.0491,0.7612 6.1732,1.6853 4.4443,2.9289 2.9289,4.4443 1.6853,6.1732 0.7612,8.0491 0.1921,10 0,20 0,21.9509 0.1921,23.8268 0.7612,25.5557 1.6853,27.0711 2.9289,28.3147 4.4443,29.2388 6.1732,29.8079 8.0491,30 10,30 20,29.8079 21.9509,29.2388 23.8268,28.3147 25.5557,27.0711 27.0711,25.5557 28.3147,23.8268 29.2388,21.9509 29.8079,20 30,10 30,8.0491 29.8079,6.1732 29.2388,4.4443 28.3147,2.9289 27.0711,1.6853 25.5557,0.7612 23.8268,0.1921 21.9509,0 20,0 10))
155 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 0,0 10,-10 0,0 -10,10 0 ))'), 10));
156 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 0,0 10,-10 0,0 -10,10 0 ))'), 10))
157 POLYGON((17.0711 -7.0711,18.3147 -5.5557,19.2388 -3.8268,19.8079 -1.9509,20 0,19.8079 1.9509,19.2388 3.8268,18.3147 5.5557,17.0711 7.0711,7.0711 17.0711,5.5557 18.3147,3.8268 19.2388,1.9509 19.8079,0 20,-1.9509 19.8079,-3.8268 19.2388,-5.5557 18.3147,-7.0711 17.0711,-17.0711 7.0711,-18.3147 5.5557,-19.2388 3.8268,-19.8079 1.9509,-20 0,-19.8079 -1.9509,-19.2388 -3.8268,-18.3147 -5.5557,-17.0711 -7.0711,-7.0711 -17.0711,-5.5557 -18.3147,-3.8268 -19.2388,-1.9509 -19.8079,0 -20,1.9509 -19.8079,3.8268 -19.2388,5.5557 -18.3147,7.0711 -17.0711,17.0711 -7.0711))
158 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 100));
159 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 100))
160 POLYGON((-100 0,-98.0785 -19.509,-92.388 -38.2683,-83.147 -55.557,-70.7107 -70.7107,-55.557 -83.147,-38.2683 -92.388,-19.509 -98.0785,0 -100,10 -100,29.509 -98.0785,48.2683 -92.388,65.557 -83.147,80.7107 -70.7107,93.147 -55.557,102.388 -38.2683,108.0785 -19.509,110 0,110 10,108.0785 29.509,102.388 48.2683,93.147 65.557,80.7107 80.7107,65.557 93.147,48.2683 102.388,29.509 108.0785,10 110,0 110,-19.509 108.0785,-38.2683 102.388,-55.557 93.147,-70.7107 80.7107,-83.147 65.557,-92.388 48.2683,-98.0785 29.509,-100 10,-100 0))
161 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0))'), 5));
162 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0))'), 5))
163 POLYGON((-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,10 -5,10.9755 -4.9039,11.9134 -4.6194,12.7779 -4.1573,13.5355 -3.5355,14.1573 -2.7779,14.6194 -1.9134,14.9039 -0.9755,15 0,15 10,14.9039 10.9755,14.6194 11.9134,14.1573 12.7779,13.5355 13.5355,12.7779 14.1573,11.9134 14.6194,10.9755 14.9039,10 15,0 15,-0.9755 14.9039,-1.9134 14.6194,-2.7779 14.1573,-3.5355 13.5355,-4.1573 12.7779,-4.6194 11.9134,-4.9039 10.9755,-5 10,-5 0))
164 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0))'), 10));
165 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0))'), 10))
166 POLYGON((-6 4,-5.8079 2.0491,-5.2388 0.1732,-4.3147 -1.5557,-3.0711 -3.0711,-1.5557 -4.3147,0.1732 -5.2388,2.0491 -5.8079,4 -6,6 -6,7.9509 -5.8079,9.8268 -5.2388,11.5557 -4.3147,13.0711 -3.0711,14.3147 -1.5557,15.2388 0.1732,15.8079 2.0491,16 4,16 6,15.8079 7.9509,15.2388 9.8268,14.3147 11.5557,13.0711 13.0711,11.5557 14.3147,9.8268 15.2388,7.9509 15.8079,6 16,4 16,2.0491 15.8079,0.1732 15.2388,-1.5557 14.3147,-3.0711 13.0711,-4.3147 11.5557,-5.2388 9.8268,-5.8079 7.9509,-6 6,-6 4))
167 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8))'), 2));
168 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8))'), 2))
169 POLYGON((2 4,2.0384 3.6098,2.1522 3.2346,2.3371 2.8889,2.5858 2.5858,2.8889 2.3371,3.2346 2.1522,3.6098 2.0384,4 2,6 2,6.3902 2.0384,6.7654 2.1522,7.1111 2.3371,7.4142 2.5858,7.6629 2.8889,7.8478 3.2346,7.9616 3.6098,8 4,8 6,7.9616 6.3902,7.8478 6.7654,7.6629 7.1111,7.4142 7.4142,7.1111 7.6629,6.7654 7.8478,6.3902 7.9616,6 8,4 8,3.6098 7.9616,3.2346 7.8478,2.8889 7.6629,2.5858 7.4142,2.3371 7.1111,2.1522 6.7654,2.0384 6.3902,2 6,2 4))
170 SELECT ST_ASTEXT(ST_BUFFER(g, 20)) FROM gis_geometrycollection WHERE fid=100;
171 ST_ASTEXT(ST_BUFFER(g, 20))
172 POLYGON((15 -17.3607,16.0557 -17.8885,19.6688 -19.2764,23.4815 -19.9423,27.3511 -19.8613,31.1326 -19.0366,34.6845 -17.4989,37.8737 -15.3058,40.5807 -12.5396,42.7043 -9.3037,44.1648 -5.7194,44.9075 -1.9209,44.9049 1.7904,46.0036 3.0049,47.9326 6.1444,49.2528 9.5845,49.9196 13.2084,49.9102 16.8932,49.225 20.5137,47.8872 23.947,45.9422 27.0766,43.4562 29.7963,40.5133 32.0138,37.2136 33.6538,33.6691 34.6606,32.3688 34.7809,30.9438 37.0746,28.4577 39.795,25.5146 42.013,22.2146 43.6534,18.6696 44.6605,15 45,11.3304 44.6605,7.7854 43.6534,4.4854 42.013,1.5423 39.795,-0.9438 37.0746,-2.3763 34.7688,-3.8547 34.625,-7.5649 33.5141,-10.9914 31.709,-14.0057 29.2773,-16.4949 26.3102,-18.3655 22.919,-19.5474 19.2308,-19.9963 15.384,-19.6954 11.5228,-18.6559 7.792,-16.9169 4.3314,-14.8483 1.6639,-14.9987 0.2282,-14.696 -3.4738,-13.714 -7.056,-12.0864 -10.3949,-9.8696 -13.3752,-7.1399 -15.8941,-3.9914 -17.8649,-0.5329 -19.2195,3.1165 -19.9111,6.8309 -19.916,10.4821 -19.234,13.9443 -17.8885,15 -17.3607))
173 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), -2));
174 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), -2))
175 POLYGON((8 2,8 8,2 8,2 2,8 2))
176 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), -5));
177 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), -5))
178 GEOMETRYCOLLECTION EMPTY
179 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), -10));
180 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), -10))
181 GEOMETRYCOLLECTION EMPTY
182 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), -2));
183 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), -2))
184 MULTIPOLYGON(((4 2,3.6098 2.0384,3.2346 2.1522,2.8889 2.3371,2.5858 2.5858,2.3371 2.8889,2.1522 3.2346,2.0384 3.6098,2 4,2 2,4 2)),((6 8,6.3902 7.9616,6.7654 7.8478,7.1111 7.6629,7.4142 7.4142,7.6629 7.1111,7.8478 6.7654,7.9616 6.3902,8 6,8 8,6 8)),((2 8,2 6,2.0384 6.3902,2.1522 6.7654,2.3371 7.1111,2.5858 7.4142,2.8889 7.6629,3.2346 7.8478,3.6098 7.9616,4 8,2 8)),((8 2,8 4,7.9616 3.6098,7.8478 3.2346,7.6629 2.8889,7.4142 2.5858,7.1111 2.3371,6.7654 2.1522,6.3902 2.0384,6 2,8 2)))
185 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), -3));
186 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), -3))
187 GEOMETRYCOLLECTION EMPTY
188 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), -5));
189 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), -5))
190 GEOMETRYCOLLECTION EMPTY
191 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'), -1));
192 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'), -1))
193 MULTIPOLYGON(((4 1,9 1,9 6,8.9808 5.8049,8.9239 5.6173,8.8315 5.4444,8.7071 5.2929,8.5556 5.1685,8.3827 5.0761,8.1951 5.0192,8 5,6 5,5.8049 5.0192,5.6173 5.0761,5.4444 5.1685,5.2929 5.2929,5.1685 5.4444,5.0761 5.6173,5.0192 5.8049,5 6,5 8,5.0192 8.1951,5.0761 8.3827,5.1685 8.5556,5.2929 8.7071,5.4444 8.8315,5.6173 8.9239,5.8049 8.9808,6 9,1 9,1 4,1.0192 4.1951,1.0761 4.3827,1.1685 4.5556,1.2929 4.7071,1.4444 4.8315,1.6173 4.9239,1.8049 4.9808,2 5,4 5,4.1951 4.9808,4.3827 4.9239,4.5556 4.8315,4.7071 4.7071,4.8315 4.5556,4.9239 4.3827,4.9808 4.1951,5 4,5 2,4.9808 1.8049,4.9239 1.6173,4.8315 1.4444,4.7071 1.2929,4.5556 1.1685,4.3827 1.0761,4.1951 1.0192,4 1)),((1 1,2 1,1.8049 1.0192,1.6173 1.0761,1.4444 1.1685,1.2929 1.2929,1.1685 1.4444,1.0761 1.6173,1.0192 1.8049,1 2,1 1)),((9 9,8 9,8.1951 8.9808,8.3827 8.9239,8.5556 8.8315,8.7071 8.7071,8.8315 8.5556,8.9239 8.3827,8.9808 8.1951,9 8,9 9)))
194 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'), -2));
195 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'), -2))
196 MULTIPOLYGON(((2 8,2 6,4 6,4 8,2 8)),((8 2,8 4,6 4,6 2,8 2)))
197 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'), -3));
198 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'), -3))
199 GEOMETRYCOLLECTION EMPTY
200 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'), -5));
201 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'), -5))
202 GEOMETRYCOLLECTION EMPTY
203 #####################################################################################
204 # ST_BUFFER(multipolygon, distance)
205 #####################################################################################
206 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_of_elems), 0));
207 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_of_elems), 0))
208 MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0)))
209 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((3 3,5 5,7 3,3 3)))'), 0.5));
210 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((3 3,5 5,7 3,3 3)))'), 0.5))
211 POLYGON((2.6464 3.3536,2.5843 3.2778,2.5381 3.1913,2.5096 3.0975,2.5 3,2.5096 2.9025,2.5381 2.8087,2.5843 2.7222,2.6464 2.6464,2.7222 2.5843,2.8087 2.5381,2.9025 2.5096,3 2.5,7 2.5,7.0975 2.5096,7.1913 2.5381,7.2778 2.5843,7.3536 2.6464,7.4157 2.7222,7.4619 2.8087,7.4904 2.9025,7.5 3,7.4904 3.0975,7.4619 3.1913,7.4157 3.2778,7.3536 3.3536,5.3536 5.3536,5.2778 5.4157,5.1913 5.4619,5.0975 5.4904,5 5.5,4.9025 5.4904,4.8087 5.4619,4.7222 5.4157,4.6464 5.3536,2.6464 3.3536))
212 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))'), 1));
213 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))'), 1))
214 POLYGON((5 6.4142,0.7071 10.7071,0.5556 10.8315,0.3827 10.9239,0.1951 10.9808,-0 11,-0.1951 10.9808,-0.3827 10.9239,-0.5556 10.8315,-0.7071 10.7071,-0.8315 10.5556,-0.9239 10.3827,-0.9808 10.1951,-1 10,-1 0,-0.9808 -0.1951,-0.9239 -0.3827,-0.8315 -0.5556,-0.7071 -0.7071,-0.5556 -0.8315,-0.3827 -0.9239,-0.1951 -0.9808,0 -1,10 -1,10.1951 -0.9808,10.3827 -0.9239,10.5556 -0.8315,10.7071 -0.7071,10.8315 -0.5556,10.9239 -0.3827,10.9808 -0.1951,11 -0,11 10,10.9808 10.1951,10.9239 10.3827,10.8315 10.5556,10.7071 10.7071,10.5556 10.8315,10.3827 10.9239,10.1951 10.9808,10 11,9.8049 10.9808,9.6173 10.9239,9.4444 10.8315,9.2929 10.7071,5 6.4142))
215 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))'), 20));
216 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))'), 20))
217 POLYGON((-3.5192 29.6534,-3.9018 29.6157,-7.6537 28.4776,-11.1114 26.6294,-14.1421 24.1421,-16.6294 21.1114,-18.4776 17.6537,-19.6157 13.9018,-20 10,-20 0,-19.6157 -3.9018,-18.4776 -7.6537,-16.6294 -11.1114,-14.1421 -14.1421,-11.1114 -16.6294,-7.6537 -18.4776,-3.9018 -19.6157,0 -20,3.9018 -19.6157,7.6537 -18.4776,11.1114 -16.6294,14.1421 -14.1421,24.1421 -4.1421,29.1421 0.8579,31.6294 3.8886,33.4776 7.3463,34.6157 11.0982,35 15,34.6157 18.9018,33.4776 22.6537,31.6294 26.1114,29.1421 29.1421,26.1114 31.6294,22.6537 33.4776,18.9018 34.6157,15 35,10 35,6.0982 34.6157,2.3463 33.4776,-1.1114 31.6294,-3.5192 29.6534))
218 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4, 4 4)))'), 4));
219 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4, 4 4)))'), 4))
220 POLYGON((-4 0,-3.9231 -0.7804,-3.6955 -1.5307,-3.3259 -2.2223,-2.8284 -2.8284,-2.2223 -3.3259,-1.5307 -3.6955,-0.7804 -3.9231,0 -4,10 -4,10.7804 -3.9231,11.5307 -3.6955,12.2223 -3.3259,12.8284 -2.8284,13.3259 -2.2223,13.6955 -1.5307,13.9231 -0.7804,14 0,14 10,13.9231 10.7804,13.6955 11.5307,13.3259 12.2223,12.8284 12.8284,12.2223 13.3259,11.5307 13.6955,10.7804 13.9231,10 14,0 14,-0.7804 13.9231,-1.5307 13.6955,-2.2223 13.3259,-2.8284 12.8284,-3.3259 12.2223,-3.6955 11.5307,-3.9231 10.7804,-4 10,-4 0))
221 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 4));
222 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 4))
223 POLYGON((-4 0,-3.9231 -0.7804,-3.6955 -1.5307,-3.3259 -2.2223,-2.8284 -2.8284,-2.2223 -3.3259,-1.5307 -3.6955,-0.7804 -3.9231,0 -4,10 -4,10.7804 -3.9231,11.5307 -3.6955,12.2223 -3.3259,12.8284 -2.8284,13.3259 -2.2223,13.6955 -1.5307,13.9231 -0.7804,14 0,14 10,13.9231 10.7804,13.6955 11.5307,13.3259 12.2223,12.8284 12.8284,12.2223 13.3259,11.5307 13.6955,10.7804 13.9231,10 14,0 14,-0.7804 13.9231,-1.5307 13.6955,-2.2223 13.3259,-2.8284 12.8284,-3.3259 12.2223,-3.6955 11.5307,-3.9231 10.7804,-4 10,-4 0))
224 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)))'), 5));
225 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)))'), 5))
226 POLYGON((-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,10 -5,10.9755 -4.9039,11.9134 -4.6194,12.7779 -4.1573,13.5355 -3.5355,14.1573 -2.7779,14.6194 -1.9134,14.9039 -0.9755,15 0,15 10,14.9039 10.9755,14.6194 11.9134,14.1573 12.7779,13.5355 13.5355,12.7779 14.1573,11.9134 14.6194,10.9755 14.9039,10 15,0 15,-0.9755 14.9039,-1.9134 14.6194,-2.7779 14.1573,-3.5355 13.5355,-4.1573 12.7779,-4.6194 11.9134,-4.9039 10.9755,-5 10,-5 0))
227 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8)))'), 2));
228 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8)))'), 2))
229 POLYGON((2 4,2.0384 3.6098,2.1522 3.2346,2.3371 2.8889,2.5858 2.5858,2.8889 2.3371,3.2346 2.1522,3.6098 2.0384,4 2,6 2,6.3902 2.0384,6.7654 2.1522,7.1111 2.3371,7.4142 2.5858,7.6629 2.8889,7.8478 3.2346,7.9616 3.6098,8 4,8 6,7.9616 6.3902,7.8478 6.7654,7.6629 7.1111,7.4142 7.4142,7.1111 7.6629,6.7654 7.8478,6.3902 7.9616,6 8,4 8,3.6098 7.9616,3.2346 7.8478,2.8889 7.6629,2.5858 7.4142,2.3371 7.1111,2.1522 6.7654,2.0384 6.3902,2 6,2 4))
230 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((10 10,10 0,5 10,10 10)),((0 10,0 20,5 10,0 10)))'), 20));
231 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((10 10,10 0,5 10,10 10)),((0 10,0 20,5 10,0 10)))'), 20))
232 POLYGON((-8.2927 -8.136,-7.8885 -8.9443,-5.8618 -12.1821,-3.2565 -14.9755,-0.1676 -17.2226,3.2922 -18.8416,6.9966 -19.7732,10.8106 -19.9836,14.5951 -19.465,18.2119 -18.2364,21.5292 -16.3425,24.4259 -13.8526,26.7964 -10.8573,28.5542 -7.466,29.6352 -3.8023,30 0,30 10,29.6157 13.9018,28.4776 17.6537,26.6294 21.1114,24.1421 24.1421,21.1114 26.6294,18.2927 28.136,17.8885 28.9443,15.8618 32.1821,13.2565 34.9755,10.1676 37.2226,6.7078 38.8416,3.0034 39.7732,-0.8106 39.9836,-4.5951 39.465,-8.2119 38.2364,-11.5292 36.3425,-14.4259 33.8526,-16.7964 30.8573,-18.5542 27.466,-19.6352 23.8023,-20 20,-20 10,-19.6157 6.0982,-18.4776 2.3463,-16.6294 -1.1114,-14.1421 -4.1421,-11.1114 -6.6294,-8.2927 -8.136))
233 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),((0 0,0 10,10 10,10 0,0 0)))'), 100));
234 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),((0 0,0 10,10 10,10 0,0 0)))'), 100))
235 POLYGON((10 110,0 110,-19.509 108.0785,-38.2683 102.388,-55.557 93.147,-70.7107 80.7107,-83.147 65.557,-92.388 48.2683,-98.0785 29.509,-100 10,-100 0,-98.0785 -19.509,-92.388 -38.2683,-83.147 -55.557,-70.7107 -70.7107,-55.557 -83.147,-38.2683 -92.388,-19.509 -98.0785,0 -100,10 -100,29.509 -98.0785,48.2683 -92.388,65.557 -83.147,80.7107 -70.7107,93.147 -55.557,102.388 -38.2683,108.0785 -19.509,110 0,110 10,108.0785 29.509,102.388 48.2683,93.147 65.557,80.7107 80.7107,65.557 93.147,48.2683 102.388,29.509 108.0785,10 110))
236 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),'
237 '((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6, 4 4)))'), 1000));
238 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),'
239 '((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6, 4 4)))'), 1000))
240 POLYGON((10 1010,0 1010,-195.0903 990.7853,-382.6834 933.8795,-555.5702 841.4696,-707.1068 717.1068,-831.4696 565.5702,-923.8795 392.6834,-980.7853 205.0903,-1000 10,-1000 0,-980.7853 -195.0903,-923.8795 -382.6834,-831.4696 -555.5702,-707.1068 -707.1068,-555.5702 -831.4696,-382.6834 -923.8795,-195.0903 -980.7853,0 -1000,10 -1000,205.0903 -980.7853,392.6834 -923.8795,565.5702 -831.4696,717.1068 -707.1068,841.4696 -555.5702,933.8795 -382.6834,990.7853 -195.0903,1010 0,1010 10,990.7853 205.0903,933.8795 392.6834,841.4696 565.5702,717.1068 717.1068,565.5702 841.4696,392.6834 933.8795,205.0903 990.7853,10 1010))
241 SELECT ST_ASTEXT(ST_BUFFER(g, 20)) FROM gis_geometrycollection WHERE fid=103;
242 ST_ASTEXT(ST_BUFFER(g, 20))
243 POLYGON((15.000001034274 -17.360680292135,16.055728090001 -17.888543819998,17.05695241022 -18.277767398939,18.036969761672 -18.748765556701,18.791543359698 -18.952076436705,19.513605851123 -19.232770971526,20.560323430982 -19.428653186497,21.601027046921 -19.709058396185,22.389620895482 -19.770985011858,23.160268586622 -19.915204953167,24.215869804709 -19.914396496148,25.280859015937 -19.998027858096,26.076802800948 -19.91297501152,26.870235860276 -19.912363441514,27.898439945493 -19.718318771356,28.95112445877 -19.605831160941,29.727007318712 -19.373220151413,30.515848948033 -19.224344212027,31.481833991057 -18.84712011122,32.486808017295 -18.54582717789,33.215198543551 -18.170226369641,33.971663531698 -17.874821774608,34.843454553241 -17.330602224035,35.767478416673 -16.854121411289,36.421934267429 -16.345232902906,37.118766195662 -15.910232741694,37.868228891705 -15.220630359922,38.681390555289 -14.588336179073,39.23747994126 -13.960736648624,39.84886619747 -13.398177960067,40.452478682288 -12.589495516168,41.129291729157 -11.825647902577,41.565485691838 -11.098358088614,42.068021715792 -10.425096388487,42.507787320356 -9.527207557571,43.027802344439 -8.660158349006,43.32621505532 -7.856199441815,43.699872356845 -7.093290762243,43.963765683364 -6.138563136424,44.312255965376 -5.199689368395,44.459455114067 -4.345222020385,44.688266689815 -3.517407390498,44.770500401079 -2.539654230981,44.938901960873 -1.562110301703,44.926432690103 -0.685615870684,44.999194398682 0.17950878459,44.900370525731 1.146355088366,44.891418507445 1.775576406702,46.00363701272 3.004850881915,47.93259127868 6.144370715087,49.252848420451 9.584482693302,49.919594126876 13.208416951261,49.910196632822 16.893164029441,49.224974923287 20.513650260851,47.887187905897 23.946983224481,45.942244919301 27.076623159353,43.45616437569 29.796338746271,40.513332856672 32.013812983715,37.213640726934 33.653776761362,33.669091493324 34.660563766424,32.368108982336 34.780922427548,31.90644890027 35.685129179498,29.678014161645 38.585135268761,26.958748218274 41.030855905158,23.839583028956 42.940506455343,20.424823139988 44.250228411628,16.828657752429 44.916224813565,13.171342247571 44.916224813565,9.575176860011 44.250228411628,6.160416971044 42.940506455343,3.041251781726 41.030855905158,0.321985838355 38.585135268761,-1.90644890027 35.685129179498,-2.368940236166 34.779294335031,-3.694618779319 34.655782662502,-7.26206237471 33.63497920755,-10.579533192563 31.972727459883,-13.532838135665 29.726245006582,-16.020319327581 26.972859668531,-17.956353353016 23.807347742745,-19.274298564215 20.338671637916,-19.928789002022 16.686229199389,-19.897295970845 12.97574382832,-19.180903515418 9.334936864233,-17.804271106102 5.889131195082,-15.814784817162 2.756937426164,-14.842110268168 1.716355116701,-14.999194398682 0.17950878459,-14.688266689815 -3.517407390498,-13.699872356845 -7.093290762243,-12.068021715792 -10.425096388487,-9.84886619747 -13.398177960067,-7.118766195662 -15.910232741694,-3.971663531698 -17.874821774608,-0.515848948033 -19.224344212027,3.129764139724 -19.912363441514,6.839731413378 -19.915204953167,10.486394148877 -19.232770971526,13.944271909999 -17.888543819998,15.000001034274 -17.360680292135))
244 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)))'), -2));
245 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)))'), -2))
246 POLYGON((8 2,8 8,2 8,2 2,8 2))
247 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)))'), -5));
248 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)))'), -5))
249 GEOMETRYCOLLECTION EMPTY
250 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), -2));
251 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), -2))
252 MULTIPOLYGON(((4 2,3.6098 2.0384,3.2346 2.1522,2.8889 2.3371,2.5858 2.5858,2.3371 2.8889,2.1522 3.2346,2.0384 3.6098,2 4,2 2,4 2)),((6 8,6.3902 7.9616,6.7654 7.8478,7.1111 7.6629,7.4142 7.4142,7.6629 7.1111,7.8478 6.7654,7.9616 6.3902,8 6,8 8,6 8)),((2 8,2 6,2.0384 6.3902,2.1522 6.7654,2.3371 7.1111,2.5858 7.4142,2.8889 7.6629,3.2346 7.8478,3.6098 7.9616,4 8,2 8)),((8 2,8 4,7.9616 3.6098,7.8478 3.2346,7.6629 2.8889,7.4142 2.5858,7.1111 2.3371,6.7654 2.1522,6.3902 2.0384,6 2,8 2)))
253 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), -3));
254 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), -3))
255 GEOMETRYCOLLECTION EMPTY
256 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((14 14,14 16,16 16,16 14,14 14)))'), -1));
257 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((14 14,14 16,16 16,16 14,14 14)))'), -1))
258 POLYGON((1 1,9 1,9 9,1 9,1 1))
259 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((14 14,14 16,16 16,16 14,14 14)))'), -2));
260 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((14 14,14 16,16 16,16 14,14 14)))'), -2))
261 POLYGON((8 2,8 8,2 8,2 2,8 2))
262 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((14 14,14 16,16 16,16 14,14 14)))'), -4));
263 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((14 14,14 16,16 16,16 14,14 14)))'), -4))
264 POLYGON((6 4,6 6,4 6,4 4,6 4))
265 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((14 14,14 16,16 16,16 14,14 14)))'), -5));
266 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((14 14,14 16,16 16,16 14,14 14)))'), -5))
267 GEOMETRYCOLLECTION EMPTY
268 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((14 14,14 16,16 16,16 14,14 14)))'), -10));
269 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((14 14,14 16,16 16,16 14,14 14)))'), -10))
270 GEOMETRYCOLLECTION EMPTY
271 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10)))'), -1));
272 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10)))'), -1))
273 MULTIPOLYGON(((9 1,9 9,1 9,1 1,9 1)),((19 11,19 19,11 19,11 11,19 11)))
274 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10)))'), -3));
275 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10)))'), -3))
276 MULTIPOLYGON(((7 3,7 7,3 7,3 3,7 3)),((17 13,17 17,13 17,13 13,17 13)))
277 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10)))'), -5));
278 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10)))'), -5))
279 GEOMETRYCOLLECTION EMPTY
280 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10)))'), -10));
281 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10)))'), -10))
282 GEOMETRYCOLLECTION EMPTY
283 #####################################################################################
284 # ST_BUFFER(geometrycollection, distance)
285 #####################################################################################
286 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_collection_elems), 0));
287 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_collection_elems), 0))
288 GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),LINESTRING(15 25,15 10),MULTIPOINT((5 0),(25 0)),POINT(15 25))
289 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_collection_multilinestr), 1));
290 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_collection_multilinestr), 1))
291 POLYGON((4.50019361905 10.556672376815,5.892614926281 9.562085728793,4.019419324309 0.196116135138,4.000065081195 0.011408687709,4.015200021201 -0.173692261649,4.064302118633 -0.352802316894,4.145677772042 -0.519743716476,4.256520218947 -0.668758413155,4.393006345088 -0.794706677269,4.550428549089 -0.893244373353,4.723357114359 -0.960972795569,4.905827487762 -0.99555589393,5.091546005578 -0.995800847993,5.274106970947 -0.961699208941,5.4472135955 -0.894427191,15.0000007955 3.881966409,24.5527864045 -0.894427191,24.733439590444 -0.96381821318,24.924075646999 -0.997113580602,25.117555122776 -0.993066358865,25.306632078379 -0.951828119205,25.484225451823 -0.87494326205,25.643684249166 -0.765291178164,25.779036628812 -0.626978413479,25.885213551082 -0.46518487613,25.958238617235 -0.285969845332,25.995376988335 -0.096045047207,25.99523780685 0.097476703972,25.957826285221 0.287347885566,23.177098224214 9.556438748626,30.529998940003 14.152001695995,30.676573065982 14.263624493626,30.800181850636 14.400242544096,30.896629563934 14.557218535754,30.962642421023 14.729224134665,30.995979706344 14.910420847563,30.995509831641 15.094658201472,30.961248746164 15.275682513043,30.894359395295 15.447349161224,30.797112245965 15.603831157968,30.672808218785 15.739816937314,30.525666642834 15.850690649186,30.360682036347 15.932688838068,30.183454574666 15.983028188321,30 16,20.618032 16,15.894427191 25.4472135955,15.797188509938 25.603730469351,15.672882972781 25.739748947239,15.525731112119 25.850650808352,15.360729159316 25.932670613678,15.183479408002 25.983023553553,15 26,14.816520591998 25.983023553553,14.639270840684 25.932670613678,14.474268887881 25.850650808352,14.327117027219 25.739748947239,14.202811490062 25.603730469351,14.105572809 25.4472135955,9.381968 16,7.766189581762 16,15.857492925713 29.485504244572,15.940291061129 29.659628555309,15.988134057995 29.846406108749,15.999243362145 30.038893485424,15.973205987343 30.229935004293,15.910989867968 30.412428733796,15.814907876237 30.579590504793,15.688531841633 30.725206110742,15.536559768828 30.84386231962,15.364641190271 30.931148109786,15.179167145907 30.983818648851,14.987032597506 30.999915919702,14.795380109788 30.978841509403,14.611334326959 30.921378855086,14.441737115443 30.829664119825,14.292893218813 30.707106781187,-0.707106781187 15.707106781187,-0.758878778974 15.644018897057,-0.824742876616 15.565507902218,-0.827675154326 15.560191995888,-0.831469612303 15.55557023302,-0.870383007767 15.48276721867,-0.918273137568 15.395947527863,-0.92049375771 15.389018160313,-0.923879532511 15.382683432365,-0.947914428546 15.303452915227,-0.977369413652 15.211539663557,-0.978352725672 15.203113737568,-0.980785280403 15.195090322016,-0.988887108376 15.112845412598,-0.999815675461 15.01919935162,-0.999062400801 15.009533483231,-1 15,-0.991945385667 14.91820938163,-0.984770218923 14.826139090296,-0.981842132638 14.81562964489,-0.980785280403 14.804909677984,-0.957108924331 14.726857567452,-0.932797228049 14.639598374942,-0.927352364488 14.628763569504,-0.923879532511 14.617316567635,-0.885771296418 14.546020856591,-0.845845618808 14.466572226873,-0.837668018456 14.456027293298,-0.831469612303 14.44442976698,-0.780726891788 14.382602281982,-0.727175957447 14.313548889642,-0.716194969395 14.303971614728,-0.707106781187 14.292893218813,-0.645930525379 14.242689160552,-0.581238193719 14.186266528793,2.867526737201 11.722863006707,-0.857492925713 5.514495755428,-0.941389582191 5.337321292749,-0.989109164963 5.147183761963,-0.998817837225 4.951390041746,-0.970142500145 4.757464374964,-0.904185130847 4.572859216236,-0.803480434044 4.404668838285,-0.671898434757 4.259356703014,-0.514495755428 4.142507074287,-0.337321292749 4.058610417809,-0.147183761963 4.010890835037,0.048609958254 4.001182162775,0.242535625036 4.029857499855,0.427140783764 4.095814869153,0.595331161715 4.196519565956,0.740643296986 4.328101565243,0.857492925713 4.485504244572,4.50019361905 10.556672376815),(2.414211814785 16,9.963202594983 23.54898828992,5.433809311846 15.999999484692,2.414211814785 16))
292 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'), 0));
293 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'), 0))
294 GEOMETRYCOLLECTION EMPTY
295 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'), 10));
296 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'), 10))
297 GEOMETRYCOLLECTION EMPTY
298 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))'), 100));
299 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))'), 100))
300 GEOMETRYCOLLECTION EMPTY
301 SELECT ST_AREA(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10))'), 10)) BETWEEN 568.21 AND 568.22;
302 ST_AREA(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10))'), 10)) BETWEEN 568.21 AND 568.22
303 1
304 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10)))'), 5));
305 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10)))'), 5))
306 MULTIPOLYGON(((15 10,14.9039 10.9755,14.6194 11.9134,14.1573 12.7779,13.5355 13.5355,12.7779 14.1573,11.9134 14.6194,10.9755 14.9039,10 15,9.0245 14.9039,8.0866 14.6194,7.2221 14.1573,6.4645 13.5355,5.8427 12.7779,5.3806 11.9134,5.0961 10.9755,5 10,5.0961 9.0245,5.3806 8.0866,5.8427 7.2221,6.4645 6.4645,7.2221 5.8427,8.0866 5.3806,9.0245 5.0961,10 5,10.9755 5.0961,11.9134 5.3806,12.7779 5.8427,13.5355 6.4645,14.1573 7.2221,14.6194 8.0866,14.9039 9.0245,15 10)),((5 0,4.9039 0.9755,4.6194 1.9134,4.1573 2.7779,3.5355 3.5355,2.7779 4.1573,1.9134 4.6194,0.9755 4.9039,0 5,-0.9755 4.9039,-1.9134 4.6194,-2.7779 4.1573,-3.5355 3.5355,-4.1573 2.7779,-4.6194 1.9134,-4.9039 0.9755,-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,0.9755 -4.9039,1.9134 -4.6194,2.7779 -4.1573,3.5355 -3.5355,4.1573 -2.7779,4.6194 -1.9134,4.9039 -0.9755,5 0)))
307 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
308 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10)))'), 50));
309 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
310 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10)))'), 50))
311 POLYGON((5 -49.5075,10 -50,19.7545 -49.0393,29.1342 -46.194,37.7785 -41.5735,45.3553 -35.3553,51.5735 -27.7785,56.194 -19.1342,59.0393 -9.7545,59.2311 -7.8064,61.194 -4.1342,64.0393 5.2455,65 15,64.0393 24.7545,61.194 34.1342,56.5735 42.7785,50.3553 50.3553,42.7785 56.5735,34.1342 61.194,24.7545 64.0393,15 65,10 65,0.2455 64.0393,-9.1342 61.194,-17.6412 56.6469,-19.1342 56.194,-27.7785 51.5735,-35.3553 45.3553,-41.5735 37.7785,-46.194 29.1342,-49.0393 19.7545,-50 10,-50 0,-49.0393 -9.7545,-46.194 -19.1342,-41.5735 -27.7785,-35.3553 -35.3553,-27.7785 -41.5735,-19.1342 -46.194,-9.7545 -49.0393,0 -50,5 -49.5075))
312 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10))'), 20));
313 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10))'), 20))
314 POLYGON((18.1906 -8.1906,21.1114 -6.6294,24.1421 -4.1421,26.6294 -1.1114,28.4776 2.3463,29.6157 6.0982,30 10,29.6157 13.9018,28.4776 17.6537,26.6294 21.1114,24.1421 24.1421,21.1114 26.6294,17.6537 28.4776,13.9018 29.6157,10 30,0 30,-3.9018 29.6157,-7.6537 28.4776,-11.1114 26.6294,-14.1421 24.1421,-16.6294 21.1114,-18.4776 17.6537,-19.6157 13.9018,-20 10,-20 0,-19.6157 -3.9018,-18.4776 -7.6537,-16.6294 -11.1114,-14.1421 -14.1421,-11.1114 -16.6294,-7.6537 -18.4776,-3.9018 -19.6157,0 -20,3.9018 -19.6157,7.6537 -18.4776,11.1114 -16.6294,14.1421 -14.1421,16.6294 -11.1114,18.1906 -8.1906))
315 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10),GEOMETRYCOLLECTION())'), 10));
316 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10),GEOMETRYCOLLECTION())'), 10))
317 POLYGON((10 0,11.9509 0.1921,13.8268 0.7612,15.5557 1.6853,17.0711 2.9289,18.3147 4.4443,19.2388 6.1732,19.8079 8.0491,20 10,19.8079 11.9509,19.2388 13.8268,18.3147 15.5557,17.0711 17.0711,15.5557 18.3147,13.8268 19.2388,11.9509 19.8079,10 20,0 20,-1.9509 19.8079,-3.8268 19.2388,-5.5557 18.3147,-7.0711 17.0711,-8.3147 15.5557,-9.2388 13.8268,-9.8079 11.9509,-10 10,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,8.3147 -5.5557,9.2388 -3.8268,9.8079 -1.9509,10 0))
318 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),'
319 'MULTIPOINT(0 0,10 10),'
320 'LINESTRING(1 1,2 2,3 3),'
321 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10)))'), 0));
322 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),'
323 'MULTIPOINT(0 0,10 10),'
324 'LINESTRING(1 1,2 2,3 3),'
325
326 GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT((0 0),(10 10)),LINESTRING(1 1,2 2,3 3),MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10)))
327 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))'), 5));
328 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))'), 5))
329 POLYGON((-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,10 -5,10.9755 -4.9039,11.9134 -4.6194,12.7779 -4.1573,13.5355 -3.5355,14.1573 -2.7779,14.6194 -1.9134,14.9039 -0.9755,15 0,15 10,14.9039 10.9755,14.6194 11.9134,14.1573 12.7779,13.5355 13.5355,12.7779 14.1573,11.9134 14.6194,10.9755 14.9039,10 15,0 15,-0.9755 14.9039,-1.9134 14.6194,-2.7779 14.1573,-3.5355 13.5355,-4.1573 12.7779,-4.6194 11.9134,-4.9039 10.9755,-5 10,-5 0))
330 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))))'), 5));
331 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))))'), 5))
332 POLYGON((-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,10 -5,10.9755 -4.9039,11.9134 -4.6194,12.7779 -4.1573,13.5355 -3.5355,14.1573 -2.7779,14.6194 -1.9134,14.9039 -0.9755,15 0,15 10,14.9039 10.9755,14.6194 11.9134,14.1573 12.7779,13.5355 13.5355,12.7779 14.1573,11.9134 14.6194,10.9755 14.9039,10 15,0 15,-0.9755 14.9039,-1.9134 14.6194,-2.7779 14.1573,-3.5355 13.5355,-4.1573 12.7779,-4.6194 11.9134,-4.9039 10.9755,-5 10,-5 0))
333 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4, 4 4)),'
334 'MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),((10 10,10 15,15 15,15 10,10 10))))'), 10));
335 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4, 4 4)),'
336 'MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),((10 10,10 15,15 15,15 10,10 10)))
337 POLYGON((1.3883 20,0 20,-1.9509 19.8079,-3.8268 19.2388,-5.5557 18.3147,-7.0711 17.0711,-8.3147 15.5557,-9.2388 13.8268,-9.8079 11.9509,-10 10,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,10 -10,11.9509 -9.8079,13.8268 -9.2388,15.5557 -8.3147,17.0711 -7.0711,18.3147 -5.5557,19.2388 -3.8268,19.8079 -1.9509,20 0,20 1.3883,20.5557 1.6853,22.0711 2.9289,23.3147 4.4443,24.2388 6.1732,24.8079 8.0491,25 10,25 15,24.8079 16.9509,24.2388 18.8268,23.3147 20.5557,22.0711 22.0711,20.5557 23.3147,18.8268 24.2388,16.9509 24.8079,15 25,10 25,8.0491 24.8079,6.1732 24.2388,4.4443 23.3147,2.9289 22.0711,1.6853 20.5557,1.3883 20))
338 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
339 'MULTIPOINT(0 0,10 10)),'
340 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
341 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10))))'), 10)) as result;
342 result
343 POLYGON
344 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
345 'MULTIPOINT(0 0,10 10)),'
346 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
347 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10))),'
348 'GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4, 4 4)),'
349 'MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),'
350 '((10 10,10 15,15 15,15 10,10 10)))))'),1000));
351 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
352 'MULTIPOINT(0 0,10 10)),'
353
354 POLYGON((-381.1905 934.3324,-382.6834 933.8795,-555.5702 841.4696,-707.1068 717.1068,-831.4696 565.5702,-923.8795 392.6834,-980.7853 205.0903,-1000 10,-1000 0,-980.7853 -195.0903,-923.8795 -382.6834,-831.4696 -555.5702,-707.1068 -707.1068,-555.5702 -831.4696,-382.6834 -923.8795,-195.0903 -980.7853,0 -1000,10 -1000,205.0903 -980.7853,392.6834 -923.8795,565.5702 -831.4696,717.1068 -707.1068,841.4696 -555.5702,933.8795 -382.6834,934.3324 -381.1905,938.8795 -372.6834,995.7853 -185.0903,1015 10,1015 15,995.7853 210.0903,938.8795 397.6834,846.4696 570.5702,722.1068 722.1068,570.5702 846.4696,397.6834 938.8795,210.0903 995.7853,15 1015,10 1015,-185.0903 995.7853,-372.6834 938.8795,-381.1905 934.3324))
355 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
356 'MULTIPOINT(0 0,10 10)),'
357 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
358 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10))),'
359 'GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))'), 1000));
360 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
361 'MULTIPOINT(0 0,10 10)),'
362
363 POLYGON((5 -999.5075,10 -1000,205.0903 -980.7853,392.6834 -923.8795,565.5702 -831.4696,717.1068 -707.1068,841.4696 -555.5702,933.8795 -382.6834,937.8395 -369.6293,938.8795 -367.6834,995.7853 -180.0903,1015 15,995.7853 210.0903,938.8795 397.6834,846.4696 570.5702,722.1068 722.1068,570.5702 846.4696,397.6834 938.8795,210.0903 995.7853,15 1015,10 1015,-185.0903 995.7853,-372.6834 938.8795,-381.1905 934.3324,-382.6834 933.8795,-555.5702 841.4696,-707.1068 717.1068,-831.4696 565.5702,-923.8795 392.6834,-980.7853 205.0903,-1000 10,-1000 0,-980.7853 -195.0903,-923.8795 -382.6834,-831.4696 -555.5702,-707.1068 -707.1068,-555.5702 -831.4696,-382.6834 -923.8795,-195.0903 -980.7853,0 -1000,5 -999.5075))
364 SELECT ST_ASTEXT(ST_BUFFER(g, 20)) FROM gis_geometrycollection WHERE fid=115;
365 ST_ASTEXT(ST_BUFFER(g, 20))
366 POLYGON((15 -17.3607,16.0557 -17.8885,19.6688 -19.2764,23.4815 -19.9423,27.3511 -19.8613,31.1326 -19.0366,34.6845 -17.4989,37.8737 -15.3058,40.5807 -12.5396,42.7043 -9.3037,44.1648 -5.7194,44.9075 -1.9209,44.9049 1.7904,46.0036 3.0049,47.9326 6.1444,49.2528 9.5845,49.9196 13.2084,49.9102 16.8932,49.225 20.5137,47.8872 23.947,45.9422 27.0766,43.4562 29.7963,40.5133 32.0138,37.2136 33.6538,33.6691 34.6606,32.3688 34.7809,30.9438 37.0746,28.4577 39.795,25.5146 42.013,22.2146 43.6534,18.6696 44.6605,15 45,11.3304 44.6605,7.7854 43.6534,4.4854 42.013,1.5423 39.795,-0.9438 37.0746,-2.3763 34.7688,-3.8547 34.625,-7.5649 33.5141,-10.9914 31.709,-14.0057 29.2773,-16.4949 26.3102,-18.3655 22.919,-19.5474 19.2308,-19.9963 15.384,-19.6954 11.5228,-18.6559 7.792,-16.9169 4.3314,-14.8483 1.6639,-14.9987 0.2282,-14.696 -3.4738,-13.714 -7.056,-12.0864 -10.3949,-9.8696 -13.3752,-7.1399 -15.8941,-3.9914 -17.8649,-0.5329 -19.2195,3.1165 -19.9111,6.8309 -19.916,10.4821 -19.234,13.9443 -17.8885,15 -17.3607))
367 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))'), -2));
368 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))'), -2))
369 POLYGON((8 2,8 8,2 8,2 2,8 2))
370 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))'), -5));
371 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))'), -5))
372 GEOMETRYCOLLECTION EMPTY
373 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10))))'), -2));
374 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10))))'), -2))
375 MULTIPOLYGON(((2 8,2 2,8 2,8 8,2 8)),((18 12,18 18,12 18,12 12,18 12)))
376 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10))))'), -10));
377 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 20,20 20,20 10,10 10))))'), -10))
378 GEOMETRYCOLLECTION EMPTY
379 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)), POLYGON((10 10,10 20,20 20,20 10,10 10)))'), -2));
380 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)), POLYGON((10 10,10 20,20 20,20 10,10 10)))'), -2))
381 MULTIPOLYGON(((2 8,2 2,8 2,8 8,2 8)),((18 12,18 18,12 18,12 12,18 12)))
382 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)), POLYGON((10 10,10 20,20 20,20 10,10 10)))'), -5));
383 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)), POLYGON((10 10,10 20,20 20,20 10,10 10)))'), -5))
384 GEOMETRYCOLLECTION EMPTY
385 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)), MULTIPOLYGON(((10 10,10 20,20 20,20 10,10 10))))'), -2));
386 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)), MULTIPOLYGON(((10 10,10 20,20 20,20 10,10 10))))'), -2))
387 MULTIPOLYGON(((2 8,2 2,8 2,8 8,2 8)),((18 12,18 18,12 18,12 12,18 12)))
388 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)), MULTIPOLYGON(((10 10,10 20,20 20,20 10,10 10))))'), -10));
389 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)), MULTIPOLYGON(((10 10,10 20,20 20,20 10,10 10))))'), -10))
390 GEOMETRYCOLLECTION EMPTY
391 #####################################################################################
392 # ST_BUFFER() with 'point_circle' strategy
393 #####################################################################################
394 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 2, ST_BUFFER_STRATEGY('point_circle', 1)));
395 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 2, ST_BUFFER_STRATEGY('point_circle', 1)))
396 POLYGON((2 0,-1 1.7321,-1 -1.7321,2 0))
397 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 2, ST_BUFFER_STRATEGY('point_circle', 2)));
398 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 2, ST_BUFFER_STRATEGY('point_circle', 2)))
399 POLYGON((2 0,-1 1.7321,-1 -1.7321,2 0))
400 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(2.34 -2.34)'), 3, ST_BUFFER_STRATEGY('point_circle', 3)));
401 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(2.34 -2.34)'), 3, ST_BUFFER_STRATEGY('point_circle', 3)))
402 POLYGON((5.34 -2.34,0.84 0.2581,0.84 -4.9381,5.34 -2.34))
403 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1000 -1000)'), 5, ST_BUFFER_STRATEGY('point_circle', 5)));
404 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1000 -1000)'), 5, ST_BUFFER_STRATEGY('point_circle', 5)))
405 POLYGON((1005 -1000,1001.5450849718748 -995.2447174185243,995.9549150281252 -997.0610737385376,995.9549150281252 -1002.9389262614624,1001.5450849718748 -1004.7552825814757,1005 -1000))
406 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 10, ST_BUFFER_STRATEGY('point_circle', 10)));
407 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 10, ST_BUFFER_STRATEGY('point_circle', 10)))
408 POLYGON((10 0,8.0902 5.8779,3.0902 9.5106,-3.0902 9.5106,-8.0902 5.8779,-10 0,-8.0902 -5.8779,-3.0902 -9.5106,3.0902 -9.5106,8.0902 -5.8779,10 0))
409 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)'), 5, ST_BUFFER_STRATEGY('point_circle', 20)));
410 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)'), 5, ST_BUFFER_STRATEGY('point_circle', 20)))
411 POLYGON((4.7552 -1.5450,5 0,4.7552 1.5450,4.0450 2.9389,2.9389 4.0450,1.5450 4.7552,-9.18e-16 5,-1.5450 4.7552,-2.9389 4.0450,-4.0450 2.9389,-4.7552 1.5450,-5 -6.12e-16,-4.7552 -1.5450,-4.0450 -2.9389,-2.9389 -4.0450,-1.5450 -4.7552,3.06e-16 -5,1.5450 -4.7552,2.9389 -4.0450,4.0450 -2.9389,4.7552 -1.5450))
412 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(10 10,20 20,30 30)'), 5, ST_BUFFER_STRATEGY('point_circle', 4)));
413 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(10 10,20 20,30 30)'), 5, ST_BUFFER_STRATEGY('point_circle', 4)))
414 MULTIPOLYGON(((15 10,10 15,5 10,10 5,15 10)),((25 20,20 25,15 20,20 15,25 20)),((35 30,30 35,25 30,30 25,35 30)))
415 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(10 15,15 15,15 10)'), 5, ST_BUFFER_STRATEGY('point_circle', 25)));
416 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(10 15,15 15,15 10)'), 5, ST_BUFFER_STRATEGY('point_circle', 25)))
417 POLYGON((10.0394 10.0271,10.0394 9.3733,10.3511 8.1594,10.9549 7.0611,11.8129 6.1474,12.8711 5.4759,14.0631 5.0886,15.314 5.0099,16.5451 5.2447,17.6791 5.7784,18.6448 6.5773,19.3815 7.5912,19.8429 8.7566,20 10,19.8429 11.2434,19.3815 12.4088,19.3152 12.5,19.3815 12.5912,19.8429 13.7566,20 15,19.8429 16.2434,19.3815 17.4088,18.6448 18.4227,17.6791 19.2216,16.5451 19.7553,15.314 19.9901,14.0631 19.9114,12.8711 19.5241,12.5157 19.2986,11.5451 19.7553,10.314 19.9901,9.0631 19.9114,7.8711 19.5241,6.8129 18.8526,5.9549 17.9389,5.3511 16.8406,5.0394 15.6267,5.0394 14.3733,5.3511 13.1594,5.9549 12.0611,6.8129 11.1474,7.8711 10.4759,9.0631 10.0886,10.0394 10.0271))
418 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1000 -1000,0.0001 0)'), 100, ST_BUFFER_STRATEGY('point_circle', 50)));
419 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1000 -1000,0.0001 0)'), 100, ST_BUFFER_STRATEGY('point_circle', 50)))
420 MULTIPOLYGON(((1100 -1000,1099.2115 -987.4667,1096.8583 -975.131,1092.9776 -963.1875,1087.6307 -951.8246,1080.9017 -941.2215,1072.8969 -931.5453,1063.7424 -922.9487,1053.5827 -915.5672,1042.5779 -909.5173,1030.9017 -904.8943,1018.7381 -901.7713,1006.2791 -900.1973,993.7209 -900.1973,981.2619 -901.7713,969.0983 -904.8943,957.4221 -909.5173,946.4173 -915.5672,936.2576 -922.9487,927.1031 -931.5453,919.0983 -941.2215,912.3693 -951.8246,907.0224 -963.1875,903.1417 -975.131,900.7885 -987.4667,900 -1000,900.7885 -1012.5333,903.1417 -1024.869,907.0224 -1036.8125,912.3693 -1048.1754,919.0983 -1058.7785,927.1031 -1068.4547,936.2576 -1077.0513,946.4173 -1084.4328,957.4221 -1090.4827,969.0983 -1095.1057,981.2619 -1098.2287,993.7209 -1099.8027,1006.2791 -1099.8027,1018.7381 -1098.2287,1030.9017 -1095.1057,1042.5779 -1090.4827,1053.5827 -1084.4328,1063.7424 -1077.0513,1072.8969 -1068.4547,1080.9017 -1058.7785,1087.6307 -1048.1754,1092.9776 -1036.8125,1096.8583 -1024.869,1099.2115 -1012.5333,1100 -1000)),((73.1233 68.1811,72.897 68.4547,63.7425 77.0513,53.5828 84.4328,42.578 90.4827,30.9018 95.1057,18.7382 98.2287,6.2792 99.8027,-6.279 99.8027,-18.738 98.2287,-30.9016 95.1057,-42.5778 90.4827,-53.5826 84.4328,-63.7423 77.0513,-72.8968 68.4547,-80.9016 58.7785,-87.6306 48.1754,-92.9775 36.8125,-96.8582 24.869,-99.2114 12.5333,-99.9999 0,-99.2114 -12.5333,-96.8582 -24.869,-92.9775 -36.8125,-87.6306 -48.1754,-80.9016 -58.7785,-72.8968 -68.4547,-72.1228 -69.1816,-71.8969 -69.4547,-62.7424 -78.0513,-52.5827 -85.4328,-41.5779 -91.4827,-29.9017 -96.1057,-17.7381 -99.2287,-5.2791 -100.8027,7.2791 -100.8027,19.7381 -99.2287,31.9017 -96.1057,43.5779 -91.4827,54.5827 -85.4328,64.7424 -78.0513,73.8969 -69.4547,81.9017 -59.7785,88.6307 -49.1754,93.9776 -37.8125,97.8583 -25.869,100.2115 -13.5333,101 -1,100.2115 11.5333,97.8583 23.869,93.9776 35.8125,88.6307 47.1754,81.9017 57.7785,73.8969 67.4547,73.1233 68.1811)))
421 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'), 5, ST_BUFFER_STRATEGY('point_circle', 4)));
422 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'), 5, ST_BUFFER_STRATEGY('point_circle', 4)))
423 POLYGON((10 5,4.999999999999999 10,0 4.999999999999999,5 0,10 5))
424 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(5 5,10 10))'), 5, ST_BUFFER_STRATEGY('point_circle', 4)));
425 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(5 5,10 10))'), 5, ST_BUFFER_STRATEGY('point_circle', 4)))
426 POLYGON((9.999999999999998 15,0 4.999999999999999,5 0,10 5,15 10,9.999999999999998 15))
427 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),MULTIPOINT(5 5))'), 5, ST_BUFFER_STRATEGY('point_circle', 4)));
428 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),MULTIPOINT(5 5))'), 5, ST_BUFFER_STRATEGY('point_circle', 4)))
429 POLYGON((10 5,4.999999999999999 10,0 4.999999999999999,5 0,10 5))
430 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),MULTIPOINT(10 10,15 15))'), 5, ST_BUFFER_STRATEGY('point_circle', 20)));
431 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),MULTIPOINT(10 10,15 15))'), 5, ST_BUFFER_STRATEGY('point_circle', 20)))
432 POLYGON((5 10,3.4549 9.7553,2.0611 9.0451,0.9549 7.9389,0.2447 6.5451,0 5,0.2447 3.4549,0.9549 2.0611,2.0611 0.9549,3.4549 0.2447,5 0,6.5451 0.2447,7.9389 0.9549,9.0451 2.0611,9.7553 3.4549,10 5,11.5451 5.2447,12.9389 5.9549,14.0451 7.0611,14.7553 8.4549,15 10,16.5451 10.2447,17.9389 10.9549,19.0451 12.0611,19.7553 13.4549,20 15,19.7553 16.5451,19.0451 17.9389,17.9389 19.0451,16.5451 19.7553,15 20,13.4549 19.7553,12.0611 19.0451,10.9549 17.9389,10.2447 16.5451,10 15,8.4549 14.7553,7.0611 14.0451,5.9549 12.9389,5.2447 11.5451,5 10))
433 #####################################################################################
434 # ST_BUFFER() with 'point_square' strategy
435 #####################################################################################
436 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 2, ST_BUFFER_STRATEGY('point_square')));
437 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 2, ST_BUFFER_STRATEGY('point_square')))
438 POLYGON((-2 -2,2 -2,2 2,-2 2,-2 -2))
439 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(2.34 -2.34)'), 3, ST_BUFFER_STRATEGY('point_square')));
440 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(2.34 -2.34)'), 3, ST_BUFFER_STRATEGY('point_square')))
441 POLYGON((-0.6600000000000001 -5.34,5.34 -5.34,5.34 0.6600000000000001,-0.6600000000000001 0.6600000000000001,-0.6600000000000001 -5.34))
442 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1000 -1000)'), 5, ST_BUFFER_STRATEGY('point_square')));
443 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1000 -1000)'), 5, ST_BUFFER_STRATEGY('point_square')))
444 POLYGON((995 -1005,1005 -1005,1005 -995,995 -995,995 -1005))
445 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0.000001)'), 10, ST_BUFFER_STRATEGY('point_square')));
446 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0.000001)'), 10, ST_BUFFER_STRATEGY('point_square')))
447 POLYGON((-10 -9.999999,10 -9.999999,10 10.000001,-10 10.000001,-10 -9.999999))
448 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)'), 5, ST_BUFFER_STRATEGY('point_square')));
449 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)'), 5, ST_BUFFER_STRATEGY('point_square')))
450 POLYGON((-5 5,-5 -5,5 -5,5 5,-5 5))
451 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(10 10,20 20,30 30)'), 5, ST_BUFFER_STRATEGY('point_square')));
452 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(10 10,20 20,30 30)'), 5, ST_BUFFER_STRATEGY('point_square')))
453 MULTIPOLYGON(((15 15,5 15,5 5,15 5,15 15)),((15 15,25 15,25 25,15 25,15 15)),((25 25,35 25,35 35,25 35,25 25)))
454 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(10 15,15 15,15 10)'), 5, ST_BUFFER_STRATEGY('point_square')));
455 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(10 15,15 15,15 10)'), 5, ST_BUFFER_STRATEGY('point_square')))
456 POLYGON((20 20,5 20,5 10,10 10,10 5,20 5,20 10,20 20))
457 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1000 -1000,0.0001 0.000)'), 100, ST_BUFFER_STRATEGY('point_square')));
458 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1000 -1000,0.0001 0.000)'), 100, ST_BUFFER_STRATEGY('point_square')))
459 MULTIPOLYGON(((900 -1100,1100 -1100,1100 -900,900 -900,900 -1100)),((-99 -100,-99 -101,101 -101,101 99,100.00012000480018 99,100.0001 100,-99.9999 100,-99.9999 -100,-99 -100)))
460 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'), 5, ST_BUFFER_STRATEGY('point_square')));
461 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'), 5, ST_BUFFER_STRATEGY('point_square')))
462 POLYGON((0 0,10 0,10 10,0 10,0 0))
463 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(5 5,10 10))'), 5, ST_BUFFER_STRATEGY('point_square')));
464 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(5 5,10 10))'), 5, ST_BUFFER_STRATEGY('point_square')))
465 POLYGON((5 10,0 10,0 0,10 0,10 5,15 5,15 15,5 15,5 10))
466 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),MULTIPOINT(5 5))'), 5, ST_BUFFER_STRATEGY('point_square')));
467 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),MULTIPOINT(5 5))'), 5, ST_BUFFER_STRATEGY('point_square')))
468 POLYGON((0 0,10 0,10 10,0 10,0 0))
469 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),MULTIPOINT(10 10,15 15))'), 5, ST_BUFFER_STRATEGY('point_square')));
470 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),MULTIPOINT(10 10,15 15))'), 5, ST_BUFFER_STRATEGY('point_square')))
471 POLYGON((5 10,0 10,0 0,10 0,10 5,15 5,15 10,20 10,20 20,10 20,10 15,5 15,5 10))
472 #####################################################################################
473 # ST_BUFFER() with 'end_round' strategy
474 #####################################################################################
475 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1,1 1)'), 5, ST_BUFFER_STRATEGY('end_round', 1)));
476 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1,1 1)'), 5, ST_BUFFER_STRATEGY('end_round', 1)))
477 POLYGON((6 1,5.9039 1.9755,5.6194 2.9134,5.1573 3.7779,4.5355 4.5355,3.7779 5.1573,2.9134 5.6194,1.9755 5.9039,1 6,0.0245 5.9039,-0.9134 5.6194,-1.7779 5.1573,-2.5355 4.5355,-3.1573 3.7779,-3.6194 2.9134,-3.9039 1.9755,-4 1,-3.9039 0.0245,-3.6194 -0.9134,-3.1573 -1.7779,-2.5355 -2.5355,-1.7779 -3.1573,-0.9134 -3.6194,0.0245 -3.9039,1 -4,1.9755 -3.9039,2.9134 -3.6194,3.7779 -3.1573,4.5355 -2.5355,5.1573 -1.7779,5.6194 -0.9134,5.9039 0.0245,6 1))
478 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,-0 0,0 0)'), 5, ST_BUFFER_STRATEGY('end_round', 3)));
479 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,-0 0,0 0)'), 5, ST_BUFFER_STRATEGY('end_round', 3)))
480 POLYGON((5 0,4.9039 0.9755,4.6194 1.9134,4.1573 2.7779,3.5355 3.5355,2.7779 4.1573,1.9134 4.6194,0.9755 4.9039,0 5,-0.9755 4.9039,-1.9134 4.6194,-2.7779 4.1573,-3.5355 3.5355,-4.1573 2.7779,-4.6194 1.9134,-4.9039 0.9755,-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,0.9755 -4.9039,1.9134 -4.6194,2.7779 -4.1573,3.5355 -3.5355,4.1573 -2.7779,4.6194 -1.9134,4.9039 -0.9755,5 0))
481 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 10, ST_BUFFER_STRATEGY('end_round', 4)));
482 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 10, ST_BUFFER_STRATEGY('end_round', 4)))
483 POLYGON((-10 -0,0 -10,5 -10,6.9509 -9.8079,8.8268 -9.2388,10.5557 -8.3147,12.0711 -7.0711,13.3147 -5.5557,14.2388 -3.8268,14.8079 -1.9509,15 0,15 5,14.8079 6.9509,14.2388 8.8268,13.3147 10.5557,12.0711 12.0711,10.5557 13.3147,8.8268 14.2388,6.9509 14.8079,5 15,0 15,-1.9509 14.8079,-3.8268 14.2388,-5.5557 13.3147,-7.0711 12.0711,-8.3147 10.5557,-9.2388 8.8268,-9.8079 6.9509,-10 5,-10 -0))
484 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0)'), 1000, ST_BUFFER_STRATEGY('end_round', 10)));
485 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0)'), 1000, ST_BUFFER_STRATEGY('end_round', 10)))
486 POLYGON((1707.1068 -292.8932,707.1069 707.1067,156.4346 987.6883,-453.9904 891.0065,-891.0064 453.9905,-987.6882 -156.4344,-707.1067 -707.1067,-706.1068 -708.1068,292.8932 -1707.1067,444.4298 -1831.4696,617.3166 -1923.8795,804.9097 -1980.7853,1000 -2000,1195.0903 -1980.7853,1382.6834 -1923.8795,1555.5702 -1831.4696,1707.1068 -1707.1068,1831.4696 -1555.5703,1923.8795 -1382.6835,1980.7853 -1195.0904,2000 -1000,1980.7853 -804.9097,1923.8795 -617.3166,1831.4696 -444.4298,1707.1068 -292.8932))
487 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0 0),(0 0,0 -0))'), 10, ST_BUFFER_STRATEGY('end_round', 1)));
488 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0 0),(0 0,0 -0))'), 10, ST_BUFFER_STRATEGY('end_round', 1)))
489 POLYGON((9.8079 -1.9509,10 0,9.8079 1.9509,9.2388 3.8268,8.3147 5.5557,7.0711 7.0711,5.5557 8.3147,3.8268 9.2388,1.9509 9.8079,0 10,-1.9509 9.8079,-3.8268 9.2388,-5.5557 8.3147,-7.0711 7.0711,-8.3147 5.5557,-9.2388 3.8268,-9.8079 1.9509,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,8.3147 -5.5557,9.2388 -3.8268,9.8079 -1.9509))
490 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'), 50, ST_BUFFER_STRATEGY('end_round', 5)));
491 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'), 50, ST_BUFFER_STRATEGY('end_round', 5)))
492 POLYGON((-18.5932 -36.4912,0 -50,5 -50,14.7545 -49.0393,24.1342 -46.194,32.7785 -41.5735,40.3553 -35.3553,46.5735 -27.7785,51.194 -19.1342,54.0393 -9.7545,55 0,55 5,54.0393 14.7545,51.194 24.1342,46.5735 32.7785,40.3553 40.3553,32.7785 46.5735,24.1342 51.194,14.7545 54.0393,5 55,0 55,-9.7545 54.0393,-19.1342 51.194,-27.7785 46.5735,-35.3553 40.3553,-41.5735 32.7785,-46.194 24.1342,-49.0393 14.7545,-50 5,-50 0,-46.2663 -11.4912,-47.5528 -15.4508,-44.1846 -17.898,-40.4508 -29.3893,-18.5932 -36.4912))
493 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'), 100, ST_BUFFER_STRATEGY('end_round', 10)));
494 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'), 100, ST_BUFFER_STRATEGY('end_round', 10)))
495 POLYGON((107.0831 5,108.7688 15.6434,105.1057 22.8328,105.1057 30.9017,102.3883 34.6419,99.1007 55.399,55.399 99.1007,25.245 103.8766,15.6434 108.7688,5 107.0831,-5.6434 108.7688,-15.245 103.8766,-45.399 99.1007,-89.1007 55.399,-92.3883 34.6419,-95.1057 30.9017,-95.1057 22.8328,-98.7688 15.6434,-97.0831 5,-98.7688 -5.6434,-95.1057 -12.8328,-95.1057 -30.9017,-90.3629 -37.4295,-89.1007 -45.399,-72.5426 -61.9571,-58.7785 -80.9017,-51.1046 -83.3951,-45.399 -89.1007,-22.2706 -92.7638,-8.9071 -97.1059,-5.6434 -98.7688,-4.3968 -98.5714,0 -100,10 -100,14.3968 -98.5714,15.6434 -98.7688,18.9071 -97.1059,32.2706 -92.7638,55.399 -89.1007,61.1046 -83.3951,68.7785 -80.9017,82.5426 -61.9571,99.1007 -45.399,100.3629 -37.4295,105.1057 -30.9017,105.1057 -12.8328,108.7688 -5.6434,107.0831 5))
496 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0 0),(2 2,4 -9))'), 1000, ST_BUFFER_STRATEGY('end_round', 50)));
497 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0 0),(2 2,4 -9))'), 1000, ST_BUFFER_STRATEGY('end_round', 50)))
498 POLYGON((292.9 -1707.1,444.4 -1831.5,617.3 -1923.9,804.9 -1980.8,1000 -2000,1195.1 -1980.8,1382.7 -1923.9,1555.6 -1831.5,1707.1 -1707.1,1831.5 -1555.6,1923.9 -1382.7,1980.8 -1195.1,2000 -1000,1980.8 -804.9,1923.9 -617.3,1831.5 -444.4,1707.1 -292.9,736.3 677.9,692.8 725,596.8 805.9,491.3 874.1,378.2 928.5,259.1 968.4,135.9 993,10.7 1002,-114.7 995.2,-238.3 972.7,-358 934.9,-446.4 894.3,-454 891,-455.6 890.1,-472.1 882.5,-542.1 838.9,-562.1 827.1,-566.2 823.9,-578.7 816.1,-630.8 773.8,-661.3 750.1,-667.4 744.1,-676.2 736.9,-711.7 699.7,-750.1 661.3,-757.5 651.8,-763 646.1,-784.3 617.3,-827.1 562.1,-834.9 548.8,-837.6 545.1,-847.7 527.2,-891 454,-898.5 436.7,-899.1 435.6,-901.2 430.4,-940.9 338.7,-975.9 218.1,-995.6 94.1,-999.5 -31.4,-987.7 -156.4,-960.3 -279,-950.8 -305.5,-949.7 -309.8,-942.5 -328.5,-917.8 -397.1,-910.4 -411.5,-904.5 -426.9,-869.2 -492.4,-860.7 -509,-858.4 -512.5,-844.9 -537.5,-772 -639.7,-686.8 -732,-657.5 -756.7,292.9 -1707.1))
499 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10))'), 10, ST_BUFFER_STRATEGY('end_round', 4)));
500 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10))'), 10, ST_BUFFER_STRATEGY('end_round', 4)))
501 POLYGON((-7.0711 7.0711,-7.0711 -7.0711,7.0711 -7.0711,17.0711 2.9289,17.0711 2.9289,17.0711 17.0711,2.9289 17.0711,-7.0711 7.0711))
502 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,5 0),(0 0,0 5)))'), 10, ST_BUFFER_STRATEGY('end_round', 10)));
503 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,5 0),(0 0,0 5)))'), 10, ST_BUFFER_STRATEGY('end_round', 10)))
504 POLYGON((8.7738 8.7738,8.0902 10.8779,3.0902 14.5106,-3.0902 14.5106,-8.0902 10.8779,-10 5,-10 0,-9.5106 -1.5063,-9.5106 -3.0902,-8.5796 -4.3715,-8.0902 -5.8779,-6.8088 -6.8088,-5.8779 -8.0902,-4.3715 -8.5796,-3.0902 -9.5106,-1.5063 -9.5106,0 -10,5 -10,10.8779 -8.0902,14.5106 -3.0902,14.5106 3.0902,10.8779 8.0902,8.7738 8.7738))
505 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
506 'MULTILINESTRING((0 0,10 10)))'), 10, ST_BUFFER_STRATEGY('end_round', 10)));
507 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
508 'MULTILINESTRING((0 0,10 10)))'), 10, ST_BUFFER_STRATEGY('end_round', 10)))
509 POLYGON((-7.0711 7.0711,-9.8769 1.5643,-8.9101 -4.5399,-4.5399 -8.9101,1.5643 -9.8769,7.0711 -7.0711,17.0711 2.9289,17.0711 2.9289,19.8769 8.4357,18.9101 14.5399,14.5399 18.9101,8.4357 19.8769,2.9289 17.0711,-7.0711 7.0711))
510 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
511 'LINESTRING(0 0,-5 -5,-10 -10),'
512 'MULTILINESTRING((0 0,5 5,10 10)),'
513 'MULTILINESTRING((0 0,10 0),(0 0,-10 0)))'), 10, ST_BUFFER_STRATEGY('end_round', 50)));
514 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
515 'LINESTRING(0 0,-5 -5,-10 -10),'
516 'MULTILINESTRI
517 POLYGON((-4.1421 10,-10 10,-11.2533 9.9211,-12.4869 9.6858,-13.6812 9.2978,-14.8175 8.7631,-15.8779 8.0902,-16.8455 7.2897,-17.7051 6.3742,-18.4433 5.3583,-19.0483 4.2578,-19.5106 3.0902,-19.8229 1.8738,-19.9803 0.6279,-19.9803 -0.6279,-19.8229 -1.8738,-19.5106 -3.0902,-19.0483 -4.2578,-18.6471 -4.9875,-19.1775 -6.0285,-19.6029 -7.2101,-19.8769 -8.4357,-19.9951 -9.6859,-19.9556 -10.9411,-19.7592 -12.1814,-19.4088 -13.3874,-18.9101 -14.5399,-18.2708 -15.6208,-17.5011 -16.6131,-16.6131 -17.5011,-15.6208 -18.2708,-14.5399 -18.9101,-13.3874 -19.4088,-12.1814 -19.7592,-10.9411 -19.9556,-9.6859 -19.9951,-8.4357 -19.8769,-7.2101 -19.6029,-6.0285 -19.1775,-4.9096 -18.6074,-3.8709 -17.9016,-2.9289 -17.0711,4.1421 -10,10 -10,11.2533 -9.9211,12.4869 -9.6858,13.6812 -9.2978,14.8175 -8.7631,15.8779 -8.0902,16.8455 -7.2897,17.7051 -6.3742,18.4433 -5.3583,19.0483 -4.2578,19.5106 -3.0902,19.8229 -1.8738,19.9803 -0.6279,19.9803 0.6279,19.8229 1.8738,19.5106 3.0902,19.0483 4.2578,18.6471 4.9875,19.1775 6.0285,19.6029 7.2101,19.8769 8.4357,19.9951 9.6859,19.9556 10.9411,19.7592 12.1814,19.4088 13.3874,18.9101 14.5399,18.2708 15.6208,17.5011 16.6131,16.6131 17.5011,15.6208 18.2708,14.5399 18.9101,13.3874 19.4088,12.1814 19.7592,10.9411 19.9556,9.6859 19.9951,8.4357 19.8769,7.2101 19.6029,6.0285 19.1775,4.9096 18.6074,3.8709 17.9016,2.9289 17.0711,-4.1421 10))
518 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 1, ST_BUFFER_STRATEGY('end_round', 5)));
519 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 1, ST_BUFFER_STRATEGY('end_round', 5)))
520 POLYGON((-0.3719 -0.7298,0 -1,5 -1,5.1951 -0.9808,5.3827 -0.9239,5.5556 -0.8315,5.7071 -0.7071,5.8315 -0.5556,5.9239 -0.3827,5.9808 -0.1951,6 0,6 5,5.9808 5.1951,5.9239 5.3827,5.8315 5.5556,5.7071 5.7071,5.5556 5.8315,5.3827 5.9239,5.1951 5.9808,5 6,0 6,-0.1951 5.9808,-0.3827 5.9239,-0.5556 5.8315,-0.7071 5.7071,-0.8315 5.5556,-0.9239 5.3827,-0.9808 5.1951,-1 5,-1 0,-0.9253 -0.2298,-0.9511 -0.309,-0.8837 -0.358,-0.809 -0.5878,-0.3719 -0.7298),(1 1,1 4,4 4,4 1,1 1))
521 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 2, ST_BUFFER_STRATEGY('end_round', 5)));
522 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 2, ST_BUFFER_STRATEGY('end_round', 5)))
523 POLYGON((-0.7437 -1.4596,0 -2,5 -2,5.3902 -1.9616,5.7654 -1.8478,6.1111 -1.6629,6.4142 -1.4142,6.6629 -1.1111,6.8478 -0.7654,6.9616 -0.3902,7 0,7 5,6.9616 5.3902,6.8478 5.7654,6.6629 6.1111,6.4142 6.4142,6.1111 6.6629,5.7654 6.8478,5.3902 6.9616,5 7,0 7,-0.3902 6.9616,-0.7654 6.8478,-1.1111 6.6629,-1.4142 6.4142,-1.6629 6.1111,-1.8478 5.7654,-1.9616 5.3902,-2 5,-2 0,-1.8507 -0.4596,-1.9021 -0.618,-1.7674 -0.7159,-1.618 -1.1756,-0.7437 -1.4596),(2 2,2 3,3 3,3 2,2 2))
524 #####################################################################################
525 # ST_BUFFER() with 'end_flat' strategy
526 #####################################################################################
527 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1,1 1)'), 5, ST_BUFFER_STRATEGY('end_flat')));
528 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1,1 1)'), 5, ST_BUFFER_STRATEGY('end_flat')))
529 POLYGON((6 1,5.9039 1.9755,5.6194 2.9134,5.1573 3.7779,4.5355 4.5355,3.7779 5.1573,2.9134 5.6194,1.9755 5.9039,1 6,0.0245 5.9039,-0.9134 5.6194,-1.7779 5.1573,-2.5355 4.5355,-3.1573 3.7779,-3.6194 2.9134,-3.9039 1.9755,-4 1,-3.9039 0.0245,-3.6194 -0.9134,-3.1573 -1.7779,-2.5355 -2.5355,-1.7779 -3.1573,-0.9134 -3.6194,0.0245 -3.9039,1 -4,1.9755 -3.9039,2.9134 -3.6194,3.7779 -3.1573,4.5355 -2.5355,5.1573 -1.7779,5.6194 -0.9134,5.9039 0.0245,6 1))
530 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,-0 0,0 0)'), 5, ST_BUFFER_STRATEGY('end_flat')));
531 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,-0 0,0 0)'), 5, ST_BUFFER_STRATEGY('end_flat')))
532 POLYGON((5 0,4.9039 0.9755,4.6194 1.9134,4.1573 2.7779,3.5355 3.5355,2.7779 4.1573,1.9134 4.6194,0.9755 4.9039,0 5,-0.9755 4.9039,-1.9134 4.6194,-2.7779 4.1573,-3.5355 3.5355,-4.1573 2.7779,-4.6194 1.9134,-4.9039 0.9755,-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,0.9755 -4.9039,1.9134 -4.6194,2.7779 -4.1573,3.5355 -3.5355,4.1573 -2.7779,4.6194 -1.9134,4.9039 -0.9755,5 0))
533 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 10, ST_BUFFER_STRATEGY('end_flat')));
534 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 10, ST_BUFFER_STRATEGY('end_flat')))
535 POLYGON((-10 0,0 0,0 -10,5 -10,6.9509 -9.8079,8.8268 -9.2388,10.5557 -8.3147,12.0711 -7.0711,13.3147 -5.5557,14.2388 -3.8268,14.8079 -1.9509,15 0,15 5,14.8079 6.9509,14.2388 8.8268,13.3147 10.5557,12.0711 12.0711,10.5557 13.3147,8.8268 14.2388,6.9509 14.8079,5 15,0 15,-1.9509 14.8079,-3.8268 14.2388,-5.5557 13.3147,-7.0711 12.0711,-8.3147 10.5557,-9.2388 8.8268,-9.8079 6.9509,-10 5,-10 0))
536 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0)'), 1000, ST_BUFFER_STRATEGY('end_flat')));
537 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0)'), 1000, ST_BUFFER_STRATEGY('end_flat')))
538 POLYGON((1707.1068 -292.8932,707.1069 707.1067,-707.1067 -707.1067,-706.1068 -708.1068,292.8932 -1707.1067,444.4298 -1831.4696,617.3166 -1923.8795,804.9097 -1980.7853,1000 -2000,1195.0903 -1980.7853,1382.6834 -1923.8795,1555.5702 -1831.4696,1707.1068 -1707.1068,1831.4696 -1555.5703,1923.8795 -1382.6835,1980.7853 -1195.0904,2000 -1000,1980.7853 -804.9097,1923.8795 -617.3166,1831.4696 -444.4298,1707.1068 -292.8932))
539 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0 0),(0 0,0 -0))'), 10, ST_BUFFER_STRATEGY('end_flat')));
540 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0 0),(0 0,0 -0))'), 10, ST_BUFFER_STRATEGY('end_flat')))
541 POLYGON((9.8079 -1.9509,10 0,9.8079 1.9509,9.2388 3.8268,8.3147 5.5557,7.0711 7.0711,5.5557 8.3147,3.8268 9.2388,1.9509 9.8079,0 10,-1.9509 9.8079,-3.8268 9.2388,-5.5557 8.3147,-7.0711 7.0711,-8.3147 5.5557,-9.2388 3.8268,-9.8079 1.9509,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,8.3147 -5.5557,9.2388 -3.8268,9.8079 -1.9509))
542 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'), 50, ST_BUFFER_STRATEGY('end_flat')));
543 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'), 50, ST_BUFFER_STRATEGY('end_flat')))
544 POLYGON((-50 0,0 0,0 -50,5 -50,14.7545 -49.0393,24.1342 -46.194,32.7785 -41.5735,40.3553 -35.3553,46.5735 -27.7785,51.194 -19.1342,54.0393 -9.7545,55 0,55 5,54.0393 14.7545,51.194 24.1342,46.5735 32.7785,40.3553 40.3553,32.7785 46.5735,24.1342 51.194,14.7545 54.0393,5 55,0 55,-9.7545 54.0393,-19.1342 51.194,-27.7785 46.5735,-35.3553 40.3553,-41.5735 32.7785,-46.194 24.1342,-49.0393 14.7545,-50 5,-50 0))
545 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'), 100, ST_BUFFER_STRATEGY('end_flat')));
546 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'), 100, ST_BUFFER_STRATEGY('end_flat')))
547 POLYGON((0 -10,0 -100,10 -100,10 -10,70.7107 -70.7107,80.7107 -60.7107,15 5,80.7107 70.7107,70.7107 80.7107,10 20,10 100,0 100,0 20,-60.7107 80.7107,-70.7107 70.7107,-5 5,-70.7107 -60.7107,-60.7107 -70.7107,0 -10))
548 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0.0001 0),(2 2,4 -9.002))'), 1000, ST_BUFFER_STRATEGY('end_flat')));
549 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0.0001 0),(2 2,4 -9.002))'), 1000, ST_BUFFER_STRATEGY('end_flat')))
550 POLYGON((1707.1068 -292.8932,707.1069 707.1067,2.0002 2,-981.8756 -176.854,-979.8756 -187.856,-11.8904 -11.8906,-707.1067 -707.1067,-706.1068 -708.1068,292.8932 -1707.1067,444.4298 -1831.4696,617.3166 -1923.8795,804.9097 -1980.7853,1000 -2000,1195.0903 -1980.7853,1382.6834 -1923.8795,1555.5702 -1831.4696,1707.1068 -1707.1068,1831.4696 -1555.5703,1923.8795 -1382.6835,1980.7853 -1195.0904,2000 -1000,1980.7853 -804.9097,1923.8795 -617.3166,1831.4696 -444.4298,1707.1068 -292.8932))
551 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10))'), 10, ST_BUFFER_STRATEGY('end_flat')));
552 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10))'), 10, ST_BUFFER_STRATEGY('end_flat')))
553 POLYGON((-7.0711 7.0711,7.0711 -7.0711,17.0711 2.9289,17.0711 2.9289,2.9289 17.0711,-7.0711 7.0711))
554 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,5 0),(0 0,0 5)))'), 10, ST_BUFFER_STRATEGY('end_flat')));
555 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,5 0),(0 0,0 5)))'), 10, ST_BUFFER_STRATEGY('end_flat')))
556 POLYGON((5 5,5 10,0 10,0 5,-10 5,-10 0,0 0,0 -10,5 -10,5 0,10 0,10 5,5 5))
557 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
558 'MULTILINESTRING((0 0,10 10)))'), 10, ST_BUFFER_STRATEGY('end_flat')));
559 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
560 'MULTILINESTRING((0 0,10 10)))'), 10, ST_BUFFER_STRATEGY('end_flat')))
561 POLYGON((-7.0711 7.0711,7.0711 -7.0711,17.0711 2.9289,17.0711 2.9289,2.9289 17.0711,-7.0711 7.0711))
562 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
563 'LINESTRING(0 0,-5 -5,-10 -10),'
564 'MULTILINESTRING((0 0,5 5,10 10)),'
565 'MULTILINESTRING((0 0,10 0),(0 0,-10 0)))'), 10, ST_BUFFER_STRATEGY('end_flat')));
566 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
567 'LINESTRING(0 0,-5 -5,-10 -10),'
568 'MULTILINESTRI
569 POLYGON((-4.1421 10,-10 10,-10 4.1421,-17.0711 -2.9289,-10 -10,-2.9289 -17.0711,4.1421 -10,10 -10,10 -4.1421,17.0711 2.9289,10 10,2.9289 17.0711,-4.1421 10))
570 #####################################################################################
571 # ST_BUFFER() with 'join_round' strategy
572 #####################################################################################
573 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1,1 1)'), 5, ST_BUFFER_STRATEGY('join_round', 1)));
574 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1,1 1)'), 5, ST_BUFFER_STRATEGY('join_round', 1)))
575 POLYGON((6 1,5.9039 1.9755,5.6194 2.9134,5.1573 3.7779,4.5355 4.5355,3.7779 5.1573,2.9134 5.6194,1.9755 5.9039,1 6,0.0245 5.9039,-0.9134 5.6194,-1.7779 5.1573,-2.5355 4.5355,-3.1573 3.7779,-3.6194 2.9134,-3.9039 1.9755,-4 1,-3.9039 0.0245,-3.6194 -0.9134,-3.1573 -1.7779,-2.5355 -2.5355,-1.7779 -3.1573,-0.9134 -3.6194,0.0245 -3.9039,1 -4,1.9755 -3.9039,2.9134 -3.6194,3.7779 -3.1573,4.5355 -2.5355,5.1573 -1.7779,5.6194 -0.9134,5.9039 0.0245,6 1))
576 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,-0 0,0 0)'), 5, ST_BUFFER_STRATEGY('join_round', 3)));
577 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,-0 0,0 0)'), 5, ST_BUFFER_STRATEGY('join_round', 3)))
578 POLYGON((5 0,4.9039 0.9755,4.6194 1.9134,4.1573 2.7779,3.5355 3.5355,2.7779 4.1573,1.9134 4.6194,0.9755 4.9039,0 5,-0.9755 4.9039,-1.9134 4.6194,-2.7779 4.1573,-3.5355 3.5355,-4.1573 2.7779,-4.6194 1.9134,-4.9039 0.9755,-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,0.9755 -4.9039,1.9134 -4.6194,2.7779 -4.1573,3.5355 -3.5355,4.1573 -2.7779,4.6194 -1.9134,4.9039 -0.9755,5 0))
579 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(10 10,10 15,15 15,15 10,10 10)'), 10, ST_BUFFER_STRATEGY('join_round', 4)));
580 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(10 10,10 15,15 15,15 10,10 10)'), 10, ST_BUFFER_STRATEGY('join_round', 4)))
581 POLYGON((8.0491 0.1921,10 0,15 0,25 10,25 15,15 25,10 25,0 15,0 10,0.1921 8.0491,0.7612 6.1732,1.6853 4.4443,2.9289 2.9289,4.4443 1.6853,6.1732 0.7612,8.0491 0.1921))
582 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0)'), 1000, ST_BUFFER_STRATEGY('join_round', 10)));
583 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0)'), 1000, ST_BUFFER_STRATEGY('join_round', 10)))
584 POLYGON((1707.1068 -292.8932,707.1069 707.1067,555.5704 831.4696,382.6836 923.8795,195.0905 980.7853,0.0002 1000,-195.0902 980.7853,-382.6833 923.8796,-555.5701 831.4696,-707.1066 707.1068,-831.4695 555.5703,-923.8794 382.6835,-980.7852 195.0904,-999.9999 0.0001,-980.7852 -195.0903,-923.8795 -382.6834,-831.4695 -555.5702,-707.1067 -707.1067,-706.1068 -708.1068,292.8932 -1707.1067,843.5655 -1987.6883,1453.9905 -1891.0065,1891.0065 -1453.9905,1987.6883 -843.5656,1707.1068 -292.8932))
585 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0 0),(0 0,0 -0))'), 10, ST_BUFFER_STRATEGY('join_round', 1)));
586 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0 0),(0 0,0 -0))'), 10, ST_BUFFER_STRATEGY('join_round', 1)))
587 POLYGON((9.8079 -1.9509,10 0,9.8079 1.9509,9.2388 3.8268,8.3147 5.5557,7.0711 7.0711,5.5557 8.3147,3.8268 9.2388,1.9509 9.8079,0 10,-1.9509 9.8079,-3.8268 9.2388,-5.5557 8.3147,-7.0711 7.0711,-8.3147 5.5557,-9.2388 3.8268,-9.8079 1.9509,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,8.3147 -5.5557,9.2388 -3.8268,9.8079 -1.9509))
588 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'), 50, ST_BUFFER_STRATEGY('join_round', 5)));
589 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'), 50, ST_BUFFER_STRATEGY('join_round', 5)))
590 POLYGON((30.26 -39.537,40.3553 -35.3553,55 0,55 5,40.3553 40.3553,5 55,0 55,-35.3553 40.3553,-39.537 30.26,-41.5735 27.7785,-46.194 19.1342,-49.0393 9.7545,-49.3539 6.5598,-50 5,-50 0,-49.0393 -9.7545,-46.194 -19.1342,-41.5735 -27.7785,-35.3553 -35.3553,-27.7785 -41.5735,-19.1342 -46.194,-9.7545 -49.0393,0 -50,5 -50,6.5598 -49.3539,9.7545 -49.0393,19.1342 -46.194,27.7785 -41.5735,30.26 -39.537))
591 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'), 100, ST_BUFFER_STRATEGY('join_round', 10)));
592 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'), 100, ST_BUFFER_STRATEGY('join_round', 10)))
593 POLYGON((5 109.5075,0 110,-19.509 108.0785,-38.2683 102.388,-55.557 93.147,-70.7107 80.7107,-83.147 65.557,-92.388 48.2683,-98.0785 29.509,-100 10,-99.5075 5,-100 0,-98.0785 -19.509,-92.388 -38.2683,-83.147 -55.557,-70.7107 -70.7107,-55.557 -83.147,-38.2683 -92.388,-19.509 -98.0785,0 -100,10 -100,29.509 -98.0785,48.2683 -92.388,65.557 -83.147,80.7107 -70.7107,93.147 -55.557,102.388 -38.2683,108.0785 -19.509,110 0,109.5075 5,110 10,108.0785 29.509,102.388 48.2683,93.147 65.557,80.7107 80.7107,65.557 93.147,48.2683 102.388,29.509 108.0785,10 110,5 109.5075))
594 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0 0),(2 2,4 -9))'), 1000, ST_BUFFER_STRATEGY('join_round', 50)));
595 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0 0),(2 2,4 -9))'), 1000, ST_BUFFER_STRATEGY('join_round', 50)))
596 POLYGON((292.89 -1707.11,387.09 -1790.16,490.96 -1860.74,602.85 -1917.75,721.01 -1960.29,843.57 -1987.69,968.59 -1999.51,1094.11 -1995.56,1218.14 -1975.92,1338.74 -1940.88,1453.99 -1891.01,1562.08 -1827.08,1661.31 -1750.11,1750.11 -1661.31,1827.08 -1562.08,1891.01 -1453.99,1940.88 -1338.74,1975.92 -1218.14,1995.56 -1094.11,1999.51 -968.59,1987.69 -843.57,1960.29 -721.01,1917.75 -602.85,1860.74 -490.96,1790.16 -387.09,1707.11 -292.89,735.31 678.9,720.7 697.32,571.24 824.17,399.9 919.43,213.27 979.43,18.53 1001.86,-176.85 985.88,-194.48 980.85,-195.09 980.79,-201.44 978.86,-365.36 932.08,-379.37 924.88,-382.68 923.88,-415.68 906.24,-539.75 842.54,-549.85 834.53,-555.57 831.47,-609.84 786.93,-693.32 720.7,-699.7 713.19,-707.11 707.11,-772.93 626.91,-820.17 571.24,-823.45 565.34,-831.47 555.57,-895.94 434.96,-915.43 399.9,-916.56 396.37,-923.88 382.68,-972.63 221.96,-975.43 213.27,-975.52 212.44,-980.79 195.09,-1000 0,-980.79 -195.09,-930.55 -360.69,-926.08 -376.36,-925.39 -377.7,-923.88 -382.68,-897.34 -432.34,-836.54 -550.75,-714.7 -704.33,-682.91 -731.3,292.89 -1707.11))
597 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,0 0))'), 1, ST_BUFFER_STRATEGY('join_round', 1)));
598 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,0 0))'), 1, ST_BUFFER_STRATEGY('join_round', 1)))
599 POLYGON((-1 0,0.7071067811865475 -0.7071067811865475,5.707106781186548 4.292893218813452,5 6,0 6,-1 5,-1 0))
600 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 5, ST_BUFFER_STRATEGY('join_round', 5)));
601 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 5, ST_BUFFER_STRATEGY('join_round', 5)))
602 POLYGON((-5 0,-3.5355 -3.5355,0 -5,10 -5,13.5355 -3.5355,15 0,15 10,13.5355 13.5355,10 15,0 15,-3.5355 13.5355,-5 10,-5 0))
603 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 10,10 20,20 20,20 10,10 10))'), 10, ST_BUFFER_STRATEGY('join_round', 10)));
604 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 10,10 20,20 20,20 10,10 10))'), 10, ST_BUFFER_STRATEGY('join_round', 10)))
605 POLYGON((0 10,1.3397 5,5 1.3397,10 0,20 0,25 1.3397,28.6603 5,30 10,30 20,28.6603 25,25 28.6603,20 30,10 30,5 28.6603,1.3397 25,0 20,0 10))
606 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 0,0 10,-10 0,0 -10,10 0 ))'), 10, ST_BUFFER_STRATEGY('join_round', 50)));
607 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 0,0 10,-10 0,0 -10,10 0 ))'), 10, ST_BUFFER_STRATEGY('join_round', 50)))
608 POLYGON((17.0711 -7.0711,17.8718 -6.1672,18.5578 -5.1734,19.119 -4.1041,19.5472 -2.975,19.8362 -1.8026,19.9818 -0.6038,19.9818 0.6038,19.8362 1.8026,19.5472 2.975,19.119 4.1041,18.5578 5.1734,17.8718 6.1672,17.0711 7.0711,7.0711 17.0711,6.1672 17.8718,5.1734 18.5578,4.1041 19.119,2.975 19.5472,1.8026 19.8362,0.6038 19.9818,-0.6038 19.9818,-1.8026 19.8362,-2.975 19.5472,-4.1041 19.119,-5.1734 18.5578,-6.1672 17.8718,-7.0711 17.0711,-17.0711 7.0711,-17.8718 6.1672,-18.5578 5.1734,-19.119 4.1041,-19.5472 2.975,-19.8362 1.8026,-19.9818 0.6038,-19.9818 -0.6038,-19.8362 -1.8026,-19.5472 -2.975,-19.119 -4.1041,-18.5578 -5.1734,-17.8718 -6.1672,-17.0711 -7.0711,-7.0711 -17.0711,-6.1672 -17.8718,-5.1734 -18.5578,-4.1041 -19.119,-2.975 -19.5472,-1.8026 -19.8362,-0.6038 -19.9818,0.6038 -19.9818,1.8026 -19.8362,2.975 -19.5472,4.1041 -19.119,5.1734 -18.5578,6.1672 -17.8718,7.0711 -17.0711,17.0711 -7.0711))
609 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1, ST_BUFFER_STRATEGY('join_round',60)));
610 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1, ST_BUFFER_STRATEGY('join_round',60)))
611 POLYGON((-1 0,-0.9945 -0.1045,-0.9781 -0.2079,-0.9511 -0.309,-0.9135 -0.4067,-0.866 -0.5,-0.809 -0.5878,-0.7431 -0.6691,-0.6691 -0.7431,-0.5878 -0.809,-0.5 -0.866,-0.4067 -0.9135,-0.309 -0.9511,-0.2079 -0.9781,-0.1045 -0.9945,0 -1,8 -1,8.1045 -0.9945,8.2079 -0.9781,8.309 -0.9511,8.4067 -0.9135,8.5 -0.866,8.5878 -0.809,8.6691 -0.7431,8.7431 -0.6691,8.809 -0.5878,8.866 -0.5,8.9135 -0.4067,8.9511 -0.309,8.9781 -0.2079,8.9945 -0.1045,9 0,9 8,8.9945 8.1045,8.9781 8.2079,8.9511 8.309,8.9135 8.4067,8.866 8.5,8.809 8.5878,8.7431 8.6691,8.6691 8.7431,8.5878 8.809,8.5 8.866,8.4067 8.9135,8.309 8.9511,8.2079 8.9781,8.1045 8.9945,8 9,0 9,-0.1045 8.9945,-0.2079 8.9781,-0.309 8.9511,-0.4067 8.9135,-0.5 8.866,-0.5878 8.809,-0.6691 8.7431,-0.7431 8.6691,-0.809 8.5878,-0.866 8.5,-0.9135 8.4067,-0.9511 8.309,-0.9781 8.2079,-0.9945 8.1045,-1 8,-1 0),(3 3,3 5,5 5,5 3,3 3))
612 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 100, ST_BUFFER_STRATEGY('join_round', 60)));
613 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 100, ST_BUFFER_STRATEGY('join_round', 60)))
614 POLYGON((-100 0,-99.4522 -10.4528,-97.8148 -20.7912,-95.1057 -30.9017,-91.3545 -40.6737,-86.6025 -50,-80.9017 -58.7785,-74.3145 -66.9131,-66.9131 -74.3145,-58.7785 -80.9017,-50 -86.6025,-40.6737 -91.3545,-30.9017 -95.1057,-20.7912 -97.8148,-10.4528 -99.4522,0 -100,10 -100,20.4528 -99.4522,30.7912 -97.8148,40.9017 -95.1057,50.6737 -91.3545,60 -86.6025,68.7785 -80.9017,76.9131 -74.3145,84.3145 -66.9131,90.9017 -58.7785,96.6025 -50,101.3545 -40.6737,105.1057 -30.9017,107.8148 -20.7912,109.4522 -10.4528,110 0,110 10,109.4522 20.4528,107.8148 30.7912,105.1057 40.9017,101.3545 50.6737,96.6025 60,90.9017 68.7785,84.3145 76.9131,76.9131 84.3145,68.7785 90.9017,60 96.6025,50.6737 101.3545,40.9017 105.1057,30.7912 107.8148,20.4528 109.4522,10 110,0 110,-10.4528 109.4522,-20.7912 107.8148,-30.9017 105.1057,-40.6737 101.3545,-50 96.6025,-58.7785 90.9017,-66.9131 84.3145,-74.3145 76.9131,-80.9017 68.7785,-86.6025 60,-91.3545 50.6737,-95.1057 40.9017,-97.8148 30.7912,-99.4522 20.4528,-100 10,-100 0))
615 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))'), 0.5, ST_BUFFER_STRATEGY('join_round', 1)));
616 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))'), 0.5, ST_BUFFER_STRATEGY('join_round', 1)))
617 POLYGON((-0.5 0,0.3536 -0.3536,5.3536 4.6464,5 5.5,0 5.5,-0.5 5,-0.5 0))
618 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))'), 1, ST_BUFFER_STRATEGY('join_round', 5)));
619 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))'), 1, ST_BUFFER_STRATEGY('join_round', 5)))
620 POLYGON((5 6.4142,0.7071 10.7071,-0.3827 10.9239,-1 10,-1 0,-0.8971 -0.2483,-0.9239 -0.3827,-0.81 -0.4588,-0.7071 -0.7071,0 -1,10 -1,10.7071 -0.7071,10.81 -0.4588,10.9239 -0.3827,10.8971 -0.2483,11 0,11 10,10.3827 10.9239,9.2929 10.7071,5 6.4142))
621 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))'), 20, ST_BUFFER_STRATEGY('join_round', 10)));
622 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))'), 20, ST_BUFFER_STRATEGY('join_round', 10)))
623 POLYGON((-3.1699 29.1506,-10 27.3205,-17.3205 20,-20 10,-20 0,-16.6294 -11.1114,-7.6537 -18.4776,3.9018 -19.6157,14.1421 -14.1421,24.1421 -4.1421,29.1421 0.8579,34.6157 11.0982,33.4776 22.6537,26.1114 31.6294,15 35,10 35,-0 32.3205,-3.1699 29.1506))
624 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4, 4 4)))'), 4, ST_BUFFER_STRATEGY('join_round', 50)));
625 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4, 4 4)))'), 4, ST_BUFFER_STRATEGY('join_round', 50)))
626 POLYGON((-4 0,-3.9708 -0.4821,-3.8838 -0.9573,-3.7401 -1.4184,-3.5418 -1.8589,-3.2919 -2.2723,-2.994 -2.6525,-2.6525 -2.994,-2.2723 -3.2919,-1.8589 -3.5418,-1.4184 -3.7401,-0.9573 -3.8838,-0.4821 -3.9708,0 -4,10 -4,10.4821 -3.9708,10.9573 -3.8838,11.4184 -3.7401,11.8589 -3.5418,12.2723 -3.2919,12.6525 -2.994,12.994 -2.6525,13.2919 -2.2723,13.5418 -1.8589,13.7401 -1.4184,13.8838 -0.9573,13.9708 -0.4821,14 0,14 10,13.9708 10.4821,13.8838 10.9573,13.7401 11.4184,13.5418 11.8589,13.2919 12.2723,12.994 12.6525,12.6525 12.994,12.2723 13.2919,11.8589 13.5418,11.4184 13.7401,10.9573 13.8838,10.4821 13.9708,10 14,0 14,-0.4821 13.9708,-0.9573 13.8838,-1.4184 13.7401,-1.8589 13.5418,-2.2723 13.2919,-2.6525 12.994,-2.994 12.6525,-3.2919 12.2723,-3.5418 11.8589,-3.7401 11.4184,-3.8838 10.9573,-3.9708 10.4821,-4 10,-4 0))
627 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 4, ST_BUFFER_STRATEGY('join_round', 60)));
628 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 4, ST_BUFFER_STRATEGY('join_round', 60)))
629 POLYGON((-4 0,-3.9781 -0.4181,-3.9126 -0.8316,-3.8042 -1.2361,-3.6542 -1.6269,-3.4641 -2,-3.2361 -2.3511,-2.9726 -2.6765,-2.6765 -2.9726,-2.3511 -3.2361,-2 -3.4641,-1.6269 -3.6542,-1.2361 -3.8042,-0.8316 -3.9126,-0.4181 -3.9781,0 -4,10 -4,10.4181 -3.9781,10.8316 -3.9126,11.2361 -3.8042,11.6269 -3.6542,12 -3.4641,12.3511 -3.2361,12.6765 -2.9726,12.9726 -2.6765,13.2361 -2.3511,13.4641 -2,13.6542 -1.6269,13.8042 -1.2361,13.9126 -0.8316,13.9781 -0.4181,14 0,14 10,13.9781 10.4181,13.9126 10.8316,13.8042 11.2361,13.6542 11.6269,13.4641 12,13.2361 12.3511,12.9726 12.6765,12.6765 12.9726,12.3511 13.2361,12 13.4641,11.6269 13.6542,11.2361 13.8042,10.8316 13.9126,10.4181 13.9781,10 14,0 14,-0.4181 13.9781,-0.8316 13.9126,-1.2361 13.8042,-1.6269 13.6542,-2 13.4641,-2.3511 13.2361,-2.6765 12.9726,-2.9726 12.6765,-3.2361 12.3511,-3.4641 12,-3.6542 11.6269,-3.8042 11.2361,-3.9126 10.8316,-3.9781 10.4181,-4 10,-4 0))
630 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10))'), 10, ST_BUFFER_STRATEGY('join_round', 4)));
631 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10))'), 10, ST_BUFFER_STRATEGY('join_round', 4)))
632 POLYGON((-7.0711 7.0711,-8.3147 5.5557,-9.2388 3.8268,-9.8079 1.9509,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,17.0711 2.9289,17.0711 2.9289,18.3147 4.4443,19.2388 6.1732,19.8079 8.0491,20 10,19.8079 11.9509,19.2388 13.8268,18.3147 15.5557,17.0711 17.0711,15.5557 18.3147,13.8268 19.2388,11.9509 19.8079,10 20,8.0491 19.8079,6.1732 19.2388,4.4443 18.3147,2.9289 17.0711,-7.0711 7.0711))
633 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,5 0),(0 0,0 5)))'), 10, ST_BUFFER_STRATEGY('join_round', 10)));
634 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,5 0),(0 0,0 5)))'), 10, ST_BUFFER_STRATEGY('join_round', 10)))
635 POLYGON((9.0953 9.0953,8.3147 10.5557,7.0711 12.0711,5.5557 13.3147,3.8268 14.2388,1.9509 14.8079,0 15,-1.9509 14.8079,-3.8268 14.2388,-5.5557 13.3147,-7.0711 12.0711,-8.3147 10.5557,-9.2388 8.8268,-9.8079 6.9509,-10 5,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,5 -10,6.9509 -9.8079,8.8268 -9.2388,10.5557 -8.3147,12.0711 -7.0711,13.3147 -5.5557,14.2388 -3.8268,14.8079 -1.9509,15 0,14.8079 1.9509,14.2388 3.8268,13.3147 5.5557,12.0711 7.0711,10.5557 8.3147,9.0953 9.0953))
636 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 5,5 5,5 0,0 0)))'), 10, ST_BUFFER_STRATEGY('join_round', 4)));
637 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 5,5 5,5 0,0 0)))'), 10, ST_BUFFER_STRATEGY('join_round', 4)))
638 POLYGON((-10 0,0 -10,5 -10,15 0,15 5,5 15,0 15,-10 5,-10 0))
639 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,2 2,4 0,0 0)),((3 3,3 5,5 5,5 3,3 3))))'), 10, ST_BUFFER_STRATEGY('join_round', 4)));
640 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,2 2,4 0,0 0)),((3 3,3 5,5 5,5 3,3 3))))'), 10, ST_BUFFER_STRATEGY('join_round', 4)))
641 POLYGON((-2.9289 9.0711,-5.0711 9.0711,-7.0711 7.0711,-9.2388 -3.8268,0 -10,4 -10,13.2388 -3.8268,12.3984 0.3984,15 3,15 5,5 15,3 15,-2.9289 9.0711))
642 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
643 'MULTILINESTRING((0 0,10 10)))'), 10, ST_BUFFER_STRATEGY('join_round', 10)));
644 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
645 'MULTILINESTRING((0 0,10 10)))'), 10, ST_BUFFER_STRATEGY('join_round', 10)))
646 POLYGON((-7.0711 7.0711,-8.3147 5.5557,-9.2388 3.8268,-9.8079 1.9509,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,17.0711 2.9289,17.0711 2.9289,18.3147 4.4443,19.2388 6.1732,19.8079 8.0491,20 10,19.8079 11.9509,19.2388 13.8268,18.3147 15.5557,17.0711 17.0711,15.5557 18.3147,13.8268 19.2388,11.9509 19.8079,10 20,8.0491 19.8079,6.1732 19.2388,4.4443 18.3147,2.9289 17.0711,-7.0711 7.0711))
647 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
648 'LINESTRING(0 0,-5 -5,-10 -10),'
649 'MULTILINESTRING((0 0,5 5,10 10)),'
650 'MULTILINESTRING((0 0,10 0),(0 0,-10 0)))'), 10, ST_BUFFER_STRATEGY('join_round', 50)));
651 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
652 'LINESTRING(0 0,-5 -5,-10 -10),'
653 'MULTILINESTRI
654 POLYGON((-4.1421 10,-10 10,-11.9509 9.8079,-13.8268 9.2388,-15.5557 8.3147,-17.0711 7.0711,-18.3147 5.5557,-19.2388 3.8268,-19.8079 1.9509,-20 0,-19.8079 -1.9509,-19.2388 -3.8268,-18.6117 -5,-19.2388 -6.1732,-19.8079 -8.0491,-20 -10,-19.8079 -11.9509,-19.2388 -13.8268,-18.3147 -15.5557,-17.0711 -17.0711,-15.5557 -18.3147,-13.8268 -19.2388,-11.9509 -19.8079,-10 -20,-8.0491 -19.8079,-6.1732 -19.2388,-4.4443 -18.3147,-2.9289 -17.0711,4.1421 -10,10 -10,11.9509 -9.8079,13.8268 -9.2388,15.5557 -8.3147,17.0711 -7.0711,18.3147 -5.5557,19.2388 -3.8268,19.8079 -1.9509,20 0,19.8079 1.9509,19.2388 3.8268,18.6117 5,19.2388 6.1732,19.8079 8.0491,20 10,19.8079 11.9509,19.2388 13.8268,18.3147 15.5557,17.0711 17.0711,15.5557 18.3147,13.8268 19.2388,11.9509 19.8079,10 20,8.0491 19.8079,6.1732 19.2388,4.4443 18.3147,2.9289 17.0711,-4.1421 10))
655 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 5,5 5,5 0,0 0)),'
656 'MULTIPOLYGON(((0 0,2 2,4 0,0 0)),((3 3,3 5,5 5,5 3,3 3))))'), 10, ST_BUFFER_STRATEGY('join_round', 10)));
657 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 5,5 5,5 0,0 0)),'
658 'MULTIPOLYGON(((0 0,2 2,4 0,0 0)),((3 3,3 5,5 5,5 3,3 3))))'), 10, ST_BUFFER_STRATEGY('join_round', 10))
659 POLYGON((15 5,13.6603 10,10 13.6603,5 15,0 15,-5 13.6603,-8.6603 10,-10 5,-10 0,-8.6603 -5,-5 -8.6603,0 -10,5 -10,10 -8.6603,13.6603 -5,15 0,15 5))
660 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
661 'POLYGON((0 0,0 5,5 5,5 0,0 0)),'
662 'MULTILINESTRING((0 0,5 5,10 10)),'
663 'MULTIPOLYGON(((0 0,1 1,1 0,0 0)),((2 2,3 3,3 2,2 2))))'), 10, ST_BUFFER_STRATEGY('join_round', 50)));
664 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
665 'POLYGON((0 0,0 5,5 5,5 0,0 0)),'
666 'MULTILINESTR
667 POLYGON((0.8579 15,0 15,-1.2054 14.9271,-2.3932 14.7094,-3.546 14.3502,-4.6472 13.8546,-5.6806 13.2298,-6.6312 12.4851,-7.4851 11.6312,-8.2298 10.6806,-8.8546 9.6472,-9.3502 8.546,-9.7094 7.3932,-9.9271 6.2054,-10 5,-10 0,-9.9271 -1.2054,-9.7094 -2.3932,-9.3502 -3.546,-8.8546 -4.6472,-8.2298 -5.6806,-7.4851 -6.6312,-6.6312 -7.4851,-5.6806 -8.2298,-4.6472 -8.8546,-3.546 -9.3502,-2.3932 -9.7094,-1.2054 -9.9271,0 -10,5 -10,6.2054 -9.9271,7.3932 -9.7094,8.546 -9.3502,9.6472 -8.8546,10.6806 -8.2298,11.6312 -7.4851,12.4851 -6.6312,13.2298 -5.6806,13.8546 -4.6472,14.3502 -3.546,14.7094 -2.3932,14.9271 -1.2054,15 0,15 0.8579,17.0711 2.9289,18.3147 4.4443,19.2388 6.1732,19.8079 8.0491,20 10,19.8079 11.9509,19.2388 13.8268,18.3147 15.5557,17.0711 17.0711,15.5557 18.3147,13.8268 19.2388,11.9509 19.8079,10 20,8.0491 19.8079,6.1732 19.2388,4.4443 18.3147,2.9289 17.0711,0.8579 15))
668 #####################################################################################
669 # ST_BUFFER() with 'join_mitter' strategy
670 #####################################################################################
671 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1,1 1)'), 5, ST_BUFFER_STRATEGY('join_miter', 1)));
672 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1,1 1)'), 5, ST_BUFFER_STRATEGY('join_miter', 1)))
673 POLYGON((6 1,5.9039 1.9755,5.6194 2.9134,5.1573 3.7779,4.5355 4.5355,3.7779 5.1573,2.9134 5.6194,1.9755 5.9039,1 6,0.0245 5.9039,-0.9134 5.6194,-1.7779 5.1573,-2.5355 4.5355,-3.1573 3.7779,-3.6194 2.9134,-3.9039 1.9755,-4 1,-3.9039 0.0245,-3.6194 -0.9134,-3.1573 -1.7779,-2.5355 -2.5355,-1.7779 -3.1573,-0.9134 -3.6194,0.0245 -3.9039,1 -4,1.9755 -3.9039,2.9134 -3.6194,3.7779 -3.1573,4.5355 -2.5355,5.1573 -1.7779,5.6194 -0.9134,5.9039 0.0245,6 1))
674 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,-0 0,0 0)'), 5, ST_BUFFER_STRATEGY('join_miter', 3)));
675 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,-0 0,0 0)'), 5, ST_BUFFER_STRATEGY('join_miter', 3)))
676 POLYGON((5 0,4.9039 0.9755,4.6194 1.9134,4.1573 2.7779,3.5355 3.5355,2.7779 4.1573,1.9134 4.6194,0.9755 4.9039,0 5,-0.9755 4.9039,-1.9134 4.6194,-2.7779 4.1573,-3.5355 3.5355,-4.1573 2.7779,-4.6194 1.9134,-4.9039 0.9755,-5 0,-4.9039 -0.9755,-4.6194 -1.9134,-4.1573 -2.7779,-3.5355 -3.5355,-2.7779 -4.1573,-1.9134 -4.6194,-0.9755 -4.9039,0 -5,0.9755 -4.9039,1.9134 -4.6194,2.7779 -4.1573,3.5355 -3.5355,4.1573 -2.7779,4.6194 -1.9134,4.9039 -0.9755,5 0))
677 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 10, ST_BUFFER_STRATEGY('join_miter', 4)));
678 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 10, ST_BUFFER_STRATEGY('join_miter', 4)))
679 POLYGON((0 -10,15 -10,15 0,15 5,15 15,5 15,0 15,-10 15,-10 5,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10))
680 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0)'), 1000, ST_BUFFER_STRATEGY('join_miter', 10)));
681 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0)'), 1000, ST_BUFFER_STRATEGY('join_miter', 10)))
682 POLYGON((1707.1068 -292.8932,707.1069 707.1067,555.5704 831.4696,382.6836 923.8795,195.0905 980.7853,0.0002 1000,-195.0902 980.7853,-382.6833 923.8796,-555.5701 831.4696,-707.1066 707.1068,-831.4695 555.5703,-923.8794 382.6835,-980.7852 195.0904,-999.9999 0.0001,-980.7852 -195.0903,-923.8795 -382.6834,-831.4695 -555.5702,-707.1067 -707.1067,-706.1068 -708.1068,292.8932 -1707.1067,8071.0676 -8071.068,1707.1068 -292.8932))
683 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0 0),(0 0,0 -0))'), 10, ST_BUFFER_STRATEGY('join_miter', 1)));
684 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0 0),(0 0,0 -0))'), 10, ST_BUFFER_STRATEGY('join_miter', 1)))
685 POLYGON((9.8079 -1.9509,10 0,9.8079 1.9509,9.2388 3.8268,8.3147 5.5557,7.0711 7.0711,5.5557 8.3147,3.8268 9.2388,1.9509 9.8079,0 10,-1.9509 9.8079,-3.8268 9.2388,-5.5557 8.3147,-7.0711 7.0711,-8.3147 5.5557,-9.2388 3.8268,-9.8079 1.9509,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,8.3147 -5.5557,9.2388 -3.8268,9.8079 -1.9509))
686 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'), 50, ST_BUFFER_STRATEGY('join_miter', 5)));
687 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'), 50, ST_BUFFER_STRATEGY('join_miter', 5)))
688 POLYGON((-9.7545 -49.0393,0 -50,5 -50,55 -50,55 0,55 5,55 55,5 55,0 55,-50 55,-50 5,-50 0,-49.0393 -9.7545,-46.194 -19.1342,-41.5735 -27.7785,-35.3553 -35.3553,-27.7785 -41.5735,-19.1342 -46.194,-9.7545 -49.0393))
689 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'), 100, ST_BUFFER_STRATEGY('join_miter', 10)));
690 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'), 100, ST_BUFFER_STRATEGY('join_miter', 10)))
691 POLYGON((5 109.5075,0 110,-19.509 108.0785,-38.2683 102.388,-55.557 93.147,-70.7107 80.7107,-83.147 65.557,-92.388 48.2683,-98.0785 29.509,-100 10,-99.5075 5,-100 0,-98.0785 -19.509,-92.388 -38.2683,-83.147 -55.557,-70.7107 -70.7107,-55.557 -83.147,-38.2683 -92.388,-19.509 -98.0785,0 -100,10 -100,29.509 -98.0785,48.2683 -92.388,65.557 -83.147,80.7107 -70.7107,93.147 -55.557,102.388 -38.2683,108.0785 -19.509,110 0,109.5075 5,110 10,108.0785 29.509,102.388 48.2683,93.147 65.557,80.7107 80.7107,65.557 93.147,48.2683 102.388,29.509 108.0785,10 110,5 109.5075))
692 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0 0),(2 2,4 -9))'), 1000, ST_BUFFER_STRATEGY('join_miter', 50)));
693 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0 0),(2 2,4 -9))'), 1000, ST_BUFFER_STRATEGY('join_miter', 50)))
694 POLYGON((292.9 -1707.1,36355.3 -36355.3,1707.1 -292.9,735.3 678.9,720.7 697.3,571.2 824.2,399.9 919.4,213.3 979.4,18.5 1001.9,-176.9 985.9,-194.5 980.8,-195.1 980.8,-201.3 978.9,-365.4 932.1,-379.4 924.9,-382.7 923.9,-415.6 906.3,-539.8 842.5,-549.9 834.5,-555.6 831.5,-609.9 786.9,-693.3 720.7,-699.7 713.2,-707.1 707.1,-773 626.8,-820.2 571.2,-823.5 565.3,-831.5 555.6,-896 434.8,-915.4 399.9,-916.6 396.4,-923.9 382.7,-972.7 221.7,-975.4 213.3,-975.5 212.5,-980.8 195.1,-1000 0,-980.8 -195.1,-930.6 -360.6,-926.1 -376.4,-925.4 -377.7,-923.9 -382.7,-897.4 -432.2,-836.5 -550.8,-714.7 -704.3,-683 -731.2,292.9 -1707.1))
695 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,0 0))'), 1, ST_BUFFER_STRATEGY('join_miter', 1)));
696 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,0 0))'), 1, ST_BUFFER_STRATEGY('join_miter', 1)))
697 POLYGON((-1 0,-0.3827 -0.9239,0.7071 -0.7071,5.7071 4.2929,5.9239 5.3827,5 6,0 6,-0.7071 5.7071,-1 5,-1 0))
698 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 5, ST_BUFFER_STRATEGY('join_miter', 5)));
699 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 5, ST_BUFFER_STRATEGY('join_miter', 5)))
700 POLYGON((-5 0,-5 -5,0 -5,10 -5,15 -5,15 0,15 10,15 15,10 15,0 15,-5 15,-5 10,-5 0))
701 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 10,10 20,20 20,20 10,10 10))'), 10, ST_BUFFER_STRATEGY('join_miter', 10)));
702 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 10,10 20,20 20,20 10,10 10))'), 10, ST_BUFFER_STRATEGY('join_miter', 10)))
703 POLYGON((0 10,0 0,10 0,20 0,30 0,30 10,30 20,30 30,20 30,10 30,0 30,0 20,0 10))
704 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 0,0 10,-10 0,0 -10,10 0 ))'), 10, ST_BUFFER_STRATEGY('join_miter', 50)));
705 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((10 0,0 10,-10 0,0 -10,10 0 ))'), 10, ST_BUFFER_STRATEGY('join_miter', 50)))
706 POLYGON((17.0711 -7.0711,24.1421 -0,17.0711 7.0711,7.0711 17.0711,-0 24.1421,-7.0711 17.0711,-17.0711 7.0711,-24.1421 -0,-17.0711 -7.0711,-7.0711 -17.0711,-0 -24.1421,7.0711 -17.0711,17.0711 -7.0711))
707 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1, ST_BUFFER_STRATEGY('join_miter',60)));
708 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1, ST_BUFFER_STRATEGY('join_miter',60)))
709 POLYGON((-1 0,-1 -1,0 -1,8 -1,9 -1,9 0,9 8,9 9,8 9,0 9,-1 9,-1 8,-1 0),(3 3,3 5,5 5,5 3,3 3))
710 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 100, ST_BUFFER_STRATEGY('join_miter', 60)));
711 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 100, ST_BUFFER_STRATEGY('join_miter', 60)))
712 POLYGON((-100 0,-100 -100,0 -100,10 -100,110 -100,110 0,110 10,110 110,10 110,0 110,-100 110,-100 10,-100 0))
713 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))'), 0.5, ST_BUFFER_STRATEGY('join_miter', 1)));
714 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))'), 0.5, ST_BUFFER_STRATEGY('join_miter', 1)))
715 POLYGON((-0.5 0,-0.1913 -0.4619,0.3536 -0.3536,5.3536 4.6464,5.4619 5.1913,5 5.5,0 5.5,-0.3536 5.3536,-0.5 5,-0.5 0))
716 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))'), 1, ST_BUFFER_STRATEGY('join_miter', 5)));
717 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))'), 1, ST_BUFFER_STRATEGY('join_miter', 5)))
718 POLYGON((5 6.4142,0.7071 10.7071,-1 12.4142,-1 10,-1 0.4142,-2.4142 -1,-1 -1,12.4142 -1,11 0.4142,11 12.4142,9.2929 10.7071,5 6.4142))
719 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))'), 20, ST_BUFFER_STRATEGY('join_miter', 10)));
720 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))'), 20, ST_BUFFER_STRATEGY('join_miter', 10)))
721 POLYGON((-20 -48.2843,63.2843 35,15 35,10 35,-10 35,-10 30,-20 30,-20 10,-20 0,-20 -48.2843))
722 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4, 4 4)))'), 4, ST_BUFFER_STRATEGY('join_miter', 50)));
723 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4, 4 4)))'), 4, ST_BUFFER_STRATEGY('join_miter', 50)))
724 POLYGON((-4 0,-4 -4,0 -4,10 -4,14 -4,14 0,14 10,14 14,10 14,0 14,-4 14,-4 10,-4 0))
725 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 4, ST_BUFFER_STRATEGY('join_miter', 60)));
726 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 4, ST_BUFFER_STRATEGY('join_miter', 60)))
727 POLYGON((-4 0,-4 -4,0 -4,10 -4,14 -4,14 0,14 10,14 14,10 14,0 14,-4 14,-4 10,-4 0))
728 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10))'), 10, ST_BUFFER_STRATEGY('join_miter', 4)));
729 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10))'), 10, ST_BUFFER_STRATEGY('join_miter', 4)))
730 POLYGON((-7.0711 7.0711,-8.3147 5.5557,-9.2388 3.8268,-9.8079 1.9509,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,17.0711 2.9289,17.0711 2.9289,18.3147 4.4443,19.2388 6.1732,19.8079 8.0491,20 10,19.8079 11.9509,19.2388 13.8268,18.3147 15.5557,17.0711 17.0711,15.5557 18.3147,13.8268 19.2388,11.9509 19.8079,10 20,8.0491 19.8079,6.1732 19.2388,4.4443 18.3147,2.9289 17.0711,-7.0711 7.0711))
731 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,5 0),(0 0,0 5)))'), 10, ST_BUFFER_STRATEGY('join_miter', 10)));
732 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,5 0),(0 0,0 5)))'), 10, ST_BUFFER_STRATEGY('join_miter', 10)))
733 POLYGON((9.0953 9.0953,8.3147 10.5557,7.0711 12.0711,5.5557 13.3147,3.8268 14.2388,1.9509 14.8079,0 15,-1.9509 14.8079,-3.8268 14.2388,-5.5557 13.3147,-7.0711 12.0711,-8.3147 10.5557,-9.2388 8.8268,-9.8079 6.9509,-10 5,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,5 -10,6.9509 -9.8079,8.8268 -9.2388,10.5557 -8.3147,12.0711 -7.0711,13.3147 -5.5557,14.2388 -3.8268,14.8079 -1.9509,15 0,14.8079 1.9509,14.2388 3.8268,13.3147 5.5557,12.0711 7.0711,10.5557 8.3147,9.0953 9.0953))
734 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 5,5 5,5 0,0 0)))'), 10, ST_BUFFER_STRATEGY('join_miter', 4)));
735 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 5,5 5,5 0,0 0)))'), 10, ST_BUFFER_STRATEGY('join_miter', 4)))
736 POLYGON((-10 0,-10 -10,0 -10,5 -10,15 -10,15 0,15 5,15 15,5 15,0 15,-10 15,-10 5,-10 0))
737 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,2 2,4 0,0 0)),((3 3,3 5,5 5,5 3,3 3))))'), 10, ST_BUFFER_STRATEGY('join_miter', 4)));
738 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,2 2,4 0,0 0)),((3 3,3 5,5 5,5 3,3 3))))'), 10, ST_BUFFER_STRATEGY('join_miter', 4)))
739 POLYGON((0.8579 15,-7 15,-7 7.1421,-24.1421 -10,0 -10,4 -10,28.1421 -10,15 3.1421,15 15,5 15,3.1421 15,2 16.1421,0.8579 15))
740 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
741 'MULTILINESTRING((0 0,10 10)))'), 10, ST_BUFFER_STRATEGY('join_miter', 10)));
742 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
743 'MULTILINESTRING((0 0,10 10)))'), 10, ST_BUFFER_STRATEGY('join_miter', 10)))
744 POLYGON((-7.0711 7.0711,-8.3147 5.5557,-9.2388 3.8268,-9.8079 1.9509,-10 0,-9.8079 -1.9509,-9.2388 -3.8268,-8.3147 -5.5557,-7.0711 -7.0711,-5.5557 -8.3147,-3.8268 -9.2388,-1.9509 -9.8079,0 -10,1.9509 -9.8079,3.8268 -9.2388,5.5557 -8.3147,7.0711 -7.0711,17.0711 2.9289,17.0711 2.9289,18.3147 4.4443,19.2388 6.1732,19.8079 8.0491,20 10,19.8079 11.9509,19.2388 13.8268,18.3147 15.5557,17.0711 17.0711,15.5557 18.3147,13.8268 19.2388,11.9509 19.8079,10 20,8.0491 19.8079,6.1732 19.2388,4.4443 18.3147,2.9289 17.0711,-7.0711 7.0711))
745 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
746 'LINESTRING(0 0,-5 -5,-10 -10),'
747 'MULTILINESTRING((0 0,5 5,10 10)),'
748 'MULTILINESTRING((0 0,10 0),(0 0,-10 0)))'), 10, ST_BUFFER_STRATEGY('join_miter', 50)));
749 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
750 'LINESTRING(0 0,-5 -5,-10 -10),'
751 'MULTILINESTRI
752 POLYGON((-4.1422 10,-10 10,-11.9509 9.8079,-13.8268 9.2388,-15.5557 8.3147,-17.0711 7.0711,-18.3147 5.5557,-19.2388 3.8268,-19.8079 1.9509,-20 0,-19.8079 -1.9509,-19.2388 -3.8268,-18.6117 -5,-19.2388 -6.1732,-19.8079 -8.0491,-20 -10,-19.8079 -11.9509,-19.2388 -13.8268,-18.3147 -15.5557,-17.0711 -17.0711,-15.5557 -18.3147,-13.8268 -19.2388,-11.9509 -19.8079,-10 -20,-8.0491 -19.8079,-6.1732 -19.2388,-4.4443 -18.3147,-2.9289 -17.0711,4.1422 -10,10 -10,11.9509 -9.8079,13.8268 -9.2388,15.5557 -8.3147,17.0711 -7.0711,18.3147 -5.5557,19.2388 -3.8268,19.8079 -1.9509,20 0,19.8079 1.9509,19.2388 3.8268,18.6117 5,19.2388 6.1732,19.8079 8.0491,20 10,19.8079 11.9509,19.2388 13.8268,18.3147 15.5557,17.0711 17.0711,15.5557 18.3147,13.8268 19.2388,11.9509 19.8079,10 20,8.0491 19.8079,6.1732 19.2388,4.4443 18.3147,2.9289 17.0711,-4.1422 10))
753 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 5,5 5,5 0,0 0)),'
754 'MULTIPOLYGON(((0 0,2 2,4 0,0 0)),((3 3,3 5,5 5,5 3,3 3))))'), 10, ST_BUFFER_STRATEGY('join_miter', 10)));
755 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 5,5 5,5 0,0 0)),'
756 'MULTIPOLYGON(((0 0,2 2,4 0,0 0)),((3 3,3 5,5 5,5 3,3 3))))'), 10, ST_BUFFER_STRATEGY('join_miter', 10))
757 POLYGON((15 5,15 15,5 15,0 15,-10 15,-10 5,-10 0,-10 -10,0 -10,5 -10,15 -10,15 0,15 5))
758 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
759 'POLYGON((0 0,0 5,5 5,5 0,0 0)),'
760 'MULTILINESTRING((0 0,5 5,10 10)),'
761 'MULTIPOLYGON(((0 0,1 1,1 0,0 0)),((2 2,3 3,3 2,2 2))))'), 10, ST_BUFFER_STRATEGY('join_miter', 50)));
762 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,10 10),'
763 'POLYGON((0 0,0 5,5 5,5 0,0 0)),'
764 'MULTILINESTR
765 POLYGON((0.8579 15,-10 15,-10 5,-10 0,-10 -10,0 -10,5 -10,15 -10,15 0,15 0.8579,17.0711 2.9289,18.3147 4.4443,19.2388 6.1732,19.8079 8.0491,20 10,19.8079 11.9509,19.2388 13.8268,18.3147 15.5557,17.0711 17.0711,15.5557 18.3147,13.8268 19.2388,11.9509 19.8079,10 20,8.0491 19.8079,6.1732 19.2388,4.4443 18.3147,2.9289 17.0711,0.8579 15))
766 #####################################################################################
767 # ST_BUFFER() with more than one strategy values
768 #####################################################################################
769 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
770 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_round', 10)));
771 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
772 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_round', 10)))
773 POLYGON((1.4645 8.5355,8.5355 1.4645,13.5355 6.4645,13.5355 6.4645,6.4645 13.5355,1.4645 8.5355))
774 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
775 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_miter', 10)));
776 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
777 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_miter', 10)))
778 POLYGON((1.4645 8.5355,8.5355 1.4645,13.5355 6.4645,13.5355 6.4645,6.4645 13.5355,1.4645 8.5355))
779 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
780 ST_BUFFER_STRATEGY('end_round', 10), ST_BUFFER_STRATEGY('join_round', 10)));
781 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
782 ST_BUFFER_STRATEGY('end_round', 10), ST_BUFFER_STRATEGY('join_round', 10)))
783 POLYGON((1.4645 8.5355,0.0616 5.7822,0.545 2.73,2.73 0.545,5.7822 0.0616,8.5355 1.4645,13.5355 6.4645,13.5355 6.4645,14.9384 9.2178,14.455 12.27,12.27 14.455,9.2178 14.9384,6.4645 13.5355,1.4645 8.5355))
784 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
785 ST_BUFFER_STRATEGY('end_round', 10), ST_BUFFER_STRATEGY('join_miter', 10)));
786 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
787 ST_BUFFER_STRATEGY('end_round', 10), ST_BUFFER_STRATEGY('join_miter', 10)))
788 POLYGON((1.4645 8.5355,0.0616 5.7822,0.545 2.73,2.73 0.545,5.7822 0.0616,8.5355 1.4645,13.5355 6.4645,13.5355 6.4645,14.9384 9.2178,14.455 12.27,12.27 14.455,9.2178 14.9384,6.4645 13.5355,1.4645 8.5355))
789 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
790 ST_BUFFER_STRATEGY('join_round', 10), ST_BUFFER_STRATEGY('end_flat')));
791 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
792 ST_BUFFER_STRATEGY('join_round', 10), ST_BUFFER_STRATEGY('end_flat')))
793 POLYGON((1.4645 8.5355,8.5355 1.4645,13.5355 6.4645,13.5355 6.4645,6.4645 13.5355,1.4645 8.5355))
794 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
795 ST_BUFFER_STRATEGY('join_round', 10), ST_BUFFER_STRATEGY('end_round', 10)));
796 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
797 ST_BUFFER_STRATEGY('join_round', 10), ST_BUFFER_STRATEGY('end_round', 10)))
798 POLYGON((1.4645 8.5355,0.0616 5.7822,0.545 2.73,2.73 0.545,5.7822 0.0616,8.5355 1.4645,13.5355 6.4645,13.5355 6.4645,14.9384 9.2178,14.455 12.27,12.27 14.455,9.2178 14.9384,6.4645 13.5355,1.4645 8.5355))
799 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
800 ST_BUFFER_STRATEGY('join_miter', 10), ST_BUFFER_STRATEGY('end_flat')));
801 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
802 ST_BUFFER_STRATEGY('join_miter', 10), ST_BUFFER_STRATEGY('end_flat')))
803 POLYGON((1.4645 8.5355,8.5355 1.4645,13.5355 6.4645,13.5355 6.4645,6.4645 13.5355,1.4645 8.5355))
804 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
805 ST_BUFFER_STRATEGY('join_miter', 10), ST_BUFFER_STRATEGY('end_round', 10)));
806 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
807 ST_BUFFER_STRATEGY('join_miter', 10), ST_BUFFER_STRATEGY('end_round', 10)))
808 POLYGON((1.4645 8.5355,0.0616 5.7822,0.545 2.73,2.73 0.545,5.7822 0.0616,8.5355 1.4645,13.5355 6.4645,13.5355 6.4645,14.9384 9.2178,14.455 12.27,12.27 14.455,9.2178 14.9384,6.4645 13.5355,1.4645 8.5355))
809 #####################################################################################
810 # Additional test cases
811 #####################################################################################
812 # Strategy names with both upper and lower case letters should work
813 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
814 ST_BUFFER_STRATEGY('End_Round', 18), ST_BUFFER_STRATEGY('JOIN_MITER', 10)));
815 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
816 ST_BUFFER_STRATEGY('End_Round', 18), ST_BUFFER_STRATEGY('JOIN_MITER', 10)))
817 POLYGON((3.1542 5.4937,3.2167 5.3784,3.4765 5.148,3.7995 5.0203,4.1467 5.0108,4.4762 5.1206,4.7482 5.3365,4.93 5.6324,4.9996 5.9727,4.9487 6.3162,3.9487 9.3162,2.8627 12.5741,2.0299 9.2425,0.0299 1.2425,0.0054 0.8961,0.1009 0.5622,0.3049 0.2811,0.5927 0.0867,0.9296 0.0025,1.275 0.0386,1.5873 0.1906,1.8287 0.4403,1.9701 0.7575,3.1542 5.4937))
818 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
819 ST_BUFFER_STRATEGY('END_flat'), ST_BUFFER_STRATEGY('Join_Round', 30)));
820 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
821 ST_BUFFER_STRATEGY('END_flat'), ST_BUFFER_STRATEGY('Join_Round', 30)))
822 POLYGON((3.2154 5.7385,4.9487 6.3162,3.9487 9.3162,3.8679 9.4967,3.7532 9.6578,3.609 9.7931,3.4411 9.8975,3.2558 9.9667,3.0606 9.9982,2.863 9.9906,2.6708 9.9443,2.4914 9.861,2.3319 9.7441,2.1986 9.5981,2.0965 9.4287,2.0299 9.2425,0.0299 1.2425,1.9701 0.7575,3.2154 5.7385))
823 # The ST_BUFFER_STRATEGY() can be used in arbitrary contexts
824 SET @buf_strat = ST_BUFFER_STRATEGY('point_circle', 10);
825 CREATE TABLE t0(geom GEOMETRY);
826 INSERT INTO t0 VALUES
827 (ST_GEOMFROMTEXT('POINT(0 0)')),
828 (ST_GEOMFROMTEXT('point(1 1)'));
829 SELECT ST_ASTEXT(ST_BUFFER(geom, 1, @buf_strat)) FROM t0;
830 ST_ASTEXT(ST_BUFFER(geom, 1, @buf_strat))
831 POLYGON((1 0,0.809 0.5878,0.309 0.9511,-0.309 0.9511,-0.809 0.5878,-1 -0,-0.809 -0.5878,-0.309 -0.9511,0.309 -0.9511,0.809 -0.5878,1 0))
832 POLYGON((2 1,1.809 1.5878,1.309 1.9511,0.691 1.9511,0.191 1.5878,0 1,0.191 0.4122,0.691 0.0489,1.309 0.0489,1.809 0.4122,2 1))
833 DROP TABLE t0;
834 CREATE TABLE t1(geom GEOMETRY, strategy binary(12));
835 INSERT INTO t1 VALUES
836 (ST_GEOMFROMTEXT('POINT(0 0)'), ST_BUFFER_STRATEGY('point_circle', 10)),
837 (ST_GEOMFROMTEXT('POINT(1 1)'), ST_BUFFER_STRATEGY('point_square'));
838 SELECT ST_ASTEXT(ST_BUFFER(geom, 1, strategy)) FROM t1;
839 ST_ASTEXT(ST_BUFFER(geom, 1, strategy))
840 POLYGON((1 0,0.809 0.5878,0.309 0.9511,-0.309 0.9511,-0.809 0.5878,-1 -0,-0.809 -0.5878,-0.309 -0.9511,0.309 -0.9511,0.809 -0.5878,1 0))
841 POLYGON((0 0,2 0,2 2,0 2,0 0))
842 DROP TABLE t1;
843 SELECT HEX(ST_BUFFER_STRATEGY('join_miter', 10));
844 HEX(ST_BUFFER_STRATEGY('join_miter', 10))
845 040000000000000000002440
846 SET names gb18030;
847 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
848 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_miter', 10)));
849 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
850 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_miter', 10)))
851 POLYGON((3.2154 5.7385,4.9487 6.3162,3.9487 9.3162,2.8627 12.5741,2.0299 9.2425,0.0299 1.2425,1.9701 0.7575,3.2154 5.7385))
852 SET names default;
853 #####################################################################################
854 # Invalid function calls
855 #####################################################################################
856 SELECT ST_ASTEXT(ST_BUFFER(NULL, 1));
857 ST_ASTEXT(ST_BUFFER(NULL, 1))
858 NULL
859 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), NULL));
860 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), NULL))
861 NULL
862 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, NULL));
863 ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, NULL))
864 NULL
865 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT()'), 1));
866 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
867 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING()'), 1));
868 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
869 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON(())'), 1));
870 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
871 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT()'), 1));
872 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
873 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING(())'), 1));
874 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
875 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON((()))'), 1));
876 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
877 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(a 0)'), 1));
878 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
879 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(! 0)'), 1));
880 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
881 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT('!' 0)'), 1));
882 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!' 0)'), 1))' at line 1
883 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(12,34 0)'), 1));
884 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
885 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'), 1));
886 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
887 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'), 1));
888 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
889 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'), 1));
890 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!' 0,10 10)'), 1))' at line 1
891 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'), 1));
892 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
893 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'), 1));
894 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
895 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'), 1));
896 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
897 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'), 1));
898 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!' 0,10 10,10 0,0 0))'), 1))' at line 1
899 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'), 1));
900 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
901 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0))'), 1));
902 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
903 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,5 5))'), 1));
904 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
905 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,5 5,10 10))'), 1));
906 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
907 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,10 10),(0 0))'), 1));
908 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
909 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5)),((10 10)))'), 1));
910 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
911 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5)),((1 1,1 1,1 1,1 1)))'), 1));
912 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
913 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,10 10)),((10 10))'), 1));
914 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
915 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), -1));
916 ERROR HY000: Incorrect arguments to st_buffer
917 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), -100));
918 ERROR HY000: Incorrect arguments to st_buffer
919 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), -10));
920 ERROR HY000: Incorrect arguments to st_buffer
921 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,1 1,2 2,3 3)'), -20));
922 ERROR HY000: Incorrect arguments to st_buffer
923 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 2,3 3)'), -20));
924 ERROR HY000: Incorrect arguments to st_buffer
925 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 0,3 1,4 0)'), -1));
926 ERROR HY000: Incorrect arguments to st_buffer
927 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1),(2 2,3 3))'), -5));
928 ERROR HY000: Incorrect arguments to st_buffer
929 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10),(10 0,0 10))'), -2));
930 ERROR HY000: Incorrect arguments to st_buffer
931 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))'), -2));
932 ERROR HY000: Incorrect arguments to st_buffer
933 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10))'), -2));
934 ERROR HY000: Incorrect arguments to st_buffer
935 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), MULTIPOINT(0 0,2 2,4 4))'), -2));
936 ERROR HY000: Incorrect arguments to st_buffer
937 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,2 2), MULTILINESTRING((4 4,5 5),(6 6,7 7)))'), -2));
938 ERROR HY000: Incorrect arguments to st_buffer
939 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
940 'POINT(0 0),'
941 'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
942 'MULTIPOINT(0 0,10 10,20 20,30 30,40 40),'
943 'MULTILINESTRING((0 0,10 0),(0 0,0 10),(0 0,-10 0),(0 0,0 -10)))'), -2));
944 ERROR HY000: Incorrect arguments to st_buffer
945 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'), 1, ST_BUFFER_STRATEGY('point_circle', 10)));
946 ERROR HY000: Incorrect arguments to st_buffer
947 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0))'), 100, ST_BUFFER_STRATEGY('point_circle', 10)));
948 ERROR HY000: Incorrect arguments to st_buffer
949 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 1, ST_BUFFER_STRATEGY('point_circle', 10)));
950 ERROR HY000: Incorrect arguments to st_buffer
951 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 1,2 0,0 0)),((3 3,4 4,5 3,3 3)))'), 1, ST_BUFFER_STRATEGY('point_circle', 10)));
952 ERROR HY000: Incorrect arguments to st_buffer
953 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'), 1, ST_BUFFER_STRATEGY('point_square')));
954 ERROR HY000: Incorrect arguments to st_buffer
955 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(0 0,-10 0))'), 1, ST_BUFFER_STRATEGY('point_square')));
956 ERROR HY000: Incorrect arguments to st_buffer
957 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((5 5,5 10,10 10,10 5,5 5))'), 5, ST_BUFFER_STRATEGY('point_square')));
958 ERROR HY000: Incorrect arguments to st_buffer
959 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 1,2 0,0 0)),((3 3,4 4,5 3,3 3)))'), 1, ST_BUFFER_STRATEGY('point_square')));
960 ERROR HY000: Incorrect arguments to st_buffer
961 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('end_round', 10)));
962 ERROR HY000: Incorrect arguments to st_buffer
963 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0,-10 0)'), 1, ST_BUFFER_STRATEGY('end_round', 10)));
964 ERROR HY000: Incorrect arguments to st_buffer
965 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 1, ST_BUFFER_STRATEGY('end_round', 10)));
966 ERROR HY000: Incorrect arguments to st_buffer
967 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 1,2 0,0 0)),((3 3,4 4,5 3,3 3)))'), 1, ST_BUFFER_STRATEGY('end_round', 10)));
968 ERROR HY000: Incorrect arguments to st_buffer
969 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('end_flat')));
970 ERROR HY000: Incorrect arguments to st_buffer
971 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0,-10 0)'), 1, ST_BUFFER_STRATEGY('end_flat')));
972 ERROR HY000: Incorrect arguments to st_buffer
973 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 1, ST_BUFFER_STRATEGY('end_flat')));
974 ERROR HY000: Incorrect arguments to st_buffer
975 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 1,2 0,0 0)),((3 3,4 4,5 3,3 3)))'), 1, ST_BUFFER_STRATEGY('end_flat')));
976 ERROR HY000: Incorrect arguments to st_buffer
977 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('join_round', 10)));
978 ERROR HY000: Incorrect arguments to st_buffer
979 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0,-10 0)'), 1, ST_BUFFER_STRATEGY('join_round', 10)));
980 ERROR HY000: Incorrect arguments to st_buffer
981 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('join_miter', 10)));
982 ERROR HY000: Incorrect arguments to st_buffer
983 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0,-10 0)'), 1, ST_BUFFER_STRATEGY('join_miter', 10)));
984 ERROR HY000: Incorrect arguments to st_buffer
985 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
986 ST_BUFFER_STRATEGY('point_square'), ST_BUFFER_STRATEGY('end_round', 30)));
987 ERROR HY000: Incorrect arguments to st_buffer
988 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
989 ST_BUFFER_STRATEGY('point_square'), ST_BUFFER_STRATEGY('end_flat')));
990 ERROR HY000: Incorrect arguments to st_buffer
991 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
992 ST_BUFFER_STRATEGY('point_square'), ST_BUFFER_STRATEGY('join_round', 30)));
993 ERROR HY000: Incorrect arguments to st_buffer
994 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
995 ST_BUFFER_STRATEGY('point_square'), ST_BUFFER_STRATEGY('join_miter', 30)));
996 ERROR HY000: Incorrect arguments to st_buffer
997 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
998 ST_BUFFER_STRATEGY('end_round', 10), ST_BUFFER_STRATEGY('join_round', 30)));
999 ERROR HY000: Incorrect arguments to st_buffer
1000 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
1001 ST_BUFFER_STRATEGY('end_round', 10), ST_BUFFER_STRATEGY('join_miter', 30)));
1002 ERROR HY000: Incorrect arguments to st_buffer
1003 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
1004 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_round', 30)));
1005 ERROR HY000: Incorrect arguments to st_buffer
1006 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
1007 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_miter', 30)));
1008 ERROR HY000: Incorrect arguments to st_buffer
1009 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
1010 ST_BUFFER_STRATEGY('point_square'), ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_miter', 10)));
1011 ERROR HY000: Incorrect arguments to st_buffer
1012 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
1013 ST_BUFFER_STRATEGY('point_square'), ST_BUFFER_STRATEGY('end_round', 20), ST_BUFFER_STRATEGY('join_miter', 10)));
1014 ERROR HY000: Incorrect arguments to st_buffer
1015 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1016 ST_BUFFER_STRATEGY('end_round', 30), ST_BUFFER_STRATEGY('join_round',60)));
1017 ERROR HY000: Incorrect arguments to st_buffer
1018 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1019 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_round',60)));
1020 ERROR HY000: Incorrect arguments to st_buffer
1021 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1022 ST_BUFFER_STRATEGY('point_circle', 30), ST_BUFFER_STRATEGY('join_round',60)));
1023 ERROR HY000: Incorrect arguments to st_buffer
1024 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1025 ST_BUFFER_STRATEGY('point_square'), ST_BUFFER_STRATEGY('join_round',60)));
1026 ERROR HY000: Incorrect arguments to st_buffer
1027 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1028 ST_BUFFER_STRATEGY('end_round', 30), ST_BUFFER_STRATEGY('point_circle',60)));
1029 ERROR HY000: Incorrect arguments to st_buffer
1030 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1031 ST_BUFFER_STRATEGY('end_round', 30), ST_BUFFER_STRATEGY('point_square')));
1032 ERROR HY000: Incorrect arguments to st_buffer
1033 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1034 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('point_circle',60)));
1035 ERROR HY000: Incorrect arguments to st_buffer
1036 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1037 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('point_square')));
1038 ERROR HY000: Incorrect arguments to st_buffer
1039 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1040 ST_BUFFER_STRATEGY('join_round', 20), ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('point_circle',60)));
1041 ERROR HY000: Incorrect arguments to st_buffer
1042 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1043 ST_BUFFER_STRATEGY('join_round', 20), ST_BUFFER_STRATEGY('end_round', 30), ST_BUFFER_STRATEGY('point_square')));
1044 ERROR HY000: Incorrect arguments to st_buffer
1045 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
1046 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('point_circle', 20)));
1047 ERROR HY000: Incorrect arguments to st_buffer
1048 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
1049 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('point_square')));
1050 ERROR HY000: Incorrect arguments to st_buffer
1051 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
1052 ST_BUFFER_STRATEGY('join_miter',10), ST_BUFFER_STRATEGY('point_circle', 20)));
1053 ERROR HY000: Incorrect arguments to st_buffer
1054 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
1055 ST_BUFFER_STRATEGY('join_miter',10), ST_BUFFER_STRATEGY('point_square')));
1056 ERROR HY000: Incorrect arguments to st_buffer
1057 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
1058 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_miter',10), ST_BUFFER_STRATEGY('point_circle', 20)));
1059 ERROR HY000: Incorrect arguments to st_buffer
1060 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1, 3 9, 4 6)'), 1,
1061 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('join_miter',10), ST_BUFFER_STRATEGY('point_square')));
1062 ERROR HY000: Incorrect arguments to st_buffer
1063 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(1 1)'), 1,
1064 ST_BUFFER_STRATEGY('point_square', 20)));
1065 ERROR HY000: Incorrect arguments to st_buffer_strategy
1066 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)'), 1,
1067 ST_BUFFER_STRATEGY('end_flat', 20)));
1068 ERROR HY000: Incorrect arguments to st_buffer_strategy
1069 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1,
1070 ST_BUFFER_STRATEGY('point_circle')));
1071 ERROR HY000: Incorrect arguments to st_buffer_strategy
1072 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1)'), 1,
1073 ST_BUFFER_STRATEGY('end_round')));
1074 ERROR HY000: Incorrect arguments to st_buffer_strategy
1075 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1076 ST_BUFFER_STRATEGY('join_round')));
1077 ERROR HY000: Incorrect arguments to st_buffer_strategy
1078 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))'), 1,
1079 ST_BUFFER_STRATEGY('join_miter')));
1080 ERROR HY000: Incorrect arguments to st_buffer_strategy
1081 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, 1));
1082 ERROR HY000: Incorrect arguments to st_buffer
1083 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_GEOMFROMTEXT('POINT(1 1)')));
1084 ERROR HY000: Incorrect arguments to st_buffer
1085 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('point_square'), ST_GEOMFROMTEXT('POINT(1 1)')));
1086 ERROR HY000: Incorrect arguments to st_buffer
1087 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('point_round')));
1088 ERROR HY000: Incorrect arguments to st_buffer_strategy
1089 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('point_flat')));
1090 ERROR HY000: Incorrect arguments to st_buffer_strategy
1091 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('end_circle')));
1092 ERROR HY000: Incorrect arguments to st_buffer_strategy
1093 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('end_miter')));
1094 ERROR HY000: Incorrect arguments to st_buffer_strategy
1095 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('join_square')));
1096 ERROR HY000: Incorrect arguments to st_buffer_strategy
1097 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('join_flat')));
1098 ERROR HY000: Incorrect arguments to st_buffer_strategy
1099 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('joint_round')));
1100 ERROR HY000: Incorrect arguments to st_buffer_strategy
1101 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('join_round2', 16)));
1102 ERROR HY000: Incorrect arguments to st_buffer_strategy
1103 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('join_rou', 32)));
1104 ERROR HY000: Incorrect arguments to st_buffer_strategy
1105 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('point_circle', 0)));
1106 ERROR HY000: Incorrect arguments to st_buffer_strategy
1107 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('point_circle', -1)));
1108 ERROR HY000: Incorrect arguments to st_buffer_strategy
1109 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 1, ST_BUFFER_STRATEGY('point_circle', -1000)));
1110 ERROR HY000: Incorrect arguments to st_buffer_strategy
1111 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1, ST_BUFFER_STRATEGY('end_round', 0)));
1112 ERROR HY000: Incorrect arguments to st_buffer_strategy
1113 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1, ST_BUFFER_STRATEGY('end_round', -1)));
1114 ERROR HY000: Incorrect arguments to st_buffer_strategy
1115 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1, ST_BUFFER_STRATEGY('end_round', -1000)));
1116 ERROR HY000: Incorrect arguments to st_buffer_strategy
1117 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1, ST_BUFFER_STRATEGY('join_round', 0)));
1118 ERROR HY000: Incorrect arguments to st_buffer_strategy
1119 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1, ST_BUFFER_STRATEGY('join_round', -1)));
1120 ERROR HY000: Incorrect arguments to st_buffer_strategy
1121 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1, ST_BUFFER_STRATEGY('join_round', -1000)));
1122 ERROR HY000: Incorrect arguments to st_buffer_strategy
1123 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1, ST_BUFFER_STRATEGY('join_miter', 0)));
1124 ERROR HY000: Incorrect arguments to st_buffer_strategy
1125 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1, ST_BUFFER_STRATEGY('join_miter', -1)));
1126 ERROR HY000: Incorrect arguments to st_buffer_strategy
1127 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1, ST_BUFFER_STRATEGY('join_miter', -1000)));
1128 ERROR HY000: Incorrect arguments to st_buffer_strategy
1129 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 5,
1130 ST_BUFFER_STRATEGY('point_square'), ST_BUFFER_STRATEGY('point_circle', 10)));
1131 ERROR HY000: Incorrect arguments to st_buffer
1132 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)'), 5,
1133 ST_BUFFER_STRATEGY('point_cicle', 10), ST_BUFFER_STRATEGY('point_square')));
1134 ERROR HY000: Incorrect arguments to st_buffer_strategy
1135 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
1136 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('end_round', 10)));
1137 ERROR HY000: Incorrect arguments to st_buffer
1138 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), 5,
1139 ST_BUFFER_STRATEGY('join_miter', 10), ST_BUFFER_STRATEGY('join_round', 10)));
1140 ERROR HY000: Incorrect arguments to st_buffer
1141 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((5 5,5 10,10 10,10 5,5 5))'), 5,
1142 ST_BUFFER_STRATEGY('join_miter', 10), ST_BUFFER_STRATEGY('join_round', 10)));
1143 ERROR HY000: Incorrect arguments to st_buffer
1144 SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,1 1))'), 5,
1145 ST_BUFFER_STRATEGY('end_flat'), ST_BUFFER_STRATEGY('end_round', 10)));
1146 ERROR HY000: Incorrect arguments to st_buffer
1147 SELECT ST_BUFFER_STRATEGY('end_round', 10, 100);
1148 ERROR 42000: Incorrect parameter count in the call to native function 'ST_BUFFER_STRATEGY'
1149 SELECT ST_BUFFER_STRATEGY();
1150 ERROR 42000: Incorrect parameter count in the call to native function 'ST_BUFFER_STRATEGY'
1151 SELECT ST_BUFFER();
1152 ERROR 42000: Incorrect parameter count in the call to native function 'ST_BUFFER'
1153 SELECT ST_BUFFER(ST_GEOMFROMTEXT('point(0 0)'));
1154 ERROR 42000: Incorrect parameter count in the call to native function 'ST_BUFFER'
1155 set session max_points_in_geometry=1024*1024;
1156 do
1157 st_buffer(point(-5,0),8772,st_buffer_strategy('point_circle',8*1024));
1158 # Clean up
1159 DROP TABLE gis_geometrycollection;
1160 #
1161 # Bug #21841051 PREPARE STATEMENT RETURNS DIFFERENT NUMBER OF ROWS WHEN
1162 # EXECUTED SECOND TIME
1163 #
1164 CREATE TABLE t1 (id INT, a VARCHAR(20));
1165 INSERT INTO t1 VALUES (2, 'point_square');
1166 CREATE TABLE t2 (id INT);
1167 INSERT INTO t2 VALUES (1), (3);
1168 PREPARE stmt FROM 'SELECT COUNT(*) FROM (SELECT ST_Buffer_Strategy(a) AS a1
1169 FROM t1 RIGHT OUTER JOIN t2 ON (t1.id > t2.id) GROUP BY a1) AS a2';
1170 EXECUTE stmt;
1171 COUNT(*)
1172 2
1173 EXECUTE stmt;
1174 COUNT(*)
1175 2
1176 DEALLOCATE PREPARE stmt;
1177 DROP TABLE t1, t2;
1178 #
1179 # WL#8579 Spatial Reference Systems
1180 #
1181 # SRID 0 (should pass)
1182 DO ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)', 0), 1));
1183 # Projected SRS (should pass)
1184 DO ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POINT(0 0)', 2000), 1));
1185 #
1186 # Bug #24947868 BOOST::GEOMETRY::BUFFER RETURNS INVALID MULTIPOLYGON
1187 #
1188 SELECT ST_ISVALID(
1189 ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)'), 5)
1190 ) AS result;
1191 result
1192 1
1193 SELECT ST_ISVALID(
1194 ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)'),
1195 5,
1196 ST_BUFFER_STRATEGY('point_circle', 20))
1197 ) AS result;
1198 result
1199 1
1200 SELECT ST_ISVALID(
1201 ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)'),
1202 5,
1203 ST_BUFFER_STRATEGY('point_square'))
1204 ) AS result;
1205 result
1206 1
1207 #
1208 # Bug #25662426 BG::BUFFER(LS, MPY) THROWS
1209 # BG::INCONSISTENT_TURNS_EXCEPTION
1210 #
1211 DO ST_BUFFER(
1212 ST_GEOMFROMTEXT(
1213 'LINESTRING(170 4756,168 4756,168 4759,168 4764,171 4764,171 3764)'
1214 ),
1215 10
1216 );
1217 #
1218 # WL#11096 Don't do Cartesian computations on geographic geometries
1219 #
1220 # Assume SRID 10 is not defined.
1221 DO ST_BUFFER(x'0A000000010100000000000000000000000000000000000000', 10);
1222 ERROR SR001: There's no spatial reference system with SRID 10.