ST_Intersect issue on Postgis 3.5.0

[Łukasz Szałek]

Hi all

I have run a couple of tests on Postgresql 17 with Postgis 3.5.0
Have you ever met such a situation that:

Case 1: On PG 15.3 with Postgis 3.3.7

POSTGIS="3.3.1 3786b21" [EXTENSION] PGSQL="150" GEOS="3.11.0-CAPI-1.17.0" PROJ="7.2.1" LIBXML="2.9.1" LIBJSON="0.11"



QUERY: SELECT st_intersects(ST_GeomFromText('LINESTRING(20.4181889 52.2294573, 20.4181297 52.2293530)',4326), ST_GeomFromText('POLYGON((20.4184446 52.2300275, 20.4184364 52.2299621, 20.4183278 52.2297000, 20.4182316 52.2294864, 20.4181977 52.2294529, 20.4181239 52.2294898, 20.4181889 52.2294573, 20.4182713 52.2295927, 20.4183541 52.2297635, 20.4184219 52.2299443, 20.4184446 52.2300275))',4326));

Produces:

ERROR:  GEOSIntersects: TopologyException: side location conflict at 20.418188900000001 52.2294573. This can occur if the input geometry is invalid.




Case 2: On PG17.0 with Postgis 3.5.0
POSTGIS="3.5.0 d2c3ca4" [EXTENSION] PGSQL="170" GEOS="3.13.0-CAPI-1.19.0" PROJ="9.5.0 (compiled against PROJ 9.13.0) LIBXML="2.9.13" LIBJSON="0.14" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"

Same QUERY: SELECT st_intersects(ST_GeomFromText('LINESTRING(20.4181889 52.2294573, 20.4181297 52.2293530)',4326),
ST_GeomFromText('POLYGON((20.4184446 52.2300275, 20.4184364 52.2299621, 20.4183278 52.2297000, 20.4182316 52.2294864, 20.4181977 52.2294529, 20.4181239 52.2294898, 20.4181889 52.2294573, 20.4182713 52.2295927, 20.4183541 52.2297635, 20.4184219 52.2299443, 20.4184446 52.2300275))',4326));

Produces: True

Is it some kind of regression?

Thank for any information

Best regards
Łukasz Szałek

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20241016/5b7aedef/attachment.htm>