--source include/have_innodb.inc --source include/have_debug.inc SET GLOBAL innodb_file_format='Barracuda'; SET GLOBAL innodb_file_per_table=1; CREATE TABLE `t` ( `a` INT NOT NULL, PRIMARY KEY (`a`) ) ENGINE=InnoDB ; SET DEBUG= 'd,crash_innodb_before_commit_inplace_alter'; --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect --error 2013 ALTER TABLE `t` ADD COLUMN `b` INT NOT NULL; --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect --enable_reconnect --source include/wait_until_connected_again.inc # See if the data dictionary has any temp tables present. SELECT name FROM information_schema.innodb_sys_tables WHERE name LIKE 'test/#sql%'; # The ALTER will fail because the temp table can't be created. ALTER TABLE `t` ADD COLUMN `b` INT NOT NULL; DROP TABLE `t`;