Home » Support » Forum » Issue with upper?

Issue with upper?

#1

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

#2

The two queries look exactly the same.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
#3

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

#4

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

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

Post Reply

To post a reply and/or subscribe to update notifications - please login