ObjectDB ObjectDB

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?

edit
delete
#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
ObjectDB - Fast Object Database for Java (JPA/JDO)
edit
delete
#3

I'll send you a ticket with the DB.

Try this query:

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

Thanks.

Build 2.3.3_01 fixes this bug.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
edit
delete

Reply

To post on this website please sign in.