Same column returned with multiple aliases in scalar query

Description

In the case of a relation "OneToMany" between two JPA entities, when we make a search on the parent entity, the generated SQL presents duplicated fields. Here is an example:

In more complicated cases, there can be more than two duplicated fields. Although the duplication of fields doesn't distort performance at a DB level.

Environment

Postgres 9.x

Assignee

Gail Badner

Reporter

Tom Ross

Fix versions

Labels

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure