Invalid query when ORDER BY with DISTINCT

[Ryszard-Trojnacki]

When I create Qurey with "order by" for example:

@Test
public void orderByWithoutLimit() {
db.createQuery(QueueJob.class).setDistinct(true).orderBy(QueueJob.USER+"."+User.USERNAME).findList();
}

which gives SQL Query something like this:
select distinct t0.id as c0, t0.file_id as c1, t0.file_name as c2, t0.driver_id as c3, t0.file_hash as c4, t0.user_id as c5, t0.job_id as c6 from queue_jobs t0 left outer join users t1 on t1.id = t0.user_id order by t1.username
limit 11
I got error from database (PosgreSQL, H2, Microsoft SQL Server; there is no error in mySQL) that "order by" property must be in select list:

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

I think that in such cases the order by field should be added to select columns list.

[rbygrave]

Thanks. I'll ponder this for a little while (busy getting version 4 out) and then have another look.

[rbygrave]

Fixed in 4.0.1