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

Commit260b6af

Browse files
committed
Update remaining tests for new psql, with the exception of 'arrays',
which is broken in some weird way that I don't understand. I think itmay be exposing a bug in the new psql --- for one thing, I get differentresults when I run psql by hand than the regress script gets. Whatthe heck???
1 parent0e821fb commit260b6af

File tree

13 files changed

+4279
-3845
lines changed

13 files changed

+4279
-3845
lines changed
Lines changed: 100 additions & 97 deletions
Original file line numberDiff line numberDiff line change
@@ -1,132 +1,135 @@
1-
QUERY: SELECT avg(four) AS avg_1 FROM onek;
2-
avg_1
3-
-----
4-
1
1+
--
2+
-- AGGREGATES
3+
--
4+
SELECT avg(four) AS avg_1 FROM onek;
5+
avg_1
6+
-------
7+
1
58
(1 row)
69

7-
QUERY:SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
8-
avg_32
9-
------
10-
32
10+
SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
11+
avg_32
12+
--------
13+
32
1114
(1 row)
1215

13-
QUERY:SELECT avg(b) AS avg_107_943 FROM aggtest;
14-
avg_107_943
15-
-----------
16-
107.943
16+
SELECT avg(b) AS avg_107_943 FROM aggtest;
17+
avg_107_943
18+
-------------
19+
107.943
1720
(1 row)
1821

19-
QUERY:SELECT avg(gpa) AS avg_3_4 FROM student;
20-
avg_3_4
21-
-------
22-
3.4
22+
SELECT avg(gpa) AS avg_3_4 FROM student;
23+
avg_3_4
24+
---------
25+
3.4
2326
(1 row)
2427

25-
QUERY:SELECT sum(four) AS sum_1500 FROM onek;
26-
sum_1500
27-
--------
28-
1500
28+
SELECT sum(four) AS sum_1500 FROM onek;
29+
sum_1500
30+
----------
31+
1500
2932
(1 row)
3033

31-
QUERY: SELECT sum(a) AS sum_198 FROM aggtest;
32-
sum_198
33-
-------
34-
198
34+
SELECT sum(a) AS sum_198 FROM aggtest;
35+
sum_198
36+
---------
37+
198
38+
(1 row)
39+
40+
SELECT sum(b) AS avg_431_773 FROM aggtest;
41+
avg_431_773
42+
-------------
43+
431.773
3544
(1 row)
3645

37-
QUERY:SELECT sum(b) ASavg_431_773 FROMaggtest;
38-
avg_431_773
39-
-----------
40-
431.773
46+
SELECT sum(gpa) ASavg_6_8 FROMstudent;
47+
avg_6_8
48+
---------
49+
6.8
4150
(1 row)
4251

43-
QUERY:SELECTsum(gpa) ASavg_6_8 FROMstudent;
44-
avg_6_8
52+
SELECTmax(four) ASmax_3 FROMonek;
53+
max_3
4554
-------
46-
6.8
55+
3
4756
(1 row)
4857

49-
QUERY:SELECT max(four) ASmax_3 FROMonek;
50-
max_3
51-
-----
52-
3
58+
SELECT max(a) ASmax_100 FROMaggtest;
59+
max_100
60+
---------
61+
100
5362
(1 row)
5463

55-
QUERY:SELECT max(a) ASmax_100 FROM aggtest;
56-
max_100
57-
-------
58-
100
64+
SELECT max(aggtest.b) ASmax_324_78 FROM aggtest;
65+
max_324_78
66+
------------
67+
324.78
5968
(1 row)
6069

61-
QUERY:SELECT max(aggtest.b) ASmax_324_78 FROMaggtest;
62-
max_324_78
63-
----------
64-
324.78
70+
SELECT max(student.gpa) ASmax_3_7 FROMstudent;
71+
max_3_7
72+
---------
73+
3.7
6574
(1 row)
6675

67-
QUERY:SELECTmax(student.gpa) ASmax_3_7 FROMstudent;
68-
max_3_7
69-
-------
70-
3.7
76+
SELECTcount(four) AScnt_1000 FROMonek;
77+
cnt_1000
78+
----------
79+
1000
7180
(1 row)
7281

73-
QUERY: SELECT count(four) AS cnt_1000 FROM onek;
74-
cnt_1000
75-
--------
76-
1000
77-
(1 row)
78-
79-
QUERY: SELECT count(DISTINCT four) AS cnt_4 FROM onek;
80-
cnt_4
81-
-----
82-
4
83-
(1 row)
84-
85-
QUERY: select ten, count(*), sum(four) from onek group by ten;
86-
ten|count|sum
87-
---+-----+---
88-
0| 100|100
89-
1| 100|200
90-
2| 100|100
91-
3| 100|200
92-
4| 100|100
93-
5| 100|200
94-
6| 100|100
95-
7| 100|200
96-
8| 100|100
97-
9| 100|200
82+
SELECT count(DISTINCT four) AS cnt_4 FROM onek;
83+
cnt_4
84+
-------
85+
4
86+
(1 row)
87+
88+
select ten, count(*), sum(four) from onek group by ten;
89+
ten | count | sum
90+
-----+-------+-----
91+
0 | 100 | 100
92+
1 | 100 | 200
93+
2 | 100 | 100
94+
3 | 100 | 200
95+
4 | 100 | 100
96+
5 | 100 | 200
97+
6 | 100 | 100
98+
7 | 100 | 200
99+
8 | 100 | 100
100+
9 | 100 | 200
98101
(10 rows)
99102

100-
QUERY:select ten, count(four), sum(DISTINCT four) from onek group by ten;
101-
ten|count|sum
102-
---+-----+---
103-
0| 100| 2
104-
1| 100| 4
105-
2| 100| 2
106-
3| 100| 4
107-
4| 100| 2
108-
5| 100| 4
109-
6| 100| 2
110-
7| 100| 4
111-
8| 100| 2
112-
9| 100| 4
103+
select ten, count(four), sum(DISTINCT four) from onek group by ten;
104+
ten |count |sum
105+
-----+-------+-----
106+
0|100 | 2
107+
1|100 | 4
108+
2|100 | 2
109+
3|100 | 4
110+
4|100 | 2
111+
5|100 | 4
112+
6|100 | 2
113+
7|100 | 4
114+
8|100 | 2
115+
9|100 | 4
113116
(10 rows)
114117

115-
QUERY:SELECT newavg(four) AS avg_1 FROM onek;
116-
avg_1
117-
-----
118-
1
118+
SELECT newavg(four) AS avg_1 FROM onek;
119+
avg_1
120+
-------
121+
1
119122
(1 row)
120123

121-
QUERY:SELECT newsum(four) AS sum_1500 FROM onek;
122-
sum_1500
123-
--------
124-
1500
124+
SELECT newsum(four) AS sum_1500 FROM onek;
125+
sum_1500
126+
----------
127+
1500
125128
(1 row)
126129

127-
QUERY:SELECT newcnt(four) AS cnt_1000 FROM onek;
128-
cnt_1000
129-
--------
130-
1000
130+
SELECT newcnt(four) AS cnt_1000 FROM onek;
131+
cnt_1000
132+
----------
133+
1000
131134
(1 row)
132135

0 commit comments

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