[nhibernate-issues] [JIRA] Commented: (NH-467) Many-to-one ignores "WHERE" class mapping element on associated Class

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-467?page=comments#action_14802 ]
     
john book commented on NH-467:
------------------------------

http://durl.us/1eb7
http://durl.us/1eb8
http://durl.us/1eb9
http://durl.us/1eba
http://durl.us/1ebb
http://durl.us/1ebc
http://durl.us/1ebd
http://durl.us/1ebe
http://durl.us/1ebf
http://durl.us/1ec0
http://durl.us/1ec1
http://durl.us/1ec2
http://durl.us/1ec3
http://durl.us/1ec4
http://durl.us/1ec5
http://durl.us/1ec6
http://durl.us/1ec7
http://durl.us/1ec8
http://durl.us/1ec9
http://durl.us/1eca
http://durl.us/1ecb
http://durl.us/1ecc
http://durl.us/1ecd
http://durl.us/1ece
http://durl.us/1ecf
http://durl.us/1ed0
http://durl.us/1ed1
http://durl.us/1ed2
http://durl.us/1ed3
http://durl.us/1ed4
http://durl.us/1ed5
http://durl.us/1ed6
http://durl.us/1ed7
http://durl.us/1ed8
http://durl.us/1ed9
http://durl.us/1eda
http://durl.us/1edb
http://durl.us/1edc
http://durl.us/1edd
http://durl.us/1ede
http://durl.us/1edf
http://durl.us/1ee0
http://durl.us/1ee1
http://durl.us/1ee2
http://durl.us/1ee3
http://durl.us/1ee4
http://durl.us/1ee5
http://durl.us/1ee6
http://durl.us/1ee7
http://durl.us/1ee8
http://durl.us/1ee9
http://durl.us/1eea
http://durl.us/1eeb
http://durl.us/1eec
http://durl.us/1eed
http://durl.us/1eee
http://durl.us/1eef
http://durl.us/1ef0
http://durl.us/1ef1
http://durl.us/1ef2
http://durl.us/1ef3
http://durl.us/1ef4
http://durl.us/1ef5
http://durl.us/1ef6
http://durl.us/1ef7
http://durl.us/1ef8
http://durl.us/1ef9
http://durl.us/1efa
http://durl.us/1efb
http://durl.us/1efc
http://durl.us/1efd
http://durl.us/1efe
http://durl.us/1eff
http://durl.us/1f00
http://durl.us/1f01
http://durl.us/1f02
http://durl.us/1f03
http://durl.us/1f04
http://durl.us/1f05
http://durl.us/1f06
http://durl.us/1f07
http://durl.us/1f08
http://durl.us/1f09
http://durl.us/1f0a
http://durl.us/1f0b
http://durl.us/1f0c
http://durl.us/1f0d
http://durl.us/1f0e

> Many-to-one ignores "WHERE" class mapping element on associated Class
> ---------------------------------------------------------------------
>
>          Key: NH-467
>          URL: http://jira.nhibernate.org/browse/NH-467
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.0
>     Reporter: Alexei
>      Fix For: 1.2.0.Alpha1

>
> For example a Employee->User association
> Class Employee:
> <class name="Employee, MyApp" table="Employee" where="inactive=0" >
> ...
> <many-to-one name="User" class="User, MyApp"  
> column="UserId" unique="true" not-null="false" >
> Class User:
> <class name="User, MyApp" table="Users" where="inactive=0" >
> Will generate SQL:
> SELECT... FROM Employee this LEFT OUTER JOIN Users user1_ ON this.UserId=user1_.id WHERE this.inactive=0
> The User objects will be retrived ignoring the "inactive" flag on Users table. Similar behaviour with <bag>, <one-to-one> and others.

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