add the test case for affected_rows