NOT NULL not working

#1

I added a OneToOne Realtionship to one of my entity classes. To  give this field a value in my existing datasets i wrote an upgrade method. The cool thing is that

SELECT u FROM Unit u WHERE u.lastPosition IS NOT NULL

returns no datasets.

Is this a bug or am i missing something?

#2

Are you using the last build?

Can you provide a test database that demonstrates it (even with no code - given a test database the query can be checked in the Explorer)?

ObjectDB Support
#3

I'll send you a ticket with the DB.

Try this query:

 SELECT FROM Unit u where u.lastPosition IS NULL
#4

Thanks.

Build 2.3.3_01 fixes this bug.

ObjectDB Support

Reply