--- tbl_opt_avg_row_length.result 2013-01-22 22:05:05.246633000 +0400 +++ tbl_opt_avg_row_length.reject 2013-01-23 02:50:58.123521742 +0400 @@ -5,12 +5,12 @@ t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=300 +) ENGINE= DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=300 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 AVG_ROW_LENGTH=30000000; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=30000000 +) ENGINE= DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=30000000 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) DROP TABLE t1;