• Eugene Kosov's avatar
    MDEV-15364 FOREIGN CASCADE operations in system versioned referenced tables · 19a182b1
    Eugene Kosov authored
    Make foreign system versioning tables work in CASCADE UPDATE/SET NULL.
    In that case basically row update is performed. This patch makes insert
    of a historical row performed too.
    
    row_update_versioned_insert(): restores btr_pcur_t, reads row from it, makes
    row historical and inserts to table.
    
    row_ins_check_foreign_constraint(): disable constraint check for historical
    rows because it has no sense. Also check will fail always, because referenced
    table is updated at that point.
    
    row_update_cascade_for_mysql(): insert historical row for system versioning
    tables before updating current row.
    
    revert DATA_VERSIONED -> DATA_UNVERSIONED
    19a182b1
foreign.result 9.17 KB