3.2

Hi!

Can someone tell me what's wrong with the following HQL query?

from Movie m join fetch m.user where m.isActive = 1
and m.id > (select max(id) - ? from movies as rslt)
and m.id < rslt + ? order by m.id desc

Thanks!

Hi,
Here is a guess.

(select max(id) - ? from movies as rslt)
i) lets us use rslt as an alias for table movies and not to capture the result of the query.
ii) It's scope is restricted to subquery.

So, when it is used later,
m.id < rslt + ?
rslt is expected to hold a result but is not available.

Correct me if I am wrong.

-----------------------------------------
Rate the reply if you find it helpful