[postgis-tickets] r16943 - [raster] Fix envelope Contains shortcut in ST_Clip

[Darafei]

Author: komzpa
Date: 2018-10-23 06:07:29 -0700 (Tue, 23 Oct 2018)
New Revision: 16943

Modified:
   branches/2.3/NEWS
   branches/2.3/raster/rt_pg/rtpostgis.sql.in
Log:
[raster] Fix envelope Contains shortcut in ST_Clip

Patch by Sai-bot

Closes #3457


Modified: branches/2.3/NEWS
===================================================================
--- branches/2.3/NEWS	2018-10-23 13:05:58 UTC (rev 16942)
+++ branches/2.3/NEWS	2018-10-23 13:07:29 UTC (rev 16943)
@@ -13,6 +13,7 @@
   - #4020, Fix leftovers in topology upgrade from 2.1 (Sandro Santilli)
   - #4203, Fix build with GNU Make 4.1 (Sandro Santilli)
   - #4206, Fix support for PostgreSQL 12 dev branch (Laurenz Albe)
+  - #3457, Fix raster envelope shortcut in ST_Clip (Sai-bot)
 
 PostGIS 2.3.7
 2018/04/06

Modified: branches/2.3/raster/rt_pg/rtpostgis.sql.in
===================================================================
--- branches/2.3/raster/rt_pg/rtpostgis.sql.in	2018-10-23 13:05:58 UTC (rev 16942)
+++ branches/2.3/raster/rt_pg/rtpostgis.sql.in	2018-10-23 13:07:29 UTC (rev 16943)
@@ -6654,7 +6654,7 @@
  	AS $$
 	BEGIN
 		-- short-cut if geometry's extent fully contains raster's extent
-		IF (nodataval IS NULL OR array_length(nodataval, 1) < 1) AND geom ~ ST_Envelope(rast) THEN
+		IF (nodataval IS NULL OR array_length(nodataval, 1) < 1) AND ST_Contains(geom, ST_Envelope(rast)) THEN
 			RETURN rast;
 		END IF;