summaryrefslogtreecommitdiff
path: root/sql-bench/test-create.sh
diff options
context:
space:
mode:
authormonty@donna.mysql.com <>2000-11-24 01:51:18 +0200
committermonty@donna.mysql.com <>2000-11-24 01:51:18 +0200
commit81bc313e99ed12ff87ca45529a11ab31acc28263 (patch)
treef7a94e9f7992838a96724db08a38f94bd9d50e27 /sql-bench/test-create.sh
parentc62554025dad1f70cf5335233864b390cf5de95e (diff)
downloadmariadb-git-81bc313e99ed12ff87ca45529a11ab31acc28263.tar.gz
All statements are now run in a sub transaction
Give warning if we are using non transactional tables and do ROLLBACK Porting of crash-me and benchmarks to FrontBase
Diffstat (limited to 'sql-bench/test-create.sh')
-rwxr-xr-xsql-bench/test-create.sh12
1 files changed, 6 insertions, 6 deletions
diff --git a/sql-bench/test-create.sh b/sql-bench/test-create.sh
index f72461a6c48..09d79c67b04 100755
--- a/sql-bench/test-create.sh
+++ b/sql-bench/test-create.sh
@@ -64,7 +64,7 @@ if ($opt_force) # If tables used in this test exist, drop 'em
print "Okay..Let's make sure that our tables don't exist yet.\n\n";
for ($i=1 ; $i <= $max_tables ; $i++)
{
- $dbh->do("drop table bench_$i");
+ $dbh->do("drop table bench_$i" . $server->{'drop_attr'});
}
}
@@ -90,7 +90,7 @@ for ($i=1 ; $i <= $max_tables ; $i++)
# Got an error; Do cleanup
for ($i=1 ; $i <= $max_tables ; $i++)
{
- $dbh->do("drop table bench_$i");
+ $dbh->do("drop table bench_$i" . $server->{'drop_attr'});
}
die "Test aborted";
}
@@ -148,13 +148,13 @@ if ($opt_fast && $server->{'limits'}->{'multi_drop'} &&
{
$query.=",bench_$i";
}
- $sth = $dbh->do($query) or die $DBI::errstr;
+ $sth = $dbh->do($query . $server->{'drop_attr'}) or die $DBI::errstr;
}
else
{
for ($i=1 ; $i <= $max_tables ; $i++)
{
- $sth = $dbh->do("drop table bench_$i")
+ $sth = $dbh->do("drop table bench_$i" . $server->{'drop_attr'})
or die $DBI::errstr;
}
}
@@ -186,7 +186,7 @@ for ($i=1 ; $i <= $opt_loop_count ; $i++)
"s char(10)",
"v varchar(100)"],
["primary key (i)"]));
- $sth = $dbh->do("drop table bench_$i") or die $DBI::errstr;
+ $sth = $dbh->do("drop table bench_$i" . $server->{'drop_attr'}) or die $DBI::errstr;
}
$end_time=new Benchmark;
@@ -239,7 +239,7 @@ $loop_time=new Benchmark;
for ($i=1 ; $i <= $opt_loop_count ; $i++)
{
do_many($dbh,$server->create("bench_$i", \@fields, \@index));
- $dbh->do("drop table bench_$i") or die $DBI::errstr;
+ $dbh->do("drop table bench_$i" . $server->{'drop_attr'}) or die $DBI::errstr;
}
$end_time=new Benchmark;