Add Unit test cases for autocommit off mode

both three cases will fail now.