The testWithClause from WithClauseTest class fails on PostgreSQL

Description

While this test runs just fine on H2, on PostgreSQL, it fails with the following error message:

The query in question looks like this:

It could be because the human2_2_ alias is referenced in a JOIN ON clause before it's being declared in an INNER JOIN as an alias.

Environment

None

Assignee

Christian Beikov

Reporter

Vlad Mihalcea

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

Priority

Major
Configure