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;