94 words

Issue with upper?

#1
2012-01-17 01:37

Hi,

Query 1:

SELECT DISTINCT $1, $2.lastName AS $O0
FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1
     LEFT JOIN $1.profile $2
ORDER BY UPPER($2.lastName)

Correctly returns all the different lastName's for each $1

Now the same but with upper

SELECT DISTINCT $1, UPPER($2.lastName) AS $O0
FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1
     LEFT JOIN $1.profile $2
ORDER BY UPPER($2.lastName)

This suddenly returns always the same lastName for every result which is the entry of the last available $1 in the table???

Alex

quasado
quasado's picture
Joined on 2011-04-30
User Post #77
#2
2012-01-17 05:48

The two queries look exactly the same.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #860
#3
2012-01-17 06:01

Sorry -- copy'n'paste ;) corrected my original posting

quasado
quasado's picture
Joined on 2011-04-30
User Post #79
#4
2012-01-17 09:40

Build 2.3.6_07 fixes this issue. Thank you for your report.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #864

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