[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_14550 ]
     
john john commented on NH-467:
------------------------------

http://shortlink.co.uk/gnv
http://shortlink.co.uk/gnw
http://shortlink.co.uk/gnx
http://shortlink.co.uk/gny
http://shortlink.co.uk/go0
http://shortlink.co.uk/go1
http://shortlink.co.uk/go2
http://shortlink.co.uk/go3
http://shortlink.co.uk/go4
http://shortlink.co.uk/go5
http://shortlink.co.uk/go6
http://shortlink.co.uk/go7
http://shortlink.co.uk/go8
http://shortlink.co.uk/go9
http://shortlink.co.uk/goa
http://shortlink.co.uk/gob
http://shortlink.co.uk/goc
http://shortlink.co.uk/god
http://shortlink.co.uk/goe
http://shortlink.co.uk/gof
http://shortlink.co.uk/gog
http://shortlink.co.uk/goh
http://shortlink.co.uk/goi
http://shortlink.co.uk/goj
http://shortlink.co.uk/gok
http://shortlink.co.uk/gol
http://shortlink.co.uk/gom
http://shortlink.co.uk/gon
http://shortlink.co.uk/goo
http://shortlink.co.uk/gop
http://shortlink.co.uk/goq
http://shortlink.co.uk/gor
http://shortlink.co.uk/gos
http://shortlink.co.uk/got
http://shortlink.co.uk/gou
http://shortlink.co.uk/gov
http://shortlink.co.uk/gow
http://shortlink.co.uk/gox
http://shortlink.co.uk/goy
http://shortlink.co.uk/gp0
http://shortlink.co.uk/gp1
http://shortlink.co.uk/gp2
http://shortlink.co.uk/gp3
http://shortlink.co.uk/gp5
http://shortlink.co.uk/gp6
http://shortlink.co.uk/gp7
http://shortlink.co.uk/gp8
http://shortlink.co.uk/gp9
http://shortlink.co.uk/gpa
http://shortlink.co.uk/gpb
http://shortlink.co.uk/gpc
http://shortlink.co.uk/gpd
http://shortlink.co.uk/gpe
http://shortlink.co.uk/gpf
http://shortlink.co.uk/gpg
http://shortlink.co.uk/gph
http://shortlink.co.uk/gpi
http://shortlink.co.uk/gpj
http://shortlink.co.uk/gpk
http://shortlink.co.uk/gpl
http://shortlink.co.uk/gpm
http://shortlink.co.uk/gpn
http://shortlink.co.uk/gpo
http://shortlink.co.uk/gpp
http://shortlink.co.uk/gpq
http://shortlink.co.uk/gpr
http://shortlink.co.uk/gps
http://shortlink.co.uk/gpt
http://shortlink.co.uk/gpu
http://shortlink.co.uk/gpw
http://shortlink.co.uk/gpx
http://shortlink.co.uk/gpy
http://shortlink.co.uk/gq0
http://shortlink.co.uk/gq1
http://shortlink.co.uk/gq2
http://shortlink.co.uk/gq3
http://shortlink.co.uk/gq4
http://shortlink.co.uk/gq5
http://shortlink.co.uk/gq6
http://shortlink.co.uk/gq7
http://shortlink.co.uk/gq8
http://shortlink.co.uk/gq9
http://shortlink.co.uk/gqa
http://shortlink.co.uk/gqb
http://shortlink.co.uk/gqc
http://shortlink.co.uk/gqd
http://shortlink.co.uk/gqe
http://shortlink.co.uk/gqf
http://shortlink.co.uk/gqg
http://shortlink.co.uk/gqh
http://shortlink.co.uk/gqi
http://shortlink.co.uk/gqj
http://shortlink.co.uk/gqk
http://shortlink.co.uk/gql
http://shortlink.co.uk/gqm
http://shortlink.co.uk/gqn
http://shortlink.co.uk/gqo
http://shortlink.co.uk/gqp
http://shortlink.co.uk/gqq
http://shortlink.co.uk/gqrs

> 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