[postgis-devel] [PostGIS] #253: Gist causes wrong result from ~=

[PostGIS]

#253: Gist causes wrong result from ~=
----------------------+-----------------------------------------------------
  Reporter:  nicklas  |       Owner:  pramsey      
      Type:  defect   |      Status:  new          
  Priority:  medium   |   Milestone:  postgis 1.5.0
 Component:  postgis  |     Version:  1.4.X        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by nicklas):

 I have tried:
 8.3.7 with postgis 1.3.5 wich gives the expected result, returning nothing

 Then I have tried
 8.4.1 with postgis 1.4.0 and my spike, both giving the strange result with
 returning two rows.
 It is difficult to investigate what is happening since the fenomen
 dissapears at once you take away any of the other polygons. It must be
 something with the way the index is built with this specific dataset. I
 guess it makes this a quite mean bug since it can hide wrong answers among
 many correct answers.
 how to see how the index is built in this case?

 /Nicklas

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/253#comment:4>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS