prosody
ce4b4c2863f3
plugins/mod_storage_sql.lua

Find changesets by keywords by author, files, the commit message, revision number or hash, or revset expression.

Software / code / prosody

Diff

plugins/mod_storage_sql.lua @ 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 (4 weeks ago)
parent 13845:2558be2daaca
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