My favorites | Sign in
Project Home Issues
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 5318: Eclair does not accept OFFSET for LIMIT clause on SQLiteQueryBuilder.query
5 people starred this issue and may be notified of changes. Back to list
Status:  Obsolete
Owner:  ----
Closed:  Jun 2013


Sign in to add a comment
 
Reported by nagam...@gmail.com, Dec 9, 2009
When specify limit clause that has OFFSET keyword on SQLiteQueryBuilder.query, Eclair throws 
InvalidArgumentException(invalid LIMIT clause: 20 OFFSET 0).

Because LIMIT clause is checked with following sLimitPattern.

private static final Pattern sLimitPattern = Pattern.compile("\\s*\\d+\\s*(,\\s*\\d+\\s*)?");
    <framework/base/core/java/android/database/sqlite/SQLiteQueryBuilder.java>

SQLITE3 accepts both comma separated LIMIT clause and OFFSET one.

Cupcake has a bug for LIMIT support.
Donut is OK.
Eclair only accept comma separated LIMIT clause.

2.0 is only used on Droid. So please fix this on 2.0.1 and replace all 2.0 devices with 2.0.1.

Jun 23, 2013
#1 jbq@android.com
Based on its date, this issue was originally reported before Android 2.3. Because of the many changes that existed in Android 4.x compared to previous versions, it's very likely that this issue doesn't exist in recent versions of Android like 4.2.2 or newer. Because of the high likelihood that this issue is obsolete, it is getting closed automatically by a script, without a human looking at it in detail. If the issue still exists on a Nexus 4 or Nexus 7 running Android 4.2.2 and is not related to Google applications, please open a new report accordingly.

Status: Obsolete
Sign in to add a comment

Powered by Google Project Hosting