@Test
@FixFor( "MODE-2247" )
public void shouldBeAbleToExecuteExceptOperationWithSimpleCriteria() throws Exception {

    String sql1 = "SELECT car1.[jcr:path] FROM [car:Car] AS car1 WHERE car1.[jcr:name] LIKE '%Land Rover%'";
    String sql2 = "SELECT car2.[jcr:path] FROM [car:Car] AS car2 WHERE car2.[jcr:name] LIKE '%LR3%'";
    String queryString = sql1 + " EXCEPT " + sql2;
    Query query = session.getWorkspace().getQueryManager().createQuery(queryString, Query.JCR_SQL2);
    QueryResult result = query.execute();
    validateQuery().rowCount(1).hasColumns("jcr:path").hasNodesAtPaths("/Cars/Utility/Land Rover LR2")
                   .validate(query, result);
}