Skip to content

Commit 511b368

Browse files
author
Thomas G. Lockhart
committed
Renamed from "junkfilter" test.
1 parent 3a3c1b8 commit 511b368

File tree

1 file changed

+132
-0
lines changed

1 file changed

+132
-0
lines changed

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

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(*)
42+
FROM test_missing_target GROUP BY b ORDER BY b;
43+
b|count
44+
-+-----
45+
1| 1
46+
2| 2
47+
3| 3
48+
4| 4
49+
(4 rows)
50+
51+
QUERY: SELECT c FROM test_missing_target ORDER BY a;
52+
c
53+
--------
54+
XXXX
55+
AAAA
56+
AAAA
57+
BBBB
58+
BBBB
59+
BBBB
60+
CCCC
61+
CCCC
62+
CCCC
63+
CCCC
64+
(10 rows)
65+
66+
QUERY: SELECT count(*) FROM test_missing_target GROUP BY b ORDER BY b desc;
67+
count
68+
-----
69+
4
70+
3
71+
2
72+
1
73+
(4 rows)
74+
75+
QUERY: SELECT count(*) FROM test_missing_target ORDER BY 1 desc;
76+
count
77+
-----
78+
10
79+
(1 row)
80+
81+
QUERY: SELECT c, count(*) FROM test_missing_target GROUP BY 1;
82+
c |count
83+
--------+-----
84+
AAAA | 2
85+
BBBB | 3
86+
CCCC | 4
87+
XXXX | 1
88+
(4 rows)
89+
90+
QUERY: SELECT c, count(*) FROM test_missing_target GROUP BY 3;
91+
ERROR: ORDER/GROUP BY position 3 is not in target list
92+
QUERY: SELECT count(*) FROM test_missing_target x, test_missing_target y
93+
WHERE x.a = y.a
94+
GROUP BY b ORDER BY b;
95+
ERROR: Column b is ambiguous
96+
QUERY: SELECT x.b, count(*) FROM test_missing_target x, test_missing_target y
97+
WHERE x.a = y.a
98+
GROUP BY x.b;
99+
b|count
100+
-+-----
101+
1| 1
102+
2| 2
103+
3| 3
104+
4| 4
105+
(4 rows)
106+
107+
QUERY: SELECT count(*) FROM test_missing_target x, test_missing_target y
108+
WHERE x.a = y.a
109+
GROUP BY x.b;
110+
count
111+
-----
112+
1
113+
2
114+
3
115+
4
116+
(4 rows)
117+
118+
QUERY: SELECT count(*) INTO TABLE test_missing_target2
119+
FROM test_missing_target x, test_missing_target y
120+
WHERE x.a = y.a
121+
GROUP BY x.b;
122+
QUERY: SELECT * FROM test_missing_target2;
123+
count
124+
-----
125+
1
126+
2
127+
3
128+
4
129+
(4 rows)
130+
131+
QUERY: DROP TABLE test_missing_target;
132+
QUERY: DROP TABLE test_missing_target2;

0 commit comments

Comments
 (0)