While Envers highlights this problem with how some of its queried are rendered, this can be observed directly in ORM because the ANTLR parser does not even like this query:

SELECT e1.id FROM by.MyEntity e1, by.MyEntity e2 WHERE e2.id = e1.id