diff options
Diffstat (limited to 'sql-bench/test-insert.sh')
| -rwxr-xr-x | sql-bench/test-insert.sh | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql-bench/test-insert.sh b/sql-bench/test-insert.sh index a6161781ba9..e6690b043f1 100755 --- a/sql-bench/test-insert.sh +++ b/sql-bench/test-insert.sh @@ -867,6 +867,10 @@ if ($server->small_rollback_segment()) if ($limits->{'insert_select'}) { + if ($opt_lock_tables) + { + $sth = $dbh->do("UNLOCK TABLES") || die $DBI::errstr; + } print "\nTesting INSERT INTO ... SELECT\n"; do_many($dbh,$server->create("bench2", ["id int NOT NULL", @@ -911,6 +915,10 @@ if ($limits->{'insert_select'}) $dbh->disconnect; # close connection $dbh = $server->connect(); } + if ($opt_lock_tables) + { + $sth = $dbh->do("LOCK TABLES bench1 WRITE") || die $DBI::errstr; + } } |