added tests to make sure autocommit works