Bug #3501 a crash due to stack overrun on COUNT(DISTINCT ...)
Submitted: 19 Apr 2004 6:47 Modified: 28 Apr 2004 14:44
Reporter: SINISA MILIVOJEVIC Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.0.19 OS:Any (any)
Assigned to: CPU Architecture:Any

[19 Apr 2004 6:47] SINISA MILIVOJEVIC
Description:
Stack get's overflown due to the error. 

How to repeat:
By using uploaded tables and running this query:

INSERT INTO sTotals_tmp SELECT  YEAR(      FROM_UNIXTIME(time)) AS YearNum, 	MONTH(     FROM_UNIXTIME(time)) AS MonthNum, 	DAYOFMONTH(FROM_UNIXTIME(time)) AS DayOfMonth, 	WEEK(      FROM_UNIXTIME(time)) AS WeekNum, 	DAYOFWEEK( FROM_UNIXTIME(time)) AS DayOfWeek, 	IFNULL(Category, 'NULL'), 	IFNULL(SubCategory, 'NULL'), 	SUM(Duration), 	COUNT(DISTINCT pages200401.id), 	COUNT(DISTINCT sessions200401.sessionid), 	COUNT(DISTINCT users_new.UID), 	COUNT(DISTINCT users_once.UID), COUNT(DISTINCT users_more.UID), COUNT(DISTINCT users200401.uid),  4, 	MD5(CONCAT(LEFT(FROM_UNIXTIME(time),10), IFNULL(Category, 'NULL'),  IFNULL(SubCategory, 'NULL') , IFNULL(IFNULL(pages200401.CatID, 'NULL'), 'NULL') , IFNULL(IFNULL(pages200401.DomID, 'NULL'), 'NULL'))) AS sTotalsHash, IFNULL(pages200401.CatID, 'NULL') , IFNULL(pages200401.DomID, 'NULL')  FROM pages200401,sessions200401,users200401 LEFT JOIN users200401 AS users_new   ON  users_new.UID = sessions200401.UID   AND users_new.SiteVisits = 1 LEFT JOIN users200401 AS users_once   ON  users_once.UID = sessions200401.UID    AND users_once.SiteVisits = 2 LEFT JOIN users200401 AS users_more   ON  users_more.UID = sessions200401.UID   AND users_more.SiteVisits >  2 WHERE  sessions200401.sessionid = pages200401.sessionid AND    users200401.uid = sessions200401.uid AND     CatID = 17225 GROUP BY sTotalsHash;
[28 Apr 2004 14:44] MySQL Verification Team
duplicate of #3265