[postgis-devel] Issue 119 in postgis: ST_AsSVG crashed DB backend with large geometries.

[Courtin Olivier]

On Mar 9, 2009, at 2:59 PM, codesite-noreply at google.com wrote:

Regina,

> I assume this change broke my torture test.  Can you try this on  
> your machine to rule
> out an error in my compilation.  I testd this on the latest 1.4 SVN  
> and don't recall
> it ever crashing before. The below now crashes my server.  I flipped  
> the change back
> from fixed to testing.

I also meet crashes on gardentest with St_Dump fonction, like:

SELECT ST_Dump(foo1.the_geom)
  FROM ((SELECT ST_SetSRID(ST_Point(i,j),4326) As the_geom
FROM generate_series(-10,50,15) As i
  CROSS JOIN generate_series(40,70, 15) j)) As foo1;


>        SELECT ST_AsSVG(foo1.the_geom)
>
>                        FROM ((SELECT  
> ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j)
> As the_geom
>                FROM generate_series(-10,50,10) As i
>                        CROSS JOIN generate_series(40,70, 20) As j))  
> As foo1 CROSS
> JOIN ((SELECT ST_SetSRID(ST_Point(i,j),4326) As the_geom
>                FROM generate_series(-10,50,15) As i
>                        CROSS JOIN generate_series(40,70, 15) j)) As  
> foo2
>                        LIMIT 3;

This one just pass on my machine,

HTH,

--
Olivier