Software / code / prosody
Changeset
13852:ce4b4c2863f3 13.0
mod_storage_sql: Also retrieve all SQLite3 indices
Missed this in 2558be2daaca
| author | Kim Alvefur <zash@zash.se> |
|---|---|
| date | Wed, 16 Apr 2025 15:35:07 +0200 |
| parents | 13851:ecafafec7806 |
| children | 13853:5611ce3bc54c 13854:0b01f40df0f9 |
| files | plugins/mod_storage_sql.lua |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/plugins/mod_storage_sql.lua Tue Apr 15 21:47:13 2025 +0200 +++ b/plugins/mod_storage_sql.lua Wed Apr 16 15:35:07 2025 +0200 @@ -879,7 +879,7 @@ local indices = {}; engine:transaction(function () if params.driver == "SQLite3" then - for row in engine:select [[SELECT "name" FROM "sqlite_schema" WHERE "type"='index' AND "tbl_name"='prosody' AND "name"='prosody_index';]] do + for row in engine:select [[SELECT "name" FROM "sqlite_schema" WHERE "type"='index' AND "tbl_name"='prosody';]] do indices[row[1]] = true; end elseif params.driver == "PostgreSQL" then
