MySQL: Foreign Keys between InnoDB and MyISAM

Accidentally putting a foreign key between an InnoDB table and a MyISAM table results in an error "Cannot add or update a child row: a foreign key constraint fails"