Ann, Kevin,
> Currently for both Falcon and InnoDB, a repeatable read
> transaction's isolation is broken if a destructive alter table,
> drop table, or truncate is executed by a concurrent transaction.
Please see this bug and it's related worklog to see whether the work planned
to fix it resolves the problem. If it does, please let Omer know.
http://bugs.mysql.com/bug.php?id=989
https://intranet.mysql.com/worklog/Server-BackLog/?tid=4284
James Day, MySQL Senior Support Engineer, Sun Microsystems, England