[postgis-tickets] r17920 - Avoid use of bogus AddRasterConstraint when running upgrade tests

[Sandro Santilli]

Author: strk
Date: 2019-10-16 12:10:57 -0700 (Wed, 16 Oct 2019)
New Revision: 17920

Modified:
   trunk/regress/run_test.pl
Log:
Avoid use of bogus AddRasterConstraint when running upgrade tests

Works around bug #4547

Closes #4530

Modified: trunk/regress/run_test.pl
===================================================================
--- trunk/regress/run_test.pl	2019-10-15 17:21:39 UTC (rev 17919)
+++ trunk/regress/run_test.pl	2019-10-16 19:10:57 UTC (rev 17920)
@@ -320,12 +320,12 @@
 
   if ( $OPT_WITH_RASTER )
   {
-    $query = "insert into upgrade_test(r) ";
-    $query .= "select ST_AddBand(ST_MakeEmptyRaster(10, 10, 1, 1, 2, 2, 0, 0,4326), 1, '8BSI'::text, -129, NULL);";
+    $query = "UPDATE upgrade_test SET r = ";
+    $query .= " ST_AddBand(ST_MakeEmptyRaster(10, 10, 1, 1, 2, 2, 0, 0,4326), 1, '8BSI'::text, -129, NULL);";
     $ret = sql($query);
-    unless ( $ret =~ /^INSERT/ ) {
+    unless ( $ret =~ /^UPDATE/ ) {
       `dropdb $DB`;
-      print "\nSomething went wrong inserting raster into upgrade_test table: $ret.\n";
+      print "\nSomething went wrong setting raster into upgrade_test table: $ret.\n";
       exit(1);
     }