[postgis-tickets] [PostGIS] #3080: PostgreSQL 9.5 regress failure on st_reclass

PostGIS trac at osgeo.org
Sun Mar 22 01:00:59 PDT 2015


#3080: PostgreSQL 9.5 regress failure on st_reclass
--------------------+-------------------------------------------------------
 Reporter:  robe    |       Owner:  dustymugs    
     Type:  defect  |      Status:  new          
 Priority:  high    |   Milestone:  PostGIS 2.2.0
Component:  raster  |     Version:  trunk        
 Keywords:          |  
--------------------+-------------------------------------------------------

Comment(by robe):

 The offending query is this:


 {{{
 SELECT
         ST_Value(t.rast, 1, 1, 1),
         ST_Value(t.rast, 1, 10, 10),
         ST_BandNoDataValue(rast, 1)
 FROM (
         SELECT ST_Reclass(
                 ST_SetValue(
                         ST_SetValue(
                                 ST_AddBand(
                                         ST_MakeEmptyRaster(100, 100, 10,
 10, 2, 2, 0, 0, 0),
                                         1, '32BF', 1, 0
                                 ),
                                 1, 1, 1, 3.14159
                         ),
                         1, 10, 10, 2.71828
                 ),
                 ROW(1,
 'a-100]:50-1,(-100-1000]:150-50,(1000-10000]:254-150', '8BUI', 0)
         ) AS rast
 ) AS t;
 }}}


 In older versions of PostgreSQL, that would output just one notice.  In
 9.5 it is outputting the some notice twice.

 Full message is

 {{{
 NOTICE:  Invalid argument for reclassargset. Invalid expression of
 reclassexpr for reclassarg of index 0 . Returning original raster
 CONTEXT:  PL/pgSQL function st_reclass(raster,reclassarg[]) line 14 at
 RETURN
 NOTICE:  Invalid argument for reclassargset. Invalid expression of
 reclassexpr for reclassarg of index 0 . Returning original raster
 CONTEXT:  PL/pgSQL function st_reclass(raster,reclassarg[]) line 14 at
 RETURN
 NOTICE:  Invalid argument for reclassargset. Invalid expression of
 reclassexpr for reclassarg of index 0 . Returning original raster
 CONTEXT:  PL/pgSQL function st_reclass(raster,reclassarg[]) line 14 at
 RETURN

 }}}


 I was hoping I could reduce this down to a query or function that doesn't
 involve PostGIS, but have been unable to find one.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3080#comment:2>
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-tickets mailing list