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
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Elena Stepanova [ elenst ] |
| Fix Version/s | 10.0.6 [ 13202 ] | |
| Fix Version/s | 5.5.34 [ 13700 ] | |
| Fix Version/s | 5.3.13 [ 12602 ] | |
| Affects Version/s | 5.3.12 [ 12000 ] | |
| Affects Version/s | 10.0.4 [ 13101 ] |
| Assignee | Elena Stepanova [ elenst ] | Igor Babaev [ igor ] |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | defaullt [ 29127 ] | MariaDB v2 [ 44128 ] |
| Workflow | MariaDB v2 [ 44128 ] | MariaDB v3 [ 63398 ] |
| Workflow | MariaDB v3 [ 63398 ] | MariaDB v4 [ 147078 ] |