[postgis-tickets] [PostGIS] #3484: IS DISTINCT FROM not seeing additional points
PostGIS
trac at osgeo.org
Tue Mar 1 03:49:56 PST 2016
#3484: IS DISTINCT FROM not seeing additional points
----------------------+---------------------------
Reporter: pvalsecc | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.2.2
Component: postgis | Version: 2.2.x
Keywords: |
----------------------+---------------------------
This result is wrong:
{{{
SELECT
ST_GeomFromText('MULTIPOLYGON(((2494153.5178082585 1118531.569023041,
2494549.8246264406 1118753.159932132, 2494600.960990077
1118817.0803866775, 2494153.5178082585 1118531.569023041)))',2056)
is distinct from
ST_GeomFromText('MULTIPOLYGON(((2494153.5178082585 1118531.569023041,
2494527.2564446223 1118796.7735684956, 2494549.8246264406
1118753.159932132, 2494600.960990077 1118817.0803866775,
2494153.5178082585 1118531.569023041)))',2056);
?column?
----------
f
}}}
As you can see the second geometry as one more point.
What's strange is that this error doesn't happen in 4326:
{{{
# SELECT
ST_GeomFromText('MULTIPOLYGON(((-71.1031880899493 42.3152774590236,
-71.1031627617667 42.3152960829043, -71.1038734225584 42.3151140942995,
-71.1031880899493 42.3152774590236)))',4326)
is distinct from
ST_GeomFromText('MULTIPOLYGON(((-71.1031880899493 42.3152774590236, -71
42, -71.1031627617667 42.3152960829043, -71.1038734225584
42.3151140942995, -71.1031880899493 42.3152774590236)))',4326);
?column?
----------
t
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3484>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list