diff options
| author | Kim Alvefur <zash@zash.se> | 2023-06-17 00:00:21 +0200 |
|---|---|---|
| committer | Kim Alvefur <zash@zash.se> | 2023-06-17 00:00:21 +0200 |
| commit | a45c06b51fbc250f738b320c96d974bf733eb5b3 (patch) | |
| tree | 2ad4c1aab690715b56030369807a1a7ccf72896d /plugins | |
| parent | f70ab44b4c3f4bdf65795b85fc2f98e94feca1fb (diff) | |
| download | prosody-a45c06b51fbc250f738b320c96d974bf733eb5b3.tar.gz prosody-a45c06b51fbc250f738b320c96d974bf733eb5b3.zip | |
mod_storage_sql: Be more specific when checking for old index in SQLite3
Prevents false positives in the odd case where something other than an
index with this name might exist.
Diffstat (limited to 'plugins')
| -rw-r--r-- | plugins/mod_storage_sql.lua | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/plugins/mod_storage_sql.lua b/plugins/mod_storage_sql.lua index 3b20b3cc..3afb5d78 100644 --- a/plugins/mod_storage_sql.lua +++ b/plugins/mod_storage_sql.lua @@ -850,7 +850,7 @@ local function upgrade_table(engine, params, apply_changes) -- luacheck: ignore local indices = {}; engine:transaction(function () if params.driver == "SQLite3" then - for row in engine:select [[SELECT "name" from "sqlite_schema" WHERE "name"='prosody_index';]] do + for row in engine:select [[SELECT "name" FROM "sqlite_schema" WHERE "type"='index' AND "tbl_name"='prosody' AND "name"='prosody_index';]] do indices[row[1]] = true; end elseif params.driver == "PostgreSQL" then |