[postgis-tickets] r15405 - Revise rt_union test so passes equally on PostgreSQL 10 and lower. Lower calls SRF for each column, triggering the same error notice multiple times, PostgreSQL 10 called SRF only once. Revised syntax so old versions call SRF only once.

[Regina Obe]

Author: robe
Date: 2017-05-25 23:25:16 -0700 (Thu, 25 May 2017)
New Revision: 15405

Modified:
   trunk/raster/test/regress/rt_union.sql
   trunk/raster/test/regress/rt_union_expected
Log:
Revise rt_union test so passes equally on PostgreSQL 10 and lower.  Lower calls SRF for each column, triggering the same error notice multiple times, PostgreSQL 10 called SRF only once. Revised syntax so old versions call SRF only once.

Closes #3763 for trunk PostGIS 2.4.0 

Modified: trunk/raster/test/regress/rt_union.sql
===================================================================
--- trunk/raster/test/regress/rt_union.sql	2017-05-26 04:41:19 UTC (rev 15404)
+++ trunk/raster/test/regress/rt_union.sql	2017-05-26 06:25:16 UTC (rev 15405)
@@ -143,13 +143,13 @@
 
 SELECT
 	uniontype,
-	x,
-	y,
-	val
+	(pp).x,
+	(pp).y,
+	(pp).val
 FROM (
 	SELECT
 		uniontype,
-		(ST_PixelAsPoints(rast)).*
+		(ST_PixelAsPoints(rast)) AS pp
 	FROM raster_union_out
 ) foo
 ORDER BY uniontype, y, x;

Modified: trunk/raster/test/regress/rt_union_expected
===================================================================
--- trunk/raster/test/regress/rt_union_expected	2017-05-26 04:41:19 UTC (rev 15404)
+++ trunk/raster/test/regress/rt_union_expected	2017-05-26 06:25:16 UTC (rev 15405)
@@ -53,9 +53,6 @@
 SUM|2|3|2
 SUM|3|3|2
 NOTICE:  No pixels found for band 1
-NOTICE:  No pixels found for band 1
-NOTICE:  No pixels found for band 1
-NOTICE:  No pixels found for band 1
 COUNT|1|1|1
 COUNT|2|1|1
 COUNT|3|1|1