[postgis-tickets] [PostGIS] #4151: ST_3DDwithin Errors on memcmp with pt_in_ring_3d

PostGIS trac at osgeo.org
Thu Aug 16 05:57:29 PDT 2018


#4151: ST_3DDwithin Errors on memcmp with pt_in_ring_3d
----------------------+---------------------------
  Reporter:  tilt     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.5.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by Algunenano):

 The first polygon you are using is invalid; the first and last point of
 the polygon should be the same:
 - First: {{{ 238122.872000001 576633.508999999 5.98677038142003 }}}
 - Last: {{{ 238122.872000001 576633.508999999 5.98677038142796 }}}

 The z coordinate is `5.98677038142003` vs `5.98677038142796`.

 If you change it to the same value it outputs:
 {{{
 SELECT
 ST_3DDwithin(ST_GeometryFromText('POLYGON Z ((
 238122.872000001 576633.508999999 5.98677038142003,
 238122.872 576633.509 5.98677038052055,
 238121.623809392 576634.389879555 4.95792405791038,
 238120.252000002 576635.357999998 3.82718245716979,
 238120.252 576635.358 3.82718245541562,
 238121.873 576637.738 3.8333125996467,
 238121.873000001 576637.737999999 3.83331260027449,
 238124.460390651 576635.62447975 6.0745417745131,
 238122.991788134 576633.427399075 6.08439985368325,
 238122.872000001 576633.508999999 5.98677038142003))'),
 ST_GeometryFromText('POINT Z (238123 576634 0)')
 ,0.1)
  st_3ddwithin
 --------------
  f
 (1 row)
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4151#comment:2>
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