Offset without limit returns all results

This is actually a problem in Views.

It may also not be fixable -- the reason this is true is that if there is a 'num posts' setting that's not 0, and the pager isn't on, it uses db_query_range() but if it num posts is 0, it just uses db_query(). I'm not sure whether or not db_query_range can be used if I have an offset and want all posts. I'll have to check.

Voting for this, as I just spent a good hour or 2 trying to figure out why the hell offset didn't work. Offset is broken if the results are not limited, which makes sense...to a point.

Unfortunately, offset only works when there is a range of some kind; to use offset, there must also be a limit.

I believe it should be put into the documentation or function comment that if you want offset to work, a specific amount should be returned. (aka, not 0, e.g., 9999999) I hope this has already been done in the dev versions or 6.x versions.

This is not fixable in Views 1.