155 words

Wrong select results

#1
2016-11-17 09:51

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

mastervoland
mastervoland's picture
Joined on 2014-01-25
User Post #15
#2
2016-11-17 09:52

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?

mastervoland
mastervoland's picture
Joined on 2014-01-25
User Post #16
#3
2016-11-17 10:36

<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>

mastervoland
mastervoland's picture
Joined on 2014-01-25
User Post #18
#4
2016-11-17 12:09

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
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #2,646

Post Reply

Please read carefully the posting instructions - before posting to the ObjectDB website.

  • You may have to disable pop up blocking in order to use the toolbar (e.g. in Chrome).
  • Use ctrl + right click to open the browser context menu in the editing area (e.g. for using a browser spell checker).
  • To insert formatted lines (e.g. Java code, stack trace) - select a style in the toolbar and then insert the text in the new created block.
  • Avoid overflow of published source code examples by breaking long lines.
  • You may mark in paragraph code words (e.g. class names) with the code style (can be applied by ctrl + D).
  • Long stack traces (> 50 lines) and complex source examples (> 100 lines) should be posted as attachments.
Attachments:
Maximum file size: 32 MB
Cancel