Limit optimization leads to problematic join condition for composite PKs

[beikov]

The fix for https://github.com/Blazebit/blaze-persistence/issues/1810 causes some issues when trying to limit something that has a composite primary key, because the generated query looks like join CompositePkEntity e on e = (limit((select e2.pk1, e2.pk2 from CompositePkEntity e2 ...),1)) which Hibernate complains about.

[haraleib]

Hello @beikov, Is there any progress going on on this bug ?

[beikov]

Hi @haraleib, no, I'm not currently working on this. Is it critical for you? If so, what version of Hibernate ORM are you using?

[haraleib]

As we want to move to an official BlazePersistence Version, this bug is the last regression we have so far to do so.

[beikov]

Ok, but what version of Hibernate ORM are you using?

[haraleib]

5.4.4.Final