It took me quite a while to figure out why my SQL statements weren’t working properly on an android device (was working on iOS and in simulator both). Posting here in case it helps somebody in the future:
Turns out that (some?) android devices don’t support using LIMIT clauses inside UPDATE clauses, when using corona sdk and the sqlite sql database.