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";
}
test_create_tables.sql
Description: Binary data
test_load_tables.sql
Description: Binary data
------------------------------------------------------------------------- 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
