• vasil's avatar
    branches/zip: · f66c5e5d
    vasil authored
    Disable part of innodb-index test because MySQL changed its behavior and
    is not calling ::add_index() anymore in the following ALTER TABLE:
    
    CREATE TABLE t (a INT) ENGINE=INNODB;
    INSERT INTO t VALUES (NULL);
    ALTER TABLE t ADD PRIMARY KEY (a);  -- adding primary index on non-NULL column
    
    Previously, in ALTER TABLE, MySQL would call ::add_index() which would
    fail with a "primary key cannot contain NULL" error.
    
    The change occured in:
    
      mysql-5.1$ bzr log -v -r2667
      ------------------------------------------------------------
      revno: 2667
      committer: Davi Arnaut <davi@mysql.com>
      branch nick: 33873-5.1
      timestamp: Tue 2008-06-17 11:12:21 -0300
      message:
        Bug#33873: Fast ALTER TABLE doesn't work with multibyte character sets
        
        The problem was that when comparing tables for a possible
        fast alter table, the comparison was being performed using
        the parsed information and not the final definition.
              
        The solution is to use the possible final table layout to
        compare if a fast alter is possible or not.
      modified:
        mysql-test/include/mix1.inc
        mysql-test/r/alter_table.result
        mysql-test/r/innodb_mysql.result
        mysql-test/t/alter_table.test
        sql/sql_table.cc
      mysql-5.1$
    f66c5e5d
innodb-index.result 26.5 KB