@Test
public void shouldBeAbleToCreateAndExecuteJcrSql2QueryToFindAllNodesWithOrderByPath() throws RepositoryException {

    String sql = "SELECT * FROM [nt:base] ORDER BY [jcr:path]";
    Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
    QueryResult result = query.execute();
    String[] columnNames = allColumnNames("nt:base");
    validateQuery().rowCount(totalNodeCount).noWarnings().hasColumns(columnNames).validate(query, result);
}