[PostGIS] #5830: Bug in ST_Equals for large data volumes

[PostGIS]

#5830: Bug in ST_Equals for large data volumes
------------------------+-----------------------------
  Reporter:  hhinrichs  |      Owner:  pramsey
      Type:  defect     |     Status:  new
  Priority:  high       |  Milestone:  PostGIS 3.5.2
 Component:  postgis    |    Version:  3.5.x
Resolution:             |   Keywords:  st_within, llvm
------------------------+-----------------------------
Description changed by hhinrichs:

Old 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.

New 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.

 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?

--
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5830#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.