mysql 5.x hangs in copy to tmp table

This happens with nested queries.

It is a known bug in version 5. It looks like it is going to be fixed with 6.0 release.

However, here are some reasons:
-Tables are over indexed: reduce the number of indexes solved the problem with some cases