Bug #24819 subquery with more than 1 row

• Submitted: 5 Dec 2006 13:25
• Modified: 19 Aug 2009 22:42
• Reporter: Balazs Odor
• Status: Verified
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 5.0.27
• OS: Linux (Debian Linux)
• CPU Architecture: Any

[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.