Bug #43167 table locks are not working properly
Submitted: 25 Feb 2009 6:16 Modified: 25 Feb 2009 6:54
Reporter: pavan devulapalli Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:6.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: table locks are not working properly

[25 Feb 2009 6:16] pavan devulapalli 
Description:
table locks are not working properly.

just go through this:

create table t1 (i int);
lock table t1 write;
insert into t1 values(20);

then value 20 is inserting. as i used WRITE lock it should not  update or insert.
plz. get back to me with solution.

How to repeat:
create table t1 (i int);
lock table t1 write;
insert into t1 values(20);

then value 20 is inserting. as i used WRITE lock it should not  update or insert.
plz. get back to me with solution.
[25 Feb 2009 6:54] Sveta Smirnova 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please read at http://dev.mysql.com/doc/refman/6.0/en/lock-tables.html about how WRITE LOCK works