add test for ASYNC auto commit execution strategy