MySQL Bugs: #125: crash on word database test

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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