Bug #7769 Server crashes from simple query
Submitted: 10 Jan 2005 13:43 Modified: 20 Jan 2005 18:28
Reporter: Marcus Eriksson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.8 OS:Linux (Linux)
Assigned to: Igor Babaev CPU Architecture:Any

[10 Jan 2005 13:43] Marcus Eriksson 
Description:
"group_concat" and "having" makes server crash

How to repeat:
CREATE TABLE t1 (id INT);
SELECT GROUP_CONCAT(id) AS gc FROM t1 HAVING gc is null;
[16 Jan 2005 3:59] Igor Babaev 
The fix was merged by Monty into the 5.0 tree as well 

ChangeSet
  1.2129 05/01/15 01:05:00 igor@rurik.mysql.com +3 -0
  func_gconcat.result, func_gconcat.test:
    Added a test case for bug #7769.
  item_sum.h:
    Fixed bug #7769: a crash for queries with group_concat and
    having when the query table was empty.
    The bug was due to an unsafe dereferencing.
  mysql-test/r/func_gconcat.result
    1.33 05/01/15 01:04:32 igor@rurik.mysql.com +5 -0
    Added a test case for bug #7769.
[20 Jan 2005 18:28] Paul DuBois 
Mentioned in 4.1.10 and 5.0.3 change notes.