[postgis-tickets] [SCM] PostGIS branch master updated. 3.2.0alpha1-5-g97139b6

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, master has been updated
       via  97139b6e803b0588b64497cd1c60d47abb30572a (commit)
      from  d807a0faec9d6e85b9fe107e3c5b0396cef01339 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 97139b6e803b0588b64497cd1c60d47abb30572a
Author: Regina Obe <lr at pcorp.us>
Date:   Tue Sep 21 08:49:42 2021 -0400

    Test functions even if not directly in sect1 section.
    Put in OVER(ORDER BY random()) for all aggs and window functions.
    Exclude ST_AsMVT and ST_AsFlatGeobuf for now since they have known
    crashers.  Until fixed.
    References #4998 for PostGIS 3.2.

diff --git a/doc/xsl/postgis_gardentest.sql.xsl b/doc/xsl/postgis_gardentest.sql.xsl
index c896340..77ece32 100644
--- a/doc/xsl/postgis_gardentest.sql.xsl
+++ b/doc/xsl/postgis_gardentest.sql.xsl
@@ -10,7 +10,7 @@
 	<xsl:output method="text" />
 	<xsl:variable name='testversion'>3.2.0</xsl:variable>
 	<xsl:variable name='fnexclude14'>AddGeometryColumn DropGeometryColumn DropGeometryTable</xsl:variable>
-	<xsl:variable name='fnexclude'>AddGeometryColumn DropGeometryColumn DropGeometryTable</xsl:variable>
+	<xsl:variable name='fnexclude'>AddGeometryColumn DropGeometryColumn DropGeometryTable ST_AsFlatGeobuf ST_AsMVT</xsl:variable>
 	<!--This is just a place holder to state functions not supported or tested separately -->
 
 	<xsl:variable name='var_srid'>3395</xsl:variable>
@@ -481,7 +481,7 @@ SELECT '<xsl:value-of select="$log_label" /> Geography: End Testing';
 	</xsl:for-each>
 <!--End test on operators -->
 <!-- Start regular function checks excluding operators -->
-		<xsl:for-each select="sect1[not(contains(@id,'Operator'))]/refentry">
+		<xsl:for-each select="sect1[not(contains(@id,'Operator'))]//refentry">
 		<xsl:sort select="@id"/>
 
 			<xsl:for-each select="refsynopsisdiv/funcsynopsis/funcprototype">
@@ -511,11 +511,11 @@ SELECT '<xsl:value-of select="$log_label" /> Geography: End Testing';
 				  </xsl:choose>
 				</xsl:variable>
 
-				<!-- is a window function -->
+				<!-- is a window or aggregate function -->
 				<xsl:variable name='over_clause'>
 					 <xsl:choose>
-					 	<xsl:when test="paramdef/type[contains(text(),'winset')]">
-					 		<xsl:value-of select="'OVER()'"/>
+					 	<xsl:when test="paramdef/type[contains(text(),'set')]">
+					 		<xsl:value-of select="'OVER(ORDER BY random())'"/>
 					 	</xsl:when>
 					<xsl:otherwise>
 					  <xsl:value-of select="''"/>
diff --git a/doc/xsl/raster_gardentest.sql.xsl b/doc/xsl/raster_gardentest.sql.xsl
index 13af0e5..83186d6 100644
--- a/doc/xsl/raster_gardentest.sql.xsl
+++ b/doc/xsl/raster_gardentest.sql.xsl
@@ -185,7 +185,7 @@ COMMIT;
 
 
 <!--Start test on operators  -->
-	<xsl:for-each select="sect1[contains(@id,'RT_Operator')]/refentry">
+	<xsl:for-each select="sect1[contains(@id,'RT_Operator')]//refentry">
 		<xsl:sort select="@id"/>
 		<xsl:for-each select="refsynopsisdiv/funcsynopsis/funcprototype">
 			<xsl:variable name='fnname'><xsl:value-of select="funcdef/function"/></xsl:variable>
@@ -266,6 +266,19 @@ COMMIT;
 					</xsl:otherwise>
 				  </xsl:choose>
 				</xsl:variable>
+
+				<!-- is a window or aggregate function -->
+				<xsl:variable name='over_clause'>
+					 <xsl:choose>
+					 	<xsl:when test="paramdef/type[contains(text(),'set')]">
+					 		<xsl:value-of select="'OVER(ORDER BY random())'"/>
+					 	</xsl:when>
+					<xsl:otherwise>
+					  <xsl:value-of select="''"/>
+					</xsl:otherwise>
+				  </xsl:choose>
+				</xsl:variable>
+
 				SELECT 'Start Considering <xsl:value-of select="funcdef/function" /> <xsl:value-of select="$geoftype" />';
 
 				<!-- For each function prototype generate a test sql statement -->
@@ -296,7 +309,7 @@ SELECT  'Ending <xsl:value-of select="funcdef/function" />(<xsl:value-of select=
 	 <!-- If output is raster show ewkt convexhull rep -->
 	 		INSERT INTO <xsl:value-of select="$var_logtable" />(log_label, func, g1, log_start, log_sql)
 			  	VALUES('<xsl:value-of select="$log_label" /> <xsl:value-of select="$geoftype" /> <xsl:text> </xsl:text><xsl:value-of select="@ID" /><xsl:text> </xsl:text><xsl:value-of select="@PixType" />','<xsl:value-of select="$fnname" />', '<xsl:value-of select="@PixType" />', clock_timestamp(),
-			  		'<xsl:call-template name="escapesinglequotes"><xsl:with-param name="arg1">SELECT ST_AsEWKT(ST_ConvexHull(<xsl:value-of select="$fnname" />(<xsl:value-of select="$fnfakeparams" />))) FROM (<xsl:value-of select="." />) As rast1 LIMIT 3;</xsl:with-param></xsl:call-template>'
+			  		'<xsl:call-template name="escapesinglequotes"><xsl:with-param name="arg1">SELECT ST_AsEWKT(ST_ConvexHull(<xsl:value-of select="$fnname" />(<xsl:value-of select="$fnfakeparams" />) <xsl:value-of select="$over_clause" />)) FROM (<xsl:value-of select="." />) As rast1 LIMIT 3;</xsl:with-param></xsl:call-template>'
 			  	);
 			  </xsl:when>
 			  <xsl:otherwise>

-----------------------------------------------------------------------

Summary of changes:
 doc/xsl/postgis_gardentest.sql.xsl | 10 +++++-----
 doc/xsl/raster_gardentest.sql.xsl  | 17 +++++++++++++++--
 2 files changed, 20 insertions(+), 7 deletions(-)


hooks/post-receive
-- 
PostGIS