• unknown's avatar
    Bug#60196 / Bug#11831040 · 08f128f6
    unknown authored
    Setting lowercase_table_names to 2 on Windows causing Foreign Key problems
    
    This problem was exposed by the fix for Bug#55222.  There was a codepath in dict0load.c,
    dict_load_foreigns() that made sure the table name matched case sensitive in order to
    load a referenced table into the dictionary as needed.  If an engine is rebooted which
    accesses a table with foreign keys, and lower_case_table_names=2, then the table with
    foreign keys will get an error when it is changed (insert/updated/delete).
    Once the referenced tables are loaded into the dictionary cache by a select statement
    on those tables, the same change would succeed because the affected code path would
    not get followed.
    08f128f6
innodb_bug60196.result 2.01 KB