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

Commita7b8f06

Browse files
committed
Fix typo
1 parentb4e2ada commita7b8f06

File tree

2 files changed

+116
-116
lines changed

2 files changed

+116
-116
lines changed

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

Lines changed: 72 additions & 72 deletions
Original file line numberDiff line numberDiff line change
@@ -69,124 +69,124 @@ SELECT proname, provolatile FROM pg_proc
6969
--
7070
-- SECURITY DEFINER | INVOKER
7171
--
72-
CREATE FUNCTIONfunctext_C_1(int) RETURNS bool LANGUAGE 'sql'
72+
CREATE FUNCTIONfunctest_C_1(int) RETURNS bool LANGUAGE 'sql'
7373
AS 'SELECT $1 > 0';
74-
CREATE FUNCTIONfunctext_C_2(int) RETURNS bool LANGUAGE 'sql'
74+
CREATE FUNCTIONfunctest_C_2(int) RETURNS bool LANGUAGE 'sql'
7575
SECURITY DEFINER AS 'SELECT $1 = 0';
76-
CREATE FUNCTIONfunctext_C_3(int) RETURNS bool LANGUAGE 'sql'
76+
CREATE FUNCTIONfunctest_C_3(int) RETURNS bool LANGUAGE 'sql'
7777
SECURITY INVOKER AS 'SELECT $1 < 0';
7878
SELECT proname, prosecdef FROM pg_proc
79-
WHERE oid in ('functext_C_1'::regproc,
80-
'functext_C_2'::regproc,
81-
'functext_C_3'::regproc) ORDER BY proname;
79+
WHERE oid in ('functest_C_1'::regproc,
80+
'functest_C_2'::regproc,
81+
'functest_C_3'::regproc) ORDER BY proname;
8282
proname | prosecdef
8383
--------------+-----------
84-
functext_c_1 | f
85-
functext_c_2 | t
86-
functext_c_3 | f
84+
functest_c_1 | f
85+
functest_c_2 | t
86+
functest_c_3 | f
8787
(3 rows)
8888

89-
ALTER FUNCTIONfunctext_C_1(int) IMMUTABLE;-- unrelated change, no effect
90-
ALTER FUNCTIONfunctext_C_2(int) SECURITY INVOKER;
91-
ALTER FUNCTIONfunctext_C_3(int) SECURITY DEFINER;
89+
ALTER FUNCTIONfunctest_C_1(int) IMMUTABLE;-- unrelated change, no effect
90+
ALTER FUNCTIONfunctest_C_2(int) SECURITY INVOKER;
91+
ALTER FUNCTIONfunctest_C_3(int) SECURITY DEFINER;
9292
SELECT proname, prosecdef FROM pg_proc
93-
WHERE oid in ('functext_C_1'::regproc,
94-
'functext_C_2'::regproc,
95-
'functext_C_3'::regproc) ORDER BY proname;
93+
WHERE oid in ('functest_C_1'::regproc,
94+
'functest_C_2'::regproc,
95+
'functest_C_3'::regproc) ORDER BY proname;
9696
proname | prosecdef
9797
--------------+-----------
98-
functext_c_1 | f
99-
functext_c_2 | f
100-
functext_c_3 | t
98+
functest_c_1 | f
99+
functest_c_2 | f
100+
functest_c_3 | t
101101
(3 rows)
102102

103103
--
104104
-- LEAKPROOF
105105
--
106-
CREATE FUNCTIONfunctext_E_1(int) RETURNS bool LANGUAGE 'sql'
106+
CREATE FUNCTIONfunctest_E_1(int) RETURNS bool LANGUAGE 'sql'
107107
AS 'SELECT $1 > 100';
108-
CREATE FUNCTIONfunctext_E_2(int) RETURNS bool LANGUAGE 'sql'
108+
CREATE FUNCTIONfunctest_E_2(int) RETURNS bool LANGUAGE 'sql'
109109
LEAKPROOF AS 'SELECT $1 > 100';
110110
SELECT proname, proleakproof FROM pg_proc
111-
WHERE oid in ('functext_E_1'::regproc,
112-
'functext_E_2'::regproc) ORDER BY proname;
111+
WHERE oid in ('functest_E_1'::regproc,
112+
'functest_E_2'::regproc) ORDER BY proname;
113113
proname | proleakproof
114114
--------------+--------------
115-
functext_e_1 | f
116-
functext_e_2 | t
115+
functest_e_1 | f
116+
functest_e_2 | t
117117
(2 rows)
118118

119-
ALTER FUNCTIONfunctext_E_1(int) LEAKPROOF;
120-
ALTER FUNCTIONfunctext_E_2(int) STABLE;-- unrelated change, no effect
119+
ALTER FUNCTIONfunctest_E_1(int) LEAKPROOF;
120+
ALTER FUNCTIONfunctest_E_2(int) STABLE;-- unrelated change, no effect
121121
SELECT proname, proleakproof FROM pg_proc
122-
WHERE oid in ('functext_E_1'::regproc,
123-
'functext_E_2'::regproc) ORDER BY proname;
122+
WHERE oid in ('functest_E_1'::regproc,
123+
'functest_E_2'::regproc) ORDER BY proname;
124124
proname | proleakproof
125125
--------------+--------------
126-
functext_e_1 | t
127-
functext_e_2 | t
126+
functest_e_1 | t
127+
functest_e_2 | t
128128
(2 rows)
129129

130-
ALTER FUNCTIONfunctext_E_2(int) NOT LEAKPROOF;-- remove leakproog attribute
130+
ALTER FUNCTIONfunctest_E_2(int) NOT LEAKPROOF;-- remove leakproog attribute
131131
SELECT proname, proleakproof FROM pg_proc
132-
WHERE oid in ('functext_E_1'::regproc,
133-
'functext_E_2'::regproc) ORDER BY proname;
132+
WHERE oid in ('functest_E_1'::regproc,
133+
'functest_E_2'::regproc) ORDER BY proname;
134134
proname | proleakproof
135135
--------------+--------------
136-
functext_e_1 | t
137-
functext_e_2 | f
136+
functest_e_1 | t
137+
functest_e_2 | f
138138
(2 rows)
139139

140140
-- it takes superuser privilege to turn on leakproof, but not for turn off
141-
ALTER FUNCTIONfunctext_E_1(int) OWNER TO regress_unpriv_user;
142-
ALTER FUNCTIONfunctext_E_2(int) OWNER TO regress_unpriv_user;
141+
ALTER FUNCTIONfunctest_E_1(int) OWNER TO regress_unpriv_user;
142+
ALTER FUNCTIONfunctest_E_2(int) OWNER TO regress_unpriv_user;
143143
SET SESSION AUTHORIZATION regress_unpriv_user;
144144
SET search_path TO temp_func_test, public;
145-
ALTER FUNCTIONfunctext_E_1(int) NOT LEAKPROOF;
146-
ALTER FUNCTIONfunctext_E_2(int) LEAKPROOF;
145+
ALTER FUNCTIONfunctest_E_1(int) NOT LEAKPROOF;
146+
ALTER FUNCTIONfunctest_E_2(int) LEAKPROOF;
147147
ERROR: only superuser can define a leakproof function
148-
CREATE FUNCTIONfunctext_E_3(int) RETURNS bool LANGUAGE 'sql'
148+
CREATE FUNCTIONfunctest_E_3(int) RETURNS bool LANGUAGE 'sql'
149149
LEAKPROOF AS 'SELECT $1 < 200';-- failed
150150
ERROR: only superuser can define a leakproof function
151151
RESET SESSION AUTHORIZATION;
152152
--
153153
-- CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
154154
--
155-
CREATE FUNCTIONfunctext_F_1(int) RETURNS bool LANGUAGE 'sql'
155+
CREATE FUNCTIONfunctest_F_1(int) RETURNS bool LANGUAGE 'sql'
156156
AS 'SELECT $1 > 50';
157-
CREATE FUNCTIONfunctext_F_2(int) RETURNS bool LANGUAGE 'sql'
157+
CREATE FUNCTIONfunctest_F_2(int) RETURNS bool LANGUAGE 'sql'
158158
CALLED ON NULL INPUT AS 'SELECT $1 = 50';
159-
CREATE FUNCTIONfunctext_F_3(int) RETURNS bool LANGUAGE 'sql'
159+
CREATE FUNCTIONfunctest_F_3(int) RETURNS bool LANGUAGE 'sql'
160160
RETURNS NULL ON NULL INPUT AS 'SELECT $1 < 50';
161-
CREATE FUNCTIONfunctext_F_4(int) RETURNS bool LANGUAGE 'sql'
161+
CREATE FUNCTIONfunctest_F_4(int) RETURNS bool LANGUAGE 'sql'
162162
STRICT AS 'SELECT $1 = 50';
163163
SELECT proname, proisstrict FROM pg_proc
164-
WHERE oid in ('functext_F_1'::regproc,
165-
'functext_F_2'::regproc,
166-
'functext_F_3'::regproc,
167-
'functext_F_4'::regproc) ORDER BY proname;
164+
WHERE oid in ('functest_F_1'::regproc,
165+
'functest_F_2'::regproc,
166+
'functest_F_3'::regproc,
167+
'functest_F_4'::regproc) ORDER BY proname;
168168
proname | proisstrict
169169
--------------+-------------
170-
functext_f_1 | f
171-
functext_f_2 | f
172-
functext_f_3 | t
173-
functext_f_4 | t
170+
functest_f_1 | f
171+
functest_f_2 | f
172+
functest_f_3 | t
173+
functest_f_4 | t
174174
(4 rows)
175175

176-
ALTER FUNCTIONfunctext_F_1(int) IMMUTABLE;-- unrelated change, no effect
177-
ALTER FUNCTIONfunctext_F_2(int) STRICT;
178-
ALTER FUNCTIONfunctext_F_3(int) CALLED ON NULL INPUT;
176+
ALTER FUNCTIONfunctest_F_1(int) IMMUTABLE;-- unrelated change, no effect
177+
ALTER FUNCTIONfunctest_F_2(int) STRICT;
178+
ALTER FUNCTIONfunctest_F_3(int) CALLED ON NULL INPUT;
179179
SELECT proname, proisstrict FROM pg_proc
180-
WHERE oid in ('functext_F_1'::regproc,
181-
'functext_F_2'::regproc,
182-
'functext_F_3'::regproc,
183-
'functext_F_4'::regproc) ORDER BY proname;
180+
WHERE oid in ('functest_F_1'::regproc,
181+
'functest_F_2'::regproc,
182+
'functest_F_3'::regproc,
183+
'functest_F_4'::regproc) ORDER BY proname;
184184
proname | proisstrict
185185
--------------+-------------
186-
functext_f_1 | f
187-
functext_f_2 | t
188-
functext_f_3 | f
189-
functext_f_4 | t
186+
functest_f_1 | f
187+
functest_f_2 | t
188+
functest_f_3 | f
189+
functest_f_4 | t
190190
(4 rows)
191191

192192
-- information_schema tests
@@ -236,15 +236,15 @@ drop cascades to function functest_a_3()
236236
drop cascades to function functest_b_2(integer)
237237
drop cascades to function functest_b_3(integer)
238238
drop cascades to function functest_b_4(integer)
239-
drop cascades to functionfunctext_c_1(integer)
240-
drop cascades to functionfunctext_c_2(integer)
241-
drop cascades to functionfunctext_c_3(integer)
242-
drop cascades to functionfunctext_e_1(integer)
243-
drop cascades to functionfunctext_e_2(integer)
244-
drop cascades to functionfunctext_f_1(integer)
245-
drop cascades to functionfunctext_f_2(integer)
246-
drop cascades to functionfunctext_f_3(integer)
247-
drop cascades to functionfunctext_f_4(integer)
239+
drop cascades to functionfunctest_c_1(integer)
240+
drop cascades to functionfunctest_c_2(integer)
241+
drop cascades to functionfunctest_c_3(integer)
242+
drop cascades to functionfunctest_e_1(integer)
243+
drop cascades to functionfunctest_e_2(integer)
244+
drop cascades to functionfunctest_f_1(integer)
245+
drop cascades to functionfunctest_f_2(integer)
246+
drop cascades to functionfunctest_f_3(integer)
247+
drop cascades to functionfunctest_f_4(integer)
248248
drop cascades to function functest_b_2(bigint)
249249
DROP USER regress_unpriv_user;
250250
RESET search_path;

‎src/test/regress/sql/create_function_3.sql

Lines changed: 44 additions & 44 deletions
Original file line numberDiff line numberDiff line change
@@ -52,86 +52,86 @@ SELECT proname, provolatile FROM pg_proc
5252
--
5353
-- SECURITY DEFINER | INVOKER
5454
--
55-
CREATEFUNCTIONfunctext_C_1(int) RETURNS bool LANGUAGE'sql'
55+
CREATEFUNCTIONfunctest_C_1(int) RETURNS bool LANGUAGE'sql'
5656
AS'SELECT $1 > 0';
57-
CREATEFUNCTIONfunctext_C_2(int) RETURNS bool LANGUAGE'sql'
57+
CREATEFUNCTIONfunctest_C_2(int) RETURNS bool LANGUAGE'sql'
5858
SECURITY DEFINERAS'SELECT $1 = 0';
59-
CREATEFUNCTIONfunctext_C_3(int) RETURNS bool LANGUAGE'sql'
59+
CREATEFUNCTIONfunctest_C_3(int) RETURNS bool LANGUAGE'sql'
6060
SECURITY INVOKERAS'SELECT $1 < 0';
6161
SELECT proname, prosecdefFROM pg_proc
62-
WHEREoidin ('functext_C_1'::regproc,
63-
'functext_C_2'::regproc,
64-
'functext_C_3'::regproc)ORDER BY proname;
62+
WHEREoidin ('functest_C_1'::regproc,
63+
'functest_C_2'::regproc,
64+
'functest_C_3'::regproc)ORDER BY proname;
6565

66-
ALTERFUNCTIONfunctext_C_1(int) IMMUTABLE;-- unrelated change, no effect
67-
ALTERFUNCTIONfunctext_C_2(int) SECURITY INVOKER;
68-
ALTERFUNCTIONfunctext_C_3(int) SECURITY DEFINER;
66+
ALTERFUNCTIONfunctest_C_1(int) IMMUTABLE;-- unrelated change, no effect
67+
ALTERFUNCTIONfunctest_C_2(int) SECURITY INVOKER;
68+
ALTERFUNCTIONfunctest_C_3(int) SECURITY DEFINER;
6969
SELECT proname, prosecdefFROM pg_proc
70-
WHEREoidin ('functext_C_1'::regproc,
71-
'functext_C_2'::regproc,
72-
'functext_C_3'::regproc)ORDER BY proname;
70+
WHEREoidin ('functest_C_1'::regproc,
71+
'functest_C_2'::regproc,
72+
'functest_C_3'::regproc)ORDER BY proname;
7373

7474
--
7575
-- LEAKPROOF
7676
--
77-
CREATEFUNCTIONfunctext_E_1(int) RETURNS bool LANGUAGE'sql'
77+
CREATEFUNCTIONfunctest_E_1(int) RETURNS bool LANGUAGE'sql'
7878
AS'SELECT $1 > 100';
79-
CREATEFUNCTIONfunctext_E_2(int) RETURNS bool LANGUAGE'sql'
79+
CREATEFUNCTIONfunctest_E_2(int) RETURNS bool LANGUAGE'sql'
8080
LEAKPROOFAS'SELECT $1 > 100';
8181
SELECT proname, proleakproofFROM pg_proc
82-
WHEREoidin ('functext_E_1'::regproc,
83-
'functext_E_2'::regproc)ORDER BY proname;
82+
WHEREoidin ('functest_E_1'::regproc,
83+
'functest_E_2'::regproc)ORDER BY proname;
8484

85-
ALTERFUNCTIONfunctext_E_1(int) LEAKPROOF;
86-
ALTERFUNCTIONfunctext_E_2(int) STABLE;-- unrelated change, no effect
85+
ALTERFUNCTIONfunctest_E_1(int) LEAKPROOF;
86+
ALTERFUNCTIONfunctest_E_2(int) STABLE;-- unrelated change, no effect
8787
SELECT proname, proleakproofFROM pg_proc
88-
WHEREoidin ('functext_E_1'::regproc,
89-
'functext_E_2'::regproc)ORDER BY proname;
88+
WHEREoidin ('functest_E_1'::regproc,
89+
'functest_E_2'::regproc)ORDER BY proname;
9090

91-
ALTERFUNCTIONfunctext_E_2(int) NOT LEAKPROOF;-- remove leakproog attribute
91+
ALTERFUNCTIONfunctest_E_2(int) NOT LEAKPROOF;-- remove leakproog attribute
9292
SELECT proname, proleakproofFROM pg_proc
93-
WHEREoidin ('functext_E_1'::regproc,
94-
'functext_E_2'::regproc)ORDER BY proname;
93+
WHEREoidin ('functest_E_1'::regproc,
94+
'functest_E_2'::regproc)ORDER BY proname;
9595

9696
-- it takes superuser privilege to turn on leakproof, but not for turn off
97-
ALTERFUNCTIONfunctext_E_1(int) OWNER TO regress_unpriv_user;
98-
ALTERFUNCTIONfunctext_E_2(int) OWNER TO regress_unpriv_user;
97+
ALTERFUNCTIONfunctest_E_1(int) OWNER TO regress_unpriv_user;
98+
ALTERFUNCTIONfunctest_E_2(int) OWNER TO regress_unpriv_user;
9999

100100
SET SESSION AUTHORIZATION regress_unpriv_user;
101101
SET search_path TO temp_func_test, public;
102-
ALTERFUNCTIONfunctext_E_1(int) NOT LEAKPROOF;
103-
ALTERFUNCTIONfunctext_E_2(int) LEAKPROOF;
102+
ALTERFUNCTIONfunctest_E_1(int) NOT LEAKPROOF;
103+
ALTERFUNCTIONfunctest_E_2(int) LEAKPROOF;
104104

105-
CREATEFUNCTIONfunctext_E_3(int) RETURNS bool LANGUAGE'sql'
105+
CREATEFUNCTIONfunctest_E_3(int) RETURNS bool LANGUAGE'sql'
106106
LEAKPROOFAS'SELECT $1 < 200';-- failed
107107

108108
RESET SESSION AUTHORIZATION;
109109

110110
--
111111
-- CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
112112
--
113-
CREATEFUNCTIONfunctext_F_1(int) RETURNS bool LANGUAGE'sql'
113+
CREATEFUNCTIONfunctest_F_1(int) RETURNS bool LANGUAGE'sql'
114114
AS'SELECT $1 > 50';
115-
CREATEFUNCTIONfunctext_F_2(int) RETURNS bool LANGUAGE'sql'
115+
CREATEFUNCTIONfunctest_F_2(int) RETURNS bool LANGUAGE'sql'
116116
CALLEDONNULL INPUTAS'SELECT $1 = 50';
117-
CREATEFUNCTIONfunctext_F_3(int) RETURNS bool LANGUAGE'sql'
117+
CREATEFUNCTIONfunctest_F_3(int) RETURNS bool LANGUAGE'sql'
118118
RETURNSNULLONNULL INPUTAS'SELECT $1 < 50';
119-
CREATEFUNCTIONfunctext_F_4(int) RETURNS bool LANGUAGE'sql'
119+
CREATEFUNCTIONfunctest_F_4(int) RETURNS bool LANGUAGE'sql'
120120
STRICTAS'SELECT $1 = 50';
121121
SELECT proname, proisstrictFROM pg_proc
122-
WHEREoidin ('functext_F_1'::regproc,
123-
'functext_F_2'::regproc,
124-
'functext_F_3'::regproc,
125-
'functext_F_4'::regproc)ORDER BY proname;
126-
127-
ALTERFUNCTIONfunctext_F_1(int) IMMUTABLE;-- unrelated change, no effect
128-
ALTERFUNCTIONfunctext_F_2(int) STRICT;
129-
ALTERFUNCTIONfunctext_F_3(int) CALLEDONNULL INPUT;
122+
WHEREoidin ('functest_F_1'::regproc,
123+
'functest_F_2'::regproc,
124+
'functest_F_3'::regproc,
125+
'functest_F_4'::regproc)ORDER BY proname;
126+
127+
ALTERFUNCTIONfunctest_F_1(int) IMMUTABLE;-- unrelated change, no effect
128+
ALTERFUNCTIONfunctest_F_2(int) STRICT;
129+
ALTERFUNCTIONfunctest_F_3(int) CALLEDONNULL INPUT;
130130
SELECT proname, proisstrictFROM pg_proc
131-
WHEREoidin ('functext_F_1'::regproc,
132-
'functext_F_2'::regproc,
133-
'functext_F_3'::regproc,
134-
'functext_F_4'::regproc)ORDER BY proname;
131+
WHEREoidin ('functest_F_1'::regproc,
132+
'functest_F_2'::regproc,
133+
'functest_F_3'::regproc,
134+
'functest_F_4'::regproc)ORDER BY proname;
135135

136136

137137
-- information_schema tests

0 commit comments

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