add omitted test cases for runSql/all method