|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|
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
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.
|► Sign in to add a comment|