diff options
author | unknown <monty@hundin.mysql.fi> | 2001-08-26 23:24:48 +0300 |
---|---|---|
committer | unknown <monty@hundin.mysql.fi> | 2001-08-26 23:24:48 +0300 |
commit | 30774b35493d3ad14ee40b73d4b9ffff51dd6cd1 (patch) | |
tree | 7df1f3b7860b5ebb86cad40aa765d858dcbe716b /sql-bench/test-insert.sh | |
parent | 0733b85d75c560cc2e9cca84e490a4ccde5a945a (diff) | |
download | mariadb-git-30774b35493d3ad14ee40b73d4b9ffff51dd6cd1.tar.gz |
Fixed bug in auto-increment handling with InnoDB
Some small speedups
Docs/manual.texi:
Changelog
client/mysqldump.c:
Fixed quoting problem for table names when using --opt
mysys/mf_casecnv.c:
Speed up some common string functions
sql-bench/test-insert.sh:
Small changes that shouldn't affect results
sql-bench/test-select.sh:
Small changes that shouldn't affect results
sql/field.h:
Added reset() functions to speed up some common things
sql/gen_lex_hash.cc:
Smaller hash table
sql/ha_innobase.cc:
Fixed bug in auto-increment handling with InnoDB
Diffstat (limited to 'sql-bench/test-insert.sh')
-rw-r--r-- | sql-bench/test-insert.sh | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql-bench/test-insert.sh b/sql-bench/test-insert.sh index b8f20b123a5..9d1adda1fc3 100644 --- a/sql-bench/test-insert.sh +++ b/sql-bench/test-insert.sh @@ -562,7 +562,7 @@ if ($limits->{'group_functions'}) fetch_all_rows($dbh,"select min(id) from bench1"); fetch_all_rows($dbh,"select max(id) from bench1"); fetch_all_rows($dbh,"select sum(id+0.0) from bench1"); - fetch_all_rows($dbh,"select min(id3),max(id3),sum(id3 +0.0) from bench1"); + fetch_all_rows($dbh,"select min(id3),max(id3),sum(id3-0.0) from bench1"); if ($limits->{'group_func_sql_min_str'}) { fetch_all_rows($dbh,"select min(dummy1),max(dummy1) from bench1"); @@ -579,7 +579,7 @@ if ($limits->{'group_functions'}) $count++; - $sth=$dbh->prepare($query="select count(*),sum(id+0.0),min(id),max(id),avg(id+0.0) from bench1") or die $DBI::errstr; + $sth=$dbh->prepare($query="select count(*),sum(id+0.0),min(id),max(id),avg(id-0.0) from bench1") or die $DBI::errstr; $sth->execute or die $DBI::errstr; @row=$sth->fetchrow_array; if ($row[0] != $total_rows || |