• unknown's avatar
    Fix for bug #25162: Backing up DB from 5.1 adds 'USING BTREE' to KEYs · 4d794c23
    unknown 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.
    
    
    mysql-test/r/create.result:
      Added a test case for bug #25162.
    mysql-test/t/create.test:
      Added a test case for bug #25162.
    sql/sql_yacc.yy:
      Changed the parser to support both 5.0 and 5.1 syntax for index type
      specification in CREATE TABLE.
    4d794c23
create.result 90.8 KB