MySQL Bugs: #5161: Views: group_concat() function leads to trouble

Bug #5161	Views: group_concat() function leads to trouble
Submitted:	23 Aug 2004 1:47	Modified:	1 Sep 2004 20:36
Reporter:	Peter Gulutzan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.1	OS:	Linux (SuSE 8.2)
Assigned to:	Oleksandr Byelkin	CPU Architecture:	Any

Description:
If I use GROUP_CONCAT with SEPARATOR in a view, MySQL 
returns an error. Suspicious detail: the error message 
says "seperator" instead of "separator". After a while 
I get a "Lost connection to MySQL server" error. 

How to repeat:
mysql> create table t (col1 char(10)); 
Query OK, 0 rows affected (0.28 sec) 
 
mysql> create view v as select group_concat(col1 separator '.') from t; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> show create view v; 
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use near 'seperator '.') AS 
`group_concat(col1 separator '.')` from `db5`.`t`' at line 1 
mysql> show create view v; 
Packets out of order (Found: 2, expected 1) 
ERROR 2013 (HY000): Lost connection to MySQL server during query

it is typo in word 'separator' (seperator). Bug is present in 4.1 and will be fixed there.

ChangeSet 
  1.2033 04/09/01 21:32:24 bell@sanja.is.com.ua +2 -0 
  fixed typo in group_concat printing (BUG#5161) 
 
Bug is fixed in 4.1 and will apper soon in 5.0 (after merge)