> 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.
James Day, MySQL Senior Support Engineer, Sun Microsystems, England