Hello,
why is CUBA’s decorated entity manager unable to parse:
SELECT a FROM ns$A a LEFT JOIN ns$B b ON b.a = a AND b.createdAt = :at WHERE b.id IS NULL AND a.createdAt < :to
Saying Number of children more than 2 [Join variable: b] when undecorated EclipseLink entity manager is happy to parse it?
Thx,
Thank you for reporting the issue.
It may happen because CUBA has its own JPQL parser and transformer that comes into play before passing the query to EclipseLink. I’m afraid parameters in JOIN clause are not supported at the moment, but we’ll try to fix it - see the linked issue.
Thank you Konstantin!
Hi,
The issue is fixed in the platform version 6.6.0.
See the following issue in our bug tracker: