[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.4.1
 Component:  postgis  |     Version:  1.3.X        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by nicklas):

 now I'm little confused. I thought I found this as a special case, because
 I had to struggle to minimize the dataset without destroying the error.
 [[BR]]

 If you try se same thing at testcase2 it will work as expected and return
 nothing and the only difference is that I took away one of the other
 polygons and ran vacuum full analyze on it.[[BR]]
 [[BR]]
 But now I see that it maybe is the planner that is cheating me. on
 testcase2 it[[BR]] doesn't seem to use the index:[[BR]]
 it seems like the change in behavior is because the planner decides the
 dataset is too small for using the index. Am I right?
 /Nicklas

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