• unknown's avatar
    Apply innodb-5.1-ss2146 and innodb-5.1-ss2178 snapshots. · d39f2048
    unknown authored
    Fixes:
    
    Bug #18942: DROP DATABASE does not drop an orphan FOREIGN KEY constraint
      Fix Bug#18942 by dropping all foreign key constraints at the end of
      DROP DATABASE. Usually, by then, there are no foreign constraints
      left because all of them are dropped when the relevant tables are
      dropped. This code is to ensure that any orphaned FKs are wiped too.
    
    Bug #29157: UPDATE, changed rows incorrect
      Return HA_ERR_RECORD_IS_THE_SAME from ha_innobase::update_row() if no
      columns were updated.
    
    Bug #32440: InnoDB free space info does not appear in SHOW TABLE STATUS or I_S
      Put information about the free space in a tablespace in
      INFORMATION_SCHEMA.TABLES.DATA_FREE. This information was previously
      available in INFORMATION_SCHEMA.TABLES.TABLE_COMMENT, but MySQL has
      removed it from there recently.
      The stored value is in kilobytes.
      This can be considered as a permanent workaround to
      http://bugs.mysql.com/32440. "Workaround" becasue that bug is about the
      data missing from TABLE_COMMENT and this is actually not solved.
    
    
    mysql-test/r/innodb.result:
      New tests for bugs fixed as part of snapshots innodb-5.1-ss2146 and innodb-5.1-ss2178
    mysql-test/r/partition_innodb.result:
      Update results - InnoDB now sets Data_length (show table status)
    mysql-test/t/innodb.test:
      New tests for bugs fixed as part of snapshots innodb-5.1-ss2146 and innodb-5.1-ss2178
    mysql-test/t/partition_innodb.test:
      Mask out Data_Free in show table status, because it varies depending on
      which tests have been run.
    storage/innobase/handler/ha_innodb.cc:
      Apply innodb-5.1-ss2146 and innodb-5.1-ss2178 snapshots.
      
      
      Revision r2178:
      branches/5.1:
      
      Merge r2177 from trunk/:
      
      Fix Bug#29157 "UPDATE, changed rows incorrect":
      
      Return HA_ERR_RECORD_IS_THE_SAME from ha_innobase::update_row() if no
      columns were updated.
      
      
      Revision r2169:
      branches/5.1:
      
      Bug#32440:
      
      Put information about the free space in a tablespace in
      INFORMATION_SCHEMA.TABLES.DATA_FREE. This information was previously
      available in INFORMATION_SCHEMA.TABLES.TABLE_COMMENT, but MySQL has
      removed it from there recently.
      
      The stored value is in kilobytes.
      
      This can be considered as a permanent workaround to
      http://bugs.mysql.com/32440. "Workaround" becasue that bug is about the
      data missing from TABLE_COMMENT and this is actually not solved.
    storage/innobase/row/row0mysql.c:
      Apply innodb-5.1-ss2146 and innodb-5.1-ss2178 snapshots.
      
      
      Revision r2161:
      branches/5.1:
      
      Merge r2160 from trunk/:
      
      Fix Bug#18942 by dropping all foreign key constraints at the end of
      DROP DATABASE. Usually, by then, there are no foreign constraints
      left because all of them are dropped when the relevant tables are
      dropped. This code is to ensure that any orphaned FKs are wiped too.
    storage/innobase/trx/trx0trx.c:
      Apply innodb-5.1-ss2146 and innodb-5.1-ss2178 snapshots.
    d39f2048
innodb.test 70.5 KB