[MonetDB-users] Syntax in Query causes a Server Crash - Critical

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