Hi All!

To speed up queries, I use a subselect in conjunction with an INNER JOIN, something like this:

"SELECT OBJECT(o) FROM Userfood o
 WHERE o.id NOT IN
 (SELECT uf.id FROM IngredientAllergen ia INNER JOIN ia.userfoods uf
 WHERE ia = :ingAll)"

This worked perfectly well under JBoss 4.0.4 GA, but when I switch to JBoss 4.0.5 GA, it doesn't even send the query to the database and I don't get any error message.

Sorry if this issue has been handlled before, but I didn't find any references.

Thanks for any help,
Andreas