added tests for autocommit