@FixFor( "MODE-1145" )
@Test
public void shouldParseQueryWithResidualPropertyInSelectAndCriteria() throws Exception {

    String sql = "SELECT [jcr:path], something FROM [nt:unstructured] AS u WHERE something LIKE 'value%'";
    Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
    assertThat(query, is(notNullValue()));
    QueryResult result = query.execute();
    validateQuery().rowCount(2).hasColumns("jcr:path", "something").onEachRow(new Predicate() {
        @Override
        public void validate( int rowNumber,
                              Row row ) throws RepositoryException {
            assertThat(row.getNode().hasProperty("something"), is(true));
        }
    }).validate(query, result);
}