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

Commitc822642

Browse files
committed
Add some basic tests of GUC behavior.
Joachim Wieland
1 parent7946f77 commitc822642

File tree

4 files changed

+222
-4
lines changed

4 files changed

+222
-4
lines changed

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

Lines changed: 150 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,150 @@
1+
-- SET vacuum_cost_delay to some value
2+
SET vacuum_cost_delay TO 400;
3+
SHOW vacuum_cost_delay;
4+
vacuum_cost_delay
5+
-------------------
6+
400ms
7+
(1 row)
8+
9+
-- SET LOCAL has no effect outside of a transaction
10+
SET LOCAL vacuum_cost_delay TO 500;
11+
SHOW vacuum_cost_delay;
12+
vacuum_cost_delay
13+
-------------------
14+
400ms
15+
(1 row)
16+
17+
-- SET LOCAL within a transaction that commits
18+
BEGIN;
19+
SET LOCAL vacuum_cost_delay TO 500;
20+
SHOW vacuum_cost_delay;
21+
vacuum_cost_delay
22+
-------------------
23+
500ms
24+
(1 row)
25+
26+
COMMIT;
27+
SHOW vacuum_cost_delay;
28+
vacuum_cost_delay
29+
-------------------
30+
400ms
31+
(1 row)
32+
33+
-- SET should be reverted after ROLLBACK
34+
BEGIN;
35+
SET vacuum_cost_delay TO 600;
36+
SHOW vacuum_cost_delay;
37+
vacuum_cost_delay
38+
-------------------
39+
600ms
40+
(1 row)
41+
42+
ROLLBACK;
43+
SHOW vacuum_cost_delay;
44+
vacuum_cost_delay
45+
-------------------
46+
400ms
47+
(1 row)
48+
49+
-- Some tests with subtransactions
50+
BEGIN;
51+
SET vacuum_cost_delay TO 700;
52+
SAVEPOINT first_sp;
53+
SET vacuum_cost_delay TO 800;
54+
ROLLBACK TO first_sp;
55+
SHOW vacuum_cost_delay;
56+
vacuum_cost_delay
57+
-------------------
58+
700ms
59+
(1 row)
60+
61+
SAVEPOINT second_sp;
62+
SET vacuum_cost_delay TO 900;
63+
SAVEPOINT third_sp;
64+
SET vacuum_cost_delay TO 1000;
65+
SHOW vacuum_cost_delay;
66+
vacuum_cost_delay
67+
-------------------
68+
1s
69+
(1 row)
70+
71+
ROLLBACK TO third_sp;
72+
SHOW vacuum_cost_delay;
73+
vacuum_cost_delay
74+
-------------------
75+
900ms
76+
(1 row)
77+
78+
ROLLBACK TO second_sp;
79+
SHOW vacuum_cost_delay;
80+
vacuum_cost_delay
81+
-------------------
82+
700ms
83+
(1 row)
84+
85+
ROLLBACK;
86+
-- SET LOCAL with Savepoints
87+
BEGIN;
88+
SHOW vacuum_cost_delay;
89+
vacuum_cost_delay
90+
-------------------
91+
400ms
92+
(1 row)
93+
94+
SAVEPOINT sp;
95+
SET LOCAL vacuum_cost_delay TO 300;
96+
SHOW vacuum_cost_delay;
97+
vacuum_cost_delay
98+
-------------------
99+
300ms
100+
(1 row)
101+
102+
ROLLBACK TO sp;
103+
SHOW vacuum_cost_delay;
104+
vacuum_cost_delay
105+
-------------------
106+
400ms
107+
(1 row)
108+
109+
ROLLBACK;
110+
-- SET followed by SET LOCAL
111+
BEGIN;
112+
SET vacuum_cost_delay TO 400;
113+
SET LOCAL vacuum_cost_delay TO 500;
114+
SHOW vacuum_cost_delay;
115+
vacuum_cost_delay
116+
-------------------
117+
500ms
118+
(1 row)
119+
120+
COMMIT;
121+
SHOW vacuum_cost_delay;
122+
vacuum_cost_delay
123+
-------------------
124+
400ms
125+
(1 row)
126+
127+
--
128+
-- Test RESET. We use datestyle because the reset value is forced by
129+
-- pg_regress, so it doesn't depend on the installation's configuration.
130+
--
131+
SHOW datestyle;
132+
DateStyle
133+
---------------
134+
Postgres, MDY
135+
(1 row)
136+
137+
SET datestyle = iso, ymd;
138+
SHOW datestyle;
139+
DateStyle
140+
-----------
141+
ISO, YMD
142+
(1 row)
143+
144+
RESET datestyle;
145+
SHOW datestyle;
146+
DateStyle
147+
---------------
148+
Postgres, MDY
149+
(1 row)
150+

‎src/test/regress/parallel_schedule

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
# ----------
22
# The first group of parallel test
3-
# $PostgreSQL: pgsql/src/test/regress/parallel_schedule,v 1.32 2006/03/11 04:38:41 momjian Exp $
3+
# $PostgreSQL: pgsql/src/test/regress/parallel_schedule,v 1.33 2006/08/04 00:00:13 tgl Exp $
44
# ----------
55
test: boolean char name varchar text int2 int4 int8 oid float4 float8 bit numeric
66

@@ -69,7 +69,7 @@ test: misc
6969
# ----------
7070
# The fifth group of parallel test
7171
# ----------
72-
test: select_views portals_p2 rules foreign_key cluster dependency
72+
test: select_views portals_p2 rules foreign_key cluster dependency guc
7373

7474
# ----------
7575
# The sixth group of parallel test

‎src/test/regress/serial_schedule

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
# $PostgreSQL: pgsql/src/test/regress/serial_schedule,v 1.30 2006/01/22 05:20:34 neilc Exp $
1+
# $PostgreSQL: pgsql/src/test/regress/serial_schedule,v 1.31 2006/08/04 00:00:13 tgl Exp $
22
# This should probably be in an order similar to parallel_schedule.
33
test: boolean
44
test: char
@@ -84,6 +84,8 @@ test: portals_p2
8484
test: rules
8585
test: foreign_key
8686
test: cluster
87+
test: dependency
88+
test: guc
8789
test: limit
8890
test: plpgsql
8991
test: copy2
@@ -100,4 +102,3 @@ test: polymorphism
100102
test: rowtypes
101103
test: stats
102104
test: tablespace
103-
test: dependency

‎src/test/regress/sql/guc.sql

Lines changed: 67 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,67 @@
1+
-- SET vacuum_cost_delay to some value
2+
SET vacuum_cost_delay TO400;
3+
SHOW vacuum_cost_delay;
4+
5+
-- SET LOCAL has no effect outside of a transaction
6+
SET LOCAL vacuum_cost_delay TO500;
7+
SHOW vacuum_cost_delay;
8+
9+
-- SET LOCAL within a transaction that commits
10+
BEGIN;
11+
SET LOCAL vacuum_cost_delay TO500;
12+
SHOW vacuum_cost_delay;
13+
COMMIT;
14+
SHOW vacuum_cost_delay;
15+
16+
-- SET should be reverted after ROLLBACK
17+
BEGIN;
18+
SET vacuum_cost_delay TO600;
19+
SHOW vacuum_cost_delay;
20+
ROLLBACK;
21+
SHOW vacuum_cost_delay;
22+
23+
-- Some tests with subtransactions
24+
BEGIN;
25+
SET vacuum_cost_delay TO700;
26+
SAVEPOINT first_sp;
27+
SET vacuum_cost_delay TO800;
28+
ROLLBACK TO first_sp;
29+
SHOW vacuum_cost_delay;
30+
SAVEPOINT second_sp;
31+
SET vacuum_cost_delay TO900;
32+
SAVEPOINT third_sp;
33+
SET vacuum_cost_delay TO1000;
34+
SHOW vacuum_cost_delay;
35+
ROLLBACK TO third_sp;
36+
SHOW vacuum_cost_delay;
37+
ROLLBACK TO second_sp;
38+
SHOW vacuum_cost_delay;
39+
ROLLBACK;
40+
41+
-- SET LOCAL with Savepoints
42+
BEGIN;
43+
SHOW vacuum_cost_delay;
44+
SAVEPOINT sp;
45+
SET LOCAL vacuum_cost_delay TO300;
46+
SHOW vacuum_cost_delay;
47+
ROLLBACK TO sp;
48+
SHOW vacuum_cost_delay;
49+
ROLLBACK;
50+
51+
-- SET followed by SET LOCAL
52+
BEGIN;
53+
SET vacuum_cost_delay TO400;
54+
SET LOCAL vacuum_cost_delay TO500;
55+
SHOW vacuum_cost_delay;
56+
COMMIT;
57+
SHOW vacuum_cost_delay;
58+
59+
--
60+
-- Test RESET. We use datestyle because the reset value is forced by
61+
-- pg_regress, so it doesn't depend on the installation's configuration.
62+
--
63+
SHOW datestyle;
64+
SET datestyle= iso, ymd;
65+
SHOW datestyle;
66+
RESET datestyle;
67+
SHOW datestyle;

0 commit comments

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