Added locks needed for Innobase

Fixed mutex problem when doing automatic repair of MyISAM tables


Docs/manual.texi:
  changelog
include/thr_lock.h:
  Added TL_READ_WITH_SHARED_LOCKS for Innobase
mysql-test/r/update.result:
  Added 'select' to verify update results
mysql-test/t/update.test:
  Better code coverage
mysys/getvar.c:
  Allow space in to --set-variable
mysys/thr_lock.c:
  Added TL_READ_WITH_SHARED_LOCKS
sql/ha_myisam.cc:
  Added comment
sql/lock.cc:
  Added missing broadcast
sql/sql_base.cc:
  Fixed some mutex problem when doing automatic repair of MyISAM tables
sql/sql_update.cc:
  Purecoverage

1 files changed, 10 insertions, 0 deletions

diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test
index 6010c311015..a51bce8aebe 100644
--- a/mysql-test/t/update.test
+++ b/mysql-test/t/update.test
@@ -7,6 +7,16 @@ create table t1 (a int auto_increment , primary key (a));
 insert into t1 values (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL); 
 update t1 set a=a+10 where a > 34;
 update t1 set a=a+100 where a > 0;
+
+# Some strange updates to test some otherwise unused code
+update t1 set a=a+100 where a=1 and a=2;
+--error 1054
+update t1 set a=b+100 where a=1 and a=2; 
+--error 1054
+update t1 set a=b+100 where c=1 and a=2; 
+--error 1054
+update t1 set d=a+100 where a=1;
+select * from t1;
 drop table t1;
 
 CREATE TABLE t1