[postgis-devel] [PostGIS] #520: No check for different srid on operators when index is used

[PostGIS]

#520: No check for different srid on operators when index is used
---------------------+------------------------------------------------------
 Reporter:  nicklas  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 1.5.2
Component:  postgis  |     Version:  1.5.X        
 Keywords:           |  
---------------------+------------------------------------------------------
 If tbl1 and tbl2 has different srid this:
 {{{
 select * from tbl1, tbl2 where a.the_geom && b.the_geom;
 }}}
 will give error if no indexes is used, but with indexes it just runs.

 Maybe it is not possible to do the check when using indexes or it is just
 too costly. If so, I suggest the check is removed from the corresponding
 function too. Different behaviour with and without index I think is a
 little annoying.

 And in all other cases than these operators the different srids will be
 catched by the recheck with a "real" function, so as I understand it, it
 is just a matter for the operators.

 What I consider a defect here is not the lack of check but the different
 behaviour with and without index.

 /Nicklas

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/520>
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.