Opened 2 weeks ago
Last modified 5 days ago
#5830 new defect
Bug in ST_Equals for large data volumes — at Initial Version
| Reported by: | hhinrichs | Owned by: | pramsey |
|---|---|---|---|
| Priority: | high | Milestone: | PostGIS 3.5.3 |
| Component: | postgis | Version: | 3.5.x |
| Keywords: | st_within, llvm, st_equals | Cc: | hhinrichs |
Description
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 c1.gisco_code = 'DE_01001000'
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 it from source was pain and did not work in the end.
