NH-2208 - Error with filters on joined-subclass as many-to-one

[nhibernate-bot]

felice Pollano created an issue — 24th May 2010, 8:34:39:

Using filters on entities, when those entities belong to a
hierarchy, and we query for another entity having many-to-one
association to the "filtered" entity, we obtain the following error:

----> System.Data.SqlClient.SqlException : The multi-part identifier
"subofrefer1_1_.P1 does not exist" 

Attached there is a unit test to dempostrate the issue. The test requires a Database named FILTERS on a local MSSQL(Express) instance. One of the test creates the DB schema required, the other show the exception.

---

Fabio Maulo added a comment — 27th July 2010, 13:19:34:

Decoded failing test committed on trunk

[bahusoid]

Looks very similar to #1209