[postgis-tickets] [PostGIS] #2188: [raster] Issue with ST_Resize percent doesn't work always for non-georeferenced affects both in db and out db

[PostGIS]

#2188: [raster] Issue with ST_Resize percent doesn't work always for non-
georeferenced  affects both in db and out db
----------------------+-----------------------------------------------------
 Reporter:  robe      |       Owner:  pramsey      
     Type:  defect    |      Status:  new          
 Priority:  critical  |   Milestone:  PostGIS 2.1.0
Component:  postgis   |     Version:  trunk        
 Keywords:            |  
----------------------+-----------------------------------------------------
 Okay I have more pictures but these are property inspection ones in jpeg.
 For this set ST_Resize using percentage doesn't seem to work:


 {{{

 ST_Resize(rast,0.5,0.5)
 }}}

  for any of them regardless of if I have outdb or indb.


 However if I do pixel size like

 {{{

 ST_Resize(rast,100,100)
 }}}


 That works fine.

 I'm not sure if it's related to: #2182 and possibly a windows 2008
 specific issue.

 I'll check on my Windows 2003 64-bit server to verify it happens on that
 as well:

 Any rate:

 {{{
 raster2pgsql -F -Y -R C:/photos/*.jpg inspection_pics_outdb | psql
 }}}


 {{{
 raster2pgsql -F -Y C:/photos/*.jpg inspection_pics_local | psql
 }}}

 {{{
 SELECT version() || ' ' || postgis_full_version();

 -- outputs --
 PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 64-bit
 POSTGIS="2.1.0SVN r11044" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0,
 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8"
 LIBJSON="UNKNOWN" TOPOLOGY (topology procs from "2.1.0SVN r10987" need
 upgrade) RASTER

 and this is on a Windows 2008 R2 64-bit VM
 }}}


 {{{
  -- works --
 SELECT ST_Resize(rast,200,200)
 FROM inspection_pics_local
 WHERE filename='PHOTO_1_20080101_121112.jpg'
 }}}

 {{{
  -- returns a black image --
 SELECT ST_Resize(rast,0.5,0.5)
 FROM inspection_pics_local
 WHERE filename='PHOTO_1_20080101_121112.jpg'
 }}}


 I'm attaching one of the problem pics this one is public record
 inspections so no issue attaching pic.

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