• Thirunarayanan Balathandayuthapani's avatar
    MDEV-22934 Table disappear after two alter table command · 8268f266
    Thirunarayanan Balathandayuthapani authored
    Problem:
    =======
    InnoDB drops the column which has foreign key relations on it. So it
    tries to load the foreign key during rename process of copy algorithm
    even though the foreign_key_check is disabled.
    
    Solution:
    ========
    During alter copy algorithm, InnoDB ignores the error while loading
    the foreign key constraint if foreign key check is disabled. It
    should throw the warning about failure of the foreign key constraint
    when foreign key check is disabled.
    8268f266
row0mysql.cc 129 KB