sorting accross entity associations filter null values because of unexpected cross joins

Description

Given following entities:

When I try to retrieve all user and sort by room name, I get only users which have chair and room, but users without chair and room are not retrieved:

The following sql output printed, which contains unexpected cross join filtering null values:

Environment

h2, mariadb

Status

Assignee

Unassigned

Reporter

Sviataslau Apanasionak

Fix versions

None

Labels

backPortable

Backport?

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure