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