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

PostGIS trac at osgeo.org
Sat Jan 7 20:47:53 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):

 Forgot this is testing with the latest windows experimental --  r8697,
 gdal 9.0.0 rc2

 and my sql got mangled in last post
 {{{
 SELECT ST_AsRaster(foo2.the_geom, rast1.rast, '1BB', 1.5, 1.5, false),
 ST_AsEWKT(rast1.rast::geometry) As ref1_geom, ST_AsEWKT(foo2.the_geom) As
 ref2_geom

     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 2;


 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1066#comment:16>
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