ST_Intersects discrepancy between 2.5.3 and 3.0.0
|Reported by:||paf31||Owned by:||pramsey|
The following query returns different results between versions 2.5.3 (returns true) and 3.0.0 (returns false) running on Postgres 12.1:
SELECT ST_Intersects( ST_GeographyFromText('SRID=4326;POINT(-11.0 0.00005)'), ST_GeographyFromText('SRID=4326;LINESTRING(-11.0 0.0,-11.0 0.0001)') );
The result on 3.0.0 is very sensitive to the numbers used. Changing 11.0 to 10.0, for example, changes the result to true.
We discussed this on IRC and concluded it's probably a bug, so I'm posting here. Thanks!