• thek@adventure.(none)'s avatar
    Bug#28249 Query Cache returns wrong result with concurrent insert / certain lock · 8ee7e48d
    thek@adventure.(none) authored
    A race condition in the integration between MyISAM and the query cache code 
    caused the query cache to fail to invalidate itself on concurrently inserted
    data.
    
    This patch fix this problem by using the existing handler interface which, upon
    each statement cache attempt, compare the size of the table as viewed from the 
    cache writing thread and with any snap shot of the global table state. If the
    two sizes are different the global table size is unknown and the current
    statement can't be cached.
    8ee7e48d
query_cache.test 26.9 KB