Most of our tests use an in-memory DB, but I don't think it has all MySQL semantics.