[postgis-tickets] r17954 - Add tests for schema qualified functions

[Raul]

Author: algunenano
Date: 2019-10-18 05:06:31 -0700 (Fri, 18 Oct 2019)
New Revision: 17954

Modified:
   trunk/regress/core/dump.sql
   trunk/regress/core/dump_expected
   trunk/regress/core/isvaliddetail.sql
   trunk/regress/core/isvaliddetail_expected
   trunk/regress/run_test.pl
Log:
Add tests for schema qualified functions

References #4549



Modified: trunk/regress/core/dump.sql
===================================================================
--- trunk/regress/core/dump.sql	2019-10-18 09:03:09 UTC (rev 17953)
+++ trunk/regress/core/dump.sql	2019-10-18 12:06:31 UTC (rev 17954)
@@ -178,3 +178,14 @@
 	)
 )
 ');
+
+-- Check that it works without the extension schema being available
+SET search_path TO pg_catalog;
+WITH data AS
+(
+    SELECT 'POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))':: :schema geometry as geom
+)
+SELECT	't12',
+	:schema ST_AsText((public.ST_Dump(geom)).geom),
+	:schema ST_AsText((public.ST_DumpRings(geom)).geom) FROM data;
+RESET search_path;

Modified: trunk/regress/core/dump_expected
===================================================================
--- trunk/regress/core/dump_expected	2019-10-18 09:03:09 UTC (rev 17953)
+++ trunk/regress/core/dump_expected	2019-10-18 12:06:31 UTC (rev 17954)
@@ -16,3 +16,4 @@
 t9|{5,1}|POLYGON((0 0,0 9,9 9,9 0,0 0),(5 5,5 6,6 6,5 5))
 t10|0
 t11|0
+t12|POLYGON((0 0,0 1,1 1,1 0,0 0))|POLYGON((0 0,0 1,1 1,1 0,0 0))

Modified: trunk/regress/core/isvaliddetail.sql
===================================================================
--- trunk/regress/core/isvaliddetail.sql	2019-10-18 09:03:09 UTC (rev 17953)
+++ trunk/regress/core/isvaliddetail.sql	2019-10-18 12:06:31 UTC (rev 17954)
@@ -48,3 +48,12 @@
 select '5r', ST_IsValidReason(
 'POLYGON ((70 250, 40 500, 100 400, 70 250, 80 350, 60 350, 70 250))' , 1);
 
+-- Check that it works without the extension schema being available
+SET search_path TO pg_catalog;
+select 7, valid, reason, :schema st_astext(location) FROM (
+  SELECT (:schema ST_IsValidDetail(
+    'POLYGON ((70 250, 70 500, 80 400, 40 400, 70 250))':: :schema geometry
+  )).*
+) foo;
+RESET search_path;
+

Modified: trunk/regress/core/isvaliddetail_expected
===================================================================
--- trunk/regress/core/isvaliddetail_expected	2019-10-18 09:03:09 UTC (rev 17953)
+++ trunk/regress/core/isvaliddetail_expected	2019-10-18 12:06:31 UTC (rev 17954)
@@ -8,3 +8,4 @@
 6|t||
 6s|t
 5r|Valid Geometry
+7|f|Self-intersection|POINT(70 400)

Modified: trunk/regress/run_test.pl
===================================================================
--- trunk/regress/run_test.pl	2019-10-18 09:03:09 UTC (rev 17953)
+++ trunk/regress/run_test.pl	2019-10-18 12:06:31 UTC (rev 17954)
@@ -70,6 +70,7 @@
 our $OPT_UPGRADE_FROM = '';
 my $OPT_UPGRADE_TO = '';
 my $VERBOSE = 0;
+my $OPT_SCHEMA = 'public';
 
 GetOptions (
 	'verbose' => \$VERBOSE,
@@ -83,7 +84,8 @@
 	'raster' => \$OPT_WITH_RASTER,
 	'sfcgal' => \$OPT_WITH_SFCGAL,
 	'expect' => \$OPT_EXPECT,
-	'extensions' => \$OPT_EXTENSIONS
+	'extensions' => \$OPT_EXTENSIONS,
+	'schema=s' => \$OPT_SCHEMA
 	);
 
 if ( @ARGV < 1 )
@@ -770,6 +772,7 @@
           . " -v \"tmpfile='$tmpfile'\""
           . " -v \"scriptdir=$scriptdir\""
           . " -v \"regdir=$REGDIR\""
+          . " -v \"schema=$OPT_SCHEMA.\""
           . " -tXAq $DB < $sql > $outfile 2>&1";
 	my $rv = system($cmd);