[postgis-tickets] [PostGIS] #4724: [raster] crash on null input to st_summarystatsagg()

[PostGIS]

#4724: [raster] crash on null input to st_summarystatsagg()
-------------------------------------+---------------------------
 Reporter:  Robins                   |      Owner:  Bborie Park
     Type:  defect                   |     Status:  new
 Priority:  medium                   |  Milestone:  PostGIS 3.1.0
Component:  raster                   |    Version:  3.0.x
 Keywords:  st_summarystatsagg null  |
-------------------------------------+---------------------------
 **Brief**
 When st_summarystatsagg() is called with NULLs it crashes the server.


 **Repro**

 {{{
 select public.st_summarystatsagg(NULL::raster, NULL::int4, NULL::bool)
 over (order by q) from generate_series(1,2) as e(q);

 }}}


 ----

 **SQL Output**


 {{{
 db=> SELECT postgis_full_version();
 postgis_full_version

 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ------------------------------------------------
  POSTGIS="3.0.0 r17983" [EXTENSION] PGSQL="120" 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" LIBP
 ROTOBUF="1.3.2" WAGYU="0.4.3 (Internal)" RASTER
 (1 row)

 db=> select version();
                                                  version
 ---------------------------------------------------------------------------------------------------------
  PostgreSQL 12.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
 20150623 (Red Hat 4.8.5-11), 64-bit
 (1 row)

 db=> \dx
                                         List of installed extensions
       Name      | Version |   Schema   |
 Description
 ----------------+---------+------------+---------------------------------------------------------------------
  plpgsql        | 1.0     | pg_catalog | PL/pgSQL procedural language
  postgis        | 3.0.0   | public     | PostGIS geometry, geography, and
 raster spatial types and functions
  postgis_raster | 3.0.0   | public     | PostGIS raster types and
 functions
 (3 rows)


 db=> select public.st_summarystatsagg(NULL::raster, NULL::int4,
 NULL::bool) over (order by q) from generate_series(1,2) as e(q);
 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: Failed.
 !?>

 }}}

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