Fixed benchmarks and compare of NULL with <>

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;
+  }
 }