[postgis-tickets] [PostGIS] #4174: segfault when using spgist

[PostGIS]

#4174: segfault when using spgist
---------------------+---------------------------
 Reporter:  TobWen   |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.5.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 I'm on Debian Stretch, AMD64 with PostgreSQL 11b3 and PostGIS 2.5 from
 PostgreSQL's repository.

 On this (non optimized and ugly) query, I'm getting a segfault after a
 second:

 {{{
 SELECT
     b.idhu, layer, max(dba)
 FROM
     (SELECT b."IDHU" AS idhu, first(geom) AS geom FROM do_buildings b JOIN
 do_data d ON b."IDHU"::text = d."IDHU"::text GROUP BY 1 LIMIT 100) b
 CROSS JOIN unnest('{str_isof_den}'::text[]) AS lyr
 CROSS JOIN LATERAL (
      SELECT idhu, layer, dba
      FROM   do_laerm l
      WHERE  layer = lyr AND ST_Intersects(l.geom, b.geom)
      LIMIT 1
 ) AS target
 GROUP by
    1, 2;
 }}}

 I've got these two spgist indexes on the geoms (it works with normal
 gist):
 {{{
 CREATE INDEX idx_do_laerm ON do_laerm USING spgist(geom);
 CREATE INDEX idx_do_buildings ON do_buildings USING spgist(geom);
 }}}

 The dbg trace is attached to this report.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4174>
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.