Don't do a COMMIT while saving when not in a transaction

See issue sqlitebrowser#583.
menggang20 · May 5, 2016 · 6484206 · 6484206
1 parent b00c4f7
commit 6484206
Showing 1 changed file with 5 additions and 1 deletion.
diff --git a/src/sqlitedb.cpp b/src/sqlitedb.cpp
@@ -313,7 +313,11 @@ bool DBBrowserDB::releaseAllSavepoints()
         if(!releaseSavepoint(point))
             return false;
     }
-    executeSQL("COMMIT;", false, false);  // Just to be sure
+
+    // When still in a transaction, commit that too
+    if(sqlite3_get_autocommit(_db) == 0)
+        executeSQL("COMMIT;", false, false);
+
     return true;
 }