Re: lock tables and sql cache

2005-03-31 Thread Gleb Paharenko
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

lock tables and sql cache

2005-03-30 Thread Bob O'Neill
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