Hello.
I think it is a weird behavior. I've reported a bug:
http://bugs.mysql.com/bug.php?id=9511
Bob O'Neill <[EMAIL PROTECTED]> wrote:
> If I try to read table 'b' after locking table 'a', I expect to get
> the error message "Table 'b' was not locked with LOCK TABLES".
> Ho
If I try to read table 'b' after locking table 'a', I expect to get
the error message "Table 'b' was not locked with LOCK TABLES".
However, if my query that accesses table b is stored in the query
cache, I don't get the error. This causes a problem in the following
scenario:
User 1:
LOCK TABLES