[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 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 FWIW, I really don't think this is a big issue and would just assume
 forget about it if its hard to fix.  Usually when people use &&, they know
 what they are doing and I suspect trying to fix this will just slow things
 down.

 NOTE: This more common query does give error:


 {{{
 SELECT a.gid As a_gid, b.gid As a_gid, ST_SRID(a.geom) As a_srid,
   ST_SRID(b.geom) As b_srid
  FROM tb1 As a, tb1 As b
 WHERE ST_Intersects(a.geom,b.geom);

 }}}

 {{{
 ERROR:  Operation on mixed SRID geometries
 }}}

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