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

Commit1594bf2

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 parentde97e7f commit1594bf2

17 files changed

+2686
-9
lines changed
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+
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)
[8]ページ先頭
©2009-2025 Movatter.jp