1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
--
-- errors.source
--
-- $Header: /cvsroot/pgsql/src/test/regress/Attic/errors.source,v 1.1.1.1 1996/07/09 06:22:24 scrappy Exp $
-- bad in postquel, but ok in postsql
select 1
--
-- UNSUPPORTED STUFF
-- doesn't work
-- attachas nonesuch
--
-- doesn't work
-- notify pg_class
--
--
-- RETRIEVE
-- missing relation name
select
-- no such relation
select * from nonesuch;
-- bad name in target list
select nonesuch from pg_database;
-- bad attribute name on lhs of operator
select * from pg_database where nonesuch = pg_database.datname;
-- bad attribute name on rhs of operator
select * from pg_database where pg_database.datname = nonesuch;
-- bad select distinct on syntax, distinct attribute missing
select distinct on foobar from pg_database;
-- bad select distinct on syntax, distinct attribute not in target list
select distinct on foobar * from pg_database;
--
-- DELETE
-- missing relation name (this had better not wildcard!)
delete from;
-- no such relation
delete from nonesuch;
--
-- DESTROY
-- missing relation name (this had better not wildcard!)
drop table;
-- no such relation
drop table nonesuch;
--
-- RENAME
-- relation renaming
-- missing relation name
alter table rename;
-- no such relation
alter table nonesuch rename to newnonesuch;
-- no such relation
alter table nonesuch rename to stud_emp;
-- system relation
alter table stud_emp rename to pg_stud_emp;
-- conflict
alter table stud_emp rename to aggtest;
-- self-conflict
alter table stud_emp rename to stud_emp;
-- attribute renaming
-- no such relation
alter table nonesuchrel rename column nonesuchatt to newnonesuchatt;
-- no such attribute
alter table emp rename column nonesuchatt to newnonesuchatt;
-- conflict
alter table emp rename column salary to manager;
-- conflict
alter table emp rename column salary to oid;
--
-- TRANSACTION STUFF
-- not in a xact
abort;
-- not in a xact
end;
--
-- DEFINE AGGREGATE
-- left out finalfunc
create aggregate newavg1 (sfunc1 = int4pl,
basetype = int4,
stype1 = int4,
sfunc2 = int4inc,
stype2 = int4,
initcond1 = '0',
initcond2 = '0');
-- sfunc return type disagreement
create aggregate newavg2 (sfunc1 = int4pl,
basetype = int4,
stype1 = int4,
sfunc2 = int2inc,
stype2 = int2,
finalfunc = int4div,
initcond1 = '0',
initcond2 = '0');
-- sfunc/finalfunc type disagreement
create aggregate newavg3 (sfunc1 = int4pl,
basetype = int4,
stype1 = int4,
sfunc2 = int4inc,
stype2 = int4,
finalfunc = int2div,
initcond1 = '0',
initcond2 = '0');
-- left out basetype
create aggregate newcnt1 (sfunc2 = int4inc,
stype2 = int4,
initcond2 = '0');
-- left out initcond2 (for sfunc2)
create aggregate newcnt1 (sfunc2 = int4inc,
basetype = int4,
stype2 = int4);
--
-- REMOVE INDEX
-- missing index name
drop index;
-- bad index name
drop index 314159;
-- no such index
drop index nonesuch;
--
-- REMOVE AGGREGATE
-- missing aggregate name
drop aggregate;
-- bad aggregate name
drop aggregate 314159;
-- no such aggregate
drop aggregate nonesuch;
--
-- REMOVE FUNCTION
-- missing function name
drop function ();
-- bad function name
drop function 314159();
-- no such function
drop function nonesuch();
--
-- REMOVE TYPE
-- missing type name
drop type;
-- bad type name
drop type 314159;
-- no such type
drop type nonesuch;
--
-- DROP OPERATOR
-- missing everything
drop operator;
-- bad operator name
drop operator equals;
-- missing type list
drop operator ===;
-- missing parentheses
drop operator int4, int4;
-- missing operator name
drop operator (int4, int4);
-- missing type list contents
drop operator === ();
-- no such operator
drop operator === (int4);
-- no such operator by that name
drop operator === (int4, int4);
-- no such type1
drop operator = (nonesuch);
-- no such type1
drop operator = ( , int4);
-- no such type1
drop operator = (nonesuch, int4);
-- no such type2
drop operator = (int4, nonesuch);
-- no such type2
drop operator = (int4, );
--
-- DROP RULE
-- missing rule name
drop rule;
-- bad rule name
drop rule 314159;
-- no such rule
drop rule nonesuch;
-- bad keyword
drop tuple rule nonesuch;
-- no such rule
drop instance rule nonesuch;
-- no such rule
drop rewrite rule nonesuch;