Comment 1 for bug 976778

There's one work-around here http://www.mysqlperformanceblog.com/2006/07/12/insert-into-select-performance-with-innodb-tables/ - you have to disable the binlog and enable the "dangerous for replication" queries. But with innodb and versioned rows, the replication shouldn't be an issue.