HQL query delivers different results then a plain SQL query

Description

Hello,

I have following table with test data:

id, created_date, created_by, updated_date, updated_by, workstation_state, permanent_login_id, user_id, workstation_id
'3773', '2019-07-01 16:21:58', 'test', '2019-07-01 16:21:59', 'test', 'OFF', '19', '14', '26'
'3774', '2019-07-01 16:22:22', 'test', '2019-07-01 16:22:23', 'test', 'ON', '19', '14', '26'

When I execute this HQL query
select lw from LoggedInWorkstation lw where lw.user.id=14 group by lw.workstation.id order by lw.workstation.id desc
I got this:
'3773', '2019-07-01 16:21:58', 'test', '2019-07-01 16:21:59', 'test', 'OFF', '19', '14', '26' ......

but I'm expecting this
'3774', '2019-07-01 16:22:22', 'test', '2019-07-01 16:22:23', 'test', 'ON', '19', '14', '26' ........

when I execute a plain sql query inside a mysql console
SELECT * FROM logged_in_workstation as lw WHERE lw.user_id=14 GROUP BY lw.workstation_id ORDER BY lw.workstation_id DESC
I got the expected result.

Why is it different when I'm using hibernate (HQL)?

Environment

None

Status

Assignee

Unassigned

Reporter

AB

Fix versions

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Priority

Major
Configure