util.sqlite3: Skip prepared statements when no parameters are given
authorKim Alvefur <zash@zash.se>
Mon, 01 Aug 2022 17:25:40 +0200
changeset 12852 ccb030d988ac
parent 12851 d6cdde74cd9b
child 12853 330bfcaa5532
util.sqlite3: Skip prepared statements when no parameters are given Seems CREATE INDEX is unhappy as a prepared statement. Perhaps because the table has not been COMMIT-ed yet?
util/sqlite3.lua
--- a/util/sqlite3.lua	Fri Oct 01 02:27:53 2021 +0200
+++ b/util/sqlite3.lua	Mon Aug 01 17:25:40 2022 +0200
@@ -164,6 +164,16 @@
 	if not success then return success, err; end
 	local prepared = self.prepared;
 
+	if select('#', ...) == 0 then
+		local ret = self.conn:exec(sql);
+		if ret ~= lsqlite3.OK then
+			local err = sqlite_errors.new(err);
+			err.text = self.conn:errmsg();
+			return err;
+		end
+		return true;
+	end
+
 	local stmt = prepared[sql];
 	if not stmt then
 		local err;