Closed
Description
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