Skip to content

Commit 15e574e

Browse files
committed
test FREEZE in pathman_utility_stmt_hooking
1 parent 176572e commit 15e574e

File tree

2 files changed

+8
-2
lines changed

2 files changed

+8
-2
lines changed

expected/pathman_utility_stmt_hooking.out

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -157,9 +157,12 @@ SELECT * FROM copy_stmt_hooking.test WHERE val > 20;
157157
21 | test_no_part | 0 | 0
158158
(1 row)
159159

160-
/* COPY TO (partitioned column is not specified) */
160+
/* COPY FROM (partitioned column is not specified) */
161161
COPY copy_stmt_hooking.test(comment) FROM stdin;
162162
ERROR: partitioned column's value should not be NULL
163+
/* COPY FROM (we don't support FREEZE) */
164+
COPY copy_stmt_hooking.test FROM stdin WITH (FREEZE);
165+
ERROR: freeze is not supported for partitioned tables
163166
/* Drop column (make use of 'tuple_map') */
164167
ALTER TABLE copy_stmt_hooking.test DROP COLUMN comment;
165168
/* create new partition */

sql/pathman_utility_stmt_hooking.sql

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -70,11 +70,14 @@ COPY copy_stmt_hooking.test FROM stdin;
7070
\.
7171
SELECT * FROM copy_stmt_hooking.test WHERE val > 20;
7272

73-
/* COPY TO (partitioned column is not specified) */
73+
/* COPY FROM (partitioned column is not specified) */
7474
COPY copy_stmt_hooking.test(comment) FROM stdin;
7575
test_no_part
7676
\.
7777

78+
/* COPY FROM (we don't support FREEZE) */
79+
COPY copy_stmt_hooking.test FROM stdin WITH (FREEZE);
80+
7881

7982
/* Drop column (make use of 'tuple_map') */
8083
ALTER TABLE copy_stmt_hooking.test DROP COLUMN comment;

0 commit comments

Comments
 (0)