Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
Description
Hi guys, i think we have a problem with lock tables write lock and query cache
when we execute a LOCK TABLE xxx WRITE, shouldn't the query cache for that table be avoid? cause i can execute select with that table and get results even i have lock table with write lock
in other words, what i'm thinking about:
1) lock table with write should invalidate query cache table
2) locked tables should be checked before returning query cache data to client (for example, if we got the query from cache, check if we have a locked table with LOCK TABLE command, if yes, don't fetch from query cache)
this happen with any engine (including innodb but not common)