System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 2abbf2c2446537e8be164a53f73615c7723bb82d
Title: incremental_vacuum does not work
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Integration_Via_PInvoke Resolution: Unable_To_Reproduce
Last Modified: 2016-06-21 20:18:36
Version Found In: 1.0.101.0
User Comments:
anonymous added on 2016-06-15 18:23:36:
I have a db with "pragma auto_vacuum = incremental", when I try to run "pragma incremental_vacuum" by C# SQLite, then nothing happens. When I do the same from SQLiteStudio (sqlite_version 3.8.10), then the db file shrinks.
I use Dapper to execute commands, I have tried


conn.Execute("pragma incremental_vacuum");
conn.Query("pragma incremental_vacuum");

both with no result. I am sure no other connection is opened at the time the commands are issued.

mistachkin added on 2016-06-15 20:26:17:
This issue does not reproduce.  Test case added on trunk via check-in [8f68a04dccdcd107].