I am using hibernate 3.2.6. with mssqlserver 2005 and maxdb 7.6. Using Criteria api.

Some queries using left outer joins return different data in both, after investigating, it turns out upper(column1)='hello' is true in maxdb when column1 is NULL (due to the outer join). The problem also happens with lower() and probably other functions.

I dont know if you guys are aware of this and decided the hibernate user has to take it into account. If that is the case, then dismiss this post.

In case hibernate would want to take care of it on its own, it would need to add a condition column1<>NULL. I have done this with the criteria api and it solves the issue.

thanks
javi

Where you able to find a solution?