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

[PostGIS]

#5000: ST_AsMVT crash with OVER(random())
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.0.5
Component:  postgis  |    Version:  2.5.x
 Keywords:           |
---------------------+---------------------------
 {{{
 SELECT ST_AsMVT(foo1)OVER(ORDER BY random()) As result FROM ((SELECT
 ST_SetSRID(ST_Point(i,j),4326) As the_geom FROM (SELECT a*1.11111111 FROM
 generate_series(-10,50,2) As a) As i(i) CROSS JOIN generate_series(40,70,
 5) j ORDER BY i,j )) As foo1 LIMIT 10;
 }}}

 note that this doesn't crash:


 {{{
 SELECT ST_AsMVT(foo1)OVER() As result FROM ((SELECT
 ST_SetSRID(ST_Point(i,j),4326) As the_geom FROM (SELECT a*1.11111111 FROM
 generate_series(-10,50,2) As a) As i(i) CROSS JOIN generate_series(40,70,
 5) j ORDER BY i,j )) As foo1 LIMIT 10;
 }}}

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