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

[PostGIS]

#4770: Calling st_union() with WINDOW PARTITION crashes server
----------------------+---------------------------
 Reporter:  Robins    |      Owner:  pramsey
     Type:  defect    |     Status:  new
 Priority:  medium    |  Milestone:  PostGIS 3.1.0
Component:  postgis   |    Version:  3.0.x
 Keywords:  st_union  |
----------------------+---------------------------
 **Brief**

 Calling st_union() with WINDOW PARTITION crashes the server.


 **Repro**


 {{{
 WITH x AS (
   SELECT * FROM (VALUES ('A0006', 300), ('A0006', 302)) t(a,b)
 )
 SELECT
  PUBLIC.st_union(NULL::raster, NULL::_unionarg) OVER (PARTITION BY a ORDER
 BY b)
 FROM x;
 }}}



 **SQL Output**


 {{{
 db=> SELECT version();
 -[ RECORD 1
 ]---------------------------------------------------------------------------------------------------
 version | PostgreSQL 13.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC)
 7.3.1 20180712 (Red Hat 7.3.1-6), 64-bit

 db=> SELECT postgis_full_version();
 -[ RECORD 1
 ]--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 postgis_full_version | POSTGIS="3.0.2 2fb2a18" [EXTENSION] PGSQL="130"
 GEOS="3.8.0-CAPI-1.13.1 " PROJ="Rel. 5.2.0, September 15th, 2018"
 GDAL="GDAL 2.4.4, released 2020/01/08" LIBXML="2.9.1" LIBJSON="0.13.1"
 LIBPROTOBUF="1.3.2" WAGYU="0.4.3 (Internal)" TOPOLOGY RASTER

 db=> WITH x AS (
 db(>   SELECT * FROM (VALUES ('A0006', 300), ('A0006', 302)) t(a,b)
 db(> )
 db-> SELECT
 db->  PUBLIC.st_union(NULL::raster, NULL::_unionarg) OVER (PARTITION BY a
 ORDER BY b)
 db-> FROM x;
 server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
 The connection to the server was lost. Attempting reset: sFailed.
 !?>
 }}}

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