[Nhibernate-commit] SF.net SVN: nhibernate:[4079] trunk/nhibernate/src/NHibernate.Test/ NHSpecificTest/NH1394/Fixture.cs

[<dar...@us...>]

Revision: 4079
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4079&view=rev
Author:   darioquintana
Date:     2009-02-08 23:48:01 +0000 (Sun, 08 Feb 2009)

Log Message:
-----------
passing for PostgreSQL

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1394/Fixture.cs

Modified: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1394/Fixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1394/Fixture.cs	2009-02-08 23:17:21 UTC (rev 4078)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1394/Fixture.cs	2009-02-08 23:48:01 UTC (rev 4079)
@@ -1,3 +1,4 @@
+using System;
 using System.Collections.Generic;
 using NHibernate.Criterion;
 using NHibernate.Dialect;
@@ -75,21 +76,25 @@
 		{
 			using (ISession s = OpenSession())
 			{
-				DetachedCriteria dc = DetachedCriteria.For<Person>("sub");
-				dc.CreateCriteria("Pets", "pets").SetProjection(Projections.Min("pets.Weight")).Add(
-					Restrictions.EqProperty("this.Id", "sub.Id"));
+				using (new SqlLogSpy())
+				{
+                    DetachedCriteria dc = DetachedCriteria.For<Person>("sub");
+					dc.CreateCriteria("Pets", "pets").SetProjection(Projections.Min("pets.Weight")).Add(
+						Restrictions.EqProperty("this.Id", "sub.Id"));
 
-				ICriteria c = s.CreateCriteria(typeof (Person)).AddOrder(Order.Asc(Projections.SubQuery(dc)));
-				IList<Person> list = c.List<Person>();
-				int nullRelationOffSet = 2;
-				if (Dialect is Oracle8iDialect)
-				{
-					// Oracle order NULL Last (ASC)
-					nullRelationOffSet = 0;
+					ICriteria c = s.CreateCriteria(typeof (Person)).AddOrder(Order.Asc(Projections.SubQuery(dc)));
+					Console.WriteLine("list()");
+					IList<Person> list = c.List<Person>();
+					int nullRelationOffSet = 2;
+					if (Dialect is Oracle8iDialect || Dialect is PostgreSQLDialect)
+					{
+						// Oracle order NULL Last (ASC)
+						nullRelationOffSet = 0;
+					}
+					Assert.AreEqual(list[nullRelationOffSet].Name, "Tim");
+					Assert.AreEqual(list[nullRelationOffSet + 1].Name, "Joe");
+					Assert.AreEqual(list[nullRelationOffSet + 2].Name, "Sally");
 				}
-				Assert.AreEqual(list[nullRelationOffSet].Name, "Tim");
-				Assert.AreEqual(list[nullRelationOffSet+1].Name, "Joe");
-				Assert.AreEqual(list[nullRelationOffSet+2].Name, "Sally");
 			}
 		}
 
@@ -106,7 +111,7 @@
 				IList<Person> list = c.List<Person>();
 
 				int nullRelationOffSet = 0;
-				if (Dialect is Oracle8iDialect)
+				if (Dialect is Oracle8iDialect || Dialect is PostgreSQLDialect)
 				{
 					// Oracle order NULL First (DESC)
 					nullRelationOffSet = 2;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.