Wrong select results

#1

Hello, I got a realy strange SELECT problem. In explorer query "select p  from Player p where p.confirmed==false", given me some results with p.confirmed==TRUE. And when I try to do (see image) "select p, p.confirmed  from Player p where p.confirmed==false", I getting p->confirmed->true and p.confirmed->false. How so?

<odb v2.6.5_05>

And this problem not only in explorer

#2

It seems when I transfered this file from server to my pc problem disappeared. If desapeard after odb server restart. Is this some caching problem?

#3

<database>
  <size initial="1024kb" resize="1024kb" page="64kb" />
  <recovery enabled="true" sync="false" path="." max="128mb" />
  <recording enabled="false" sync="false" path="." mode="write" />
  <locking version-check="true" />
  <processing cache="1024mb" max-threads="8" />
  <query-cache results="1024mb" programs="500" />
  <extensions drop="temp,tmp" />
</database>

#4

We have the database that you uploaded in the support ticket, but according to your update at #2 above it seems that we will not be able to use it to reproduce the issue. Please try to find a simple scenario for reproducing the problem. 

ObjectDB Support

Reply