From 0c511215f23809c4b9e8f5c26ad96520252e7758 Mon Sep 17 00:00:00 2001
From: unknown <monty@donna.mysql.com>
Date: Tue, 17 Oct 2000 00:47:15 +0300
Subject: Automatic repair of MyISAM tables + small bug fixes

Docs/manual.texi:
  Updates for 3.23.26
include/Makefile.am:
  Install my_config.h
include/my_pthread.h:
  Fix for Ia64
myisam/mi_check.c:
  Wrong new record pos on dupplicate key error
myisam/mi_open.c:
  Fix for automatic repair
myisam/myisamchk.c:
  Fix for automatic repair
myisam/myisamdef.h:
  Fix for automatic repair
mysys/mf_tempfile.c:
  Fix usage of mkstemp
sql-bench/bench-init.pl.sh:
  Better help text
sql-bench/test-insert.sh:
  Fix for slow databases
sql/field.cc:
  Fix of default values for CREATE TABLE ... SELECT
sql/ha_berkeley.cc:
  Fix bug in BDB records_in_range
sql/ha_myisam.cc:
  Fix for automatic repair
sql/ha_myisam.h:
  Fix for automatic repair
sql/handler.cc:
  Fixes for innobase
sql/item_strfunc.cc:
  Fix for SUBSTR_INDEX and REPLACE
sql/log_event.h:
  Portability fix
sql/mysqld.cc:
  Added INNOBASE and fixes for automatic recover of MyISAM tables
sql/sql_base.cc:
  Fix for automatic repair
sql/sql_table.cc:
  Fix for IF EXISTS when used with CREATE TEMPORARY
---
 sql-bench/bench-init.pl.sh | 7 ++++++-
 sql-bench/test-insert.sh   | 4 ++--
 2 files changed, 8 insertions(+), 3 deletions(-)

(limited to 'sql-bench')

diff --git a/sql-bench/bench-init.pl.sh b/sql-bench/bench-init.pl.sh
index 3b9e343bc4a..3f650885c21 100755
--- a/sql-bench/bench-init.pl.sh
+++ b/sql-bench/bench-init.pl.sh
@@ -51,7 +51,7 @@ $log_prog_args=join(" ", skip_arguments(\@ARGV,"comments","cmp","server",
 					"user", "host", "database", "password",
 					"use-old-results","skip-test",
 					"machine", "dir", "suffix", "log"));
-GetOptions("skip-test=s","comments=s","cmp=s","server=s","user=s","host=s","database=s","password=s","loop-count=i","row-count=i","skip-create","skip-delete","verbose","fast-insert","lock-tables","debug","fast","force","field-count=i","regions=i","groups=i","time-limit=i","log","use-old-results","machine=s","dir=s","suffix=s","help","odbc","small-test","small-tables","small-key-tables","stage=i","old-headers","die-on-errors","create-options","hires") || usage();
+GetOptions("skip-test=s","comments=s","cmp=s","server=s","user=s","host=s","database=s","password=s","loop-count=i","row-count=i","skip-create","skip-delete","verbose","fast-insert","lock-tables","debug","fast","force","field-count=i","regions=i","groups=i","time-limit=i","log","use-old-results","machine=s","dir=s","suffix=s","help","odbc","small-test","small-tables","small-key-tables","stage=i","old-headers","die-on-errors","create-options=s","hires") || usage();
 
 usage() if ($opt_help);
 $server=get_server($opt_server,$opt_host,$opt_database,$opt_odbc,
@@ -400,6 +400,11 @@ All benchmarks takes the following options:
   with the same --cmp, you will get a test that is comparable between
   the different sql servers.
 
+--create-options=#
+  Extra argument to all create statements.  If you for example want to
+  create all MySQL tables as BDB tables use:
+  --create-options=TYPE=BDB
+
 --database (Default $opt_database)
   In which database the test tables are created.
 
diff --git a/sql-bench/test-insert.sh b/sql-bench/test-insert.sh
index ec269df5d3b..a6161781ba9 100755
--- a/sql-bench/test-insert.sh
+++ b/sql-bench/test-insert.sh
@@ -572,7 +572,7 @@ if ($limits->{'group_functions'})
 
   $loop_time=new Benchmark;
   $count=$estimated=0;
-  for ($tests=0 ; $tests < $small_loop_count ; $tests++)
+  for ($tests=1 ; $tests <= $small_loop_count ; $tests++)
   {
     $count+=2;
     fetch_all_rows($dbh,"select count(distinct dummy1) from bench1");
@@ -834,7 +834,7 @@ if ($limits->{'func_odbc_floor'} && $limits->{'left_outer_join'})
 
   $count=$estimated=0;
   $loop_time=new Benchmark;
-  for ($i=0 ; $i < $small_loop_count ; $i++)
+  for ($i=1 ; $i <= $small_loop_count ; $i++)
   {
     $count+=fetch_all_rows($dbh,"select count(a.dummy1),count(b.dummy1) from bench1 as a left outer join bench1 as b on (a.id2=b.id3) where b.id3 is null");
     $end_time=new Benchmark;
-- 
cgit v1.2.1