221 words

Issue #262 - DISTINCT key causing internal exception on 2.6.4.b10

BugVersion: 2.6.4Priority: NormalStatus: FixedReplies: 4
#1
2015-12-17 14:45

I observed that on new ObjectDb v.2.6.4.b10 query below causes internal exception

SELECT DISTINCT $1 FROM Pa3DictionaryItem $2 JOIN $2.values $1 WHERE ($2.namespace == 'com.anritsu.pa3.ttcn3' AND $2.key == 'TliEvent' AND $1 != '')

Query above also worked fine on ObjectDb version 2.6.1.b06

Symphony Teleca (Harman)
Teleca
Teleca's picture
Joined on 2013-12-09
User Post #3
#2
2015-12-18 13:14

More details are needed.

First, the query in your post is invalid since a closing " is missing at the end of the query. Please check the query.

Second, if there is an internal exception at the minimum the stack trace of that internal exception and the full error message should be posted.

Finally, if you can follow these posting instructions and provide a simple test case that demonstrates the issue it could be very helpful.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #2,363
#3
2015-12-21 15:36

First, query is valid since it's worked on prev ObjectDb releases, the problems not in '', just remove DISTINCT and you will see no problems with this query

Second, I have attached

a) Screenshot for used ObjectDb version

b) Original database for reproduce this issue from your side. Have a nice playing 8-)

Symphony Teleca (Harman)
Teleca
Teleca's picture
Joined on 2013-12-09
User Post #5
#4
2015-12-22 13:39

Thank you very much for this report, and sorry for questioning the validity of your query (the '' suffix looked like a single double quote character " with no closing).

This regression was caused by an incomplete repair of another issue in build 2.6.4_09.

Version 2.6.5 should work well.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #2,368
#5
2015-12-22 14:27

Confirming, fixed in 2.6.5 release! Bug may be closed.

Symphony Teleca (Harman)
Teleca
Teleca's picture
Joined on 2013-12-09
User Post #7

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