Bug #7116 Views: GROUP_CONCAT crashes the server
Submitted: 8 Dec 2004 22:44 Modified: 3 Mar 2005 3:54
Reporter: Trudy Pelzer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-alpha-debug OS:Linux (SuSE 9.1)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[8 Dec 2004 22:44] Trudy Pelzer 
Description:
If I create a view as an exact copy of its 
underlying table and then do a simple 
query with GROUP_CONCAT on that view, 
the server crashes. 

How to repeat:
mysql> create table t1 (col1 char(5),col2 int,col3 int); 
mysql> insert into t1 values ('one',10,25); 
mysql> insert into t1 values ('two',10,50); 
mysql> insert into t1 values ('two',10,50); 
mysql> insert into t1 values ('one',20,25); 
mysql> insert into t1 values ('one',30,25); 
mysql> create view vt1 as select * from t1; 
 
mysql> select col1,group_concat(col2,col3) from t1 group by col1; 
+------+-------------------------+ 
| col1 | group_concat(col2,col3) | 
+------+-------------------------+ 
| one  | 1025,2025,3025          | 
| two  | 1050,1050               | 
+------+-------------------------+ 
-- This is the correct result. 
 
mysql> select col1,group_concat(col2,col3) from vt1 group by col1; 
ERROR 2013 (HY000): Lost connection to MySQL server during query 
-- This is the response when I run the same query 
against the view.
[31 Jan 2005 14:27] Oleksandr Byelkin 
ChangeSet
  1.1818 05/01/31 16:24:11 bell@sanja.is.com.ua +4 -0
  fixed problem with groupping by view (BUG#7116)
[24 Feb 2005 2:19] Oleksandr Byelkin 
Thank you for bugreport!
Bugfix is pushed into 5.0.3 source repository.
[3 Mar 2005 3:54] Paul DuBois 
Noted in 5.0.3 changelog.