Skip to content

Instantly share code, notes, and snippets.

@grooverdan
Created July 21, 2017 04:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save grooverdan/3ba0aa21bf65fa59e12c67ebccfd2f18 to your computer and use it in GitHub Desktop.
Save grooverdan/3ba0aa21bf65fa59e12c67ebccfd2f18 to your computer and use it in GitHub Desktop.
gis.gis_bugs_crashes w60 [ fail ]
Test ended at 2017-07-21 03:30:31
CURRENT_TEST: gis.gis_bugs_crashes
--- /source/mysql-test/suite/gis/r/gis_bugs_crashes.result 2017-07-21 06:23:33.762428753 +0300
+++ /build/build/mysql-test/var/60/log/gis_bugs_crashes.reject 2017-07-21 06:30:31.120689033 +0300
@@ -1424,20 +1424,20 @@
POLYGON((0 15,5 0,25 0,30 15,15 25,0 15))
SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_of_elems), 1));
ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_of_elems), 1))
-POLYGON((15.000000795499957 3.8819664090000843,24.552786404500043 -0.8944271909999159,24.602840142211626 -0.9138847758624057,24.651848488083576 -0.9374382778350313,24.68956904131013 -0.9476016321993868,24.725680292556177 -0.961638548576301,24.77802155092662 -0.9714341087341194,24.83005135234607 -0.9854529198092623,24.869480168185856 -0.988549181756253,24.9080134293311 -0.9957602476583283,24.960800670876974 -0.9957203886880442,25.014042950796863 -0.9999013929047789,25.053829737719678 -0.9956498621464229,25.09351179301379 -0.995618172075694,25.144929938646055 -0.9859150899698634,25.197556222938477 -0.9802915580470347,25.236357263667767 -0.9686589396187312,25.27579244740165 -0.9612172106013335,25.32407326559291 -0.9423615320937491,25.374340400864735 -0.9272913588945115,25.41077408056943 -0.9085040201644157,25.448583176584915 -0.8937410887303918,25.49215514110493 -0.8665391798604043,25.53837392083365 -0.8427060705644654,25.571110658225003 -0.8172508019757897,25.605938309783095 -0.7955116370847162,25.64340270244788 -0.7610383156635809,25.684069527764475 -0.729416808953626,25.711870449381554 -0.6980408363256528,25.742443309873515 -0.6699088980033491,25.772634026298544 -0.6294633858229352,25.806464586457874 -0.5912823951288695,25.828269533086072 -0.5549258268736386,25.853401085789624 -0.5212548194243296,25.875399599279746 -0.4763433154068152,25.901390117221936 -0.43300791745027806,25.916302203262003 -0.39283300545914124,25.934993617842228 -0.35466453811214743,25.948194154856484 -0.3069123404970965,25.9656127982688 -0.2599844684197425,25.97297277659234 -0.217260979762059,25.98441333449074 -0.17587036952489246,25.988524918699426 -0.12698329989581847,25.99694509804366 -0.07810551508514645,25.996321582660034 -0.03427714921997431,25.999959719934076 0.00897543922952386,25.995018670951374 0.05730758558650476,25.994319786195412 0.1064338422697801,25.98555754526659 0.1498720543473131,25.981097828286487 0.19351240614374826,25.967445939436363 0.23965910557190329,25.957826285221152 0.2873478855663454,23.177098224213704 9.55643874862649,30.52999894000318 14.152001695994912,30.6765730659824 14.263624493626264,30.800181850636 14.400242544095745,30.89662956393401 14.557218535754364,30.962642421022533 14.729224134665076,30.995979706343796 14.91042084756305,30.995509831641094 15.094658201472038,30.961248746164355 15.27568251304255,30.894359395294828 15.447349161224063,30.79711224596506 15.603831157967637,30.672808218784507 15.739816937313561,30.52566664283362 15.850690649185726,30.360682036346724 15.932688838068078,30.183454574666214 15.983028188321189,30 16,19.677033490885258 15.999998676354103,15.92847669088526 25.371390676354103,15.8453224450135 25.5342564589749,15.733900708082256 25.679256763438072,15.597937410913687 25.801542795257895,15.441979151447788 25.897025322767142,15.271241156999427 25.962511420581393,15.091432887621451 25.995811240678275,14.90856711237855 25.995811240678275,14.728758843000575 25.962511420581393,14.558020848552212 25.897025322767142,14.402062589086313 25.801542795257895,14.266099291917746 25.679256763438072,14.154677554986502 25.5342564589749,14.07152330911474 25.371390676354103,10.32296650911474 15.999998676354103,0 16,-0.18473093896596693 15.982789133125083,-0.36310311873549117 15.931748960377504,-0.528976659628168 15.848636372994125,-0.6766419067832469 15.736312250329119,-0.8010159663790529 15.598642983426544,-0.8978176676507933 15.44036738713725,-0.963714928210761 15.266933581895811,-0.9964394501011175 15.084311459969465,-0.9948647985422624 14.89878719141599,-0.9590451757709032 14.716746843211665,-0.8902135553050953 14.544456559754108,-0.7907392408580822 14.38784687130818,-0.6640463107967063 14.25230855487221,-0.5144957554275266 14.142507074287456,7.6262013994373214 9.258085902160555,4.071523309114741 0.3713906763541037,4.018902171713515 0.19351240614374693,4.000040280065924 0.008975439229522573,4.01558666550926 -0.17587036952489368,4.065006382157773 -0.35466453811214854,4.146598914210377 -0.5212548194243305,4.257556690126487 -0.6699088980033499,4.394061690216905 -0.7955116370847167,4.551416823415085 -0.8937410887303923,4.724207552598352 -0.9612172106013338,4.906488206986212 -0.9956181720756941,5.091986570668903 -0.995760247658328,5.2743197074438255 -0.9616385485763005,5.447213595499958 -0.8944271909999159,15.000000795499957 3.8819664090000843))
+POLYGON((15.000000795499957 3.8819664090000843,24.552786404500043 -0.8944271909999159,24.602840142211626 -0.9138847758624057,24.651848488083576 -0.9374382778350313,24.68956904131013 -0.9476016321993868,24.725680292556177 -0.961638548576301,24.77802155092662 -0.9714341087341194,24.83005135234607 -0.9854529198092623,24.869480168185856 -0.988549181756253,24.9080134293311 -0.9957602476583283,24.960800670876974 -0.9957203886880442,25.014042950796863 -0.9999013929047789,25.053829737719678 -0.9956498621464229,25.09351179301379 -0.995618172075694,25.144929938646055 -0.9859150899698634,25.197556222938477 -0.9802915580470347,25.236357263667767 -0.9686589396187312,25.27579244740165 -0.9612172106013335,25.32407326559291 -0.9423615320937491,25.374340400864735 -0.9272913588945115,25.41077408056943 -0.9085040201644157,25.448583176584915 -0.8937410887303918,25.49215514110493 -0.8665391798604043,25.53837392083365 -0.8427060705644656,25.571110658225003 -0.8172508019757899,25.605938309783095 -0.7955116370847162,25.643402702447876 -0.7610383156635812,25.68406952776447 -0.7294168089536263,25.71187044938155 -0.6980408363256531,25.742443309873515 -0.6699088980033491,25.77263402629854 -0.6294633858229353,25.80646458645787 -0.5912823951288696,25.82826953308607 -0.5549258268736387,25.853401085789624 -0.5212548194243296,25.875399599279746 -0.4763433154068152,25.901390117221936 -0.43300791745027806,25.916302203262003 -0.3928330054591413,25.934993617842228 -0.35466453811214743,25.948194154856484 -0.3069123404970965,25.9656127982688 -0.25998446841974254,25.97297277659234 -0.21726097976205905,25.98441333449074 -0.17587036952489246,25.988524918699426 -0.12698329989581852,25.99694509804366 -0.0781055150851465,25.996321582660034 -0.034277149219974365,25.999959719934076 0.00897543922952386,25.995018670951374 0.05730758558650471,25.994319786195412 0.10643384226978005,25.98555754526659 0.14987205434731304,25.981097828286487 0.19351240614374826,25.967445939436363 0.23965910557190329,25.957826285221152 0.2873478855663454,23.177098224213704 9.55643874862649,30.52999894000318 14.152001695994912,30.6765730659824 14.263624493626264,30.800181850636 14.400242544095745,30.89662956393401 14.557218535754364,30.962642421022533 14.729224134665076,30.995979706343796 14.91042084756305,30.995509831641094 15.094658201472038,30.961248746164355 15.27568251304255,30.894359395294828 15.447349161224063,30.79711224596506 15.603831157967637,30.672808218784507 15.739816937313561,30.52566664283362 15.850690649185726,30.360682036346724 15.932688838068078,30.183454574666214 15.983028188321189,30 16,19.677033490885258 15.999998676354103,15.92847669088526 25.371390676354103,15.8453224450135 25.5342564589749,15.733900708082256 25.679256763438072,15.597937410913687 25.801542795257895,15.441979151447788 25.897025322767142,15.271241156999427 25.962511420581393,15.091432887621451 25.995811240678275,14.90856711237855 25.995811240678275,14.728758843000575 25.962511420581393,14.558020848552212 25.897025322767142,14.402062589086313 25.801542795257895,14.266099291917746 25.679256763438072,14.154677554986502 25.5342564589749,14.07152330911474 25.371390676354103,10.32296650911474 15.999998676354103,0 16,-0.18473093896596693 15.982789133125083,-0.36310311873549117 15.931748960377504,-0.528976659628168 15.848636372994125,-0.6766419067832469 15.736312250329119,-0.8010159663790529 15.598642983426544,-0.8978176676507933 15.44036738713725,-0.963714928210761 15.266933581895811,-0.9964394501011175 15.084311459969465,-0.9948647985422624 14.89878719141599,-0.9590451757709032 14.716746843211665,-0.8902135553050953 14.544456559754108,-0.7907392408580822 14.38784687130818,-0.6640463107967063 14.25230855487221,-0.5144957554275266 14.142507074287456,7.6262013994373214 9.258085902160555,4.071523309114741 0.3713906763541037,4.018902171713515 0.19351240614374693,4.000040280065924 0.008975439229522573,4.01558666550926 -0.17587036952489368,4.065006382157773 -0.35466453811214854,4.146598914210377 -0.5212548194243305,4.257556690126487 -0.6699088980033499,4.394061690216905 -0.7955116370847167,4.551416823415085 -0.8937410887303923,4.724207552598352 -0.9612172106013338,4.906488206986212 -0.9956181720756941,5.091986570668903 -0.995760247658328,5.2743197074438255 -0.9616385485763005,5.447213595499958 -0.8944271909999159,15.000000795499957 3.8819664090000843))
SET @buf = ST_BUFFER(ST_GEOMFROMTEXT(@star_of_elems), 1);
SELECT st_area(@buf);
st_area(@buf)
373.46939430619625
SELECT ST_ASTEXT(ST_BUFFER(@buf, 1));
ST_ASTEXT(ST_BUFFER(@buf, 1))
-POLYGON((15.000000290155196 2.7639326356812854,24.10557274941397 -1.7888543522067706,24.190465624402687 -1.826480651006177,24.20450880763201 -1.8319397124452754,24.2186765917243 -1.838749604849458,24.327464375084784 -1.8791490054483488,24.327265107088873 -1.8796616405935884,24.36337635833492 -1.8936985569705027,24.377432904452505 -1.8977094869125704,24.391688354132036 -1.9030037622545586,24.42940890735859 -1.9131671166189141,24.429567186350532 -1.9125796756101496,24.541726040690342 -1.9445733547666615,24.55563178619066 -1.9471757867835535,24.569891218394535 -1.9510184042287908,24.685629868698165 -1.9709769806412392,24.68553468103452 -1.9714856282046784,24.724067942179765 -1.9786966941067539,24.737663156331493 -1.979951916315987,24.751764468567117 -1.9823837919504457,24.7911932844069 -1.9854800538974362,24.791238498823798 -1.9849042786731075,24.908768516313366 -1.9957599625801121,24.92198987082111 -1.9957499793045894,24.935756067017902 -1.996832265045962,25.05462794924518 -1.9951640053093578,25.054628336995563 -1.9956495432659704,25.094310392289675 -1.9956178531952415,25.106974789506733 -1.9944276118346818,25.120295898930813 -1.9942405257024598,25.160082685853627 -1.9899889949441039,25.16002462314325 -1.9894456309612925,25.278948167323914 -1.978274445185837,25.291009452112373 -1.9759983686147133,25.303809171072434 -1.974630690844715,25.42170838156391 -1.9508709191770726,25.421792271895285 -1.9513154705203788,25.461227455629167 -1.943873741502981,25.472555538110104 -1.9406235685422784,25.484729850482733 -1.9381701033976824,25.523530891212022 -1.9265374849693786,25.523381616619808 -1.9260395738956082,25.639575748583034 -1.8927008174251858,25.65007109300261 -1.8886019465357586,25.661514028409 -1.8851699042451564,25.774338674315157 -1.839623201622056,25.774491077496407 -1.8400135188526585,25.812300173511893 -1.8252505874186347,25.82197928512949 -1.8203913123285647,25.83265309543996 -1.8160823770710004,25.869086775144652 -1.7972950383409043,25.86886280852198 -1.7968607070972782,25.978154096852997 -1.7420067549025036,25.986932856023778 -1.7365261893694666,25.996686615408894 -1.731497088740942,26.10041491578313 -1.665232973453728,26.100617024517803 -1.6655567656795678,26.135444676075895 -1.6438176007884941,26.143301076538638 -1.6378305007733711,26.152214788204162 -1.632135858161702,26.184951525595515 -1.6066805895730263,26.18467286200952 -1.6063222143862361,26.283059518461783 -1.531383139969229,26.289992039413388 -1.5250040956013753,26.29791039513499 -1.518846596550859,26.388752027310243 -1.4336533566753693,26.38899094042534 -1.4339129995500939,26.419563800917302 -1.4057810612277901,26.42556885808445 -1.3991245619157515,26.432530124914276 -1.3925960716829135,26.460331046531355 -1.3612200990549401,26.460020162394827 -1.360944637777163,26.54380520507912 -1.2680887312579299,26.54891198163088 -1.2612473502744812,26.55492518360767 -1.2544616578581653,26.629401904826597 -1.1528794358718184,26.629657750562657 -1.1530703954268433,26.65478930326621 -1.1193993879775341,26.658972380407032 -1.1125491297156505,26.664051098007253 -1.1056221419971903,26.68585604463545 -1.0692655737419594,26.685528620652207 -1.0690692003540954,26.75145556177074 -0.9611390748487358,26.754792664946645 -0.9543261452951626,26.7589766287713 -0.9473476643186252,26.81414104741621 -0.8325121235581268,26.814395999910737 -0.8326369759062741,26.83308741449096 -0.7944685085592802,26.835610608648995 -0.7878191445818611,26.838891717269295 -0.7809888794419405,26.85380380330936 -0.7408139674508036,26.8534846612795 -0.7406955086123779,26.898843715462576 -0.6211096343650977,26.90062184765695 -0.6146773415091522,26.90311439831615 -0.6079654304114377,26.93659669557918 -0.4836111295733942,26.93683120216387 -0.4836759482881778,26.94827176006227 -0.4422853380510112,26.949355894784567 -0.4362190908227318,26.95109661980577 -0.4297538339981269,26.95845659812931 -0.3870303453404434,26.958152980569054 -0.38697804112249845,26.980895269627755 -0.25967820296300714,26.981372448603466 -0.2540045062497719,26.982428919580638 -0.24787488066350033,26.992597952735455 -0.11807768757273059,26.992802682972307 -0.118094908200039,26.99644082024635 -0.07484231975054083,26.996392755576206 -0.06963935106621404,26.996843919627203 -0.06388065670814838,26.996220404243576 -0.020052290842976245,26.995946079047027 -0.02005619347490851,26.994774726819795 0.11067648187396041,26.994295593573494 0.1153632474304024,26.994218607778954 0.12065870064673825,26.980210113278623 0.25151809440581807,26.98037643677049 0.2515350914205154,26.975916719790387 0.29517544321695055,26.975086574283477 0.2993928236382699,26.974575387455747 0.3041684022175565,26.965813146526926 0.34760661429508943,26.965586455238743 0.34756088672969154,26.940015889973566 0.47719559382023985,26.938936654130952 0.48084367304121284,26.938081886481484 0.48508244551413304,26.915652547630103 0.5746958471733508,24.354196117470224 9.11287729040474,31.059997880006357 13.304003391989824,31.135861064289532 13.356432034459715,31.282435190268753 13.468054832091067,31.418103506266327 13.592705268881346,31.54171229091993 13.729323319350826,31.652210376944286 13.876747185609222,31.748658090242294 14.033723177267841,31.8302352408797 14.19891637280418,31.896248097968222 14.37092197171489,31.946135289142845 14.548277240918635,31.979472574464108 14.729473953816608,31.99597645414834 14.912971216229383,31.99550657944564 15.097208570138372,31.97806694616355 15.280619263797744,31.943805860686812 15.461643575368257,31.893014678782023 15.638742076768846,31.826125327912496 15.810408724950358,31.743706634133463 15.975183669263455,31.646459484803696 16.13166566600703,31.535210868249692 16.27852399458407,31.41090684106914 16.414509773929993,31.274604482879532 16.538466582978835,31.127462906928645 16.649340294851,30.970733403012563 16.746188041132694,30.805748796525666 16.828186230015046,30.63391211413308 16.89463755010675,30.45668465245257 16.944976900359862,30.275573551209625 16.97877619568078,30.09211897654341 16.99574800735959,29.9999998717766 16.999999999999993,20.354065404618744 17.00000129558763,16.85695338177052 25.742781352708207,16.81910689440183 25.826118991487473,16.73595264853007 25.98898477410827,16.6382554269811 26.143565318345885,16.526833690049855 26.288565622809056,16.40262087541477 26.422770944743835,16.2666575782462 26.545056976563657,16.120082833601 26.65439926475712,15.9641245741351 26.74988179226637,15.80008934307477 26.83070465243707,15.62935134862641 26.89619075025132,15.453340951521666 26.945791474703796,15.27353268214369 26.97909129480068,15.091432887621451 26.995811240678275,14.90856711237855 26.995811240678275,14.726467317856311 26.97909129480068,14.546659048478336 26.945791474703796,14.370648651373596 26.89619075025132,14.199910656925233 26.83070465243707,14.0358754258649 26.74988179226637,13.879917166399 26.65439926475712,13.733342421753797 26.545056976563654,13.59737912458523 26.42277094474383,13.473166309950146 26.288565622809056,13.361744573018903 26.143565318345885,13.264047351469936 25.98898477410828,13.180893105598173 25.82611899148748,13.14304661822948 25.742781352708207,9.64593459538125 17.00000129558763,0.00000012822340319716368 16.999999999999993,-0.09276547546074806 16.995687986551278,-0.277496414426715 16.978477119676363,-0.4598342168507198 16.944203812905386,-0.638206396620244 16.89316364015781,-0.8110746672592031 16.82579677325625,-0.9769482081518799 16.74268418587287,-1.1343965214200433 16.644542643196782,-1.2820617685751223 16.532218520531778,-1.418670480553827 16.40668050413295,-1.543044540149633 16.269011237230377,-1.6541113421272455 16.12039798328476,-1.750913043398986 15.96212238699547,-1.8326148234893713 15.795549421362105,-1.8985120840493388 15.622115616120666,-1.94803652533135 15.443316669072482,-1.9807610472217063 15.260694547146135,-1.9964034325634206 15.075824188433185,-1.9948287810045655 14.890299919879709,-1.9760506723825388 14.705721707767841,-1.9402310496111796 14.523681359563517,-1.8876788220807248 14.34574879612607,-1.8188472016149169 14.173458512668514,-1.7343297939600455 14.008296345229551,-1.6348554795130326 13.851686656783624,-1.5212821274372736 13.704980053496286,-1.3945891973758977 13.569441737060316,-1.2558692925654713 13.446240593562292,-1.1063187371962915 13.336439112977539,-1.0289917338540842 13.28501428237437,6.381436657091555 8.838754626881009,3.143046618229482 0.7427813527082074,3.112602623749806 0.6550649952115617,3.05998148634858 0.47718672500120496,3.024085241127846 0.29519462986111383,3.0052233494802545 0.11065766294688947,3.0035584197015024 -0.07483328325603994,3.019104805144839 -0.2596790920104562,3.0517284804808646 -0.4422862083066129,3.101148197129378 -0.6210803768938677,3.1669379079023123 -0.7945202139291929,3.2485304399549157 -0.9611104952413749,3.3452223843806674 -1.1194150466528656,3.4561801602967774 -1.268069125231885,3.58044720114178 -1.4057911847359967,3.716952201232198 -1.5313939238173635,3.8645183514847474 -1.6437945217431302,4.021873484682928 -1.7420239733888059,4.187661042825737 -1.8252354430277404,4.360451772009004 -1.892711564898682,4.538756044017817 -1.9438706276132547,4.721036698405677 -1.978271589087615,4.905722294348812 -1.995617878764567,5.091220658031503 -1.9957599543472009,5.275932608770463 -1.978696591002463,5.458265745545386 -1.9445748919204355,5.636648175082039 -1.8936890201382992,5.809542063138172 -1.8264776625619144,5.894427190999917 -1.7888543819998317,15.000000290155196 2.7639326356812854))
+POLYGON((15.000000290155196 2.7639326356812854,24.10557274941397 -1.7888543522067706,24.190465624402687 -1.826480651006177,24.20450880763201 -1.8319397124452754,24.2186765917243 -1.838749604849458,24.327464375084784 -1.8791490054483488,24.327265107088873 -1.8796616405935884,24.36337635833492 -1.8936985569705027,24.377432904452505 -1.8977094869125704,24.391688354132036 -1.9030037622545586,24.42940890735859 -1.9131671166189141,24.429567186350532 -1.9125796756101496,24.541726040690342 -1.9445733547666615,24.55563178619066 -1.9471757867835535,24.569891218394535 -1.9510184042287908,24.685629868698165 -1.9709769806412392,24.68553468103452 -1.9714856282046784,24.724067942179765 -1.9786966941067539,24.737663156331493 -1.979951916315987,24.751764468567117 -1.9823837919504457,24.7911932844069 -1.9854800538974362,24.791238498823798 -1.9849042786731075,24.908768516313366 -1.9957599625801121,24.92198987082111 -1.9957499793045894,24.935756067017902 -1.996832265045962,25.05462794924518 -1.9951640053093578,25.054628336995563 -1.9956495432659704,25.094310392289675 -1.9956178531952415,25.106974789506733 -1.9944276118346818,25.120295898930813 -1.9942405257024598,25.160082685853627 -1.9899889949441039,25.16002462314325 -1.9894456309612925,25.278948167323914 -1.978274445185837,25.291009452112373 -1.9759983686147133,25.303809171072434 -1.974630690844715,25.42170838156391 -1.9508709191770726,25.421792271895285 -1.9513154705203788,25.461227455629167 -1.943873741502981,25.472555538110104 -1.9406235685422784,25.484729850482733 -1.9381701033976824,25.523530891212022 -1.9265374849693786,25.523381616619808 -1.9260395738956082,25.639575748583034 -1.8927008174251858,25.65007109300261 -1.8886019465357586,25.661514028409 -1.8851699042451564,25.774338674315157 -1.839623201622056,25.774491077496407 -1.8400135188526585,25.812300173511893 -1.8252505874186347,25.82197928512949 -1.8203913123285647,25.83265309543996 -1.8160823770710004,25.869086775144652 -1.7972950383409043,25.86886280852198 -1.7968607070972782,25.978154096852997 -1.7420067549025036,25.986932856023778 -1.7365261893694666,25.996686615408894 -1.731497088740943,26.100414915783134 -1.6652329734537255,26.100617024517806 -1.6655567656795653,26.1354446760759 -1.6438176007884917,26.143301076538634 -1.6378305007733724,26.15221478820416 -1.6321358581617034,26.184951525595512 -1.6066805895730276,26.184672862009517 -1.6063222143862375,26.283059518461815 -1.5313831399691993,26.289992039413416 -1.5250040956013455,26.297910395134988 -1.5188465965508593,26.3887520273102 -1.433653356675406,26.3889909404253 -1.4339129995501305,26.419563800917263 -1.4057810612278265,26.425568858084446 -1.3991245619157515,26.432530124914273 -1.3925960716829135,26.46033104653135 -1.3612200990549406,26.460020162394823 -1.3609446377771635,26.543805205079156 -1.2680887312578857,26.548911981630916 -1.261247350274437,26.554925183607665 -1.2544616578581653,26.629401904826555 -1.1528794358718715,26.629657750562615 -1.1530703954268964,26.65478930326617 -1.1193993879775874,26.65897238040703 -1.1125491297156505,26.66405109800725 -1.1056221419971903,26.685856044635447 -1.0692655737419594,26.685528620652203 -1.0690692003540954,26.75145556177074 -0.9611390748487358,26.754792664946645 -0.9543261452951626,26.7589766287713 -0.9473476643186252,26.81414104741621 -0.8325121235581263,26.814395999910737 -0.8326369759062736,26.83308741449096 -0.7944685085592798,26.835610608648995 -0.7878191445818615,26.838891717269295 -0.780988879441941,26.85380380330936 -0.7408139674508042,26.8534846612795 -0.7406955086123785,26.898843715462576 -0.6211096343650977,26.90062184765695 -0.6146773415091522,26.903114398316145 -0.6079654304114381,26.93659669557918 -0.4836111295733939,26.93683120216387 -0.4836759482881775,26.94827176006227 -0.4422853380510109,26.949355894784567 -0.4362190908227319,26.95109661980577 -0.42975383399812694,26.95845659812931 -0.38703034534044345,26.958152980569054 -0.3869780411224985,26.980895269627755 -0.25967820296300725,26.981372448603466 -0.254004506249772,26.982428919580638 -0.24787488066350039,26.992597952735455 -0.11807768757273054,26.992802682972307 -0.11809490820003896,26.99644082024635 -0.07484231975054073,26.996392755576206 -0.06963935106621409,26.996843919627203 -0.06388065670814844,26.996220404243576 -0.0200522908429763,26.995946079047027 -0.020056193474908564,26.994774726819795 0.11067648187396054,26.994295593573494 0.11536324743040252,26.994218607778954 0.1206587006467382,26.980210113278623 0.2515180944058179,26.98037643677049 0.2515350914205152,26.97591671979039 0.29517544321695044,26.975086574283477 0.29939282363826986,26.974575387455747 0.3041684022175564,26.965813146526926 0.34760661429508943,26.965586455238743 0.34756088672969154,26.940015889973566 0.47719559382023985,26.938936654130952 0.48084367304121284,26.938081886481484 0.48508244551413304,26.915652547630103 0.5746958471733508,24.354196117470224 9.11287729040474,31.059997880006357 13.304003391989824,31.135861064289532 13.356432034459715,31.282435190268753 13.468054832091067,31.418103506266327 13.592705268881346,31.54171229091993 13.729323319350826,31.652210376944286 13.876747185609222,31.748658090242294 14.033723177267841,31.8302352408797 14.19891637280418,31.896248097968222 14.37092197171489,31.946135289142845 14.548277240918635,31.979472574464108 14.729473953816608,31.99597645414834 14.912971216229383,31.99550657944564 15.097208570138372,31.97806694616355 15.280619263797744,31.943805860686812 15.461643575368257,31.893014678782023 15.638742076768846,31.826125327912496 15.810408724950358,31.743706634133463 15.975183669263455,31.646459484803696 16.13166566600703,31.535210868249692 16.27852399458407,31.41090684106914 16.414509773929993,31.274604482879532 16.538466582978835,31.127462906928645 16.649340294851,30.970733403012563 16.746188041132694,30.805748796525666 16.828186230015046,30.63391211413308 16.89463755010675,30.45668465245257 16.944976900359862,30.275573551209625 16.97877619568078,30.09211897654341 16.99574800735959,29.9999998717766 16.999999999999993,20.354065404618744 17.00000129558763,16.85695338177052 25.742781352708207,16.81910689440183 25.826118991487473,16.73595264853007 25.98898477410827,16.6382554269811 26.143565318345885,16.526833690049855 26.288565622809056,16.40262087541477 26.422770944743835,16.2666575782462 26.545056976563657,16.120082833601 26.65439926475712,15.9641245741351 26.74988179226637,15.80008934307477 26.83070465243707,15.62935134862641 26.89619075025132,15.453340951521666 26.945791474703796,15.27353268214369 26.97909129480068,15.091432887621451 26.995811240678275,14.90856711237855 26.995811240678275,14.726467317856311 26.97909129480068,14.546659048478336 26.945791474703796,14.370648651373596 26.89619075025132,14.199910656925233 26.83070465243707,14.0358754258649 26.74988179226637,13.879917166399 26.65439926475712,13.733342421753797 26.545056976563654,13.59737912458523 26.42277094474383,13.473166309950146 26.288565622809056,13.361744573018903 26.143565318345885,13.264047351469936 25.98898477410828,13.180893105598173 25.82611899148748,13.14304661822948 25.742781352708207,9.64593459538125 17.00000129558763,0.00000012822340319716368 16.999999999999993,-0.09276547546074806 16.995687986551278,-0.277496414426715 16.978477119676363,-0.4598342168507198 16.944203812905386,-0.638206396620244 16.89316364015781,-0.8110746672592031 16.82579677325625,-0.9769482081518799 16.74268418587287,-1.1343965214200433 16.644542643196782,-1.2820617685751223 16.532218520531778,-1.418670480553827 16.40668050413295,-1.543044540149633 16.269011237230377,-1.6541113421272455 16.12039798328476,-1.750913043398986 15.96212238699547,-1.8326148234893713 15.795549421362105,-1.8985120840493388 15.622115616120666,-1.94803652533135 15.443316669072482,-1.9807610472217063 15.260694547146135,-1.9964034325634206 15.075824188433185,-1.9948287810045655 14.890299919879709,-1.9760506723825388 14.705721707767841,-1.9402310496111796 14.523681359563517,-1.8876788220807248 14.34574879612607,-1.8188472016149169 14.173458512668514,-1.7343297939600455 14.008296345229551,-1.6348554795130326 13.851686656783624,-1.5212821274372736 13.704980053496286,-1.3945891973758977 13.569441737060316,-1.2558692925654713 13.446240593562292,-1.1063187371962915 13.336439112977539,-1.0289917338540842 13.28501428237437,6.381436657091555 8.838754626881009,3.143046618229482 0.7427813527082074,3.112602623749806 0.6550649952115617,3.05998148634858 0.47718672500120496,3.024085241127846 0.29519462986111383,3.0052233494802545 0.11065766294688947,3.0035584197015024 -0.07483328325603994,3.019104805144839 -0.2596790920104562,3.0517284804808646 -0.4422862083066129,3.101148197129378 -0.6210803768938677,3.1669379079023123 -0.7945202139291929,3.2485304399549157 -0.9611104952413749,3.3452223843806674 -1.1194150466528656,3.4561801602967774 -1.268069125231885,3.58044720114178 -1.4057911847359967,3.716952201232198 -1.5313939238173635,3.8645183514847474 -1.6437945217431302,4.021873484682928 -1.7420239733888059,4.187661042825737 -1.8252354430277404,4.360451772009004 -1.892711564898682,4.538756044017817 -1.9438706276132547,4.721036698405677 -1.978271589087615,4.905722294348812 -1.995617878764567,5.091220658031503 -1.9957599543472009,5.275932608770463 -1.978696591002463,5.458265745545386 -1.9445748919204355,5.636648175082039 -1.8936890201382992,5.809542063138172 -1.8264776625619144,5.894427190999917 -1.7888543819998317,15.000000290155196 2.7639326356812854))
SELECT ST_ASTEXT(ST_CENTROID(@buf));
ST_ASTEXT(ST_CENTROID(@buf))
POINT(15.118234164053845 10.73934130957614)
SELECT ST_ASTEXT(ST_CONVEXHULL(@buf));
ST_ASTEXT(ST_CONVEXHULL(@buf))
-POLYGON((-0.9964394501011175 15.084311459969465,-0.9948647985422624 14.89878719141599,-0.9590451757709032 14.716746843211665,4.065006382157773 -0.35466453811214854,4.146598914210377 -0.5212548194243305,4.257556690126487 -0.6699088980033499,4.394061690216905 -0.7955116370847167,4.551416823415085 -0.8937410887303923,4.724207552598352 -0.9612172106013338,4.906488206986212 -0.9956181720756941,5.091986570668903 -0.995760247658328,25.014042950796863 -0.9999013929047789,25.09351179301379 -0.995618172075694,25.197556222938477 -0.9802915580470347,25.27579244740165 -0.9612172106013335,25.374340400864735 -0.9272913588945115,25.448583176584915 -0.8937410887303918,25.53837392083365 -0.8427060705644654,25.605938309783095 -0.7955116370847162,25.684069527764475 -0.729416808953626,25.742443309873515 -0.6699088980033491,25.806464586457874 -0.5912823951288695,25.853401085789624 -0.5212548194243296,25.901390117221936 -0.43300791745027806,25.934993617842228 -0.35466453811214743,30.962642421022533 14.729224134665076,30.995979706343796 14.91042084756305,30.995509831641094 15.094658201472038,30.961248746164355 15.27568251304255,30.894359395294828 15.447349161224063,30.79711224596506 15.603831157967637,30.672808218784507 15.739816937313561,30.52566664283362 15.850690649185726,15.597937410913687 25.801542795257895,15.441979151447788 25.897025322767142,15.271241156999427 25.962511420581393,15.091432887621451 25.995811240678275,14.90856711237855 25.995811240678275,14.728758843000575 25.962511420581393,14.558020848552212 25.897025322767142,14.402062589086313 25.801542795257895,-0.528976659628168 15.848636372994125,-0.6766419067832469 15.736312250329119,-0.8010159663790529 15.598642983426544,-0.8978176676507933 15.44036738713725,-0.963714928210761 15.266933581895811,-0.9964394501011175 15.084311459969465))
+POLYGON((-0.9964394501011175 15.084311459969465,-0.9948647985422624 14.89878719141599,-0.9590451757709032 14.716746843211665,4.065006382157773 -0.35466453811214854,4.146598914210377 -0.5212548194243305,4.257556690126487 -0.6699088980033499,4.394061690216905 -0.7955116370847167,4.551416823415085 -0.8937410887303923,4.724207552598352 -0.9612172106013338,4.906488206986212 -0.9956181720756941,5.091986570668903 -0.995760247658328,25.014042950796863 -0.9999013929047789,25.09351179301379 -0.995618172075694,25.197556222938477 -0.9802915580470347,25.27579244740165 -0.9612172106013335,25.374340400864735 -0.9272913588945115,25.448583176584915 -0.8937410887303918,25.53837392083365 -0.8427060705644656,25.605938309783095 -0.7955116370847162,25.68406952776447 -0.7294168089536263,25.742443309873515 -0.6699088980033491,25.80646458645787 -0.5912823951288696,25.853401085789624 -0.5212548194243296,25.901390117221936 -0.43300791745027806,25.934993617842228 -0.35466453811214743,30.962642421022533 14.729224134665076,30.995979706343796 14.91042084756305,30.995509831641094 15.094658201472038,30.961248746164355 15.27568251304255,30.894359395294828 15.447349161224063,30.79711224596506 15.603831157967637,30.672808218784507 15.739816937313561,30.52566664283362 15.850690649185726,15.597937410913687 25.801542795257895,15.441979151447788 25.897025322767142,15.271241156999427 25.962511420581393,15.091432887621451 25.995811240678275,14.90856711237855 25.995811240678275,14.728758843000575 25.962511420581393,14.558020848552212 25.897025322767142,14.402062589086313 25.801542795257895,-0.528976659628168 15.848636372994125,-0.6766419067832469 15.736312250329119,-0.8010159663790529 15.598642983426544,-0.8978176676507933 15.44036738713725,-0.963714928210761 15.266933581895811,-0.9964394501011175 15.084311459969465))
SELECT ST_ASTEXT(ST_ENVELOPE(@buf));
ST_ASTEXT(ST_ENVELOPE(@buf))
POLYGON((-0.9964394501011175 -0.9999013929047789,30.995979706343796 -0.9999013929047789,30.995979706343796 25.995811240678275,-0.9964394501011175 25.995811240678275,-0.9964394501011175 -0.9999013929047789))
mysqltest: Result content mismatch
gis.spatial_analysis_functions_buffer w60 [ fail ]
Test ended at 2017-07-21 03:30:36
CURRENT_TEST: gis.spatial_analysis_functions_buffer
--- /source/mysql-test/suite/gis/r/spatial_analysis_functions_buffer.result 2017-07-21 06:23:33.766428813 +0300
+++ /build/build/mysql-test/var/60/log/spatial_analysis_functions_buffer.reject 2017-07-21 06:30:35.812759413 +0300
@@ -118,7 +118,7 @@
LINESTRING(0 5,15 25,0 25)
SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_lines_near_horizontal), 2));
ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_lines_near_horizontal), 2))
-POLYGON((5.097759137044168 9.608963759835378,23.971008489144946 -1.7149858514250884,24.325357414501106 -1.8827791643821026,24.70563247607407 -1.978218329926633,25.097219916508294 -1.997635674449703,25.485071250072664 -1.940285000290664,25.854281567527835 -1.8083702616948187,26.190662323429528 -1.606960868087768,26.481286593972953 -1.3437968695141418,26.714985851425087 -1.0289915108550536,26.882779164382104 -0.6746425854988932,26.978218329926634 -0.294367523925931,26.997635674449704 0.09721991650829534,26.940285000290665 0.4850712500726652,26.80837026169482 0.8542815675278337,26.606960868087768 1.19066232342953,26.343796869514144 1.4812865939729531,26.028991510855054 1.7149858514250884,7.155742122517564 13.038935607632403,16.714985851425087 28.971008489144946,16.880582122258122 29.319257110618747,16.976268115990727 29.69281221749806,16.9984867242907 30.07778697084875,16.946411974686725 30.45987000858517,16.821979735935425 30.824857467591027,16.629815752474318 31.159181009586757,16.37706368326596 31.450412221483944,16.073119537656034 31.687724639240923,15.729282380541067 31.862296219572052,15.358334291813676 31.967637297702602,14.974065195011828 31.99983183940306,14.59076021957528 31.95768301880512,14.222668653918282 31.842757710172116,13.883474230885488 31.65932823965099,13.585786437626904 31.414213562373096,-1.414213562373095 16.414213562373096,-1.6463445737142413 16.1355833499139,-1.824343939397651 15.81961526997919,-1.9423590580029886 15.476698321576386,-1.9965096041812367 15.118107579824843,-1.9850151133658063 14.755633472608594,-1.9082535232702063 14.401194112481479,-1.7687487473336538 14.066443430313068,-1.5710876886984984 13.762387995202046,-1.3217694232916177 13.499025119580162,-1.0289915108550531 13.285014148574911,1.6677882530092312 11.666946290256341,-1.7149858514250884 6.028991510855053,-1.882779164382102 5.674642585498895,-1.9782183299266327 5.294367523925932,-1.997635674449703 4.902780083491706,-1.9402850002906642 4.514928749927336,-1.808370261694819 4.145718432472167,-1.606960868087768 3.80933767657047,-1.3437968695141413 3.5187134060270466,-1.0289915108550527 3.2850141485749114,-0.6746425854988922 3.117220835617897,-0.29436752392593 3.0217816700733673,0.09721991650829634 3.002364325550297,0.4850712500726662 3.0597149997093362,0.8542815675278346 3.1916297383051817,1.1906623234295306 3.393039131912232,1.4812865939729538 3.656203130485859,1.7149858514250884 3.971008489144947,5.097759137044168 9.608963759835378),(4.926404247744273 17.09797712299808,3.7257698196681064 15.09691762934371,3.2255048638235344 15.397077739077343,4.926404247744273 17.09797712299808))
+POLYGON((5.097759137044168 9.608963759835378,23.971008489144946 -1.7149858514250884,24.325357414501106 -1.8827791643821026,24.70563247607407 -1.978218329926633,25.097219916508294 -1.997635674449703,25.485071250072664 -1.940285000290664,25.854281567527835 -1.8083702616948187,26.190662323429528 -1.606960868087768,26.481286593972953 -1.3437968695141418,26.714985851425087 -1.0289915108550536,26.882779164382104 -0.6746425854988932,26.978218329926634 -0.294367523925931,26.997635674449704 0.09721991650829534,26.940285000290665 0.4850712500726652,26.80837026169482 0.8542815675278337,26.606960868087768 1.19066232342953,26.343796869514144 1.4812865939729531,26.028991510855054 1.7149858514250884,7.155742122517564 13.038935607632403,16.714985851425087 28.971008489144946,16.880582122258122 29.319257110618747,16.976268115990727 29.69281221749806,16.9984867242907 30.07778697084875,16.946411974686725 30.45987000858517,16.821979735935425 30.824857467591027,16.629815752474318 31.159181009586757,16.37706368326596 31.450412221483944,16.073119537656034 31.687724639240923,15.729282380541067 31.862296219572052,15.358334291813676 31.967637297702602,14.974065195011828 31.99983183940306,14.59076021957528 31.95768301880512,14.222668653918282 31.842757710172116,13.883474230885488 31.65932823965099,13.585786437626904 31.414213562373096,-1.414213562373095 16.414213562373096,-1.6463445737142413 16.1355833499139,-1.824343939397651 15.81961526997919,-1.9423590580029886 15.476698321576386,-1.9965096041812367 15.118107579824843,-1.9850151133658063 14.755633472608594,-1.9082535232702063 14.401194112481479,-1.7687487473336538 14.066443430313068,-1.5710876886984984 13.762387995202046,-1.3217694232916177 13.499025119580162,-1.0289915108550531 13.285014148574911,1.6677882530092312 11.666946290256341,-1.7149858514250884 6.028991510855053,-1.882779164382102 5.674642585498895,-1.9782183299266327 5.294367523925932,-1.997635674449703 4.902780083491706,-1.9402850002906642 4.514928749927336,-1.808370261694819 4.145718432472167,-1.606960868087768 3.80933767657047,-1.3437968695141413 3.5187134060270466,-1.0289915108550527 3.2850141485749114,-0.6746425854988927 3.117220835617897,-0.29436752392593046 3.0217816700733673,0.0972199165082959 3.002364325550297,0.48507125007266577 3.0597149997093362,0.8542815675278341 3.1916297383051813,1.1906623234295306 3.393039131912232,1.4812865939729536 3.6562031304858587,1.7149858514250884 3.971008489144947,5.097759137044168 9.608963759835378),(4.926404247744273 17.09797712299808,3.7257698196681064 15.09691762934371,3.2255048638235344 15.397077739077343,4.926404247744273 17.09797712299808))
SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0.00 0),(0.0 0,0 -0))'), 10));
ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0.00 0),(0.0 0,0 -0))'), 10))
POLYGON((9.807852804032304 -1.9509032201612824,10 0,9.807852804032311 1.9509032201612437,9.238795325112882 3.826834323650863,8.314696123025472 5.555702330195993,7.071067811865499 7.0710678118654515,5.555702330196048 8.314696123025435,3.8268343236509246 9.238795325112857,1.950903220161309 9.807852804032299,2.4808382392282727e-14 10,-1.9509032201612606 9.807852804032308,-3.826834323650879 9.238795325112875,-5.555702330196008 8.314696123025463,-7.071067811865463 7.071067811865487,-8.314696123025445 5.555702330196034,-9.238795325112862 3.826834323650909,-9.807852804032303 1.9509032201612921,-10 7.6571373978539e-15,-9.807852804032306 -1.9509032201612773,-9.238795325112868 -3.8268343236508944,-8.314696123025453 -5.555702330196022,-7.071067811865475 -7.0710678118654755,-5.55570233019602 -8.314696123025454,-3.826834323650897 -9.238795325112868,-1.950903220161282 -9.807852804032304,6.123233995736766e-16 -10,1.9509032201612833 -9.807852804032304,3.8268343236508984 -9.238795325112868,5.555702330196023 -8.314696123025453,7.0710678118654755 -7.071067811865475,8.314696123025453 -5.555702330196022,9.238795325112868 -3.826834323650898,9.807852804032304 -1.9509032201612824))
@@ -142,7 +142,7 @@
POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))
SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_elem_vertical), 0.5));
ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_elem_vertical), 0.5))
-POLYGON((14.999999925856745 4.44098304269668,24.77639320225002 -0.4472135954999579,24.862840146278085 -0.48081927428815,24.954006714665546 -0.49788012382916397,25.046755896506895 -0.4978090860378471,25.137896223700825 -0.4806086053006671,25.224291588292456 -0.44687054436519646,25.302969154891546 -0.39775581854235875,25.371221654936758 -0.3349544490016753,25.42670054289481 -0.26062740971216564,25.467496808921112 -0.1773322690560746,25.49220666724537 -0.08793518476244709,25.499979859967038 0.004487719614761125,25.490548914143243 0.09675620307187341,25.46423834544263 0.18569533817705186,15.464238345442629 25.18569533817705,15.422661222506749 25.26712822948745,15.366950354041126 25.339628381719038,15.298968705456844 25.400771397628947,15.220989575723893 25.44851266138357,15.135620578499712 25.481255710290696,15.045716443810724 25.497905620339136,14.954283556189274 25.497905620339136,14.864379421500287 25.481255710290696,14.779010424276105 25.44851266138357,14.701031294543156 25.400771397628947,14.633049645958872 25.339628381719034,14.577338777493251 25.26712822948745,14.535761654557371 25.18569533817705,4.53576165455737 0.18569533817705186,4.509451085856758 0.09675620307187346,4.500020140032961 0.004487719614761286,4.5077933327546305 -0.08793518476244684,4.532503191078886 -0.17733226905607427,4.573299457105188 -0.26062740971216525,4.628778345063243 -0.3349544490016749,4.697030845108452 -0.39775581854235836,4.775708411707543 -0.44687054436519613,4.8621037762991755 -0.4806086053006669,4.953244103493106 -0.49780908603784707,5.045993285334451 -0.497880123829164,5.137159853721913 -0.48081927428815024,5.223606797749979 -0.4472135954999579,14.999999925856745 4.44098304269668))
+POLYGON((14.999999925856745 4.44098304269668,24.77639320225002 -0.4472135954999579,24.862840146278085 -0.48081927428815,24.954006714665546 -0.49788012382916397,25.046755896506895 -0.4978090860378471,25.137896223700825 -0.4806086053006671,25.224291588292456 -0.44687054436519646,25.302969154891546 -0.39775581854235875,25.371221654936758 -0.3349544490016753,25.42670054289481 -0.26062740971216564,25.467496808921112 -0.17733226905607458,25.49220666724537 -0.08793518476244706,25.499979859967038 0.004487719614761153,25.490548914143243 0.09675620307187344,25.46423834544263 0.18569533817705186,15.464238345442629 25.18569533817705,15.422661222506749 25.26712822948745,15.366950354041126 25.339628381719038,15.298968705456844 25.400771397628947,15.220989575723893 25.44851266138357,15.135620578499712 25.481255710290696,15.045716443810724 25.497905620339136,14.954283556189274 25.497905620339136,14.864379421500287 25.481255710290696,14.779010424276105 25.44851266138357,14.701031294543156 25.400771397628947,14.633049645958872 25.339628381719034,14.577338777493251 25.26712822948745,14.535761654557371 25.18569533817705,4.53576165455737 0.18569533817705186,4.509451085856758 0.09675620307187346,4.500020140032961 0.004487719614761286,4.5077933327546305 -0.08793518476244684,4.532503191078886 -0.17733226905607427,4.573299457105188 -0.26062740971216525,4.628778345063243 -0.3349544490016749,4.697030845108452 -0.39775581854235836,4.775708411707543 -0.44687054436519613,4.8621037762991755 -0.4806086053006669,4.953244103493106 -0.49780908603784707,5.045993285334451 -0.497880123829164,5.137159853721913 -0.48081927428815024,5.223606797749979 -0.4472135954999579,14.999999925856745 4.44098304269668))
SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((3 3,5 5,7 3,3 3))'), 1));
ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('POLYGON((3 3,5 5,7 3,3 3))'), 1))
POLYGON((2.2928932188134525 3.7071067811865475,2.1685303876974555 3.5555702330196035,2.076120467488714 3.382683432365091,2.0192147195967696 3.1950903220161293,2 3.000000000000001,2.0192147195967696 2.8049096779838725,2.076120467488713 2.6173165676349104,2.1685303876974547 2.444429766980398,2.2928932188134525 2.2928932188134525,2.444429766980398 2.1685303876974547,2.6173165676349104 2.076120467488713,2.804909677983872 2.0192147195967696,3 2,7 2,7.195090322016128 2.0192147195967696,7.38268343236509 2.076120467488713,7.555570233019602 2.1685303876974547,7.707106781186547 2.292893218813452,7.831469612302545 2.444429766980398,7.923879532511287 2.61731656763491,7.98078528040323 2.8049096779838716,8 2.9999999999999996,7.98078528040323 3.195090322016128,7.923879532511287 3.3826834323650896,7.831469612302546 3.555570233019602,7.707106781186548 3.7071067811865475,5.707106781186548 5.707106781186548,5.555570233019602 5.831469612302545,5.38268343236509 5.923879532511287,5.195090322016129 5.98078528040323,5 6,4.804909677983872 5.98078528040323,4.61731656763491 5.923879532511287,4.444429766980398 5.831469612302546,4.292893218813452 5.707106781186548,2.2928932188134525 3.7071067811865475))
@@ -243,7 +243,7 @@
POLYGON((10 1010,0 1010,-195.09032201612712 990.7852804032307,-382.68343236508866 933.8795325112872,-555.5702330196012 841.4696123025459,-707.1067811865468 717.1067811865482,-831.4696123025448 565.5702330196028,-923.8795325112865 392.68343236509025,-980.7852804032304 205.0903220161286,-1000 10,-1000 0,-980.7852804032306 -195.09032201612771,-923.8795325112868 -382.68343236508946,-831.4696123025453 -555.5702330196021,-707.1067811865474 -707.1067811865476,-555.5702330196019 -831.4696123025454,-382.68343236508974 -923.8795325112867,-195.0903220161282 -980.7852804032304,0 -1000,10 -1000,205.09032201612834 -980.7852804032304,392.68343236508986 -923.8795325112867,565.5702330196023 -831.4696123025452,717.1067811865476 -707.1067811865474,841.4696123025452 -555.5702330196021,933.8795325112867 -382.6834323650898,990.7852804032304 -195.09032201612825,1010 0,1010 10,990.7852804032304 205.09032201612825,933.8795325112867 392.6834323650898,841.4696123025452 565.5702330196021,717.1067811865476 717.1067811865474,565.5702330196023 841.4696123025452,392.68343236508986 933.8795325112867,205.09032201612834 990.7852804032304,10 1010))
SELECT ST_ASTEXT(ST_BUFFER(g, 20)) FROM gis_geometrycollection WHERE fid=103;
ST_ASTEXT(ST_BUFFER(g, 20))
-POLYGON((15.000001034273785 -17.36068029213479,16.05572809000084 -17.88854381999832,17.056952410220337 -18.2777673989394,18.036969761671553 -18.748765556700626,18.791543359698245 -18.95207643670473,19.513605851123483 -19.23277097152601,20.560323430981825 -19.428653186496685,21.601027046921402 -19.709058396185245,22.38962089548151 -19.770985011857633,23.160268586621935 -19.915204953166562,24.215869804709342 -19.914396496147507,25.280859015937267 -19.998027858095575,26.07680280094823 -19.912975011519617,26.87023586027576 -19.912363441513882,27.898439945492665 -19.718318771355786,28.951124458769538 -19.605831160940696,29.72700731871155 -19.37322015141297,30.515848948032968 -19.224344212026676,31.48183399105669 -18.84712011122019,32.48680801729469 -18.54582717789023,33.215198543550905 -18.170226369641217,33.9716635316983 -17.874821774607845,34.843454553240534 -17.33060222403472,35.767478416673015 -16.854121411289313,36.421934267429464 -16.345232902905558,37.118766195661905 -15.910232741694333,37.868228891705265 -15.220630359922026,38.68139055528946 -14.588336179072526,39.23747994125983 -13.960736648624097,39.848866197470265 -13.398177960066992,40.45247868228838 -12.589495516167762,41.12929172915745 -11.825647902577392,41.565485691837615 -11.09835808861414,42.068021715792476 -10.425096388486605,42.50778732035646 -9.527207557571023,43.0278023444387 -8.660158349005561,43.32621505532017 -7.856199441815339,43.699872356844544 -7.0932907622429635,43.963765683363576 -6.138563136424185,44.31225596537602 -5.19968936839485,44.459455114067076 -4.345222020385013,44.688266689814796 -3.517407390497862,44.77050040107925 -2.539654230981104,44.93890196087321 -1.5621103017029268,44.926432690102686 -0.6856158706838436,44.99919439868154 0.1795087845904661,44.90037052573094 1.146355088366184,44.891418507444705 1.7755764067017321,46.003637012720034 3.0048508819149156,47.93259127868019 6.144370715087325,49.25284842045066 9.58448269330154,49.91959412687596 13.208416951261013,49.91019663282188 16.893164029440783,49.22497492328709 20.513650260851016,47.887187905896525 23.946983224481265,45.94224491930119 27.07662315935276,43.456164375690136 29.796338746271246,40.5133328566724 32.013812983714516,37.21364072693446 33.653776761361556,33.66909149332426 34.66056376642378,32.36810898233639 34.780922427548354,31.906448900269943 35.68512917949808,29.678014161645084 38.585135268761455,26.95874821827371 41.030855905157885,23.83958302895573 42.940506455342835,20.424823139988483 44.25022841162789,16.828657752428988 44.91622481356548,13.171342247570983 44.91622481356548,9.57517686001149 44.25022841162788,6.160416971044246 42.94050645534282,3.0412517817262703 41.030855905157864,0.32198583835490346 38.58513526876144,-1.9064489002699538 35.68512917949806,-2.3689402361660488 34.7792943350306,-3.6946187793193386 34.655782662501665,-7.262062374709823 33.63497920755008,-10.57953319256336 31.97272745988252,-13.532838135664944 29.72624500658238,-16.020319327581063 26.972859668530845,-17.956353353015867 23.80734774274502,-19.274298564215222 20.338671637916217,-19.928789002022352 16.686229199389274,-19.897295970845246 12.97574382831976,-19.180903515418063 9.33493686423328,-17.8042711061019 5.889131195082161,-15.814784817161637 2.756937426163592,-14.842110268168344 1.7163551167007156,-14.999194398681535 0.17950878459045144,-14.688266689814796 -3.5174073904978735,-13.699872356844537 -7.093290762242971,-12.068021715792472 -10.42509638848661,-9.848866197470263 -13.398177960066997,-7.118766195661898 -15.910232741694335,-3.971663531698301 -17.874821774607845,-0.5158489480329749 -19.224344212026672,3.129764139724236 -19.912363441513882,6.839731413378058 -19.915204953166562,10.48639414887651 -19.232770971526012,13.94427190999916 -17.88854381999832,15.000001034273785 -17.36068029213479))
+POLYGON((15.000001034273785 -17.36068029213479,16.05572809000084 -17.88854381999832,17.056952410220333 -18.2777673989394,18.03696976167155 -18.748765556700626,18.79154335969824 -18.95207643670473,19.513605851123483 -19.23277097152601,20.560323430981818 -19.428653186496685,21.601027046921395 -19.709058396185245,22.389620895481507 -19.770985011857633,23.160268586621935 -19.915204953166562,24.215869804709335 -19.914396496147507,25.280859015937263 -19.998027858095575,26.076802800948226 -19.912975011519617,26.87023586027576 -19.912363441513882,27.898439945492658 -19.718318771355786,28.95112445876953 -19.605831160940696,29.727007318711543 -19.37322015141297,30.515848948032968 -19.224344212026676,31.481833991056682 -18.84712011122019,32.486808017294685 -18.54582717789023,33.215198543550905 -18.170226369641217,33.9716635316983 -17.874821774607845,34.843454553240534 -17.33060222403472,35.767478416673015 -16.854121411289313,36.421934267429464 -16.345232902905558,37.118766195661905 -15.910232741694333,37.868228891705265 -15.220630359922028,38.681390555289454 -14.588336179072527,39.23747994125982 -13.9607366486241,39.848866197470265 -13.398177960066992,40.45247868228837 -12.589495516167764,41.129291729157444 -11.825647902577394,41.56548569183761 -11.098358088614141,42.068021715792476 -10.425096388486605,42.50778732035646 -9.527207557571025,43.0278023444387 -8.660158349005563,43.32621505532017 -7.85619944181534,43.699872356844544 -7.0932907622429635,43.963765683363576 -6.138563136424186,44.31225596537602 -5.199689368394851,44.459455114067076 -4.345222020385014,44.688266689814796 -3.517407390497862,44.77050040107925 -2.5396542309811054,44.93890196087321 -1.5621103017029279,44.926432690102686 -0.6856158706838449,44.99919439868154 0.1795087845904661,44.90037052573094 1.146355088366183,44.891418507444705 1.7755764067017321,46.003637012720034 3.0048508819149156,47.93259127868019 6.144370715087325,49.25284842045066 9.58448269330154,49.91959412687596 13.208416951261013,49.91019663282188 16.893164029440783,49.22497492328709 20.513650260851016,47.887187905896525 23.946983224481265,45.94224491930119 27.07662315935276,43.456164375690136 29.796338746271246,40.5133328566724 32.013812983714516,37.21364072693446 33.653776761361556,33.66909149332426 34.66056376642378,32.36810898233639 34.780922427548354,31.906448900269943 35.68512917949808,29.678014161645084 38.585135268761455,26.95874821827371 41.030855905157885,23.83958302895573 42.940506455342835,20.424823139988483 44.25022841162789,16.828657752428988 44.91622481356548,13.171342247570983 44.91622481356548,9.57517686001149 44.25022841162788,6.160416971044246 42.94050645534282,3.0412517817262703 41.030855905157864,0.32198583835490346 38.58513526876144,-1.9064489002699538 35.68512917949806,-2.3689402361660488 34.7792943350306,-3.6946187793193386 34.655782662501665,-7.262062374709823 33.63497920755008,-10.57953319256336 31.97272745988252,-13.532838135664937 29.72624500658239,-16.02031932758106 26.972859668530855,-17.956353353015867 23.807347742745026,-19.27429856421522 20.338671637916228,-19.92878900202235 16.686229199389285,-19.89729597084525 12.975743828319768,-19.180903515418063 9.334936864233288,-17.804271106101904 5.88913119508217,-15.814784817161645 2.756937426163601,-14.842110268168344 1.7163551167007156,-14.999194398681535 0.17950878459045144,-14.688266689814796 -3.5174073904978735,-13.699872356844537 -7.093290762242971,-12.068021715792472 -10.42509638848661,-9.848866197470263 -13.398177960066997,-7.118766195661898 -15.910232741694335,-3.971663531698301 -17.874821774607845,-0.5158489480329749 -19.224344212026672,3.129764139724236 -19.912363441513882,6.839731413378058 -19.915204953166562,10.48639414887651 -19.232770971526012,13.94427190999916 -17.88854381999832,15.000001034273785 -17.36068029213479))
SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)))'), -2));
ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)))'), -2))
POLYGON((8 2,8 8,2 8,2 2,8 2))
@@ -291,7 +291,7 @@
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))
SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_collection_multilinestr), 1));
ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT(@star_collection_multilinestr), 1))
-POLYGON((7.766188802991196 16,15.857492925712544 29.485504244572475,15.940291061129061 29.659628555309375,15.988134057995364 29.846406108749033,15.99924336214535 30.038893485424374,15.973205987343363 30.22993500429259,15.91098986796771 30.412428733795515,15.814907876237157 30.57959050479338,15.68853184163298 30.725206110741972,15.536559768828015 30.843862319620463,15.364641190270532 30.931148109786026,15.179167145906836 30.9838186488513,14.987032597505912 30.99991591970153,14.795380109787638 30.97884150940256,14.611334326959138 30.921378855086058,14.441737115442743 30.829664119825495,14.292893218813452 30.707106781186546,-0.7071067811865475 15.707106781186548,-0.7554688419207334 15.649058956452391,-0.8010159663790529 15.598642983426544,-0.8108044236437141 15.582638368941852,-0.8231722868571226 15.567791674956947,-0.82387353370499 15.56654688613857,-0.8247428766160511 15.56550790221807,-0.838215676583904 15.541084926404501,-0.86153056257408 15.499698608780829,-0.8978176676507933 15.44036738713725,-0.9037504121723406 15.424753104401463,-0.9121719696988269 15.409807634989592,-0.9147281600695789 15.402375638323978,-0.9182731375679747 15.395947527863312,-0.9363041491857993 15.33968758590701,-0.9385408492492481 15.333188783866923,-0.963714928210761 15.266933581895811,-0.9662923888527085 15.252549832205252,-0.971179529001495 15.23834916078819,-0.973316934816207 15.224186901832113,-0.9773694136518997 15.211539663556842,-0.9843331821750986 15.151871571150492,-0.9964394501011175 15.084311459969465,-0.9963330656466809 15.071777323141662,-0.9982548020906185 15.059053789912419,-0.9975946218303362 15.038228850995145,-0.999815675460913 15.019199351620259,-0.9954067020613553 14.962633858598254,-0.9948647985422624 14.89878719141599,-0.992845977328917 14.888527258781146,-0.9925075566829029 14.877816736304295,-0.9867122483957445 14.85106300898269,-0.9847702189226056 14.82613909029594,-0.9704745529536821 14.774832541528266,-0.9590451757709032 14.716746843211665,-0.9559426936284632 14.708981116876505,-0.9541267616351028 14.700597056240738,-0.9410472220493528 14.669212388824093,-0.9327972280488767 14.63959837494216,-0.9104921370590819 14.59521524558582,-0.8902135553050953 14.544456559754108,-0.8868470544168822 14.539156431191405,-0.8843743736668266 14.533221715156534,-0.8621869358674266 14.499091075785113,-0.8458456188082695 14.466572226873351,-0.8176508191517764 14.430215737236969,-0.7907392408580822 14.38784687130818,-0.7878861388539616 14.384794572793407,-0.785543844349249 14.381193997601024,-0.752865464217139 14.346674818878263,-0.7271759574466495 14.313548889642133,-0.6953129290063224 14.285758130872422,-0.6640463107967063 14.25230855487221,-0.6623607194638322 14.251070977227958,-0.6608847116458089 14.249512559790082,-0.6168428149128343 14.217320200010395,-0.5812381937190965 14.186266528793265,2.8675247064990304 11.72286207761168,-0.8574929257125442 5.514495755427527,-0.941389582191051 5.337321292749447,-0.9891091649633164 5.147183761962967,-0.9988178372248515 4.951390041745853,-0.9701425001453321 4.757464374963668,-0.9041851308474095 4.5728592162360835,-0.803480434043884 4.404668838285235,-0.6718984347570707 4.259356703013523,-0.5144957554275268 4.142507074287456,-0.33732129274944656 4.058610417808949,-0.14718376196296545 4.010890835036683,0.048609958254147725 4.001182162775148,0.24253562503633266 4.029857499854668,0.4271407837639169 4.095814869152591,0.595331161714765 4.196519565956116,0.7406432969864766 4.328101565242929,0.8574929257125442 4.485504244572473,4.500193301269526 10.556670008917294,5.8926149262809036 9.562085728793265,4.01941932430908 0.19611613513818404,4.019364011415901 0.19558247118801225,4.01921471959677 0.19509032201612922,4.019137935231209 0.19431071726948748,4.018902171713515 0.19351240614374693,4.009155651172691 0.09815646983708545,4.000065081195405 0.01140868770929469,4.000165105596132 0.010196680723664094,4.000040280065924 0.008975439229522573,4.000428326367366 0.00436158653136523,4 7.657137397853899e-16,4.00545072963838 -0.05535455764278931,4.0080943951090005 -0.08678761864427449,4.015200021200573 -0.1736922616487226,4.015493646128988 -0.17476437336656656,4.01558666550926 -0.17587036952489368,4.018283465640281 -0.1856270449971804,4.01921471959677 -0.19509032201612772,4.038172450076035 -0.2575828285870997,4.041119982788788 -0.26824662224072504,4.064302118633197 -0.3528023168938607,4.064743623816964 -0.3537139122836271,4.065006382157773 -0.35466453811214854,4.071873782635128 -0.368685946059979,4.076120467488713 -0.38268343236508945,4.107307172087979 -0.4410315170123408,4.107422252034378 -0.4412664797002449,4.145677772041797 -0.5197437164762374,4.146209767987875 -0.5204602861864557,4.146598914210377 -0.5212548194243305,4.159238505438738 -0.5381885293167137,4.168530387697455 -0.5555702330196022,4.209095109599697 -0.6050009774937036,4.25652021894709 -0.6687584131549427,4.257088491708935 -0.6692816359320028,4.257556690126487 -0.6699088980033499,4.277193438933862 -0.6879773162680687,4.292893218813452 -0.7071067811865476,4.339754090104229 -0.7455650629755607,4.393006345087573 -0.7947066772690753,4.393567486568954 -0.7950569040580475,4.394061690216905 -0.7955116370847167,4.421438254330118 -0.8126015459178574,4.444429766980398 -0.8314696123025455,4.494473810690519 -0.8582184474291166,4.550428549089282 -0.8932443733525736,4.550935683057345 -0.8934407353034348,4.551416823415085 -0.8937410887303923,4.586726182533162 -0.9075296677259079,4.61731656763491 -0.9238795325112867,4.667599723331613 -0.9391336576331688,4.723357114358982 -0.9609727955692661,4.723784320347855 -0.9610519351201247,4.724207552598352 -0.9612172106013338,4.767072421995017 -0.9693068936544817,4.804909677983872 -0.9807852804032304,4.852743132658768 -0.9854948903210408,4.905827487762359 -0.9955558939300452,4.906168420866411 -0.9955578203613323,4.906488206986212 -0.9956181720756941,4.955908646297231 -0.9956560238258106,5 -1,5.043271057890442 -0.9957366733947699,5.091546005578183 -0.9958008479925488,5.091751554664334 -0.9957600676565473,5.091986570668903 -0.995760247658328,5.146373879422239 -0.9855822437255954,5.195090322016128 -0.9807852804032304,5.232197555352073 -0.9695270804392745,5.274106970946535 -0.9616992089414005,5.274207949785685 -0.9616594628283592,5.2743197074438255 -0.9616385485763005,5.331562681725897 -0.9393857202290141,5.38268343236509 -0.9238795325112867,5.412638489155523 -0.9078680353344648,5.447213595499958 -0.8944271909999159,15.000000795499957 3.8819664090000843,24.552786404500043 -0.8944271909999159,24.587352624667037 -0.9078642527064811,24.61731656763491 -0.9238795325112867,24.634455891057762 -0.9290780159482773,24.651848488083576 -0.9374382778350313,24.65761039054385 -0.938989604117241,24.662678707250556 -0.9413895821910518,24.69347401846947 -0.9491195479721178,24.725680292556177 -0.961638548576301,24.72973355812785 -0.9623971089926734,24.733439590443513 -0.9638182131797879,24.770065620097938 -0.9702158273646265,24.804909677983872 -0.9807852804032304,24.817224043199207 -0.9819970765225351,24.83005135234607 -0.9854529198092623,24.841978822598662 -0.9863892551122224,24.852816238037036 -0.9891091649633167,24.87956190680171 -0.9904358656082217,24.9080134293311 -0.9957602476583283,24.916288736962514 -0.9957539990794801,24.924075646998674 -0.9971135806021948,24.962534936459928 -0.9963105819186819,25 -1,25.006792781673234 -0.9993309694003044,25.014042950796863 -0.9999013929047789,25.031911508874817 -0.9979909059661792,25.04860995825415 -0.9988178372248515,25.07012517067658 -0.9956368486213135,25.09351179301379 -0.995618172075694,25.10571507487357 -0.9933152993370914,25.11755512277557 -0.9930663588649152,25.155540188269292 -0.9847813014406579,25.167628038646118 -0.983489619662504,25.195090322016128 -0.9807852804032304,25.19625643190191 -0.9804313992203624,25.197556222938477 -0.9802915580470347,25.22057263809812 -0.973390115915728,25.242535625036336 -0.9701425001453315,25.258259507670157 -0.9645258140870074,25.27579244740165 -0.9612172106013335,25.29124202660409 -0.955183503853352,25.306632078379415 -0.9518281192046804,25.33846368595558 -0.938047259436226,25.374340400864735 -0.9272913588945115,25.378488869690692 -0.9251521654428415,25.38268343236509 -0.9238795325112867,25.404182546806645 -0.9123878534790911,25.427140783763917 -0.9041851308474087,25.437087777996386 -0.8982295795713192,25.448583176584915 -0.8937410887303918,25.466189798531126 -0.8827493023612208,25.484225451822855 -0.8749432620501463,25.509310971244997 -0.8576926292333512,25.53837392083365 -0.8427060705644654,25.546783036764744 -0.8361673522413668,25.5555702330196 -0.8314696123025452,25.574422829232276 -0.8159976864387467,25.595331161714768 -0.8034804340438831,25.600116664940703 -0.7991454651352508,25.605938309783095 -0.7955116370847162,25.624274170428556 -0.7786396695282194,25.643684249165982 -0.7652911781639871,25.661998463779753 -0.7465787165393631,25.684069527764475 -0.729416808953626,25.695116884952096 -0.716948820247911,25.707106781186546 -0.7071067811865475,25.72257874518184 -0.6882561177422504,25.740643296986477 -0.6718984347570698,25.741420870749362 -0.6708497060898717,25.742443309873515 -0.6699088980033491,25.75986881602468 -0.6465645191762692,25.779036628812293 -0.626978413479106,25.79102508115589 -0.6087073388921346,25.806464586457874 -0.5912823951288695,25.81814710115728 -0.5718035057601399,25.831469612302545 -0.5555702330196022,25.840754978676745 -0.5381985343782208,25.853401085789624 -0.5212548194243296,25.85519730989787 -0.5175877644159461,25.857492925712545 -0.5144957554275255,25.869526250095216 -0.4890878250616484,25.88521355108241 -0.46518487612998893,25.891824155767573 -0.44895776298178547,25.901390117221936 -0.43300791745027806,25.911410085550997 -0.4060129454059633,25.923879532511286 -0.3826834323650898,25.928122613773713 -0.36869597507903035,25.934993617842228 -0.35466453811214743,25.937541555713825 -0.34544762402521323,25.94138958219105 -0.3373212927494451,25.947924774944624 -0.3112793254149744,25.958238617235295 -0.2859698453316194,25.960764846988717 -0.27304541881202293,25.9656127982688 -0.2599844684197425,25.971542209415414 -0.22556519179511486,25.980785280403232 -0.19509032201612825,25.981717787577743 -0.18562241778565933,25.98441333449074 -0.17587036952489246,25.98567601663774 -0.1608611506079927,25.989109164963317 -0.14718376196296398,25.99037485701207 -0.12162969935129014,25.995376988335092 -0.09604504720681509,25.9953711080915 -0.08724227322657907,25.99694509804366 -0.07810551508514645,25.996359518766514 -0.03694376755534082,26 0,25.999572020933208 0.004345344387477926,25.999959719934076 0.00897543922952386,25.997866662348866 0.02945535107161418,25.998817837224852 0.04860995825414922,25.995254942623717 0.07270792572798829,25.995237806849605 0.09747670397172328,25.994385661566596 0.1018033071688996,25.994319786195412 0.1064338422697801,25.98555754526659 0.1498720543473131,25.981097828286487 0.19351240614374826,25.980865392958172 0.19429809399617176,25.980785280403232 0.19509032201612436,25.974522422658307 0.21573668884253547,25.97368808043921 0.21855756260891296,25.970142500145332 0.24253562503633413,25.962616433312704 0.263601052949679,25.957826285221152 0.2873478855663454,23.177098224213704 9.55643874862649,30.52999894000318 14.152001695994912,30.6765730659824 14.263624493626264,30.800181850636 14.400242544095745,30.89662956393401 14.557218535754364,30.962642421022533 14.729224134665076,30.995979706343796 14.91042084756305,30.995509831641094 15.094658201472038,30.961248746164355 15.27568251304255,30.894359395294828 15.447349161224063,30.79711224596506 15.603831157967637,30.672808218784507 15.739816937313561,30.52566664283362 15.850690649185726,30.360682036346724 15.932688838068078,30.183454574666214 15.983028188321189,30 16,20.618032 16,15.894427190999917 25.447213595499957,15.868243399230641 25.489363512044118,15.8453224450135 25.5342564589749,15.837249093741482 25.544762832549054,15.831469612302547 25.5555702330196,15.813517766840704 25.57744786675073,15.797188509938065 25.603730469350957,15.764192060128185 25.63983667010412,15.733900708082256 25.679256763438072,15.718866023621866 25.692779029671765,15.707106781186548 25.707106781186546,15.689535539552567 25.721527831855468,15.67288297278137 25.739748947238795,15.634369047802885 25.768776008921748,15.597937410913687 25.801542795257895,15.574712681402264 25.815761701534893,15.555570233019603 25.831469612302545,15.540469741810416 25.839543133904463,15.525731112119134 25.85065080835204,15.483165918214018 25.871809495120427,15.441979151447788 25.897025322767142,15.409915390306532 25.9093232919753,15.382683432365091 25.923879532511286,15.371737387165389 25.927198902657043,15.360729159315687 25.932670613678482,15.315655498843492 25.945476419416284,15.271241156999427 25.962511420581393,15.230395620695678 25.970075861390377,15.19509032201613 25.98078528040323,15.189369613182635 25.98135032072592,15.183479408001984 25.98302355355263,15.137527978709176 25.98727460192478,15.091432887621451 25.995811240678275,15.045263278577174 25.995811240678275,15 26,14.954734311182758 25.995811240678275,14.90856711237855 25.995811240678275,14.862472002390396 25.98727459842449,14.816520591998016 25.98302355355263,14.810631845595136 25.981350641727023,14.804909677983872 25.980785280403232,14.769596383631178 25.970074380621565,14.728758843000575 25.962511420581393,14.684337741083892 25.945473826608644,14.639270840684313 25.932670613678482,14.62826496485037 25.927199963325872,14.617316567634912 25.923879532511286,14.590078541578208 25.909320964566042,14.558020848552212 25.897025322767142,14.516830433463278 25.871807261503086,14.474268887880866 25.85065080835204,14.459536619675568 25.839547149776557,14.444429766980399 25.831469612302545,14.425287954709594 25.81576209098248,14.402062589086313 25.801542795257895,14.365614407705712 25.768761128728016,14.32711702721863 25.739748947238795,14.310467592479293 25.7215297042298,14.292893218813454 25.70710678118655,14.281142843925036 25.69278700518534,14.266099291917746 25.679256763438072,14.235803453957478 25.63983083229399,14.202811490061935 25.603730469350957,14.186470361002941 25.577427892614864,14.168530387697455 25.5555702330196,14.162762829278453 25.544778348745158,14.154677554986502 25.5342564589749,14.131745817096583 25.489342391158612,14.105572809000083 25.447213595499957,9.381968 16,7.766188802991196 16),(2.414215765597101 16,9.963197981186548 23.548984418813454,5.43381014173356 16,2.414215765597101 16))
+POLYGON((7.766188802991196 16,15.857492925712544 29.485504244572475,15.940291061129061 29.659628555309375,15.988134057995364 29.846406108749033,15.99924336214535 30.038893485424374,15.973205987343363 30.22993500429259,15.91098986796771 30.412428733795515,15.814907876237157 30.57959050479338,15.68853184163298 30.725206110741972,15.536559768828015 30.843862319620463,15.364641190270532 30.931148109786026,15.179167145906836 30.9838186488513,14.987032597505912 30.99991591970153,14.795380109787638 30.97884150940256,14.611334326959138 30.921378855086058,14.441737115442743 30.829664119825495,14.292893218813452 30.707106781186546,-0.7071067811865475 15.707106781186548,-0.7554688419207334 15.649058956452391,-0.8010159663790529 15.598642983426544,-0.8108044236437141 15.582638368941852,-0.8231722868571226 15.567791674956947,-0.82387353370499 15.56654688613857,-0.8247428766160511 15.56550790221807,-0.838215676583904 15.541084926404501,-0.86153056257408 15.499698608780829,-0.8978176676507933 15.44036738713725,-0.9037504121723406 15.424753104401463,-0.9121719696988269 15.409807634989592,-0.9147281600695789 15.402375638323978,-0.9182731375679747 15.395947527863312,-0.9363041491857993 15.33968758590701,-0.9385408492492481 15.333188783866923,-0.963714928210761 15.266933581895811,-0.9662923888527085 15.252549832205252,-0.971179529001495 15.23834916078819,-0.973316934816207 15.224186901832113,-0.9773694136518997 15.211539663556842,-0.9843331821750986 15.151871571150492,-0.9964394501011175 15.084311459969465,-0.9963330656466809 15.071777323141662,-0.9982548020906185 15.059053789912419,-0.9975946218303362 15.038228850995145,-0.999815675460913 15.019199351620259,-0.9954067020613553 14.962633858598254,-0.9948647985422624 14.89878719141599,-0.992845977328917 14.888527258781146,-0.9925075566829029 14.877816736304295,-0.9867122483957445 14.85106300898269,-0.9847702189226056 14.82613909029594,-0.9704745529536821 14.774832541528266,-0.9590451757709032 14.716746843211665,-0.9559426936284632 14.708981116876505,-0.9541267616351028 14.700597056240738,-0.9410472220493528 14.669212388824093,-0.9327972280488767 14.63959837494216,-0.9104921370590819 14.59521524558582,-0.8902135553050953 14.544456559754108,-0.8868470544168822 14.539156431191405,-0.8843743736668266 14.533221715156534,-0.8621869358674266 14.499091075785113,-0.8458456188082695 14.466572226873351,-0.8176508191517764 14.430215737236969,-0.7907392408580822 14.38784687130818,-0.7878861388539616 14.384794572793407,-0.785543844349249 14.381193997601024,-0.752865464217139 14.346674818878263,-0.7271759574466495 14.313548889642133,-0.6953129290063224 14.285758130872422,-0.6640463107967063 14.25230855487221,-0.6623607194638322 14.251070977227958,-0.6608847116458089 14.249512559790082,-0.6168428149128343 14.217320200010395,-0.5812381937190965 14.186266528793265,2.8675247064990304 11.72286207761168,-0.8574929257125442 5.514495755427527,-0.941389582191051 5.337321292749447,-0.9891091649633164 5.147183761962967,-0.9988178372248515 4.951390041745853,-0.9701425001453321 4.757464374963668,-0.9041851308474095 4.5728592162360835,-0.803480434043884 4.404668838285235,-0.6718984347570707 4.259356703013523,-0.5144957554275268 4.142507074287456,-0.33732129274944656 4.058610417808949,-0.14718376196296545 4.010890835036683,0.048609958254147725 4.001182162775148,0.24253562503633266 4.029857499854668,0.4271407837639169 4.095814869152591,0.595331161714765 4.196519565956116,0.7406432969864766 4.328101565242929,0.8574929257125442 4.485504244572473,4.500193301269526 10.556670008917294,5.8926149262809036 9.562085728793265,4.01941932430908 0.19611613513818404,4.019364011415901 0.19558247118801225,4.01921471959677 0.19509032201612922,4.019137935231209 0.19431071726948748,4.018902171713515 0.19351240614374693,4.009155651172691 0.09815646983708545,4.000065081195405 0.01140868770929469,4.000165105596132 0.010196680723664094,4.000040280065924 0.008975439229522573,4.000428326367366 0.00436158653136523,4 7.657137397853899e-16,4.00545072963838 -0.05535455764278931,4.0080943951090005 -0.08678761864427449,4.015200021200573 -0.1736922616487226,4.015493646128988 -0.17476437336656656,4.01558666550926 -0.17587036952489368,4.018283465640281 -0.1856270449971804,4.01921471959677 -0.19509032201612772,4.038172450076035 -0.2575828285870997,4.041119982788788 -0.26824662224072504,4.064302118633197 -0.3528023168938607,4.064743623816964 -0.3537139122836271,4.065006382157773 -0.35466453811214854,4.071873782635128 -0.368685946059979,4.076120467488713 -0.38268343236508945,4.107307172087979 -0.4410315170123408,4.107422252034378 -0.4412664797002449,4.145677772041797 -0.5197437164762374,4.146209767987875 -0.5204602861864557,4.146598914210377 -0.5212548194243305,4.159238505438738 -0.5381885293167137,4.168530387697455 -0.5555702330196022,4.209095109599697 -0.6050009774937036,4.25652021894709 -0.6687584131549427,4.257088491708935 -0.6692816359320028,4.257556690126487 -0.6699088980033499,4.277193438933862 -0.6879773162680687,4.292893218813452 -0.7071067811865476,4.339754090104229 -0.7455650629755607,4.393006345087573 -0.7947066772690753,4.393567486568954 -0.7950569040580475,4.394061690216905 -0.7955116370847167,4.421438254330118 -0.8126015459178574,4.444429766980398 -0.8314696123025455,4.494473810690519 -0.8582184474291166,4.550428549089282 -0.8932443733525736,4.550935683057345 -0.8934407353034348,4.551416823415085 -0.8937410887303923,4.586726182533162 -0.9075296677259079,4.61731656763491 -0.9238795325112867,4.667599723331613 -0.9391336576331688,4.723357114358982 -0.9609727955692661,4.723784320347855 -0.9610519351201247,4.724207552598352 -0.9612172106013338,4.767072421995017 -0.9693068936544817,4.804909677983872 -0.9807852804032304,4.852743132658768 -0.9854948903210408,4.905827487762359 -0.9955558939300452,4.906168420866411 -0.9955578203613323,4.906488206986212 -0.9956181720756941,4.955908646297231 -0.9956560238258106,5 -1,5.043271057890442 -0.9957366733947699,5.091546005578183 -0.9958008479925488,5.091751554664334 -0.9957600676565473,5.091986570668903 -0.995760247658328,5.146373879422239 -0.9855822437255954,5.195090322016128 -0.9807852804032304,5.232197555352073 -0.9695270804392745,5.274106970946535 -0.9616992089414005,5.274207949785685 -0.9616594628283592,5.2743197074438255 -0.9616385485763005,5.331562681725897 -0.9393857202290141,5.38268343236509 -0.9238795325112867,5.412638489155523 -0.9078680353344648,5.447213595499958 -0.8944271909999159,15.000000795499957 3.8819664090000843,24.552786404500043 -0.8944271909999159,24.587352624667037 -0.9078642527064811,24.61731656763491 -0.9238795325112867,24.634455891057762 -0.9290780159482773,24.651848488083576 -0.9374382778350313,24.65761039054385 -0.938989604117241,24.662678707250556 -0.9413895821910518,24.69347401846947 -0.9491195479721178,24.725680292556177 -0.961638548576301,24.72973355812785 -0.9623971089926734,24.733439590443513 -0.9638182131797879,24.770065620097938 -0.9702158273646265,24.804909677983872 -0.9807852804032304,24.817224043199207 -0.9819970765225351,24.83005135234607 -0.9854529198092623,24.841978822598662 -0.9863892551122224,24.852816238037036 -0.9891091649633167,24.87956190680171 -0.9904358656082217,24.9080134293311 -0.9957602476583283,24.916288736962514 -0.9957539990794801,24.924075646998674 -0.9971135806021948,24.962534936459928 -0.9963105819186819,25 -1,25.006792781673234 -0.9993309694003044,25.014042950796863 -0.9999013929047789,25.031911508874817 -0.9979909059661792,25.04860995825415 -0.9988178372248515,25.07012517067658 -0.9956368486213135,25.09351179301379 -0.995618172075694,25.10571507487357 -0.9933152993370914,25.11755512277557 -0.9930663588649152,25.155540188269292 -0.9847813014406579,25.167628038646118 -0.983489619662504,25.195090322016128 -0.9807852804032304,25.19625643190191 -0.9804313992203624,25.197556222938477 -0.9802915580470347,25.22057263809812 -0.973390115915728,25.242535625036336 -0.9701425001453315,25.258259507670157 -0.9645258140870074,25.27579244740165 -0.9612172106013335,25.29124202660409 -0.955183503853352,25.306632078379415 -0.9518281192046804,25.33846368595558 -0.938047259436226,25.374340400864735 -0.9272913588945115,25.378488869690692 -0.9251521654428415,25.38268343236509 -0.9238795325112867,25.404182546806645 -0.9123878534790911,25.427140783763917 -0.9041851308474087,25.437087777996386 -0.8982295795713192,25.448583176584915 -0.8937410887303918,25.466189798531126 -0.8827493023612208,25.484225451822855 -0.8749432620501463,25.509310971244997 -0.8576926292333512,25.53837392083365 -0.8427060705644656,25.546783036764744 -0.8361673522413671,25.5555702330196 -0.8314696123025452,25.574422829232276 -0.8159976864387467,25.595331161714768 -0.8034804340438831,25.600116664940703 -0.7991454651352509,25.605938309783095 -0.7955116370847162,25.624274170428553 -0.7786396695282194,25.643684249165982 -0.7652911781639871,25.66199846377975 -0.7465787165393634,25.68406952776447 -0.7294168089536263,25.695116884952093 -0.7169488202479112,25.707106781186546 -0.7071067811865475,25.72257874518184 -0.6882561177422504,25.740643296986477 -0.6718984347570698,25.741420870749362 -0.6708497060898717,25.742443309873515 -0.6699088980033491,25.759868816024678 -0.6465645191762693,25.779036628812293 -0.626978413479106,25.791025081155887 -0.6087073388921347,25.80646458645787 -0.5912823951288696,25.818147101157276 -0.57180350576014,25.831469612302545 -0.5555702330196022,25.840754978676745 -0.5381985343782208,25.853401085789624 -0.5212548194243296,25.85519730989787 -0.5175877644159461,25.857492925712545 -0.5144957554275255,25.869526250095216 -0.4890878250616484,25.88521355108241 -0.46518487612998893,25.891824155767573 -0.44895776298178547,25.901390117221936 -0.43300791745027806,25.911410085550997 -0.40601294540596333,25.923879532511286 -0.3826834323650898,25.928122613773713 -0.36869597507903035,25.934993617842228 -0.35466453811214743,25.937541555713825 -0.34544762402521323,25.94138958219105 -0.3373212927494451,25.947924774944624 -0.3112793254149744,25.958238617235295 -0.2859698453316194,25.960764846988717 -0.273045418812023,25.9656127982688 -0.25998446841974254,25.971542209415414 -0.22556519179511492,25.980785280403232 -0.19509032201612825,25.981717787577743 -0.18562241778565933,25.98441333449074 -0.17587036952489246,25.98567601663774 -0.1608611506079927,25.989109164963317 -0.14718376196296398,25.99037485701207 -0.12162969935129017,25.995376988335092 -0.09604504720681514,25.9953711080915 -0.08724227322657913,25.99694509804366 -0.0781055150851465,25.996359518766514 -0.03694376755534087,26 0,25.999572020933208 0.004345344387477926,25.999959719934076 0.00897543922952386,25.997866662348866 0.02945535107161418,25.998817837224852 0.04860995825414922,25.995254942623717 0.07270792572798823,25.995237806849605 0.09747670397172323,25.994385661566596 0.10180330716889954,25.994319786195412 0.10643384226978005,25.98555754526659 0.14987205434731304,25.981097828286487 0.19351240614374826,25.980865392958172 0.19429809399617176,25.980785280403232 0.19509032201612436,25.974522422658307 0.21573668884253547,25.97368808043921 0.21855756260891296,25.970142500145332 0.24253562503633413,25.962616433312704 0.263601052949679,25.957826285221152 0.2873478855663454,23.177098224213704 9.55643874862649,30.52999894000318 14.152001695994912,30.6765730659824 14.263624493626264,30.800181850636 14.400242544095745,30.89662956393401 14.557218535754364,30.962642421022533 14.729224134665076,30.995979706343796 14.91042084756305,30.995509831641094 15.094658201472038,30.961248746164355 15.27568251304255,30.894359395294828 15.447349161224063,30.79711224596506 15.603831157967637,30.672808218784507 15.739816937313561,30.52566664283362 15.850690649185726,30.360682036346724 15.932688838068078,30.183454574666214 15.983028188321189,30 16,20.618032 16,15.894427190999917 25.447213595499957,15.868243399230641 25.489363512044118,15.8453224450135 25.5342564589749,15.837249093741482 25.544762832549054,15.831469612302547 25.5555702330196,15.813517766840704 25.57744786675073,15.797188509938065 25.603730469350957,15.764192060128185 25.63983667010412,15.733900708082256 25.679256763438072,15.718866023621866 25.692779029671765,15.707106781186548 25.707106781186546,15.689535539552567 25.721527831855468,15.67288297278137 25.739748947238795,15.634369047802885 25.768776008921748,15.597937410913687 25.801542795257895,15.574712681402264 25.815761701534893,15.555570233019603 25.831469612302545,15.540469741810416 25.839543133904463,15.525731112119134 25.85065080835204,15.483165918214018 25.871809495120427,15.441979151447788 25.897025322767142,15.409915390306532 25.9093232919753,15.382683432365091 25.923879532511286,15.371737387165389 25.927198902657043,15.360729159315687 25.932670613678482,15.315655498843492 25.945476419416284,15.271241156999427 25.962511420581393,15.230395620695678 25.970075861390377,15.19509032201613 25.98078528040323,15.189369613182635 25.98135032072592,15.183479408001984 25.98302355355263,15.137527978709176 25.98727460192478,15.091432887621451 25.995811240678275,15.045263278577174 25.995811240678275,15 26,14.954734311182758 25.995811240678275,14.90856711237855 25.995811240678275,14.862472002390396 25.98727459842449,14.816520591998016 25.98302355355263,14.810631845595136 25.981350641727023,14.804909677983872 25.980785280403232,14.769596383631178 25.970074380621565,14.728758843000575 25.962511420581393,14.684337741083892 25.945473826608644,14.639270840684313 25.932670613678482,14.62826496485037 25.927199963325872,14.617316567634912 25.923879532511286,14.590078541578208 25.909320964566042,14.558020848552212 25.897025322767142,14.516830433463278 25.871807261503086,14.474268887880866 25.85065080835204,14.459536619675568 25.839547149776557,14.444429766980399 25.831469612302545,14.425287954709594 25.81576209098248,14.402062589086313 25.801542795257895,14.365614407705712 25.768761128728016,14.32711702721863 25.739748947238795,14.310467592479293 25.7215297042298,14.292893218813454 25.70710678118655,14.281142843925036 25.69278700518534,14.266099291917746 25.679256763438072,14.235803453957478 25.63983083229399,14.202811490061935 25.603730469350957,14.186470361002941 25.577427892614864,14.168530387697455 25.5555702330196,14.162762829278453 25.544778348745158,14.154677554986502 25.5342564589749,14.131745817096583 25.489342391158612,14.105572809000083 25.447213595499957,9.381968 16,7.766188802991196 16),(2.414215765597101 16,9.963197981186548 23.548984418813454,5.43381014173356 16,2.414215765597101 16))
SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'), 0));
ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'), 0))
GEOMETRYCOLLECTION()
@@ -366,7 +366,7 @@
POLYGON((6.128431095930864e-14 -1000,4.999998615178201 -999.5075428468211,10.00000000000006 -1000,205.09032201612834 -980.7852804032304,392.68343236508986 -923.8795325112867,565.5702330196023 -831.4696123025452,717.1067811865476 -707.1067811865474,841.4696123025452 -555.5702330196021,933.8795325112867 -382.6834323650898,937.8394676562176 -369.6292568486508,938.8795325112867 -367.6834323650898,995.7852804032304 -180.09032201612825,1015 15,995.7852804032304 210.09032201612825,938.8795325112867 397.6834323650898,846.4696123025452 570.5702330196021,722.1067811865476 722.1067811865474,570.5702330196023 846.4696123025452,397.68343236508986 938.8795325112867,210.09032201612834 995.7852804032304,15 1015,10 1015,-185.09032201612712 995.7852804032307,-372.68343236508866 938.8795325112872,-381.19052388386365 934.332401347996,-382.68343236508866 933.8795325112872,-555.5702330196012 841.4696123025459,-707.1067811865468 717.1067811865482,-831.4696123025448 565.5702330196028,-923.8795325112865 392.68343236509025,-980.7852804032304 205.0903220161286,-1000 10,-1000 0,-980.7852804032306 -195.09032201612771,-923.8795325112868 -382.68343236508946,-831.4696123025453 -555.5702330196021,-707.1067811865474 -707.1067811865476,-555.5702330196019 -831.4696123025454,-382.68343236508974 -923.8795325112867,-195.0903220161282 -980.7852804032304,6.128431095930864e-14 -1000))
SELECT ST_ASTEXT(ST_BUFFER(g, 20)) FROM gis_geometrycollection WHERE fid=115;
ST_ASTEXT(ST_BUFFER(g, 20))
-POLYGON((44.99142143580823 0.08708954433931228,44.99919439868154 0.1795087845904661,44.90536466789184 1.0974947498201928,44.90487037907816 1.790444027015923,46.003637012720034 3.0048508819149156,47.93259127868019 6.144370715087325,49.25284842045066 9.58448269330154,49.91959412687596 13.208416951261013,49.91019663282188 16.893164029440783,49.22497492328709 20.513650260851016,47.887187905896525 23.946983224481265,45.94224491930119 27.07662315935276,43.456164375690136 29.796338746271246,40.5133328566724 32.013812983714516,37.21364072693446 33.653776761361556,33.66909149332426 34.66056376642378,32.368805398570764 34.780856273541055,32.36506464622715 34.786885059736214,31.906448900269943 35.68512917949808,31.744800828344903 35.89549142890284,31.629392246050944 36.11140466039198,31.27046588856195 36.548756232135446,30.943770198761275 37.07460938701918,30.283891793358453 37.79666756501281,29.678014161645084 38.585135268761455,29.37725784807266 38.85563691808474,29.142135623730997 39.1421356237309,28.790704589094087 39.430552416442005,28.457659455627365 39.794978944775934,27.68748957958961 40.37542248191712,26.95874821827371 41.030855905157885,26.4940805426645 41.315339998985024,26.11140466039206 41.62939224605089,25.809571767256706 41.790726751231034,25.51462224238267 42.013016167040796,24.663337598150505 42.43617812683128,23.83958302895573 42.940506455342835,23.19836354127304 43.186444462442324,22.653668647301817 43.47759065022572,22.434619503488477 43.54403567925368,22.214583186313718 43.653412273569664,21.313397688590904 43.909418037270164,20.424823139988483 44.25022841162789,19.607877094904058 44.40152376875622,18.901806440322588 44.6157056080646,18.787530821942248 44.62696541840738,18.669588160039673 44.66047107105261,17.75047645585635 44.745507431699444,16.828657752428988 44.91622481356548,15.905400746085395 44.91622481356548,14.999999999999996 45,14.094597528871859 44.91622481356548,13.171342247570983 44.91622481356548,12.249528776390832 44.74550840069209,11.330411839960322 44.66047107105261,11.212470461247811 44.62696605490229,11.09819355967748 44.615705608064616,10.392106873818962 44.40152079982359,9.57517686001149 44.25022841162788,8.686617083145592 43.9094237029299,7.785416813686275 43.653412273569664,7.5653903271197525 43.544040571136485,7.346331352698226 43.47759065022574,6.801628327780507 43.18644134383971,6.160416971044246 42.94050645534282,5.336647976679458 42.43616929529071,4.4853777576173215 42.013016167040796,4.1903983924768475 41.790704250241504,3.888595339607985 41.62939224605093,3.5059356740207304 41.315349927347256,3.0412517817262703 41.030855905157864,2.3125274238015914 40.3754377748475,1.5423405443726317 39.794978944775934,1.209266843756315 39.43052220517743,0.8578643762690632 39.142135623730965,0.6227201077545745 38.855617091451606,0.32198583835490346 38.58513526876144,-0.28389179335846704 37.7966675650128,-0.9437701987612783 37.07460938701918,-1.270441025287576 36.54879500957307,-1.6293922460508945 36.111404660392054,-1.7448043622482214 35.89548726743415,-1.9064489002699538 35.68512917949806,-2.3650840754462186 34.78684700569657,-2.3698276848733286 34.779211652637734,-3.6946187793193386 34.655782662501665,-3.775082174065882 34.63276058259242,-3.8547162514053923 34.62501369734939,-4.987651245821263 34.28578886333544,-7.262062374709823 33.63497920755008,-7.411800985918605 33.559951187157075,-7.564885923322593 33.514116262115124,-8.763121016707359 32.8828588459831,-10.57953319256336 31.97272745988252,-10.77963013190783 31.820520264263795,-10.991382735003757 31.708964826483456,-12.066693650037198 30.841493152107933,-13.532838135664944 29.72624500658238,-13.7577564224961 29.477283641474113,-14.005717749403244 29.277250096711583,-14.880172718815652 28.23488446936388,-16.020319327581063 26.972859668530845,-16.23937019454467 26.614700605922796,-16.494857532321056 26.31015804436133,-17.13130254957483 25.156346842636992,-17.956353353015867 23.80734774274502,-18.135510884004994 23.335826285357133,-18.365462751359516 22.91895055726617,-18.750921331524832 21.716138686939072,-19.274298564215222 20.338671637916217,-19.3782397572389 19.75861851172726,-19.547388273038003 19.230793271136793,-19.68664090064202 18.03755834157436,-19.928789002022352 16.686229199389274,-19.92306352201266 16.011657428293795,-19.99631350921826 15.38398703240515,-19.908132453663804 14.252490126444698,-19.897295970845246 12.97574382831976,-19.750486976625883 12.229639923267236,-19.695404378452107 11.522781805918768,-19.40945589647874 10.496472129324916,-19.180903515418063 9.33493686423328,-18.86674279818378 8.548570966449264,-18.655944560977527 7.7919674988431815,-18.209767383097695 6.904116285245678,-17.8042711061019 5.889131195082161,-17.3035202855764 5.100762555122197,-16.916912376165385 4.3314445374670125,-16.352989586998877 3.604270767667531,-15.814784817161637 2.756937426163592,-15.116824121042253 2.010248254709561,-14.848255361665638 1.6639284367623786,-14.998698376091898 0.2281737541858938,-14.99670846136665 0.20383701385793263,-14.999194398681535 0.17950878459045144,-14.991421228170294 0.08708614429420458,-15 1.53142747957078e-14,-14.891134890674147 -1.1053138016005306,-14.83826226433565 -1.73396689991273,-14.695999575988537 -3.473845232974452,-14.6901291671827 -3.4952626201516224,-14.688266689814796 -3.5174073904978735,-14.634358306921914 -3.7124409753273464,-14.615705608064612 -3.9018064403225545,-14.236373351236756 -5.152299276580968,-14.173864500249303 -5.378448247064442,-13.713957627336061 -7.0560463378772145,-13.705198449934795 -7.0740216435496395,-13.699872356844537 -7.093290762242971,-13.562509521576573 -7.373749191384208,-13.477590650225736 -7.653668647301789,-12.854005496233027 -8.820326248420503,-12.844682981004798 -8.839360348666425,-12.086444559164068 -10.394874329524749,-12.075837401574487 -10.409138833789887,-12.068021715792472 -10.42509638848661,-11.81516725435086 -10.76385450318256,-11.629392246050905 -11.111404660392044,-10.818436655513999 -12.099565097434924,-9.8695956210582 -13.375168263098853,-9.858171497796695 -13.38571131827911,-9.848866197470263 -13.398177960066997,-9.45608514720707 -13.759588719670198,-9.14213562373095 -14.142135623730951,-8.205218264249334 -14.911041415160526,-7.139873098248529 -15.894133545381505,-7.128587901452543 -15.901195467243294,-7.118766195661898 -15.910232741694335,-6.571159808812139 -16.252077802637945,-6.11140466039204 -16.62939224605091,-5.110767215426415 -17.16424182225962,-3.9914290182143635 -17.86488746705147,-3.9810956351153584 -17.868933753494762,-3.971663531698301 -17.874821774607845,-3.2653245560669846 -18.150652630969034,-2.653668647301794 -18.477590650225736,-1.648532332079009 -18.782495206743707,-0.5328577128203715 -19.219455911385317,-0.5241308107303018 -19.221110080315295,-0.5158489480329749 -19.224344212026672,0.34135704380619547 -19.386120624339213,1.0981935596774361 -19.61570560806461,2.055222176789106 -19.70996514575438,3.1165497552471773 -19.911117878600905,3.1231792045326294 -19.911120697995113,3.129764139724236 -19.912363441513882,4.117865036817867 -19.91312024069997,5.000000000000001 -20,5.86565891032072 -19.914741893486323,6.830920111563659 -19.916016959850975,6.835275068231986 -19.915201539994495,6.839731413378058 -19.915204953166562,7.92721651699825 -19.711693731244672,8.901806440322567 -19.61570560806461,9.644122622451397 -19.390523682089984,10.482139418930693 -19.233984178828013,10.48423296512005 -19.233175413982842,10.48639414887651 -19.232770971526012,11.631020229351321 -18.787805139297916,12.653668647301796 -18.477590650225736,13.252760073258568 -18.157369081552364,13.94427190999916 -17.88854381999832,15.000001034273785 -17.36068029213479,16.05572809000084 -17.88854381999832,16.747236774227474 -18.157366180290687,17.346331352698208 -18.477590650225736,17.689033432258068 -18.58154671110643,18.036969761671553 -18.748765556700626,18.791543359698245 -18.95207643670473,19.513605851123483 -19.23277097152601,19.594916508683635 -19.247987408137078,19.668791808870285 -19.276364263595752,20.40124334551601 -19.40428842892621,21.098193559677437 -19.61570560806461,21.344648853543447 -19.63998034171071,21.601027046921402 -19.709058396185245,22.38962089548151 -19.770985011857633,23.160268586621935 -19.915204953166562,23.32582306082849 -19.915078159378893,23.48151293997342 -19.942271612043896,24.250562251999956 -19.926185270107766,25 -20,25.135728804204593 -19.986631087932036,25.280859015937267 -19.998027858095575,26.07680280094823 -19.912975011519617,26.87023586027576 -19.912363441513882,27.114439495596734 -19.866276857587046,27.351102455511384 -19.861327177298307,28.110921710511906 -19.695613425449828,28.351273745645393 -19.669929922225858,28.901806440322567 -19.61570560806461,28.925262636633487 -19.60859024870365,28.951124458769538 -19.605831160940696,29.72700731871155 -19.37322015141297,30.515848948032968 -19.224344212026676,30.82475240375357 -19.103715192807627,31.132641567588323 -19.03656238409361,31.769298348141273 -18.760937804899257,32.48680801729469 -18.54582717789023,32.56980319269134 -18.503030005444877,32.6536686473018 -18.477590650225736,33.265338781301715 -18.150646274250512,33.9716635316983 -17.874821774607845,34.323678225817794 -17.655074984499883,34.684509036457115 -17.49886524100293,35.18627058344445 -17.153826204325732,35.767478416673015 -16.854121411289313,35.93573315466416 -16.72329073333625,36.11140466039205 -16.629392246050905,36.571163790410544 -16.252075767125476,37.118766195661905 -15.910232741694333,37.48564289711332 -15.57265883911943,37.87368498331968 -15.305823563279748,38.239780629381976 -14.931721017366458,38.68139055528946 -14.588336179072526,38.902464791358476 -14.33883296924404,39.14213562373095 -14.14213562373095,39.456087912750775 -13.75958751826526,39.848866197470265 -13.398177960066992,40.197238077336785 -12.931450994866598,40.580732576245865 -12.539568269582125,40.820647529276094 -12.173982108926538,41.12929172915745 -11.825647902577392,41.36293794414533 -11.436076916340818,41.629392246050905 -11.111404660392044,41.81514237382953 -10.763885982827006,42.068021715792476 -10.425096388486605,42.36124984554748 -9.826399582995583,42.704271021648154 -9.303697522599784,42.83658440223999 -8.97898637852165,43.0278023444387 -8.660158349005561,43.22821710622332 -8.120217431632407,43.477590650225736 -7.653668647301796,43.56249254091766 -7.373783752855211,43.699872356844544 -7.0932907622429635,43.900055892670444 -6.369055881398854,44.164772344705895 -5.71939690663239,44.215347881881264 -5.460771132218529,44.31225596537602 -5.19968936839485,44.43088382318973 -4.511073761799768,44.61570560806461 -3.9018064403225647,44.63434901028023 -3.712475510554375,44.688266689814796 -3.517407390497862,44.75839154884828 -2.683627649484361,44.907539766701866 -1.9209009441363016,44.90741064201048 -1.7449123352285618,44.93890196087321 -1.5621103017029268,44.927195501582744 -0.7392356874710413,45 0,44.99142143580823 0.08708954433931228))
+POLYGON((44.99142143580823 0.08708954433931212,44.99919439868154 0.1795087845904661,44.90536466789184 1.097494749820192,44.90487037907816 1.790444027015923,46.003637012720034 3.0048508819149156,47.93259127868019 6.144370715087325,49.25284842045066 9.58448269330154,49.91959412687596 13.208416951261013,49.91019663282188 16.893164029440783,49.22497492328709 20.513650260851016,47.887187905896525 23.946983224481265,45.94224491930119 27.07662315935276,43.456164375690136 29.796338746271246,40.5133328566724 32.013812983714516,37.21364072693446 33.653776761361556,33.66909149332426 34.66056376642378,32.368805398570764 34.780856273541055,32.36506464622715 34.786885059736214,31.906448900269943 35.68512917949808,31.744800828344903 35.89549142890284,31.629392246050944 36.11140466039198,31.27046588856195 36.548756232135446,30.943770198761275 37.07460938701918,30.283891793358453 37.79666756501281,29.678014161645084 38.585135268761455,29.37725784807266 38.85563691808474,29.142135623730997 39.1421356237309,28.790704589094087 39.430552416442005,28.457659455627365 39.794978944775934,27.68748957958961 40.37542248191712,26.95874821827371 41.030855905157885,26.4940805426645 41.315339998985024,26.11140466039206 41.62939224605089,25.809571767256706 41.790726751231034,25.51462224238267 42.013016167040796,24.663337598150505 42.43617812683128,23.83958302895573 42.940506455342835,23.19836354127304 43.186444462442324,22.653668647301817 43.47759065022572,22.434619503488477 43.54403567925368,22.214583186313718 43.653412273569664,21.313397688590904 43.909418037270164,20.424823139988483 44.25022841162789,19.607877094904058 44.40152376875622,18.901806440322588 44.6157056080646,18.787530821942248 44.62696541840738,18.669588160039673 44.66047107105261,17.75047645585635 44.745507431699444,16.828657752428988 44.91622481356548,15.905400746085395 44.91622481356548,14.999999999999996 45,14.094597528871859 44.91622481356548,13.171342247570983 44.91622481356548,12.249528776390832 44.74550840069209,11.330411839960322 44.66047107105261,11.212470461247811 44.62696605490229,11.09819355967748 44.615705608064616,10.392106873818962 44.40152079982359,9.57517686001149 44.25022841162788,8.686617083145592 43.9094237029299,7.785416813686275 43.653412273569664,7.5653903271197525 43.544040571136485,7.346331352698226 43.47759065022574,6.801628327780507 43.18644134383971,6.160416971044246 42.94050645534282,5.336647976679458 42.43616929529071,4.4853777576173215 42.013016167040796,4.1903983924768475 41.790704250241504,3.888595339607985 41.62939224605093,3.5059356740207304 41.315349927347256,3.0412517817262703 41.030855905157864,2.3125274238015914 40.3754377748475,1.5423405443726317 39.794978944775934,1.209266843756315 39.43052220517743,0.8578643762690632 39.142135623730965,0.6227201077545745 38.855617091451606,0.32198583835490346 38.58513526876144,-0.28389179335846704 37.7966675650128,-0.9437701987612783 37.07460938701918,-1.270441025287576 36.54879500957307,-1.6293922460508945 36.111404660392054,-1.7448043622482214 35.89548726743415,-1.9064489002699538 35.68512917949806,-2.3650840754462186 34.78684700569657,-2.3698276848733286 34.779211652637734,-3.6946187793193386 34.655782662501665,-3.775082174065882 34.63276058259242,-3.8547162514053923 34.62501369734939,-4.987651245821263 34.28578886333544,-7.262062374709823 33.63497920755008,-7.411800985918605 33.559951187157075,-7.564885923322593 33.514116262115124,-8.763121016707359 32.8828588459831,-10.57953319256336 31.97272745988252,-10.77963013190783 31.820520264263795,-10.991382735003757 31.708964826483456,-12.066693650037195 30.841493152107937,-13.532838135664937 29.72624500658239,-13.757756422496096 29.47728364147412,-14.005717749403244 29.277250096711583,-14.880172718815647 28.23488446936389,-16.02031932758106 26.972859668530855,-16.239370194544666 26.614700605922806,-16.494857532321056 26.31015804436133,-17.131302549574826 25.156346842637,-17.956353353015867 23.807347742745026,-18.135510884004994 23.33582628535714,-18.365462751359516 22.91895055726617,-18.75092133152483 21.71613868693908,-19.27429856421522 20.338671637916228,-19.378239757238898 19.75861851172727,-19.547388273038003 19.230793271136793,-19.686640900642015 18.03755834157437,-19.92878900202235 16.686229199389285,-19.92306352201266 16.011657428293805,-19.99631350921826 15.38398703240515,-19.908132453663804 14.252490126444705,-19.89729597084525 12.975743828319768,-19.750486976625886 12.229639923267243,-19.695404378452107 11.522781805918768,-19.40945589647874 10.496472129324925,-19.180903515418063 9.334936864233288,-18.86674279818378 8.548570966449272,-18.655944560977527 7.7919674988431815,-18.2097673830977 6.904116285245687,-17.804271106101904 5.88913119508217,-17.303520285576404 5.1007625551222056,-16.916912376165385 4.3314445374670125,-16.352989586998877 3.604270767667531,-15.814784817161645 2.756937426163601,-15.116824121042255 2.0102482547095635,-14.848255361665638 1.6639284367623786,-14.998698376091898 0.2281737541858938,-14.99670846136665 0.20383701385793263,-14.999194398681535 0.17950878459045144,-14.991421228170294 0.08708614429420458,-15 1.53142747957078e-14,-14.891134890674147 -1.1053138016005306,-14.83826226433565 -1.73396689991273,-14.695999575988537 -3.473845232974452,-14.6901291671827 -3.4952626201516224,-14.688266689814796 -3.5174073904978735,-14.634358306921914 -3.7124409753273464,-14.615705608064612 -3.9018064403225545,-14.236373351236756 -5.152299276580968,-14.173864500249303 -5.378448247064442,-13.713957627336061 -7.0560463378772145,-13.705198449934795 -7.0740216435496395,-13.699872356844537 -7.093290762242971,-13.562509521576573 -7.373749191384208,-13.477590650225736 -7.653668647301789,-12.854005496233027 -8.820326248420503,-12.844682981004798 -8.839360348666425,-12.086444559164068 -10.394874329524749,-12.075837401574487 -10.409138833789887,-12.068021715792472 -10.42509638848661,-11.81516725435086 -10.76385450318256,-11.629392246050905 -11.111404660392044,-10.818436655513999 -12.099565097434924,-9.8695956210582 -13.375168263098853,-9.858171497796695 -13.38571131827911,-9.848866197470263 -13.398177960066997,-9.45608514720707 -13.759588719670198,-9.14213562373095 -14.142135623730951,-8.205218264249334 -14.911041415160526,-7.139873098248529 -15.894133545381505,-7.128587901452543 -15.901195467243294,-7.118766195661898 -15.910232741694335,-6.571159808812139 -16.252077802637945,-6.11140466039204 -16.62939224605091,-5.110767215426415 -17.16424182225962,-3.9914290182143635 -17.86488746705147,-3.9810956351153584 -17.868933753494762,-3.971663531698301 -17.874821774607845,-3.2653245560669846 -18.150652630969034,-2.653668647301794 -18.477590650225736,-1.648532332079009 -18.782495206743707,-0.5328577128203715 -19.219455911385317,-0.5241308107303018 -19.221110080315295,-0.5158489480329749 -19.224344212026672,0.34135704380619547 -19.386120624339213,1.0981935596774361 -19.61570560806461,2.055222176789106 -19.70996514575438,3.1165497552471773 -19.911117878600905,3.1231792045326294 -19.911120697995113,3.129764139724236 -19.912363441513882,4.117865036817867 -19.91312024069997,5.000000000000001 -20,5.86565891032072 -19.914741893486323,6.830920111563659 -19.916016959850975,6.835275068231986 -19.915201539994495,6.839731413378058 -19.915204953166562,7.92721651699825 -19.711693731244672,8.901806440322567 -19.61570560806461,9.644122622451397 -19.390523682089984,10.482139418930693 -19.233984178828013,10.48423296512005 -19.233175413982842,10.48639414887651 -19.232770971526012,11.631020229351321 -18.787805139297916,12.653668647301796 -18.477590650225736,13.252760073258568 -18.157369081552364,13.94427190999916 -17.88854381999832,15.000001034273785 -17.36068029213479,16.05572809000084 -17.88854381999832,16.74723677422747 -18.157366180290687,17.346331352698208 -18.477590650225736,17.689033432258064 -18.58154671110643,18.03696976167155 -18.748765556700626,18.79154335969824 -18.95207643670473,19.513605851123483 -19.23277097152601,19.594916508683635 -19.247987408137078,19.668791808870285 -19.276364263595752,20.401243345516004 -19.40428842892621,21.098193559677437 -19.61570560806461,21.34464885354344 -19.63998034171071,21.601027046921395 -19.709058396185245,22.389620895481507 -19.770985011857633,23.160268586621935 -19.915204953166562,23.32582306082849 -19.915078159378893,23.48151293997342 -19.942271612043896,24.25056225199995 -19.926185270107766,25 -20,25.135728804204586 -19.986631087932036,25.280859015937263 -19.998027858095575,26.076802800948226 -19.912975011519617,26.87023586027576 -19.912363441513882,27.11443949559673 -19.866276857587046,27.351102455511384 -19.861327177298307,28.1109217105119 -19.695613425449828,28.351273745645386 -19.669929922225858,28.901806440322567 -19.61570560806461,28.925262636633487 -19.60859024870365,28.95112445876953 -19.605831160940696,29.727007318711543 -19.37322015141297,30.515848948032968 -19.224344212026676,30.824752403753568 -19.103715192807627,31.132641567588323 -19.03656238409361,31.769298348141266 -18.760937804899257,32.486808017294685 -18.54582717789023,32.56980319269133 -18.503030005444877,32.6536686473018 -18.477590650225736,33.265338781301715 -18.150646274250512,33.9716635316983 -17.874821774607845,34.323678225817794 -17.655074984499883,34.684509036457115 -17.49886524100293,35.18627058344445 -17.153826204325732,35.767478416673015 -16.854121411289313,35.93573315466416 -16.72329073333625,36.11140466039205 -16.629392246050905,36.571163790410544 -16.252075767125476,37.118766195661905 -15.910232741694333,37.48564289711332 -15.572658839119432,37.87368498331968 -15.305823563279748,38.23978062938197 -14.93172101736646,38.681390555289454 -14.588336179072527,38.90246479135847 -14.338832969244041,39.14213562373095 -14.14213562373095,39.45608791275077 -13.75958751826526,39.848866197470265 -13.398177960066992,40.197238077336785 -12.9314509948666,40.580732576245865 -12.539568269582125,40.82064752927609 -12.17398210892654,41.129291729157444 -11.825647902577394,41.36293794414532 -11.43607691634082,41.629392246050905 -11.111404660392044,41.815142373829524 -10.763885982827007,42.068021715792476 -10.425096388486605,42.36124984554748 -9.826399582995583,42.704271021648154 -9.303697522599784,42.83658440223999 -8.978986378521652,43.0278023444387 -8.660158349005563,43.22821710622332 -8.120217431632408,43.477590650225736 -7.653668647301796,43.56249254091766 -7.3737837528552115,43.699872356844544 -7.0932907622429635,43.900055892670444 -6.369055881398855,44.164772344705895 -5.71939690663239,44.215347881881264 -5.46077113221853,44.31225596537602 -5.199689368394851,44.43088382318973 -4.511073761799769,44.61570560806461 -3.9018064403225647,44.63434901028023 -3.7124755105543756,44.688266689814796 -3.517407390497862,44.75839154884828 -2.683627649484362,44.907539766701866 -1.9209009441363016,44.90741064201048 -1.744912335228563,44.93890196087321 -1.5621103017029279,44.927195501582744 -0.7392356874710426,45 0,44.99142143580823 0.08708954433931212))
SELECT ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))'), -2));
ST_ASTEXT(ST_BUFFER(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))'), -2))
POLYGON((8 2,8 8,2 8,2 2,8 2))
mysqltest: Result content mismatch
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment