From 17f19047df0b35c589d254963781240f6e5de0e9 Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Wed, 1 Feb 2012 11:51:42 +0000 Subject: [PATCH] Make test more readable git-svn-id: http://svn.osgeo.org/postgis/trunk@8996 b70326c6-7e19-0410-871a-916f4a2858ee --- raster/test/regress/rt_mapalgebraexpr.sql | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/raster/test/regress/rt_mapalgebraexpr.sql b/raster/test/regress/rt_mapalgebraexpr.sql index be0dc1a05..dc28f2969 100644 --- a/raster/test/regress/rt_mapalgebraexpr.sql +++ b/raster/test/regress/rt_mapalgebraexpr.sql @@ -31,5 +31,11 @@ FROM ST_TestRaster(0, 0, 10) rast, ORDER BY x, y; -- Test evaluations to null (see #1523) -SELECT 'T11.1', ST_Value(rast, 1, 1), ST_Value(ST_MapAlgebraExpr(rast, 1, NULL, 'g from (select NULL as g) as foo', 2), 1, 1) FROM ST_TestRaster(0, 0, 10) rast; -SELECT 'T11.2', ST_Value(rast, 1, 1), ST_Value(ST_MapAlgebraExpr(rast, 1, NULL, 'g from (select RAST,NULL as g) as foo', 2), 1, 1) FROM ST_TestRaster(0, 0, 10) rast; +WITH op AS ( select rast AS rin, + ST_MapAlgebraExpr(rast, 1, NULL, 'g from (select NULL as g) as foo', 2) + AS rout FROM ST_TestRaster(0, 0, 10) rast ) +SELECT 'T11.1', ST_Value(rin, 1, 1), ST_Value(rout, 1, 1) FROM op; +WITH op AS ( select rast AS rin, + ST_MapAlgebraExpr(rast, 1, NULL, 'g from (select RAST,NULL as g) as foo', 2) + AS rout FROM ST_TestRaster(0, 0, 10) rast ) +SELECT 'T11.2', ST_Value(rin, 1, 1), ST_Value(rout, 1, 1) FROM op; -- 2.40.0