Skip to content

Commit 1594bf2

Browse files
author
Thomas G. Lockhart
committed
Added initial set of expected outputs for new regression testing.
Modified a few tests to match results on RedHat Linux/gcc for v6.1beta.
1 parent de97e7f commit 1594bf2

17 files changed

+2686
-9
lines changed

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

Lines changed: 96 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,96 @@
1+
QUERY: SELECT avg(four) AS avg_1 FROM onek;
2+
avg_1
3+
-----
4+
1
5+
(1 row)
6+
7+
QUERY: SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
8+
avg_32
9+
------
10+
32
11+
(1 row)
12+
13+
QUERY: SELECT avg(b) AS avg_107_943 FROM aggtest;
14+
avg_107_943
15+
-----------
16+
107.943
17+
(1 row)
18+
19+
QUERY: SELECT avg(gpa) AS avg_3_4 FROM student;
20+
avg_3_4
21+
-------
22+
3.4
23+
(1 row)
24+
25+
QUERY: SELECT sum(four) AS sum_1500 FROM onek;
26+
sum_1500
27+
--------
28+
1500
29+
(1 row)
30+
31+
QUERY: SELECT sum(a) AS sum_198 FROM aggtest;
32+
sum_198
33+
-------
34+
198
35+
(1 row)
36+
37+
QUERY: SELECT sum(b) AS avg_431_773 FROM aggtest;
38+
avg_431_773
39+
-----------
40+
431.773
41+
(1 row)
42+
43+
QUERY: SELECT sum(gpa) AS avg_6_8 FROM student;
44+
avg_6_8
45+
-------
46+
6.8
47+
(1 row)
48+
49+
QUERY: SELECT max(four) AS max_3 FROM onek;
50+
max_3
51+
-----
52+
3
53+
(1 row)
54+
55+
QUERY: SELECT max(a) AS max_100 FROM aggtest;
56+
max_100
57+
-------
58+
100
59+
(1 row)
60+
61+
QUERY: SELECT max(aggtest.b) AS max_324_78 FROM aggtest;
62+
max_324_78
63+
----------
64+
324.78
65+
(1 row)
66+
67+
QUERY: SELECT max(student.gpa) AS max_3_7 FROM student;
68+
max_3_7
69+
-------
70+
3.7
71+
(1 row)
72+
73+
QUERY: SELECT count(four) AS cnt_1000 FROM onek;
74+
cnt_1000
75+
--------
76+
1000
77+
(1 row)
78+
79+
QUERY: SELECT newavg(four) AS avg_1 FROM onek;
80+
avg_1
81+
-----
82+
1
83+
(1 row)
84+
85+
QUERY: SELECT newsum(four) AS sum_1500 FROM onek;
86+
sum_1500
87+
--------
88+
1500
89+
(1 row)
90+
91+
QUERY: SELECT newcnt(four) AS cnt_1000 FROM onek;
92+
cnt_1000
93+
--------
94+
1000
95+
(1 row)
96+

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

Lines changed: 255 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,255 @@
1+
QUERY: CREATE TABLE temp (initial int4);
2+
QUERY: ALTER TABLE temp ADD COLUMN a int4;
3+
QUERY: ALTER TABLE temp ADD COLUMN b char16;
4+
QUERY: ALTER TABLE temp ADD COLUMN c text;
5+
QUERY: ALTER TABLE temp ADD COLUMN d float8;
6+
QUERY: ALTER TABLE temp ADD COLUMN e float4;
7+
QUERY: ALTER TABLE temp ADD COLUMN f int2;
8+
QUERY: ALTER TABLE temp ADD COLUMN g polygon;
9+
QUERY: ALTER TABLE temp ADD COLUMN h abstime;
10+
QUERY: ALTER TABLE temp ADD COLUMN i char;
11+
QUERY: ALTER TABLE temp ADD COLUMN j abstime[];
12+
QUERY: ALTER TABLE temp ADD COLUMN k dt;
13+
WARN:type name lookup of dt failed
14+
QUERY: ALTER TABLE temp ADD COLUMN l tid;
15+
QUERY: ALTER TABLE temp ADD COLUMN m xid;
16+
QUERY: ALTER TABLE temp ADD COLUMN n oid8;
17+
QUERY: ALTER TABLE temp ADD COLUMN p smgr;
18+
QUERY: ALTER TABLE temp ADD COLUMN q point;
19+
QUERY: ALTER TABLE temp ADD COLUMN r lseg;
20+
QUERY: ALTER TABLE temp ADD COLUMN s path;
21+
QUERY: ALTER TABLE temp ADD COLUMN t box;
22+
QUERY: ALTER TABLE temp ADD COLUMN u tinterval;
23+
QUERY: ALTER TABLE temp ADD COLUMN v oidint4;
24+
QUERY: ALTER TABLE temp ADD COLUMN w oidname;
25+
QUERY: ALTER TABLE temp ADD COLUMN x float8[];
26+
QUERY: ALTER TABLE temp ADD COLUMN y float4[];
27+
QUERY: ALTER TABLE temp ADD COLUMN z int2[];
28+
QUERY: INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
29+
v, w, x, y, z)
30+
VALUES (4, 'char16', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)',
31+
'Mon May 1 00:30:30 1995', 'c', '{Mon May 1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}',
32+
314159, '(1,1)', 512,
33+
'1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',
34+
'(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',
35+
'1/3', '1,char16', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
36+
WARN:Relation temp does not have attribute k
37+
38+
QUERY: SELECT * FROM temp;
39+
initial|a|b|c|d|e|f|g|h|i|j|l|m|n|p|q|r|s|t|u|v|w|x|y|z
40+
-------+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
41+
(0 rows)
42+
43+
QUERY: DROP TABLE temp;
44+
QUERY: CREATE TABLE temp (
45+
initial int4
46+
) ARCHIVE = light;
47+
QUERY: ALTER TABLE temp ADD COLUMN a int4;
48+
QUERY: ALTER TABLE temp ADD COLUMN b char16;
49+
QUERY: ALTER TABLE temp ADD COLUMN c text;
50+
QUERY: ALTER TABLE temp ADD COLUMN d float8;
51+
QUERY: ALTER TABLE temp ADD COLUMN e float4;
52+
QUERY: ALTER TABLE temp ADD COLUMN f int2;
53+
QUERY: ALTER TABLE temp ADD COLUMN g polygon;
54+
QUERY: ALTER TABLE temp ADD COLUMN h abstime;
55+
QUERY: ALTER TABLE temp ADD COLUMN i char;
56+
QUERY: ALTER TABLE temp ADD COLUMN j abstime[];
57+
QUERY: ALTER TABLE temp ADD COLUMN k dt;
58+
WARN:type name lookup of dt failed
59+
QUERY: ALTER TABLE temp ADD COLUMN l tid;
60+
QUERY: ALTER TABLE temp ADD COLUMN m xid;
61+
QUERY: ALTER TABLE temp ADD COLUMN n oid8;
62+
QUERY: ALTER TABLE temp ADD COLUMN p smgr;
63+
QUERY: ALTER TABLE temp ADD COLUMN q point;
64+
QUERY: ALTER TABLE temp ADD COLUMN r lseg;
65+
QUERY: ALTER TABLE temp ADD COLUMN s path;
66+
QUERY: ALTER TABLE temp ADD COLUMN t box;
67+
QUERY: ALTER TABLE temp ADD COLUMN u tinterval;
68+
QUERY: ALTER TABLE temp ADD COLUMN v oidint4;
69+
QUERY: ALTER TABLE temp ADD COLUMN w oidname;
70+
QUERY: ALTER TABLE temp ADD COLUMN x float8[];
71+
QUERY: ALTER TABLE temp ADD COLUMN y float4[];
72+
QUERY: ALTER TABLE temp ADD COLUMN z int2[];
73+
QUERY: INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
74+
v, w, x, y, z)
75+
VALUES (4, 'char16', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)',
76+
'Mon May 1 00:30:30 1995', 'c', '{Mon May 1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}',
77+
314159, '(1,1)', 512,
78+
'1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',
79+
'(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',
80+
'1/3', '1,char16', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
81+
WARN:Relation temp does not have attribute k
82+
83+
QUERY: SELECT * FROM temp[,];
84+
initial|a|b|c|d|e|f|g|h|i|j|l|m|n|p|q|r|s|t|u|v|w|x|y|z
85+
-------+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
86+
(0 rows)
87+
88+
QUERY: DROP TABLE temp;
89+
QUERY: ALTER TABLE tenk1 RENAME TO ten_k;
90+
QUERY: SELECT unique1 FROM ten_k WHERE unique1 < 20;
91+
unique1
92+
-------
93+
18
94+
15
95+
4
96+
2
97+
1
98+
6
99+
14
100+
9
101+
8
102+
5
103+
3
104+
13
105+
12
106+
19
107+
17
108+
11
109+
7
110+
10
111+
16
112+
0
113+
(20 rows)
114+
115+
QUERY: SELECT unique2 FROM ten_k WHERE unique2 < 20;
116+
unique2
117+
-------
118+
0
119+
1
120+
2
121+
3
122+
4
123+
5
124+
6
125+
7
126+
8
127+
9
128+
10
129+
11
130+
12
131+
13
132+
14
133+
15
134+
16
135+
17
136+
18
137+
19
138+
(20 rows)
139+
140+
QUERY: SELECT hundred FROM ten_k WHERE hundred = 50;
141+
hundred
142+
-------
143+
50
144+
50
145+
50
146+
50
147+
50
148+
50
149+
50
150+
50
151+
50
152+
50
153+
50
154+
50
155+
50
156+
50
157+
50
158+
50
159+
50
160+
50
161+
50
162+
50
163+
50
164+
50
165+
50
166+
50
167+
50
168+
50
169+
50
170+
50
171+
50
172+
50
173+
50
174+
50
175+
50
176+
50
177+
50
178+
50
179+
50
180+
50
181+
50
182+
50
183+
50
184+
50
185+
50
186+
50
187+
50
188+
50
189+
50
190+
50
191+
50
192+
50
193+
50
194+
50
195+
50
196+
50
197+
50
198+
50
199+
50
200+
50
201+
50
202+
50
203+
50
204+
50
205+
50
206+
50
207+
50
208+
50
209+
50
210+
50
211+
50
212+
50
213+
50
214+
50
215+
50
216+
50
217+
50
218+
50
219+
50
220+
50
221+
50
222+
50
223+
50
224+
50
225+
50
226+
50
227+
50
228+
50
229+
50
230+
50
231+
50
232+
50
233+
50
234+
50
235+
50
236+
50
237+
50
238+
50
239+
50
240+
50
241+
50
242+
50
243+
(100 rows)
244+
245+
QUERY: ALTER TABLE ten_k RENAME TO tenk1;
246+
QUERY: SELECT unique1 FROM tenk1 WHERE unique1 < 5;
247+
unique1
248+
-------
249+
4
250+
2
251+
1
252+
3
253+
0
254+
(5 rows)
255+

0 commit comments

Comments
 (0)