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

Commitddf509e

Browse files
Tweak tests in COPY FREEZE
1 parent8de72b6 commitddf509e

File tree

2 files changed

+10
-6
lines changed

2 files changed

+10
-6
lines changed

‎src/test/regress/expected/copy2.out

Lines changed: 10 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -297,16 +297,20 @@ SELECT * FROM vistest;
297297
(2 rows)
298298

299299
COMMIT;
300+
BEGIN;
300301
TRUNCATE vistest;
301302
COPY vistest FROM stdin CSV FREEZE;
302-
NOTICE: FREEZE option specified but pre-conditions not met
303303
SELECT * FROM vistest;
304304
a
305305
---
306-
a
307-
b
306+
x
307+
y
308308
(2 rows)
309309

310+
COMMIT;
311+
TRUNCATE vistest;
312+
COPY vistest FROM stdin CSV FREEZE;
313+
NOTICE: FREEZE option specified but pre-conditions not met
310314
BEGIN;
311315
INSERT INTO vistest VALUES ('z');
312316
SAVEPOINT s1;
@@ -318,8 +322,8 @@ NOTICE: FREEZE option specified but pre-conditions not met
318322
SELECT * FROM vistest;
319323
a
320324
---
321-
a
322-
b
325+
p
326+
g
323327
z
324328
d
325329
e
@@ -360,6 +364,7 @@ SELECT * FROM vistest;
360364
(2 rows)
361365

362366
DROP TABLE vistest;
367+
DROP FUNCTION truncate_in_subxact();
363368
DROP TABLE x, y;
364369
DROP FUNCTION fn_x_before();
365370
DROP FUNCTION fn_x_after();

‎src/test/regress/sql/copy2.sql

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -229,7 +229,6 @@ INSERT INTO vistest VALUES ('z');
229229
SAVEPOINT s1;
230230
TRUNCATE vistest;
231231
ROLLBACK TO SAVEPOINT s1;
232-
-- FREEZE should be silently ignored here
233232
COPY vistestFROM stdin CSV FREEZE;
234233
d
235234
e

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp