Fix test data for PG raster

elpaso · elpaso · commit c06c209d2d20 · 2020-05-28T17:47:01.000+02:00
diff --git a/tests/src/python/test_provider_postgresraster.py b/tests/src/python/test_provider_postgresraster.py
@@ -77,6 +77,7 @@ def setUpClass(cls):
         cls._load_test_table('public', 'raster_3035_tiled_composite_pk')
         cls._load_test_table('public', 'raster_3035_untiled_multiple_rows')
         cls._load_test_table('idro', 'cosmo_i5_snow', 'bug_34823_pg_raster')
+        cls._load_test_table('public', 'int16_regression_36689', 'bug_36689_pg_raster')
 
         # Fix timing issues in backend
         # time.sleep(1)
diff --git a/tests/testdata/provider/postgresraster/bug_36689_pg_raster.sql b/tests/testdata/provider/postgresraster/bug_36689_pg_raster.sql
@@ -3,12 +3,9 @@
 -- Test github issue 36689
 --
 
-BEGIN;
 DROP TABLE IF EXISTS "int16_regression_36689";
 CREATE TABLE "int16_regression_36689" ("rid" serial PRIMARY KEY,"rast" raster,"filename" text);
 INSERT INTO "int16_regression_36689" ("rast","filename") VALUES ('0100000100555555555555C53F555555555555C5BF0000000000002240000000000000474000000000000000000000000000000000E610000006000600450080370034002E00270021001E003A00360031002D00290025003A00360032002F002D002B003600330031002F002E002C002F002F002F002F002E002D0029002B002D00300031002E00'::raster,'int16.tiff');
 CREATE INDEX ON "int16_regression_36689" USING gist (st_convexhull("rast"));
 ANALYZE "int16_regression_36689";
 SELECT AddRasterConstraints('','int16_regression_36689','rast',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,TRUE);
-END;
-VACUUM ANALYZE "int16_regression_36689";
