[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