@Test
public void shouldBeAbleToQueryWithOffsetOnNonJoin() throws RepositoryException {

    // Try with the OFFSET expression ...
    String sql = "SELECT [jcr:path] FROM [car:Car] OFFSET 2";
    Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
    QueryResult result = query.execute();
    validateQuery().rowCount(11).hasColumns("jcr:path").validate(query, result);
    // Try with the method ...
    sql = "SELECT [jcr:path] FROM [car:Car]";
    query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
    query.setOffset(2);
    result = query.execute();
    validateQuery().rowCount(11).hasColumns("jcr:path").validate(query, result);
}