Steps

• have an @Audited entity A with @Id Long id
• Use AuditEntity.property("id")
  • for example: AuditEntity.property("id").desc() to order the results

expected

• AuditEntity.property("id") should reference the A.id in the AUD table
  • thus, in the example, the audit query order should be over the ID column

observed

• AuditEntity.property("id") seems to reference the generated composite id of the AUD table's entity
  • thus, in the example, the audit query order is over ID, REVID desc
    results are ordered with the wrong order

apparent workaround

• whenever you're tempted to write AuditEntity.property("id"),
  use AuditEntity.property("originalId.id") instead. The "originalId" is not something documented, except for a @lukasz.antoniak's comment in HHH-8036