fix pathman_interval test (reported by Codecov.io)

funbringer · funbringer · commit 6f2eb101a8ed · 2017-02-10T20:09:44.000+03:00
diff --git a/.gitignore b/.gitignore
@@ -9,4 +9,4 @@ regression.out
 *.gcda
 *.gcno
 *.gcov
-pg_pathman--1.2.sql
+pg_pathman--*.sql
diff --git a/expected/pathman_interval.out b/expected/pathman_interval.out
@@ -40,7 +40,7 @@ SELECT * FROM pathman_config;
  abc     | id      |        2 | 1000
 (1 row)
 
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 NOTICE:  drop cascades to 3 other objects
 /* Range partitions for DATE type */
 CREATE TABLE abc (dt DATE NOT NULL);
@@ -72,7 +72,7 @@ SELECT * FROM pathman_config;
  abc     | dt      |        2 | @ 1 mon
 (1 row)
 
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 NOTICE:  drop cascades to 2 other objects
 /* Range partitions for FLOAT4 type */
 CREATE TABLE abc (x FLOAT4 NOT NULL);
@@ -104,10 +104,10 @@ SELECT set_interval('abc', 100);
  
 (1 row)
 
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 NOTICE:  drop cascades to 2 other objects
 /* Range partitions for FLOAT8 type */
-CREATE TABLE abc (x FLOAT4 NOT NULL);
+CREATE TABLE abc (x FLOAT8 NOT NULL);
 SELECT create_range_partitions('abc', 'x', 0, 100, 2);
  create_range_partitions 
 -------------------------
@@ -136,7 +136,7 @@ SELECT set_interval('abc', 100);
  
 (1 row)
 
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 NOTICE:  drop cascades to 2 other objects
 /* Range partitions for NUMERIC type */
 CREATE TABLE abc (x NUMERIC NOT NULL);
@@ -165,7 +165,7 @@ SELECT set_interval('abc', 100);
  
 (1 row)
 
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 NOTICE:  drop cascades to 2 other objects
 /* Hash partitioned table shouldn't accept any interval value */
 CREATE TABLE abc (id SERIAL);
@@ -179,6 +179,6 @@ SELECT set_interval('abc', 100);
 ERROR:  table "abc" is not partitioned by RANGE
 SELECT set_interval('abc', NULL::INTEGER);
 ERROR:  table "abc" is not partitioned by RANGE
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 NOTICE:  drop cascades to 3 other objects
 DROP EXTENSION pg_pathman;
diff --git a/sql/pathman_interval.sql b/sql/pathman_interval.sql
@@ -17,7 +17,7 @@ UPDATE pathman_config SET range_interval = '0' WHERE partrel = 'abc'::REGCLASS;
 SELECT set_interval('abc', 1000);
 INSERT INTO abc VALUES (250);
 SELECT * FROM pathman_config;
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 
 /* Range partitions for DATE type */
 CREATE TABLE abc (dt DATE NOT NULL);
@@ -28,7 +28,7 @@ SELECT set_interval('abc', '1 second'::INTERVAL);
 /* Set a normal interval */
 SELECT set_interval('abc', '1 month'::INTERVAL);
 SELECT * FROM pathman_config;
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 
 /* Range partitions for FLOAT4 type */
 CREATE TABLE abc (x FLOAT4 NOT NULL);
@@ -42,10 +42,10 @@ SELECT set_interval('abc', 'NaN'::FLOAT4);
 SELECT set_interval('abc', 'Infinity'::FLOAT4);
 /* Set a normal interval */
 SELECT set_interval('abc', 100);
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 
 /* Range partitions for FLOAT8 type */
-CREATE TABLE abc (x FLOAT4 NOT NULL);
+CREATE TABLE abc (x FLOAT8 NOT NULL);
 SELECT create_range_partitions('abc', 'x', 0, 100, 2);
 SELECT set_interval('abc', NULL::FLOAT8);
 /* Set a trivial interval */
@@ -56,7 +56,7 @@ SELECT set_interval('abc', 'NaN'::FLOAT8);
 SELECT set_interval('abc', 'Infinity'::FLOAT8);
 /* Set a normal interval */
 SELECT set_interval('abc', 100);
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 
 /* Range partitions for NUMERIC type */
 CREATE TABLE abc (x NUMERIC NOT NULL);
@@ -68,13 +68,13 @@ SELECT set_interval('abc', 0);
 SELECT set_interval('abc', 'NaN'::NUMERIC);
 /* Set a normal interval */
 SELECT set_interval('abc', 100);
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 
 /* Hash partitioned table shouldn't accept any interval value */
 CREATE TABLE abc (id SERIAL);
 SELECT create_hash_partitions('abc', 'id', 3);
 SELECT set_interval('abc', 100);
 SELECT set_interval('abc', NULL::INTEGER);
-DROP TABLE abc cascade;
+DROP TABLE abc CASCADE;
 
-DROP EXTENSION pg_pathman;
+DROP EXTENSION pg_pathman;
