Issue with upper?

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

The two queries look exactly the same.

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

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