• Arun Kuruvila's avatar
    Bug #12671631 CREATE TABLE .. LIKE .. FEDERATED TABLE · 08526dfb
    Arun Kuruvila authored
                  CRASHES WITH AUTO_INCREMENT COLUMN
    
    Description:- Creating a federated table with AUTO_INCREMENT
    column using LIKE clause results in a server crash.
    
    Analysis:- Creating a federated table with AUTO_INCREMENT
    column using LIKE clause results in a federated server
    crash due to the uninitialized connection structure(mysql).
    Also due to unassigned connection string for the remote
    server, at the time of preparation of "create_info"
    structure, the creation of any federated table using LIKE
    clause fails with an error, "ERROR 1 (HY000): server name:
    '' doesn't exist!". This  bug is not only with
    AUTO_INCREMENT but in all creations of federated tables with
    LIKE clause.
    
    Fix :- In ha_federated::info(), "mysql->insert_id" assigned
    to "stats.auto_increment_value" only when there is an
    active connection. This fixes the crash issue. For creating
    the federated table with LIKE clause, connection string is
    assigned at the time of preparation of "create_info"
    structure.
    08526dfb
sql_table.cc 243 KB