add a test for limit and offset.