Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.4, 5.3.12, 5.5.33a
-
None
-
None
-
Windows Vista, 32 bit
Description
Subquery in result column complains about returning multiple rows even though an aggregation is done over the rows.
CREATE TABLE t1 ( |
a INT(11) |
);
|
|
|
INSERT INTO t1 (a) VALUES (1), (2); |
|
|
CREATE TABLE t2 ( |
b INT(11) |
);
|
|
|
INSERT INTO t2 (b) VALUES (1), (2); |
|
|
SELECT
|
a,
|
(
|
SELECT |
SUM(a + c) |
FROM |
(
|
SELECT |
b as c |
FROM |
t2
|
) AS v1 |
)
|
FROM
|
t1;
|
Result:
ERROR 1242 (21000): Subquery returns more than 1 row
|
Expected
a subquery
|
1 5
|
2 7
|