[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