• Aditya A's avatar
    Bug #16051817 GOT ERROR 124 FROM STORAGE ENGINE · 60983fa9
    Aditya A authored
                   ON DELETE FROM A PARTITIONED TABLE
    
    PROBLEM
    -------
    
    The user first disables all the non unique indexes
    in the table and then rebuilds one partition.
    During rebuild the indexes on that particular
    partition are enabled. Now when we give a query 
    the optimizer is unaware that on one partition 
    indexes are enabled and if the optimizer selects
    that index,myisam thinks that the index is not 
    active and gives an error.
    
    FIX
    ---
    
    Before rebuilding a partition check whether non
    unique indexes are disabled on the partitons.
    If they are disabled then after rebuild disable
    the index on the partition. 
    
    [Approved by Mattiasj #rb3469]
    60983fa9
ha_partition.cc 239 KB