From f2296f9e0fe31607eaac11c142edc9071fd1e494 Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Thu, 17 Jul 2014 14:02:13 +0000 Subject: [PATCH] Include overviews in the test for reprojected rasters (#2843) git-svn-id: http://svn.osgeo.org/postgis/trunk@12791 b70326c6-7e19-0410-871a-916f4a2858ee --- raster/test/regress/loader/Projected.opts | 2 +- raster/test/regress/loader/Projected.select.expected | 4 +++- raster/test/regress/loader/Projected.select.sql | 5 ++++- 3 files changed, 8 insertions(+), 3 deletions(-) diff --git a/raster/test/regress/loader/Projected.opts b/raster/test/regress/loader/Projected.opts index 98cdce4d5..d98e23d0d 100644 --- a/raster/test/regress/loader/Projected.opts +++ b/raster/test/regress/loader/Projected.opts @@ -1 +1 @@ --s :3857 +-s :3857 -l 2 diff --git a/raster/test/regress/loader/Projected.select.expected b/raster/test/regress/loader/Projected.select.expected index 203172c75..9ea740384 100644 --- a/raster/test/regress/loader/Projected.select.expected +++ b/raster/test/regress/loader/Projected.select.expected @@ -1,2 +1,4 @@ 3857 -BOX(-20037508 25860122,-19887373 44927335) +-20000000 +3857 +-20000000 diff --git a/raster/test/regress/loader/Projected.select.sql b/raster/test/regress/loader/Projected.select.sql index d910efc3a..55b5b2848 100644 --- a/raster/test/regress/loader/Projected.select.sql +++ b/raster/test/regress/loader/Projected.select.sql @@ -1,2 +1,5 @@ SELECT st_srid(rast) from loadedrast limit 1; -SELECT st_extent(ST_SnapToGrid(rast::geometry,1)) from loadedrast; +SELECT st_xmin(ST_SnapToGrid(rast::geometry,1e5)) from loadedrast; + +SELECT st_srid(rast) from o_2_loadedrast limit 1; +SELECT st_xmin(ST_SnapToGrid(rast::geometry,1e5)) from o_2_loadedrast; -- 2.40.0