Tested with PS 5.5
Also, the test case linked in http://bugs.mysql.com/bug.php?id=33650 is http://lists.mysql.com/commits/136982 . It also passes.
CREATE TABLE `t1` ( `a` int(11) NOT NULL AUTO_INCREMENT, `b` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`a`) ) ENGINE=InnoDB AUTO_INCREMENT=31746 DEFAULT CHARSET=utf8
is the table used. (~ 10M).
To further confirm I enabled tracing with mysqld-debug --debug and checked with fast index creation OFF / ON, and checked copy_data_between_tables with OFF and without copy_data_between_tables when ON.
Tested with PS 5.5
Also, the test case linked in http:// bugs.mysql. com/bug. php?id= 33650 is http:// lists.mysql. com/commits/ 136982 . It also passes.
CREATE TABLE `t1` ( 31746 DEFAULT CHARSET=utf8
`a` int(11) NOT NULL AUTO_INCREMENT,
`b` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`a`)
) ENGINE=InnoDB AUTO_INCREMENT=
is the table used. (~ 10M).
To further confirm I enabled tracing with mysqld-debug --debug and checked with between_ tables with OFF and between_ tables when ON.
fast index creation OFF / ON, and checked copy_data_
without copy_data_