Would you mind entering this as a bug report on Sourceforge? Please attach the files you attached to your mail to the bug report. This makes tracking the bug much easier for us, and also makes sure we won't forget. Thanks in advance. You can find the bug report site at https://sourceforge.net/tracker/?group_id=56967&atid=482468 . Venks wrote:
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
------------------------------------------------------------------------
#!/usr/bin/perl # This function generates random strings of a given length sub generate_random_string { my $length_of_randomstring=shift;# the length of # the random string to generate
# my @chars=('A'..'Z','0'..'9','+','-',','); my @chars=('A'..'Z'); my $random_string; foreach (1..$length_of_randomstring) { # rand @chars will generate a random # number between 0 and scalar @chars $random_string.=$chars[rand @chars]; } return $random_string; }
#Generate the random string my $random_string=&generate_random_string(11);
my $i; my $random_string; my $random; my $lower=10000; my $upper=99999;
# ======================================================================================== # Please change the numbers in the for loop below for controlling the ID and the row count # ========================================================================================
for ($i=1;$i<10000001;$i++) {
$random_string=&generate_random_string(2);
$random = int(rand( $upper-$lower+1 ) ) + $lower;
# printf "%28.0f\n",$random; printf "$i\t$random\t$random_string\n";
}
------------------------------------------------------------------------
------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/
------------------------------------------------------------------------
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Sjoerd Mullender