[postgis-devel] [PostGIS] #494: [wktraster] ST_DumpAsPolygons crashes under MingW compiled wktraster (gdal)

[PostGIS]

#494: [wktraster] ST_DumpAsPolygons crashes under MingW compiled wktraster (gdal)
------------------------+---------------------------------------------------
  Reporter:  robe       |       Owner:  pracine        
      Type:  defect     |      Status:  new            
  Priority:  medium     |   Milestone:  WKTRaster 0.1.6
 Component:  wktraster  |     Version:  trunk          
Resolution:             |    Keywords:                 
------------------------+---------------------------------------------------
Comment (by jorgearevalo):

 Replying to [comment:21 robe]:
 > Okay I'm getting output now.  But still a couple of problems
 >
 > 1) Very minor -- but if I feed a raster with no bands, I get an assert
 error in postgres.exe that I have less than one band.  I presume this is
 expected?  Except it should just be a notice rather than kicking me into
 visual studio debugger - well hmm I guess since we are still in alpha it
 might be best to just leave as is if easier to debug.
 >
 Could you paste the error message and the query that caused it?



 > 2) This one is very strange and it seems very intermittent.  Once it
 fails I can't get it to work again for another 10 or so tries and then it
 works.  I haven't ever gotten just the inner subselect to work without
 doing restrictions on val which is even more bizzarre since I can't see
 how the ST_Union would ever work if the inner fails all the time.  I'm
 running 1.5.1 so I'll upgrade to 1.5.2SVN and see if I experience any
 difference.  I haven't looked at the rendered image yet to veerify it
 looks correct.
 >
 > {{{
 > SELECT ST_Union(geom)
 > FROM (SELECT (ST_DumpAsPolygons(rast)).geom
 > FROM ch13.pele
 > ) As foo
 > }}}
 >
 > This gives error
 >
 > ERROR:  parse error - invalid geometry
 > HINT:  "...00,52 101,53 101,54 101,54 99,53 99))" <-- parse error at
 position 64 within geometry
 > CONTEXT:  SQL function "st_dumpaspolygons" statement 1
 >
 > If I run Just the inner query
 > I get the same error.
 >
 Ok, I think I know the reason, and I fixed it. Please update to r5589. I
 executed st_astext over your query and I got this:


 {{{
 POLYGON((89 0,88 0,87 0,86 0,85 0,84 0,83 0,82 0,
 81 0,80 0,79 0,78 0,77 0,76 0,75 0,74 0,73 0,72 0,
 71 0,70 0,69 0,68 0,67 0,66 0,65 0,0 0,0 178,0 179,
 0 180,0 181,0 182,0 183,0 184,0 185,0 186,0 188,
 0 189,0 190,0 191,0 192,0 193,0 194,0 195,0 196,
 0 439,158 439,159 439,160 439,161 439,162 439,
 164 439,165 439,166 439,167 439,168 439,169 439,
 298 439,299 439,299 405,299 404,299 402,299 401,
 299 0,89 0))
 }}}

 Has sense? BTW, I'm using PostGIS version 1.5.0SVN

 > I'll attach the file in a bit.
 I think you attached the file in ticket #297. Could be?

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