@FixFor( "MODE-1737" )
@Test
public void shouldSupportSelectDistinct() throws RepositoryException {

    String sql = "SELECT DISTINCT cars.[car:maker], cars.[car:lengthInInches] FROM [car:Car] AS cars";
    Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
    QueryResult result = query.execute();
    String[] expectedColumns = {"car:maker", "car:lengthInInches"};
    validateQuery().rowCount(13).hasColumns(expectedColumns).validate(query, result);
}