Bug #24819 subquery with more than 1 row
Submitted: 5 Dec 2006 13:25 Modified: 19 Aug 2009 22:42
Reporter: Balazs Odor Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.27 OS:Linux (Debian Linux)
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[5 Dec 2006 13:25] Balazs Odor
Description:
Like group_concat(), concat() or concat_ws().

Usage: concat_rows(',',(select `field` from `table`))
The subquery return more than 1 row, and concat_rows() make a blob.

mysql> select `field` from `table`;
+--------+
| field  |
+--------+
| 1.row  |
| 2.row  |
| ...row |
+--------+
3 rows in set (0.00 sec)

How to repeat:
Feature request:

mysql> select concat_rows(',',(select `field` from `table`)) as `concat_rows`;
+--------------------+
| concat_rows        |
+--------------------+
| 1.row,2.row,...row |
+--------------------+
1 rows in set (0.00 sec)
[19 Aug 2009 22:42] Sveta Smirnova
Thank you for the reasonable feature request.