Bug in ST_Equals for large data volumes

[hhinrichs]

Hello,

I ran into an issue running a query that processes a large data volume. I suspect the issue is related to ​https://lists.osgeo.org/pipermail/postgis-users/2024-November/046606.html.

Dummy query that fails:

SELECT 1 FROM communities c1, communities c2 WHERE ST_Equals(c1.geom, c2.geom)

Dummy query that runs:

SELECT 1 FROM communities c1, communities c2 WHERE ST_Equals(c1.geom, c2.geom) AND ST_Intersects(c1.geom, c2.geom)

What also works is

SELECT 1 FROM communities c1, communities c2 WHERE ST_Within(c1.geom, c2.geom) AND ST_Within(c2.geom, c1.geom)

The error my postgres container logs: error: Unknown attribute kind (86) (Producer: 'LLVM16.0.6' Reader: 'LLVM 15.0.6')

I tried to run the failing query on our staging environment where we have PostGis 3.4.0 and it runs without any error.

I was unable to install 3.4.x locally as older versions seem to get deleted from the apt repository and installing from source did not work out for me.

EDIT: I wanted to attach the data but it exceeds the size limit. Should we try to find another way`to exchange it or are you able to reproduce the error with a large dataset by yourself?