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

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

     [ http://216.121.112.228/browse/NH-2786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andy updated NH-2786:
---------------------

    Attachment: NHibernate.Test.zip

Sorry for the entity names!

> 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
>         Attachments: NHibernate.Test.zip
>
>
> 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