• unknown's avatar
    Bug#30269 Query cache eats memory · a5423e18
    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
    a5423e18
query_cache_with_views.test 3.45 KB