ObjectDB ObjectDB

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

edit
delete
#2

The two queries look exactly the same.

ObjectDB Support
edit
delete
#3

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

edit
delete
#4

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

ObjectDB Support
edit
delete

Reply

To post on this website please sign in.