nhibernate/nhibernate-core — pull request #118 by rbirkby (2012-05-30 11:01:11+00:00)
Title: Testcase for NH3171 - Missing join in sql when restricting by composite ...

...column in criteria query

https://nhibernate.jira.com/browse/NH-3171

With a simple Criteria query such as:

s.CreateCriteria("a")
.CreateAlias("a.Song", "s")
.Add(Restrictions.Eq("s.Name", "Miss Kiss Kiss Bang"))

NHibernate fails to include the join to Song in the SQL query when Song is a composite column.