[postgis-tickets] [PostGIS] #4770: [raster] Calling st_union() with WINDOW PARTITION crashes server

PostGIS trac at osgeo.org
Thu Aug 19 11:01:51 PDT 2021


#4770: [raster] Calling st_union() with WINDOW PARTITION crashes server
----------------------+---------------------------
  Reporter:  Robins   |      Owner:  robe
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.0.4
 Component:  raster   |    Version:  3.0.x
Resolution:           |   Keywords:  st_union
----------------------+---------------------------

Comment (by pramsey):

 It's very odd, the implementations of the transfns between union(geom) and
 union(rast) is functionally identical, and the problem is in fact that in
 the raster case pgsql itself is calling the transfn in a bogus state...
 promising a populated aggcontext while providing an empty one. There's
 something very odd going on in an interaction with pgsql.

 Smaller reproduction:
 {{{
 SELECT
  PUBLIC.st_union(NULL::raster) OVER (ORDER BY b)
 FROM (VALUES (300), (302)) t(b);
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4770#comment:8>
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.


More information about the postgis-tickets mailing list