@SuppressWarnings( "deprecation" )
@FixFor( "MODE-934" )
@Test
public void shouldParseQueryWithJcrPathInJoinCriteriaOfJcrSqlQuery() throws RepositoryException {

    String sql = "select nt:base.jcr:primaryType, nt:base.jcr:path, car:Car.car:year "
                 + "FROM nt:base, car:Car WHERE car:Car.jcr:path = nt:base.jcr:path";
    Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.SQL);
    QueryResult result = query.execute();
    String[] columnNames = {"nt:base.jcr:primaryType", "nt:base.jcr:path", "car:Car.car:year", "jcr:path", "jcr:score"};
    validateQuery().rowCount(13).hasColumns(columnNames).validate(query, result);
}