[postgis-tickets] [PostGIS] #3283: Corrupt cached bboxes gets created (m-value)

PostGIS trac at osgeo.org
Tue Sep 22 10:14:16 PDT 2015


#3283: Corrupt cached bboxes gets created (m-value)
----------------------+---------------------------
  Reporter:  nicklas  |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.2.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:  temporal
----------------------+---------------------------

Comment (by robe):

 SAme result here.  What I don't understand is why adding the bbox back
 gives a slightly different error message.  It's almost like we have two
 separate cache box adders and the one on restore is different from the
 add_bbox one.

 When I do this:


 {{{

 select st_cpawithin(
 (select PostGIS_AddBBox(PostGIS_DropBBox(geom)) from p where gid = 1 and
 ST_IsValidTrajectory(geom))
 ,
 (select PostGIS_AddBBox(PostGIS_DropBBox(geom)) from p where gid = 2 and
 ST_IsValidTrajectory(geom))
 ,1000);
 }}}

 I get:

 {{{
 ERROR:  Could not find point with M=9.28441e-309 on first geom
 ********** Error **********

 ERROR: Could not find point with M=9.28441e-309 on first geom
 SQL state: XX000


 }}}


 But with just restoring, I got the same M=0 error message you got.  I know
 they are off by a smidge so could be just some windows artifact.


 This is testing on:


 {{{
 PostgreSQL 9.4.4, compiled by Visual C++ build 1800, 64-bit
 POSTGIS="2.2.0dev r14083" GEOS="3.5.0-CAPI-1.9.0 r4088" PROJ="Rel. 4.9.1,
 04 March 2015" GDAL="GDAL 2.0.0, released 2015/06/14" LIBXML="2.7.8"
 LIBJSON="0.12" RASTER
 }}}

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