Ticket #520 (closed defect: fixed)
No check for different srid on operators when index is used
|Reported by:||nicklas||Owned by:||pramsey|
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.