When using ValidityAuditStrategy, SETORDINAL should be removed from the query to find old revisions otherwise the revend is not correctly updated in some situations. The SETORDINAL is only relevant for keeping primary keys unique.