Hi,
 
The following query has a syntax issue. But instead of reporting the syntax error, the server crashes.
 
select count(*) from (select col2, count(*) as row_count from data_1to10 group by col2 order by row_count desc, col1) sq
 
I have attached a PERL script which can be used to generate the required data for testing. I have also attached a  table definition script and the load script.
 
Please use the attached PERL script to generate the data as follows:

./massrecs.pl > <filename>

You will need to edit the "test_load_tables.sql" script to update the filename according to the name given.

Please let me know if you are unable to execute the test for any reason.

Thanks,
 
- Venkatesh