REST API limit / SQL parser buggy [moved]

[lvca]

This is Issue 159 moved from a Google Code project.
Added by 2010-11-28T20:00:44.000Z by rasmus.m...@gmail.com.
Please review that bug for more context and additional comments, but update this bug.
Closed (Fixed).

Original labels: Type-Defect, Priority-Medium, v0.9.24

Original description

The REST API allows you to query with a limit:

http://test:2480/query/demo/sql/SELECT * FROM Account/10

But how do you specify the offset, so as to implement result set paging?

I tried adding the SQL standard LIMIT keyword to the end of the query, rather than the "/10" - the query still executes, but no limit is applied.

It seems the SQL parser is a bit too forgiving about most syntax errors?