• unknown's avatar
    Bug #27792 query cache returns wrong result, with certain system variables · ed947499
    unknown authored
     - Queries in the query cache are identified by the individual 
       characters in the query statement, the current database and 
       the current environment expressed as a set of system variable
       flags.
     - Since the set of environment flags didn't properly describe the
       current environment unexpected results were returned from the 
       query cache.
     - Query cache is now cleared when the variable ft_boolean_syntax is 
       updated.
     - An identification flag for the variable default_week_format is 
       added to the query cache record.
     
    Thanks to Martin Friebe who has supplied significant parts of this patch.
    
    
    mysql-test/r/query_cache.result:
      Added test case
    mysql-test/t/query_cache.test:
      Added test case
    sql/mysql_priv.h:
      - Added missing flags to reflect the significant local environment
        settings of the cached query.
    sql/set_var.cc:
      - Added query cache flush when system variable ft_boolean_syntax is
        updated since this also invalidates all cached result sets using this
        variable.
    sql/sql_cache.cc:
      - Added another local system variable as an identification flag
        for cached queries.
    ed947499
query_cache.test 20.5 KB