[nhibernate-issues] [NHJIRA] Created: (NH-2786) Using multiple QueryOver expressions on a polymorphic entity cause duplicate join aliases

[Andy (JIRA) <nh...@gm...>]

Using multiple QueryOver expressions on a polymorphic entity cause duplicate join aliases
-----------------------------------------------------------------------------------------

                 Key: NH-2786
                 URL: http://216.121.112.228/browse/NH-2786
             Project:  NHibernate
          Issue Type: Bug
          Components: QueryOver
    Affects Versions: 3.1.0
            Reporter: Andy
            Priority: Major


This may due to my misunderstanding of the way the QueryOver provider works but I am experiencing the following problem.

I am using the Table-per-subclass strategy.

I have an abstract entity which is subclassed by 2 other entities.  The abstract entity contains a nested property (PropA) which is referenced by both entities but within their own respective database table.  In an ideal world this property would be contained within the abstract entity table, however, this is a legacy database and I don't have that option!

When I query from an entity onto the abstract entity and then query onto the PropA entity, I am getting a SQL error due to a duplicate join alias being generated for the table referenced by PropA.

I have attached a unit test to show this behaviour.  Hopefully it is not something I am doing wrong!

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira