From ee763533f237bbe8a2bca890a2355d62617268f0 Mon Sep 17 00:00:00 2001
From: "monty@donna.mysql.com" <>
Date: Tue, 17 Oct 2000 23:57:26 +0300
Subject: Fixed benchmarks and compare of NULL with <>

---
 sql-bench/test-insert.sh | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'sql-bench')

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;
+  }
 }
 
 
-- 
cgit v1.2.1