diff options
| author | Kim Alvefur <zash@zash.se> | 2019-05-13 14:39:38 +0200 |
|---|---|---|
| committer | Kim Alvefur <zash@zash.se> | 2019-05-13 14:39:38 +0200 |
| commit | c71393e92af037676f5d097d3447a4313bf66436 (patch) | |
| tree | 484f46e0f8449e79a3e98a92950e46ad676715dd | |
| parent | bb5a09ed708d6d82d477998fd8261d3164dc3c11 (diff) | |
| download | prosody-c71393e92af037676f5d097d3447a4313bf66436.tar.gz prosody-c71393e92af037676f5d097d3447a4313bf66436.zip | |
mod_storage_sql: Handle SQLite DELETE with LIMIT being optional (fixes #1359)
| -rw-r--r-- | plugins/mod_storage_sql.lua | 21 |
1 files changed, 15 insertions, 6 deletions
diff --git a/plugins/mod_storage_sql.lua b/plugins/mod_storage_sql.lua index dbf5e2da..a449091e 100644 --- a/plugins/mod_storage_sql.lua +++ b/plugins/mod_storage_sql.lua @@ -399,12 +399,14 @@ function archive_store:delete(username, query) LIMIT %s OFFSET ? );]]; if engine.params.driver == "SQLite3" then - sql_query = [[ - DELETE FROM "prosodyarchive" - WHERE %s - ORDER BY "sort_id" %s - LIMIT %s OFFSET ?; - ]]; + if engine._have_delete_limit then + sql_query = [[ + DELETE FROM "prosodyarchive" + WHERE %s + ORDER BY "sort_id" %s + LIMIT %s OFFSET ?; + ]]; + end unlimited = "-1"; elseif engine.params.driver == "MySQL" then sql_query = [[ @@ -620,6 +622,13 @@ function module.load() module:log("error", "Old database format detected. Please run: prosodyctl mod_%s upgrade", module.name); return false, "database upgrade needed"; end + if engine.params.driver == "SQLite3" then + for row in engine:select("PRAGMA compile_options") do + if row[1] == "ENABLE_UPDATE_DELETE_LIMIT" then + engine._have_delete_limit = true; + end + end + end end end); engines[sql.db2uri(params)] = engine; |