<div dir="ltr">After spending some time trying to track down which package/version the bug occurs in, I found that it is actually from the upgrade of PostGIS from 2.0.4 to 2.1.1. I will see if I can spend more time to isolate it further, but I did confirm that it is PostGIS, not one of the dependencies.<div>
<br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jan 31, 2014 at 8:33 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">ah found the other one:</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://trac.osgeo.org/postgis/ticket/2556" target="_blank">http://trac.osgeo.org/postgis/ticket/2556</a></font></span></div><br>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Paragon
Corporation<br><b>Sent:</b> Friday, January 31, 2014 11:27 PM<br><b>To:</b>
'PostGIS Users Discussion'<br><b>Cc:</b> 'PostGIS Development
Discussion'<br><b>Subject:</b> Re: [postgis-users] Odd Behavior with
ST_Intersects (PostGIS 2.1,Ubuntu 12.04)<br></font><br></div><div><div class="h5">
<div></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Jerry,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Thanks very much for the report. I had noticed what I
think might be the same issue, but couldn't find such a short and succinct
example as yours to reproduce.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">I have added to my original ticket: <a href="http://trac.osgeo.org/postgis/ticket/2422" target="_blank">http://trac.osgeo.org/postgis/ticket/2422</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">I think there is another ticket in our bug tracker that might
be the same issue too but can't recall the number.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Thanks very very much for this great
example.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Paul -- if you are watching you have work to do
:)</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Thanks,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Regina</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://postgis.net" target="_blank">http://postgis.net</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div><br>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Jerry
Sievert<br><b>Sent:</b> Friday, January 31, 2014 6:25 PM<br><b>To:</b>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> [postgis-users] Odd Behavior
with ST_Intersects (PostGIS 2.1,Ubuntu 12.04)<br></font><br></div>
<div></div>
<div dir="ltr">Hello,
<div><br></div>
<div>I am using Ubuntu 12.04 with the official PostgreSQL apt repo (via <a href="https://wiki.postgresql.org/wiki/Apt" target="_blank">https://wiki.postgresql.org/wiki/Apt</a>).
I am running into an easily reproducible issue, and was hoping for some
help to solve this.</div>
<div><br></div>
<div>When using ST_Intersects() not all rows that intersect are returned.
This was not the case in previous versions that we have upgraded
from.</div>
<div><br></div>
<div>These are the steps to reproduce on a fresh install of Ubuntu 12.04 with
all packages updated and PostGIS/PostgreSQL 9.3 installed:</div>
<div><br></div>
<div>
<div><font face="courier new, monospace">test=# CREATE TABLE test (id serial,
condition_geo geography);</font></div>
<div><font face="courier new, monospace">CREATE TABLE</font></div>
<div><font face="courier new, monospace">test=# INSERT INTO test (condition_geo)
VALUES (ST_Buffer(ST_GeogFromWKB(ST_MakePoint(20.0,30.0)),10.0));</font></div>
<div><font face="courier new, monospace">INSERT 0 1</font></div>
<div><font face="courier new, monospace">test=# SELECT id FROM test WHERE
ST_Intersects("condition_geo", ST_Buffer(ST_GeogFromText('POINT(20.0 30.0)'),
20.0)) IS TRUE;</font></div>
<div><font face="courier new, monospace"> id</font></div>
<div><font face="courier new, monospace">----</font></div>
<div><font face="courier new, monospace"> 1</font></div>
<div><font face="courier new, monospace">(1 row)</font></div>
<div><font face="courier new, monospace"><br></font></div>
<div><font face="courier new, monospace">test=# INSERT INTO test (condition_geo)
VALUES (ST_Buffer(ST_GeogFromWKB(ST_MakePoint(20.0,30.0)),10.0));</font></div>
<div><font face="courier new, monospace">INSERT 0 1</font></div>
<div><font face="courier new, monospace">test=# SELECT id FROM test WHERE
ST_Intersects("condition_geo", ST_Buffer(ST_GeogFromText('POINT(20.0 30.0)'),
20.0)) IS TRUE;</font></div>
<div><font face="courier new, monospace"> id</font></div>
<div><font face="courier new, monospace">----</font></div>
<div><font face="courier new, monospace"> 1</font></div>
<div><font face="courier new, monospace">(1 row)</font></div>
<div><font face="courier new, monospace"><br></font></div>
<div><font face="courier new, monospace">test=# SELECT id FROM test WHERE
ST_Intersects("condition_geo", ST_Buffer(ST_GeogFromText('POINT(20.0 30.0)'),
20.0)) IS TRUE AND id = 2;</font></div>
<div><font face="courier new, monospace"> id</font></div>
<div><font face="courier new, monospace">----</font></div>
<div><font face="courier new, monospace"> 2</font></div>
<div><font face="courier new, monospace">(1 row)</font></div></div>
<div><br></div>
<div>Note that the SELECT should return both rows 1 and 2 in the first
SELECT.</div>
<div><br></div>
<div>Any thoughts?</div>
<div><br></div>
<div><br></div></div></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>