You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@manifoldcf.apache.org by kw...@apache.org on 2011/12/22 01:29:50 UTC

svn commit: r1221968 - /incubator/lcf/trunk/framework/core/src/main/java/org/apache/manifoldcf/core/database/DBInterfaceMySQL.java

Author: kwright
Date: Thu Dec 22 00:29:50 2011
New Revision: 1221968

URL: http://svn.apache.org/viewvc?rev=1221968&view=rev
Log:
Get the offset/limit clause syntax right

Modified:
    incubator/lcf/trunk/framework/core/src/main/java/org/apache/manifoldcf/core/database/DBInterfaceMySQL.java

Modified: incubator/lcf/trunk/framework/core/src/main/java/org/apache/manifoldcf/core/database/DBInterfaceMySQL.java
URL: http://svn.apache.org/viewvc/incubator/lcf/trunk/framework/core/src/main/java/org/apache/manifoldcf/core/database/DBInterfaceMySQL.java?rev=1221968&r1=1221967&r2=1221968&view=diff
==============================================================================
--- incubator/lcf/trunk/framework/core/src/main/java/org/apache/manifoldcf/core/database/DBInterfaceMySQL.java (original)
+++ incubator/lcf/trunk/framework/core/src/main/java/org/apache/manifoldcf/core/database/DBInterfaceMySQL.java Thu Dec 22 00:29:50 2011
@@ -768,14 +768,16 @@ public class DBInterfaceMySQL extends Da
   public String constructOffsetLimitClause(int offset, int limit, boolean afterOrderBy)
   {
     StringBuilder sb = new StringBuilder();
-    if (offset != 0)
-      sb.append("OFFSET ").append(Integer.toString(offset));
     if (limit != -1)
     {
-      if (offset != 0)
-        sb.append(" ");
       sb.append("LIMIT ").append(Integer.toString(limit));
     }
+    if (offset != 0)
+    {
+      if (limit != -1)
+        sb.append(" ");
+      sb.append("OFFSET ").append(Integer.toString(offset));
+    }
     return sb.toString();
   }