@FixFor( "MODE-1309" )
@Test
public void shouldBeAbleToCreateAndExecuteJcrSql2QuerySelectingResidualProperty() throws RepositoryException {

    String sql = "SELECT a.propB FROM [nt:unstructured] AS a WHERE a.propB = 'value1'";
    Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
    QueryResult result = query.execute();
    validateQuery().rowCount(2).hasColumns("propB").onEachRow(new Predicate() {
        @Override
        public void validate( int rowNumber,
                              Row row ) throws RepositoryException {
            // All the rows are identical ...
            assertThat(row.getValue("propB").getString(), is("value1"));
        }
    }).validate(query, result);
}