Revision: 5469
http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5469&view=rev
Author: patearl
Date: 2011-03-13 23:17:23 +0000 (Sun, 13 Mar 2011)
Log Message:
-----------
Fixed NH1792.
Modified Paths:
--------------
trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1792/Fixture.cs
Modified: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1792/Fixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1792/Fixture.cs 2011-03-13 23:00:55 UTC (rev 5468)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1792/Fixture.cs 2011-03-13 23:17:23 UTC (rev 5469)
@@ -79,9 +79,13 @@
{
using (ISession session = OpenSession())
{
+ string top = "";
+ if (Dialect.GetType().Name.StartsWith("Mssql"))
+ top = "top 5";
+
IList<Product> results =
session.CreateCriteria<Product>().Add(
- Expression.Sql("{alias}.Id in (Select p.Id from Product p order by Name)")).Add(Restrictions.Gt("Id", 0)).
+ Expression.Sql("{alias}.Id in (Select " + top + " p.Id from Product p order by Name)")).Add(Restrictions.Gt("Id", 0)).
SetMaxResults(3).List<Product>();
Assert.AreEqual(3, results.Count);
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
