diff options
author | walrus@mysql.com <> | 2003-01-25 17:03:00 +0500 |
---|---|---|
committer | walrus@mysql.com <> | 2003-01-25 17:03:00 +0500 |
commit | 1115b3d9b48f7928eb624a73724310e9001a8899 (patch) | |
tree | 413f8a55b201d22232d8089baecb78eb58d17f71 /sql-bench/test-select.sh | |
parent | 1ecf9d5098f46a62073c0751650a38563769b60e (diff) | |
download | mariadb-git-1115b3d9b48f7928eb624a73724310e9001a8899.tar.gz |
Change bench files for mimer compability, change crash-me for correct testing time datafields
Diffstat (limited to 'sql-bench/test-select.sh')
-rw-r--r-- | sql-bench/test-select.sh | 27 |
1 files changed, 15 insertions, 12 deletions
diff --git a/sql-bench/test-select.sh b/sql-bench/test-select.sh index a5ae1da7283..a5de042cab1 100644 --- a/sql-bench/test-select.sh +++ b/sql-bench/test-select.sh @@ -355,19 +355,22 @@ if ($limits->{'group_distinct_functions'}) print " for count_distinct ($count:$rows): " . timestr(timediff($end_time, $loop_time),"all") . "\n"; - $loop_time=new Benchmark; - $rows=$estimated=$count=0; - for ($i=0 ; $i < $opt_medium_loop_count ; $i++) - { - $count++; - $rows+=fetch_all_rows($dbh,"select count(distinct grp),count(distinct rev_idn) from bench1"); - $end_time=new Benchmark; - last if ($estimated=predict_query_time($loop_time,$end_time,\$count,$i+1, +# Workaround mimer's behavior + if (limits->{'multi_distinct'} == 1 ) { + $loop_time=new Benchmark; + $rows=$estimated=$count=0; + for ($i=0 ; $i < $opt_medium_loop_count ; $i++) + { + $count++; + $rows+=fetch_all_rows($dbh,"select count(distinct grp),count(distinct rev_idn) from bench1"); + $end_time=new Benchmark; + last if ($estimated=predict_query_time($loop_time,$end_time,\$count,$i+1, $opt_medium_loop_count)); - } - print_time($estimated); - print " for count_distinct_2 ($count:$rows): " . - timestr(timediff($end_time, $loop_time),"all") . "\n"; + } + print_time($estimated); + print " for count_distinct_2 ($count:$rows): " . + timestr(timediff($end_time, $loop_time),"all") . "\n"; + } $loop_time=new Benchmark; $rows=$estimated=$count=0; |