[postgis-tickets] [PostGIS] #5000: ST_AsMVT crash with OVER(ORDER BY random())

[PostGIS]

#5000: ST_AsMVT crash with OVER(ORDER BY random())
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.0.5
 Component:  postgis  |    Version:  2.5.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by pramsey):

 So, smaller more concrete example.
 {{{

 DROP TABLE foo;
 CREATE TABLE foo AS
 SELECT *
 FROM (
 VALUES
  ('POINT(0 0)'::geometry, 'one', 1)
 ,('POINT(1 1)'::geometry, 'two', 2)
 ) AS v(g,b,i);

 -- These all crash
 SELECT ST_AsMVT(foo) OVER(ORDER BY random() DESC) AS result FROM foo;
 SELECT ST_AsMVT(foo) OVER(ORDER BY i DESC) AS result FROM foo;
 SELECT ST_AsMVT(foo) OVER(ORDER BY i) AS result FROM foo;
 }}}

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