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

Commit5a72241

Browse files
committed
This patch resolves some regression test failures caused by platformdependencies.David Hartwig
1 parent9728ce7 commit5a72241

File tree

4 files changed

+83
-38
lines changed

4 files changed

+83
-38
lines changed
Lines changed: 36 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,12 +1,37 @@
1-
QUERY: SELECT d1, count(*) FROM DATETIME_TBL
2-
GROUP BY d1 HAVING count(*) > 1;
3-
d1 |count
4-
----------------------------+-----
5-
Thu Jun 13 00:00:00 1957 PDT| 2
6-
Mon Feb 10 09:32:01 1997 PST| 3
7-
Mon Feb 10 17:32:01 1997 PST| 13
8-
Sun Feb 16 17:32:01 1997 PST| 2
9-
Sat Mar 01 17:32:01 1997 PST| 2
10-
invalid | 2
11-
(6 rows)
1+
QUERY: CREATE TABLE test_having (a int, b int, c char(8), d char);
2+
QUERY: INSERT INTO test_having VALUES (0, 1, 'XXXX', 'A');
3+
QUERY: INSERT INTO test_having VALUES (1, 2, 'AAAA', 'b');
4+
QUERY: INSERT INTO test_having VALUES (2, 2, 'AAAA', 'c');
5+
QUERY: INSERT INTO test_having VALUES (3, 3, 'BBBB', 'D');
6+
QUERY: INSERT INTO test_having VALUES (4, 3, 'BBBB', 'e');
7+
QUERY: INSERT INTO test_having VALUES (5, 3, 'bbbb', 'F');
8+
QUERY: INSERT INTO test_having VALUES (6, 4, 'cccc', 'g');
9+
QUERY: INSERT INTO test_having VALUES (7, 4, 'cccc', 'h');
10+
QUERY: INSERT INTO test_having VALUES (8, 4, 'CCCC', 'I');
11+
QUERY: INSERT INTO test_having VALUES (9, 4, 'CCCC', 'j');
12+
QUERY: SELECT max(a) FROM test_having
13+
GROUP BY lower(c) HAVING count(*) > 2 OR min(b) = 3;
14+
max
15+
---
16+
5
17+
9
18+
(2 rows)
1219

20+
QUERY: SELECT lower(c), count(c) FROM test_having
21+
GROUP BY lower(c) HAVING count(*) > 2 OR min(a) = max(a);
22+
lower |count
23+
--------+-----
24+
bbbb | 3
25+
cccc | 4
26+
xxxx | 1
27+
(3 rows)
28+
29+
QUERY: SELECT c, max(a) FROM test_having
30+
GROUP BY c HAVING count(*) > 2 OR min(a) = max(a);
31+
c |max
32+
--------+---
33+
XXXX | 0
34+
bbbb | 5
35+
(2 rows)
36+
37+
QUERY: DROP TABLE test_having;

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

Lines changed: 13 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -1,14 +1,14 @@
1-
QUERY: CREATE TABLE test_missing_target (a int, b int, c char(8));
2-
QUERY: INSERT INTO test_missing_target VALUES (0, 1, 'XXXX');
3-
QUERY: INSERT INTO test_missing_target VALUES (1, 2, 'AAAA');
4-
QUERY: INSERT INTO test_missing_target VALUES (2, 2, 'AAAA');
5-
QUERY: INSERT INTO test_missing_target VALUES (3, 3, 'BBBB');
6-
QUERY: INSERT INTO test_missing_target VALUES (4, 3, 'BBBB');
7-
QUERY: INSERT INTO test_missing_target VALUES (5, 3, 'bbbb');
8-
QUERY: INSERT INTO test_missing_target VALUES (6, 4, 'cccc');
9-
QUERY: INSERT INTO test_missing_target VALUES (7, 4, 'cccc');
10-
QUERY: INSERT INTO test_missing_target VALUES (8, 4, 'CCCC');
11-
QUERY: INSERT INTO test_missing_target VALUES (9, 4, 'CCCC');
1+
QUERY: CREATE TABLE test_missing_target (a int, b int, c char(8), d char);
2+
QUERY: INSERT INTO test_missing_target VALUES (0, 1, 'XXXX', 'A');
3+
QUERY: INSERT INTO test_missing_target VALUES (1, 2, 'AAAA', 'b');
4+
QUERY: INSERT INTO test_missing_target VALUES (2, 2, 'AAAA', 'c');
5+
QUERY: INSERT INTO test_missing_target VALUES (3, 3, 'BBBB', 'D');
6+
QUERY: INSERT INTO test_missing_target VALUES (4, 3, 'BBBB', 'e');
7+
QUERY: INSERT INTO test_missing_target VALUES (5, 3, 'bbbb', 'F');
8+
QUERY: INSERT INTO test_missing_target VALUES (6, 4, 'cccc', 'g');
9+
QUERY: INSERT INTO test_missing_target VALUES (7, 4, 'cccc', 'h');
10+
QUERY: INSERT INTO test_missing_target VALUES (8, 4, 'CCCC', 'I');
11+
QUERY: INSERT INTO test_missing_target VALUES (9, 4, 'CCCC', 'j');
1212
QUERY: SELECT c, count(*) FROM test_missing_target GROUP BY test_missing_target.c;
1313
c |count
1414
--------+-----
@@ -210,9 +210,10 @@ cccc | 4
210210
xxxx | 1
211211
(4 rows)
212212

213-
QUERY: SELECT a FROM test_missing_target ORDER BY upper(c);
213+
QUERY: SELECT a FROM test_missing_target ORDER BY upper(d);
214214
a
215215
-
216+
0
216217
1
217218
2
218219
3
@@ -222,7 +223,6 @@ a
222223
7
223224
8
224225
9
225-
0
226226
(10 rows)
227227

228228
QUERY: SELECT count(b) FROM test_missing_target

‎src/test/regress/sql/select_having.sql

Lines changed: 22 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,6 +2,26 @@
22
-- select_having.sql
33
--
44

5-
SELECT d1,count(*)FROM DATETIME_TBL
6-
GROUP BY d1HAVINGcount(*)>1;
5+
-- load test data
6+
CREATETABLEtest_having (aint, bint, cchar(8), dchar);
7+
INSERT INTO test_havingVALUES (0,1,'XXXX','A');
8+
INSERT INTO test_havingVALUES (1,2,'AAAA','b');
9+
INSERT INTO test_havingVALUES (2,2,'AAAA','c');
10+
INSERT INTO test_havingVALUES (3,3,'BBBB','D');
11+
INSERT INTO test_havingVALUES (4,3,'BBBB','e');
12+
INSERT INTO test_havingVALUES (5,3,'bbbb','F');
13+
INSERT INTO test_havingVALUES (6,4,'cccc','g');
14+
INSERT INTO test_havingVALUES (7,4,'cccc','h');
15+
INSERT INTO test_havingVALUES (8,4,'CCCC','I');
16+
INSERT INTO test_havingVALUES (9,4,'CCCC','j');
717

18+
SELECTmax(a)FROM test_having
19+
GROUP BYlower(c)HAVINGcount(*)>2ORmin(b)=3;
20+
21+
SELECTlower(c),count(c)FROM test_having
22+
GROUP BYlower(c)HAVINGcount(*)>2ORmin(a)=max(a);
23+
24+
SELECT c,max(a)FROM test_having
25+
GROUP BY cHAVINGcount(*)>2ORmin(a)=max(a);
26+
27+
DROPTABLE test_having;

‎src/test/regress/sql/select_implicit.sql

Lines changed: 12 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -7,17 +7,17 @@
77
-- - thomas 1998-07-09
88

99
-- load test data
10-
CREATETABLEtest_missing_target (aint, bint, cchar(8));
11-
INSERT INTO test_missing_targetVALUES (0,1,'XXXX');
12-
INSERT INTO test_missing_targetVALUES (1,2,'AAAA');
13-
INSERT INTO test_missing_targetVALUES (2,2,'AAAA');
14-
INSERT INTO test_missing_targetVALUES (3,3,'BBBB');
15-
INSERT INTO test_missing_targetVALUES (4,3,'BBBB');
16-
INSERT INTO test_missing_targetVALUES (5,3,'bbbb');
17-
INSERT INTO test_missing_targetVALUES (6,4,'cccc');
18-
INSERT INTO test_missing_targetVALUES (7,4,'cccc');
19-
INSERT INTO test_missing_targetVALUES (8,4,'CCCC');
20-
INSERT INTO test_missing_targetVALUES (9,4,'CCCC');
10+
CREATETABLEtest_missing_target (aint, bint, cchar(8), dchar);
11+
INSERT INTO test_missing_targetVALUES (0,1,'XXXX','A');
12+
INSERT INTO test_missing_targetVALUES (1,2,'AAAA','b');
13+
INSERT INTO test_missing_targetVALUES (2,2,'AAAA','c');
14+
INSERT INTO test_missing_targetVALUES (3,3,'BBBB','D');
15+
INSERT INTO test_missing_targetVALUES (4,3,'BBBB','e');
16+
INSERT INTO test_missing_targetVALUES (5,3,'bbbb','F');
17+
INSERT INTO test_missing_targetVALUES (6,4,'cccc','g');
18+
INSERT INTO test_missing_targetVALUES (7,4,'cccc','h');
19+
INSERT INTO test_missing_targetVALUES (8,4,'CCCC','I');
20+
INSERT INTO test_missing_targetVALUES (9,4,'CCCC','j');
2121

2222

2323
-- w/ existing GROUP BY target
@@ -118,7 +118,7 @@ SELECT lower(test_missing_target.c), count(c)
118118
FROM test_missing_targetGROUP BYlower(c)ORDER BYlower(c);
119119

120120
-- w/o existing GROUP BY target
121-
SELECT aFROM test_missing_targetORDER BYupper(c);
121+
SELECT aFROM test_missing_targetORDER BYupper(d);
122122

123123
-- w/o existing ORDER BY target
124124
SELECTcount(b)FROM test_missing_target

0 commit comments

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