[postgis-devel] [PostGIS] #1066: [raster] raster crashes server with arbitrary tests

PostGIS trac at osgeo.org
Sat Jan 7 20:51:30 PST 2012


#1066: [raster] raster crashes server with arbitrary tests
-----------------------------+----------------------------------------------
  Reporter:  robe            |       Owner:  dustymugs    
      Type:  defect          |      Status:  assigned     
  Priority:  blocker         |   Milestone:  PostGIS 2.0.0
 Component:  postgis raster  |     Version:  trunk        
Resolution:                  |    Keywords:               
-----------------------------+----------------------------------------------

Comment(by robe):

 Here is a slightly shorter without all that extra fluff that still
 generates the same error:


 {{{
 SELECT ST_AsRaster(foo2.the_geom, rast1.rast, '1BB', 1.5, 1.5, false)

     FROM (

     (SELECT ST_SetSRID(ST_SetValue(ST_AddBand(ST_MakeEmptyRaster( 100,
 100, (i-1)*100, (i-1)*100, 0.0005, -0.0005, 0*i, 0*i), '1BB'), i,
 (i+1),0),4326) As rast

         FROM generate_series(1,10) As i)

     ) As rast1 CROSS JOIN ((SELECT
 ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j*0.05) As the_geom

     FROM (SELECT a*1.11111111 FROM generate_series(-10,50,10) As a) As
 i(i)

         CROSS JOIN generate_series(40,70, 20) As j ORDER BY i, i*j, j)) As
 foo2

             LIMIT 1;
 }}}

 Let me know if you need me to reduce it down even further.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/1066#comment:17>
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-devel mailing list