Hi guys,

I've got a class mapping with a where clause in it like the follwing:



As I understand it any query, get or load should append "Deleted = 0" to the end of any SQL statements generated...strangely this is not happening. I've got the log output set to debug and it's showing the SQL statement that will be executed as <i>not</i> having the additional clause.

Is this a bug, or have I misunderstood how this works?

Symon.

OK, after further testing I find that the where clause <i>is</i> being honored, but only on HQL queries - using the Get or Load methods of the session will not honour the where clause.

Again, is this by design or a bug?

Cheers,

Symon

Judging from code, it appears Hibernate 2.1 does this too, so I would say it's by design. But I can't tell myself whether it's right or not.