• Satya B's avatar
    Fix for BUG#21360 - mysqldump error on federated tables · cad09dab
    Satya B authored
                            
    When loading dump created by mysqldump tool an error is
    thrown saying storage engine for the table doesn't have 
    an option.
                            
    mysqldump tries to re-insert the data into the federated
    table which causes the error. Since the data is already
    available on the remote server, mysqldump shouldn't try
    to dump the data again for FEDERATED tables.
                            
    As stated in the bug page, it can be considered similar
    to the MERGE ENGINE with "view only" nature.
                            
    Fixed by adding the "FEDERATED ENGINE" to the exception
    list to ignore the data.
    
    client/mysqldump.c:
      Fixed check_if_ignore_table() to ignore FEDERATED engine
      when dumping the table data.
    mysql-test/r/federated.result:
      Result file for BUG#21360
    mysql-test/t/federated.test:
      Testcase for BUG#21360
    cad09dab
federated.test 77.1 KB