[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, st_equals
------------------------+----------------------------------------
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.
>
> 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?

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 ST_Intersects(c1.geom, c2.geom)

 What also works is

 SELECT 1 FROM communities c1, communities c2 WHERE ST_Within(c1.geom,
 c2.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 I was unable to
 Installing it from s.

 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:3>
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.