[postgis-tickets] [PostGIS] #4916: st_asgeobuf() with WINDOW PARTITION crashes server

PostGIS trac at osgeo.org
Thu Aug 19 15:58:56 PDT 2021


#4916: st_asgeobuf() with WINDOW PARTITION crashes server
----------------------+---------------------------
  Reporter:  Robins   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.1.4
 Component:  postgis  |    Version:  3.0.x
Resolution:           |   Keywords:  st_asgeobuf
----------------------+---------------------------

Comment (by pramsey):

 This crash appears to be related to passing in the NULL argument, not to
 the finalfn behaviour. I can use window functions fine, as long as I pass
 in a non-null argument.
 {{{
 SELECT public.st_asgeobuf(t, 'g') over (order by RANDOM())
 FROM (VALUES ('POINT(0 0)'::geometry, 'A0006', 300),
              ('POINT(1 1)'::geometry, 'A0006', 302)) t(g, a, b);
 }}}

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