• unknown's avatar
    Bug#30269 Query cache eats memory · 3a5a0ea3
    unknown authored
    Although the query cache doesn't support retrieval of statements containing
    column level access control, it was still possible to cache such statements
    thus wasting memory.
      
    This patch extends the access control check on the target tables to avoid
    caching a statement with column level restrictions. 
    
    Views are excepted and can be cached but only retrieved by super user account.
    
    
    mysql-test/t/query_cache_with_views.test:
      Rename: mysql-test/t/view_query_cache.test -> mysql-test/t/query_cache_with_views.test
    mysql-test/r/query_cache_with_views.result:
      Rename: mysql-test/r/view_query_cache.result -> mysql-test/r/query_cache_with_views.result
    mysql-test/r/query_cache.result:
      Modified test case to allow caching of views
    mysql-test/t/query_cache.test:
      Modified test case to allow caching of views
    sql/sql_cache.cc:
      Allow caching of views
    3a5a0ea3
query_cache_with_views.result 4.56 KB