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

<a href="http://andorra.indymedia.org/news/2006/12/4932.php">http://andorra.indymedia.org/news/2006/12/4932.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4933.php">http://andorra.indymedia.org/news/2006/12/4933.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4934.php">http://andorra.indymedia.org/news/2006/12/4934.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4935.php">http://andorra.indymedia.org/news/2006/12/4935.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4936.php">http://andorra.indymedia.org/news/2006/12/4936.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4937.php">http://andorra.indymedia.org/news/2006/12/4937.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4939.php">http://andorra.indymedia.org/news/2006/12/4939.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4940.php">http://andorra.indymedia.org/news/2006/12/4940.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4941.php">http://andorra.indymedia.org/news/2006/12/4941.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4942.php">http://andorra.indymedia.org/news/2006/12/4942.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4943.php">http://andorra.indymedia.org/news/2006/12/4943.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4944.php">http://andorra.indymedia.org/news/2006/12/4944.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4945.php">http://andorra.indymedia.org/news/2006/12/4945.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4946.php">http://andorra.indymedia.org/news/2006/12/4946.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4947.php">http://andorra.indymedia.org/news/2006/12/4947.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4948.php">http://andorra.indymedia.org/news/2006/12/4948.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4950.php">http://andorra.indymedia.org/news/2006/12/4950.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4952.php">http://andorra.indymedia.org/news/2006/12/4952.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4953.php">http://andorra.indymedia.org/news/2006/12/4953.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4954.php">http://andorra.indymedia.org/news/2006/12/4954.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4955.php">http://andorra.indymedia.org/news/2006/12/4955.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4956.php">http://andorra.indymedia.org/news/2006/12/4956.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4957.php">http://andorra.indymedia.org/news/2006/12/4957.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4958.php">http://andorra.indymedia.org/news/2006/12/4958.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4959.php">http://andorra.indymedia.org/news/2006/12/4959.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4960.php">http://andorra.indymedia.org/news/2006/12/4960.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4961.php">http://andorra.indymedia.org/news/2006/12/4961.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4962.php">http://andorra.indymedia.org/news/2006/12/4962.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4963.php">http://andorra.indymedia.org/news/2006/12/4963.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4964.php">http://andorra.indymedia.org/news/2006/12/4964.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4965.php">http://andorra.indymedia.org/news/2006/12/4965.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4966.php">http://andorra.indymedia.org/news/2006/12/4966.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4967.php">http://andorra.indymedia.org/news/2006/12/4967.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4968.php">http://andorra.indymedia.org/news/2006/12/4968.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4969.php">http://andorra.indymedia.org/news/2006/12/4969.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4970.php">http://andorra.indymedia.org/news/2006/12/4970.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4971.php">http://andorra.indymedia.org/news/2006/12/4971.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4972.php">http://andorra.indymedia.org/news/2006/12/4972.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4973.php">http://andorra.indymedia.org/news/2006/12/4973.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4974.php">http://andorra.indymedia.org/news/2006/12/4974.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4975.php">http://andorra.indymedia.org/news/2006/12/4975.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4976.php">http://andorra.indymedia.org/news/2006/12/4976.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4977.php">http://andorra.indymedia.org/news/2006/12/4977.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4978.php">http://andorra.indymedia.org/news/2006/12/4978.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4979.php">http://andorra.indymedia.org/news/2006/12/4979.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4980.php">http://andorra.indymedia.org/news/2006/12/4980.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4981.php">http://andorra.indymedia.org/news/2006/12/4981.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4982.php">http://andorra.indymedia.org/news/2006/12/4982.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4983.php">http://andorra.indymedia.org/news/2006/12/4983.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4984.php">http://andorra.indymedia.org/news/2006/12/4984.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4985.php">http://andorra.indymedia.org/news/2006/12/4985.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4986.php">http://andorra.indymedia.org/news/2006/12/4986.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4987.php">http://andorra.indymedia.org/news/2006/12/4987.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4988.php">http://andorra.indymedia.org/news/2006/12/4988.php</a>
<a href="http://andorra.indymedia.org/news/2006/12/4991.php">http://andorra.indymedia.org/news/2006/12/4991.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4992.php">http://andorra.indymedia.org/news/2006/12/4992.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4993.php">http://andorra.indymedia.org/news/2006/12/4993.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4994.php">http://andorra.indymedia.org/news/2006/12/4994.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4995.php">http://andorra.indymedia.org/news/2006/12/4995.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4996.php">http://andorra.indymedia.org/news/2006/12/4996.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4998.php">http://andorra.indymedia.org/news/2006/12/4998.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/4999.php">http://andorra.indymedia.org/news/2006/12/4999.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5000.php">http://andorra.indymedia.org/news/2006/12/5000.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5001.php">http://andorra.indymedia.org/news/2006/12/5001.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5002.php">http://andorra.indymedia.org/news/2006/12/5002.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5003.php">http://andorra.indymedia.org/news/2006/12/5003.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5004.php">http://andorra.indymedia.org/news/2006/12/5004.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5005.php">http://andorra.indymedia.org/news/2006/12/5005.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5006.php">http://andorra.indymedia.org/news/2006/12/5006.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5007.php">http://andorra.indymedia.org/news/2006/12/5007.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5008.php">http://andorra.indymedia.org/news/2006/12/5008.php</a>
<a href="http://andorra.indymedia.org/news/2006/12/5009.php">http://andorra.indymedia.org/news/2006/12/5009.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5010.php">http://andorra.indymedia.org/news/2006/12/5010.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5011.php">http://andorra.indymedia.org/news/2006/12/5011.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5012.php">http://andorra.indymedia.org/news/2006/12/5012.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5013.php">http://andorra.indymedia.org/news/2006/12/5013.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5014.php">http://andorra.indymedia.org/news/2006/12/5014.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5015.php">http://andorra.indymedia.org/news/2006/12/5015.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5016.php">http://andorra.indymedia.org/news/2006/12/5016.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5017.php">http://andorra.indymedia.org/news/2006/12/5017.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5018.php">http://andorra.indymedia.org/news/2006/12/5018.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5019.php">http://andorra.indymedia.org/news/2006/12/5019.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5020.php">http://andorra.indymedia.org/news/2006/12/5020.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5021.php">http://andorra.indymedia.org/news/2006/12/5021.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5022.php">http://andorra.indymedia.org/news/2006/12/5022.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5023.php">http://andorra.indymedia.org/news/2006/12/5023.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5024.php">http://andorra.indymedia.org/news/2006/12/5024.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5026.php">http://andorra.indymedia.org/news/2006/12/5026.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5027.php">http://andorra.indymedia.org/news/2006/12/5027.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5028.php">http://andorra.indymedia.org/news/2006/12/5028.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5029.php">http://andorra.indymedia.org/news/2006/12/5029.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5030.php">http://andorra.indymedia.org/news/2006/12/5030.php</a>

<a href="http://andorra.indymedia.org/news/2006/12/5031.php">http://andorra.indymedia.org/news/2006/12/5031.php</a>



> 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