• Venkata Sidagam's avatar
    Bug #11759445: CAN'T DELETE ROWS FROM MEMORY TABLE WITH HASH KEY. · 2226b108
    Venkata Sidagam authored
    Brief description: After insert some rows to MEMORY table with HASH key some 
    rows can't be deleted in one step.    
    
    Problem Analysis/solution: info->current_ptr will have the information about the
    current hash pointer from where we can traverse to the list to get all the       
    remaining tuples.
          
    In hp_delete_key we are updating info->current_ptr with the last_pos based on       
    the flag parameter(which is the keydef and last index are same). As part of the       
    fix we are making it to zero only when the code flow reaches to the end of the       
    function hp_delete_key() it means that the next record which has to get deleted       
    will be at the starting of the list so, that in the next call to       
    read record(heap_rnext()) will take line number 100 path instead of 102 path, 
    please see the below code in file hp_rnext.c, function heap_rnext().
     99       else if (!info->current_ptr)              /* Deleted or first call */
    100         pos= hp_search(info, keyinfo, info->lastkey, 0);
    101       else  
    102         pos= hp_search(info, keyinfo, info->lastkey, 1);
    
    with that change the hp_search() will update the info->current_ptr with the 
    record which needs to be deleted.
    
    storage/heap/hp_delete.c:
      In heap_delete_key() function we are making info->current_ptr to 0 if 
      flag is enabled.
    2226b108
hp_delete.c 6 KB