Skip to content

Projection and join fetch in hql leads to duplicated column aliases #2092

Closed
@bahusoid

Description

@bahusoid
var results =  session
.CreateQuery("select o.Employee.FirstName, o from Order o join fetch o.Customer")
.SetMaxResults(1)
.UniqueResult<object[]>();

The query above leads to duplicated column aliases for fetched Customer ID:

SELECT employee2_.FirstName AS col_0_0_
	,order0_.OrderId AS col_1_0_
	,customer1_.CustomerId AS customerid1_0_1_ -- <-HERE
	,order0_.OrderId AS orderid1_3_0_
	,customer1_.CustomerId AS customerid1_0_1_ -- <-AND HERE
...

And that doesn't work on Oracle (for queries with paging) and SQL Server CE, SQL Anywhere.

Related issue:
https://nhibernate.jira.com/browse/NH-1773

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions