[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