The simple test case is in support of http://bugs.mysql.com/bug.php?id=53775

=== Requirements ===

Test requires innodb, query cache and partitioning

=== Issue ===
 
SELECT query issued after an UPDATE to the same partitioned table is making a query cache insert.  
This query cache insertion can be later retrieved after a ROLLBACK and a new transaction is started.

=== Cause ===

ha_partition class does not implement register_query_cache_table resulting in the use of the 
parent handler class definition which always returns true.

virtual my_bool register_query_cache_table(THD *thd, char *table_key,
                                           uint key_length,
                                           qc_engine_callback
                                           *engine_callback,
                                           ulonglong *engine_data)
{
  /* My ghetto debug statement */
  DBUG_PRINT("qcache", ("Checking for caching ability in handler.h under parent handler class!"));
  *engine_callback= 0;
  return TRUE;
}

== Possible Fix ==

ha_partition needs to delegate register_query_cache_table to its underlying handle(s), or if this is too heavy
partitioning should not use query cache in a transaction.

== Current Test Status ==

This test will currently fail on the 3rd SELECT query which returns the cache hit from the first SELECT query.



