Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit6f2eb10

Browse files
committed
fix pathman_interval test (reported by Codecov.io)
1 parent0ef7349 commit6f2eb10

File tree

3 files changed

+16
-16
lines changed

3 files changed

+16
-16
lines changed

‎.gitignore

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -9,4 +9,4 @@ regression.out
99
*.gcda
1010
*.gcno
1111
*.gcov
12-
pg_pathman--1.2.sql
12+
pg_pathman--*.sql

‎expected/pathman_interval.out

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -40,7 +40,7 @@ SELECT * FROM pathman_config;
4040
abc | id | 2 | 1000
4141
(1 row)
4242

43-
DROP TABLE abccascade;
43+
DROP TABLE abcCASCADE;
4444
NOTICE: drop cascades to 3 other objects
4545
/* Range partitions for DATE type */
4646
CREATE TABLE abc (dt DATE NOT NULL);
@@ -72,7 +72,7 @@ SELECT * FROM pathman_config;
7272
abc | dt | 2 | @ 1 mon
7373
(1 row)
7474

75-
DROP TABLE abccascade;
75+
DROP TABLE abcCASCADE;
7676
NOTICE: drop cascades to 2 other objects
7777
/* Range partitions for FLOAT4 type */
7878
CREATE TABLE abc (x FLOAT4 NOT NULL);
@@ -104,10 +104,10 @@ SELECT set_interval('abc', 100);
104104

105105
(1 row)
106106

107-
DROP TABLE abccascade;
107+
DROP TABLE abcCASCADE;
108108
NOTICE: drop cascades to 2 other objects
109109
/* Range partitions for FLOAT8 type */
110-
CREATE TABLE abc (xFLOAT4 NOT NULL);
110+
CREATE TABLE abc (xFLOAT8 NOT NULL);
111111
SELECT create_range_partitions('abc', 'x', 0, 100, 2);
112112
create_range_partitions
113113
-------------------------
@@ -136,7 +136,7 @@ SELECT set_interval('abc', 100);
136136

137137
(1 row)
138138

139-
DROP TABLE abccascade;
139+
DROP TABLE abcCASCADE;
140140
NOTICE: drop cascades to 2 other objects
141141
/* Range partitions for NUMERIC type */
142142
CREATE TABLE abc (x NUMERIC NOT NULL);
@@ -165,7 +165,7 @@ SELECT set_interval('abc', 100);
165165

166166
(1 row)
167167

168-
DROP TABLE abccascade;
168+
DROP TABLE abcCASCADE;
169169
NOTICE: drop cascades to 2 other objects
170170
/* Hash partitioned table shouldn't accept any interval value */
171171
CREATE TABLE abc (id SERIAL);
@@ -179,6 +179,6 @@ SELECT set_interval('abc', 100);
179179
ERROR: table "abc" is not partitioned by RANGE
180180
SELECT set_interval('abc', NULL::INTEGER);
181181
ERROR: table "abc" is not partitioned by RANGE
182-
DROP TABLE abccascade;
182+
DROP TABLE abcCASCADE;
183183
NOTICE: drop cascades to 3 other objects
184184
DROP EXTENSION pg_pathman;

‎sql/pathman_interval.sql

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -17,7 +17,7 @@ UPDATE pathman_config SET range_interval = '0' WHERE partrel = 'abc'::REGCLASS;
1717
SELECT set_interval('abc',1000);
1818
INSERT INTO abcVALUES (250);
1919
SELECT*FROM pathman_config;
20-
DROPTABLE abccascade;
20+
DROPTABLE abcCASCADE;
2121

2222
/* Range partitions for DATE type*/
2323
CREATETABLEabc (dtDATENOT NULL);
@@ -28,7 +28,7 @@ SELECT set_interval('abc', '1 second'::INTERVAL);
2828
/* Set a normal interval*/
2929
SELECT set_interval('abc','1 month'::INTERVAL);
3030
SELECT*FROM pathman_config;
31-
DROPTABLE abccascade;
31+
DROPTABLE abcCASCADE;
3232

3333
/* Range partitions for FLOAT4 type*/
3434
CREATETABLEabc (x FLOAT4NOT NULL);
@@ -42,10 +42,10 @@ SELECT set_interval('abc', 'NaN'::FLOAT4);
4242
SELECT set_interval('abc','Infinity'::FLOAT4);
4343
/* Set a normal interval*/
4444
SELECT set_interval('abc',100);
45-
DROPTABLE abccascade;
45+
DROPTABLE abcCASCADE;
4646

4747
/* Range partitions for FLOAT8 type*/
48-
CREATETABLEabc (xFLOAT4NOT NULL);
48+
CREATETABLEabc (xFLOAT8NOT NULL);
4949
SELECT create_range_partitions('abc','x',0,100,2);
5050
SELECT set_interval('abc',NULL::FLOAT8);
5151
/* Set a trivial interval*/
@@ -56,7 +56,7 @@ SELECT set_interval('abc', 'NaN'::FLOAT8);
5656
SELECT set_interval('abc','Infinity'::FLOAT8);
5757
/* Set a normal interval*/
5858
SELECT set_interval('abc',100);
59-
DROPTABLE abccascade;
59+
DROPTABLE abcCASCADE;
6060

6161
/* Range partitions for NUMERIC type*/
6262
CREATETABLEabc (xNUMERICNOT NULL);
@@ -68,13 +68,13 @@ SELECT set_interval('abc', 0);
6868
SELECT set_interval('abc','NaN'::NUMERIC);
6969
/* Set a normal interval*/
7070
SELECT set_interval('abc',100);
71-
DROPTABLE abccascade;
71+
DROPTABLE abcCASCADE;
7272

7373
/* Hash partitioned table shouldn't accept any interval value*/
7474
CREATETABLEabc (idSERIAL);
7575
SELECT create_hash_partitions('abc','id',3);
7676
SELECT set_interval('abc',100);
7777
SELECT set_interval('abc',NULL::INTEGER);
78-
DROPTABLE abccascade;
78+
DROPTABLE abcCASCADE;
7979

80-
DROP EXTENSION pg_pathman;
80+
DROP EXTENSION pg_pathman;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp