Bug #125 crash on word database test
Submitted: 6 Mar 2003 0:58 Modified: 10 Mar 2003 12:43
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 OS:Any (any)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[6 Mar 2003 0:58] Oleksandr Byelkin
Description:
crash on word database test 

How to repeat:
select Country.Continent, City.Name, City.Population from Country LEFT 
 JOIN City ON Country.Code = City.Country  where City.Population IN (select 
 max(City.Population) AS Population from City, Country where City.Country = 
 Country.Code group by Continent); 
select Country.Continent, City.Name, City.Population from Country LEFT 
 JOIN City ON Country.Code = City.Country  where City.Population IN (select 
 max(City.Population) AS Population from City, Country where City.Country = 
 Country.Code group by Continent); 
 
on word database lead to crash mysql server 

Suggested fix:
have not yet