fix tests, handle transactional difference between postresql and mysql