@SuppressWarnings( "deprecation" )
@Test
public void shouldBeAbleToCreateAndExecuteSqlQueryWithOrderByPathClause() throws RepositoryException {

    String sql = "SELECT car:model FROM car:Car WHERE car:model IS NOT NULL ORDER BY PATH() ASC";
    Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.SQL);
    QueryResult result = query.execute();
    validateQuery().rowCount(13).hasColumns("jcr:path", "jcr:score", "car:model").validate(query, result);
}