• Mattias Jonsson's avatar
    Bug#11761296: 53775: QUERY ON PARTITIONED TABLE RETURNS CACHED · 74374933
    Mattias Jonsson authored
                                            RESULT FROM PREVIOUS TRANSACTION
    
    The current Query Cache API is not fully compatible with
    the partitioning engine.
    
    There is no good way to implement support for QC due to:
    1) a static callback for ha_partition would need to have access
    to all partition names and call the underlying callback for each
    [sub]partition with the correct name.
    2) pruning would be impossible, even if one used the ulonglong
    engine_data due to if engine_data is changed, the table is
    invalidated by the QC.
    
    So the only viable solution to avoid incorrect data is to not allow
    caching of queries using partitioned tables.
    
    (There are some extra changes, due to removal of \r as line break)
    74374933
cache_innodb.result 5.19 KB