[Nhibernate-commit] SF.net SVN: nhibernate:[3874] trunk/nhibernate/src/NHibernate

[<aye...@us...>]

Revision: 3874
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=3874&view=rev
Author:   ayenderahien
Date:     2008-10-23 19:27:00 +0000 (Thu, 23 Oct 2008)

Log Message:
-----------
NH-1547 - SqLite Paqing does not page properly after the 2nd page

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs
    trunk/nhibernate/src/NHibernate.Test/DialectTest/SQLiteDialectFixture.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs	2008-10-23 18:44:32 UTC (rev 3873)
+++ trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs	2008-10-23 19:27:00 UTC (rev 3874)
@@ -183,7 +183,7 @@
 
 			if (offset > 0)
 			{
-				pagingBuilder.Add(", ");
+				pagingBuilder.Add(" offset ");
 				pagingBuilder.Add(offset.ToString());
 			}
 

Modified: trunk/nhibernate/src/NHibernate.Test/DialectTest/SQLiteDialectFixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/DialectTest/SQLiteDialectFixture.cs	2008-10-23 18:44:32 UTC (rev 3873)
+++ trunk/nhibernate/src/NHibernate.Test/DialectTest/SQLiteDialectFixture.cs	2008-10-23 19:27:00 UTC (rev 3874)
@@ -28,7 +28,7 @@
         {
             SqlString sql = new SqlString("SELECT id, name, email FROM Users");
             SqlString s = dialect.GetLimitString(sql, 5, 10);
-            Assert.AreEqual("SELECT id, name, email FROM Users limit 10, 5", s.ToString());
+            Assert.AreEqual("SELECT id, name, email FROM Users limit 10 offset 5", s.ToString());
         }
 
         [Test]


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