Bug #8568 | GROUP_CONCAT returns string, unless in a UNION in which case returns BLOB | ||
---|---|---|---|
Submitted: | 17 Feb 2005 14:42 | Modified: | 18 Nov 2005 16:17 |
Reporter: | Steve Owen | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S3 (Non-critical) |
Version: | 4.1.10-nt | OS: | Windows (Windows 2003) |
Assigned to: | Konstantin Osipov | CPU Architecture: | Any |
[17 Feb 2005 14:42]
Steve Owen
[17 Feb 2005 14:59]
MySQL Verification Team
Verified also with Access 2003.
[6 Jul 2005 9:13]
Are Gravbrøt
Same problem on Linux
[18 Nov 2005 16:17]
Konstantin Osipov
I can't repeat this bug against the latest 4.1: mysql> create table t1 (select GROUP_CONCAT(c2) from t where c1 = 'a') UNION (select GROUP_CONCAT(c2) from t where c1 = 'b'); Query OK, 1 row affected (0.03 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> create table t2 select GROUP_CONCAT(c2) from t where c1 = 'a'; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> show create table t1; +-------+------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+------------------------------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` ( `GROUP_CONCAT(c2)` longtext ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +-------+------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show create table t2; +-------+------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+------------------------------------------------------------------------------------------+ | t2 | CREATE TABLE `t2` ( `GROUP_CONCAT(c2)` longtext ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +-------+------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> select version(); +---------------------------+ | version() | +---------------------------+ | 4.1.16-valgrind-max-debug | +---------------------------+ 1 row in set (0.00 sec) Please reopen the bug report if you still can repeat the problem.
[18 Nov 2005 20:47]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/32415