Remove new tests and change old tests

Some SQL Databases don't allow offset without limit, so don't use offset
without limit in the tests