• kaa@mbp.local's avatar
    Fix for bug #25162: Backing up DB from 5.1 adds 'USING BTREE' to KEYs · 663453d5
    kaa@mbp.local authored
                        on table creates
    
    The problem was in incompatible syntax for key definition in CREATE
    TABLE.
    
    5.0 supports only the following syntax for key definition (see "CREATE
    TABLE syntax" in the manual):
    
    {INDEX|KEY} [index_name] [index_type] (index_col_name,...)
    
    While 5.1 parser supports the above syntax, the "preferred" syntax was
    changed to:
    
    {INDEX|KEY} [index_name] (index_col_name,...) [index_type]
    
    The above syntax is used in 5.1 for the SHOW CREATE TABLE output, which
    led to dumps generated by 5.1 being incompatible with 5.0.
    
    Fixed by changing the parser in 5.0 to support both 5.0 and 5.1 syntax
    for key definition.
    663453d5
create.result 90.8 KB