Opened 11 years ago

Closed 11 years ago

#2639 closed defect (invalid)

geography ST_Intersection regress difference 2.0.4 and 2.1/2.2.0

Reported by: robe Owned by: pramsey
Priority: medium Milestone: PostGIS 2.1.2
Component: postgis Version: 2.1.x
Keywords: Cc:

Description

This is another one of those I'm not sure is just a change in algorithm or something wrong:

SELECT ST_AsText(ST_Intersection('POLYGON((-8.1111111 60,-8.16875525879031 59.4147290339516,-8.33947250246614 58.8519497029047,-8.61670226309236 58.3332893009412,-8.98979075644036 57.8786796564404,-9.44440040094119 57.5055911630924,-9.96306080290473 57.2283614024661,-10.5258401339516 57.0576441587903,-11.1111111 57,-11.6963820660484 57.0576441587903,-12.2591613970953 57.2283614024661,-12.7778217990588 57.5055911630924,-13.2324314435596 57.8786796564404,-13.6055199369076 58.3332893009412,-13.8827496975339 58.8519497029047,-14.0534669412097 59.4147290339516,-14.1111111 60,-14.0534669412097 60.5852709660484,-13.8827496975339 61.1480502970953,-13.6055199369076 61.6667106990588,-13.2324314435597 62.1213203435596,-12.7778217990588 62.4944088369076,-12.2591613970953 62.7716385975339,-11.6963820660484 62.9423558412097,-11.1111111 63,-10.5258401339516 62.9423558412097,-9.96306080290474 62.7716385975339,-9.4444004009412 62.4944088369076,-8.98979075644036 62.1213203435596,-8.61670226309237 61.6667106990588,-8.33947250246614 61.1480502970953,-8.16875525879031 60.5852709660484,-8.1111111 60))'::geography, 
'POLYGON((-8.1111111 60,-8.16875525879031 59.4147290339516,-8.33947250246614 58.8519497029047,-8.61670226309236 58.3332893009412,-8.98979075644036 57.8786796564404,-9.44440040094119 57.5055911630924,-9.96306080290473 57.2283614024661,-10.5258401339516 57.0576441587903,-11.1111111 57,-11.6963820660484 57.0576441587903,-12.2591613970953 57.2283614024661,-12.7778217990588 57.5055911630924,-13.2324314435596 57.8786796564404,-13.6055199369076 58.3332893009412,-13.8827496975339 58.8519497029047,-14.0534669412097 59.4147290339516,-14.1111111 60,-14.0534669412097 60.5852709660484,-13.8827496975339 61.1480502970953,-13.6055199369076 61.6667106990588,-13.2324314435597 62.1213203435596,-12.7778217990588 62.4944088369076,-12.2591613970953 62.7716385975339,-11.6963820660484 62.9423558412097,-11.1111111 63,-10.5258401339516 62.9423558412097,-9.96306080290474 62.7716385975339,-9.4444004009412 62.4944088369076,-8.98979075644036 62.1213203435596,-8.61670226309237 61.6667106990588,-8.33947250246614 61.1480502970953,-8.16875525879031 60.5852709660484,-8.1111111 60))'::geography));

In

PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 32-bit POSTGIS="2.0.4" GEOS="3.4.2-CAPI-1.8.2 r0" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8" LIBJSON="UNKNOWN" (core procs from "2.0.4" need upgrade) RASTER (raster procs from "2.0.4" need upgrade)

POLYGON((-8.1111111 59.9999999999987,-8.16875525879031 59.41472903395,-8.33947250246614 58.8519497029029,-8.61670226309236 58.3332893009392,-8.98979075644036 57.8786796564381,-9.44440040094119 57.5055911630899,-9.96306080290473 57.2283614024634,-10.5258401339516 57.0576441587875,-11.1111111 56.9999999999972,-11.6963820660484 57.0576441587875,-12.2591613970953 57.2283614024634,-12.7778217990588 57.5055911630899,-13.2324314435596 57.8786796564381,-13.6055199369076 58.3332893009392,-13.8827496975339 58.8519497029029,-14.0534669412097 59.41472903395,-14.1111111 59.9999999999987,-14.0534669412097 60.5852709660472,-13.8827496975339 61.1480502970943,-13.6055199369076 61.6667106990579,-13.2324314435597 62.1213203435589,-12.7778217990588 62.4944088369069,-12.2591613970953 62.7716385975333,-11.6963820660484 62.9423558412091,-11.1111111 62.9999999999994,-10.5258401339516 62.9423558412091,-9.96306080290474 62.7716385975333,-9.4444004009412 62.4944088369069,-8.98979075644036 62.1213203435589,-8.61670226309237 61.6667106990579,-8.33947250246614 61.1480502970943,-8.16875525879031 60.5852709660472,-8.1111111 59.9999999999987))

In PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 32-bit POSTGIS="2.2.0dev r12228" GEOS="3.4.2-CAPI-1.8.2 r0" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER

(and also 2.1.1 release so assume case for current 2.1.2dev)

POLYGON((-8.11111109999999 59.9999999984909,-8.16875525879032 59.4147290323908,-8.33947250246614 58.8519497012907,-8.61670226309236 58.333289299275,-8.98979075644036 57.8786796547257,-9.4444004009412 57.5055911613359,-9.96306080290472 57.2283614006773,-10.5258401339516 57.0576441569811,-11.1111111 56.9999999981838,-11.6963820660484 57.0576441569811,-12.2591613970953 57.2283614006773,-12.7778217990588 57.5055911613359,-13.2324314435596 57.8786796547257,-13.6055199369076 58.333289299275,-13.8827496975339 58.8519497012907,-14.0534669412097 59.4147290323908,-14.1111111 59.9999999984909,-14.0534669412097 60.5852709645878,-13.8827496975339 61.1480502956783,-13.6055199369076 61.6667106976798,-13.2324314435597 62.1213203422121,-12.7778217990588 62.494408835585,-12.2591613970953 62.7716385962291,-11.6963820660484 62.9423558399157,-11.1111111 62.9999999987096,-10.5258401339516 62.9423558399157,-9.96306080290473 62.7716385962291,-9.44440040094121 62.494408835585,-8.98979075644036 62.1213203422121,-8.61670226309236 61.6667106976797,-8.33947250246615 61.1480502956783,-8.16875525879031 60.5852709645878,-8.11111109999999 59.9999999984909))

Change History (2)

comment:1 by robe, 11 years ago

Summary: geography ST_Intersection regress difference 2.0.4 and 2.1.2/2.2.0geography ST_Intersection regress difference 2.0.4 and 2.1/2.2.0

comment:2 by robe, 11 years ago

Resolution: invalid
Status: newclosed

I'm guessing this is the same issue as #2635 with _ST_BestSRID expansion

Note: See TracTickets for help on using tickets.