MySQL doesn't allow fulltext indexes except for MyISAM tables, or when using MySQL 5.6 or later. So, this test should likely create a separate MyISAM table to test this on pre-5.6 MySQL versions. Maybe CREATE TEMP TABLE (...) ENGINE myisam; will work?