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

Commitb952a84

Browse files
committed
Also added two new files.
src/test/regess/sql/junkfilter.sql -- SQL forregression test src/test/regess/expected/junkfilter.out --Expected output SQL for regression testDavid Hartwig
1 parent2e61593 commitb952a84

File tree

2 files changed

+206
-0
lines changed

2 files changed

+206
-0
lines changed
Lines changed: 132 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,132 @@
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');
12+
QUERY: SELECT c, count(*) FROM test_missing_target GROUP BY test_missing_target.c;
13+
c |count
14+
--------+-----
15+
AAAA | 2
16+
BBBB | 3
17+
CCCC | 4
18+
XXXX | 1
19+
(4 rows)
20+
21+
QUERY: SELECT count(*) FROM test_missing_target GROUP BY test_missing_target.c;
22+
count
23+
-----
24+
2
25+
3
26+
4
27+
1
28+
(4 rows)
29+
30+
QUERY: SELECT count(*) FROM test_missing_target GROUP BY a ORDER BY b;
31+
ERROR: parser: illegal use of aggregates or non-group column in target list
32+
QUERY: SELECT count(*) FROM test_missing_target GROUP BY b ORDER BY b;
33+
count
34+
-----
35+
1
36+
2
37+
3
38+
4
39+
(4 rows)
40+
41+
QUERY: SELECT test_missing_target.b, count(*) FROM test_missing_target GROUP BY b ORDER BY b;
42+
b|count
43+
-+-----
44+
1| 1
45+
2| 2
46+
3| 3
47+
4| 4
48+
(4 rows)
49+
50+
QUERY: SELECT c FROM test_missing_target ORDER BY a;
51+
c
52+
--------
53+
XXXX
54+
AAAA
55+
AAAA
56+
BBBB
57+
BBBB
58+
BBBB
59+
CCCC
60+
CCCC
61+
CCCC
62+
CCCC
63+
(10 rows)
64+
65+
QUERY: SELECT count(*) FROM test_missing_target GROUP BY b ORDER BY b desc;
66+
count
67+
-----
68+
4
69+
3
70+
2
71+
1
72+
(4 rows)
73+
74+
QUERY: SELECT count(*) FROM test_missing_target ORDER BY 1 desc;
75+
count
76+
-----
77+
10
78+
(1 row)
79+
80+
QUERY: SELECT c, count(*) FROM test_missing_target GROUP BY 1;
81+
c |count
82+
--------+-----
83+
AAAA | 2
84+
BBBB | 3
85+
CCCC | 4
86+
XXXX | 1
87+
(4 rows)
88+
89+
QUERY: SELECT c, count(*) FROM test_missing_target GROUP BY 3;
90+
ERROR: left hand side of operator < has an unknown type, probably a bad attribute name
91+
QUERY: SELECT count(*) FROM test_missing_target x, test_missing_target y
92+
WHERE x.a = y.a
93+
GROUP BY b ORDER BY b;
94+
ERROR: Column b is ambiguous
95+
QUERY: SELECT x.b, count(*) FROM test_missing_target x, test_missing_target y
96+
WHERE x.a = y.a
97+
GROUP BY x.b;
98+
b|count
99+
-+-----
100+
1| 1
101+
2| 2
102+
3| 3
103+
4| 4
104+
(4 rows)
105+
106+
QUERY: SELECT count(*) FROM test_missing_target x, test_missing_target y
107+
WHERE x.a = y.a
108+
GROUP BY x.b;
109+
count
110+
-----
111+
1
112+
2
113+
3
114+
4
115+
(4 rows)
116+
117+
QUERY: SELECT count(*) INTO TABLE test_missing_target2
118+
FROM test_missing_target x, test_missing_target y
119+
WHERE x.a = y.a
120+
GROUP BY x.b;
121+
QUERY: SELECT * FROM test_missing_target2;
122+
count
123+
-----
124+
1
125+
2
126+
3
127+
4
128+
(4 rows)
129+
130+
QUERY: drop table test_missing_target;
131+
QUERY: drop table test_missing_target2;
132+

‎src/test/regress/sql/junkfilter.sql

Lines changed: 74 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,74 @@
1+
-- load test data
2+
CREATETABLEtest_missing_target (aint, bint, cchar(8));
3+
INSERT INTO test_missing_targetVALUES (0,1,'XXXX');
4+
INSERT INTO test_missing_targetVALUES (1,2,'AAAA');
5+
INSERT INTO test_missing_targetVALUES (2,2,'AAAA');
6+
INSERT INTO test_missing_targetVALUES (3,3,'BBBB');
7+
INSERT INTO test_missing_targetVALUES (4,3,'BBBB');
8+
INSERT INTO test_missing_targetVALUES (5,3,'BBBB');
9+
INSERT INTO test_missing_targetVALUES (6,4,'CCCC');
10+
INSERT INTO test_missing_targetVALUES (7,4,'CCCC');
11+
INSERT INTO test_missing_targetVALUES (8,4,'CCCC');
12+
INSERT INTO test_missing_targetVALUES (9,4,'CCCC');
13+
14+
15+
-- w/ existing GROUP BY target
16+
SELECT c,count(*)FROM test_missing_targetGROUP BYtest_missing_target.c;
17+
18+
-- w/o existing GROUP BY target using a relation name in GROUP BY clause
19+
SELECTcount(*)FROM test_missing_targetGROUP BYtest_missing_target.c;
20+
21+
-- w/o existing GROUP BY target and w/o existing a different ORDER BY target
22+
-- failure expected
23+
SELECTcount(*)FROM test_missing_targetGROUP BY aORDER BY b;
24+
25+
-- w/o existing GROUP BY target and w/o existing same ORDER BY target
26+
SELECTcount(*)FROM test_missing_targetGROUP BY bORDER BY b;
27+
28+
-- w/ existing GROUP BY target using a relation name in target
29+
SELECTtest_missing_target.b,count(*)FROM test_missing_targetGROUP BY bORDER BY b;
30+
31+
-- w/o existing GROUP BY target
32+
SELECT cFROM test_missing_targetORDER BY a;
33+
34+
-- w/o existing ORDER BY target
35+
SELECTcount(*)FROM test_missing_targetGROUP BY bORDER BY bdesc;
36+
37+
-- group using reference number
38+
SELECTcount(*)FROM test_missing_targetORDER BY1desc;
39+
40+
-- order using reference number
41+
SELECT c,count(*)FROM test_missing_targetGROUP BY1;
42+
43+
-- group using reference number out of range
44+
-- failure expected
45+
SELECT c,count(*)FROM test_missing_targetGROUP BY3;
46+
47+
-- group w/o existing GROUP BY and ORDER BY target under ambigious condition
48+
-- failure expected
49+
SELECTcount(*)FROM test_missing_target x, test_missing_target y
50+
WHEREx.a=y.a
51+
GROUP BY bORDER BY b;
52+
53+
-- group w/ existing GROUP BY target under ambigious condition
54+
SELECTx.b,count(*)FROM test_missing_target x, test_missing_target y
55+
WHEREx.a=y.a
56+
GROUP BYx.b;
57+
58+
-- group w/o existing GROUP BY target under ambigious condition
59+
SELECTcount(*)FROM test_missing_target x, test_missing_target y
60+
WHEREx.a=y.a
61+
GROUP BYx.b;
62+
63+
-- group w/o existing GROUP BY target under ambigious condition
64+
-- into a table
65+
SELECTcount(*) INTO TABLE test_missing_target2
66+
FROM test_missing_target x, test_missing_target y
67+
WHEREx.a=y.a
68+
GROUP BYx.b;
69+
SELECT*FROM test_missing_target2;
70+
71+
-- Cleanup
72+
droptable test_missing_target;
73+
droptable test_missing_target2;
74+

0 commit comments

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