/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of src/vacuum.c

2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. file: [5b9b4771] check-in: [018f3199] user: drh branch: reuse-schema, size: 15730
21:51
Merge the latest trunk enhancements into begin-concurrent. file: [0bbe81da] check-in: [5d3a6e18] user: drh branch: begin-concurrent, size: 15722
2019-04-23
22:00
Make no atttempt to generate VDBE code for VACUUM after a syntax error. file: [82dcec9e] check-in: [93084247] user: drh branch: trunk, size: 15690
2019-04-15
15:35
Merge recent changes from trunk into reuse-schema file: [36b6328b] check-in: [5c6c9e7f] user: drh branch: reuse-schema, size: 15686
14:59
Merge the latest enhancements from trunk. file: [247d5d95] check-in: [7c328e88] user: drh branch: begin-concurrent, size: 15678
2019-04-04
18:20
Minor fixes to requirements marks. file: [72690ccb] check-in: [02ebc60b] user: drh branch: trunk, size: 15646
15:25
Simplification of the recent VACUUM changes that make the code more like what it was before the change. Also, make the VACUUM command a no-inline procedure to work around a performance regression. file: [d07bc402] check-in: [9cac5ac1] user: drh branch: trunk, size: 15596
14:00
Only preserve rowid values for VACUUM INTO. Keep the legacy behavior of renumbering rowids for ordinary VACUUM. file: [b26da99e] check-in: [13a0ea64] user: drh branch: trunk, size: 15641
2019-03-26
12:07
Merge recent enhancements from trunk. file: [14622709] check-in: [774d0d52] user: drh branch: begin-concurrent, size: 15573
2019-03-20
16:03
Merge latest trunk changes into this branch. file: [04b27213] check-in: [4cd20ca6] user: dan branch: reuse-schema, size: 15581
2019-03-19
20:42
Enhance the VACUUM INTO command so that it works on read-only databases. file: [532553ee] check-in: [55be6d0a] user: drh branch: trunk, size: 15541
2019-02-05
19:51
Merge latest trunk into this branch. file: [7dbed4a7] check-in: [c089cc4f] user: dan branch: reuse-schema, size: 15330
2019-01-26
16:34
Roll back the transaction if a write statement fails with OE_Abort but there is no open statement transaction. file: [c3b29ca1] check-in: [d536be69] user: dan branch: rollback-abort, size: 15404
2019-01-02
16:08
Merge latest trunk changes into this branch. file: [b95f6ab5] check-in: [5bf212f1] user: dan branch: begin-concurrent, size: 15322
14:34
Raise an error if the argument to VACUUM INTO is an identifier. file: [a9f389f4] check-in: [6c6fb1c6] user: drh branch: trunk, size: 15290
2018-12-15
20:59
Merge latest wal2 changes into this branch. file: [ae215242] check-in: [06bb80ee] user: dan branch: begin-concurrent-wal2, size: 15268
2018-12-08
00:43
Allow the INTO clause of VACUUM to be a text-valued expression. file: [3ffe64ec] check-in: [af172b53] user: drh branch: vacuum-into, size: 15236
2018-12-07
23:48
Do not allow VACUUM INTO into a file that already exists. file: [5d494973] check-in: [92f70e0f] user: drh branch: vacuum-into, size: 14775
20:40
Merge the VACUUM simplification from trunk. file: [7b74a106] check-in: [93d92a0a] user: drh branch: vacuum-into, size: 14495
20:26
Remove a line of code from VACUUM that is no longer needed, due to the change that allows ATTACH to run within a transaction. file: [b25dbace] check-in: [a92c398f] user: drh branch: trunk, size: 14102
17:28
Prototype implementation for the VACUUM INTO command. file: [76b92b5d] check-in: [036e3320] user: drh branch: vacuum-into, size: 14818
2018-12-06
17:06
When masking bits off of sqlite3.flags, make sure the mask is 64 bits in size so as not to accidentally mask of high-order bits. file: [c6708552] check-in: [53d3b169] user: drh branch: trunk, size: 14425
16:50
When saving off the value of sqlite3.flags, take care to preserve all 64 bits. file: [675a4bda] check-in: [9c6dbcfa] user: drh branch: trunk, size: 14420
2018-11-26
07:21
Merge latest trunk changes into this branch. file: [8747a99e] check-in: [28a615a2] user: dan branch: begin-concurrent, size: 14452
2018-11-17
18:45
Merge latest trunk changes into this branch. file: [87907c33] check-in: [9fdd1868] user: dan branch: reuse-schema1, size: 14460
2018-11-06
19:26
Enable DEFENSIVE mode by default for tests. This requires lots of case of turning DEFENSIVE off in order to dodgy things to the database for testing purposes. No all of those cases are yet handled, so "make test" does not run to completion. file: [836cadc9] check-in: [a1d6c671] user: drh branch: read-only-shadow, size: 14420
2018-10-30
00:06
In the VACUUM command, defer setting writable_schema until after it has been determined that the schema is not corrupt. file: [3ff33a67] check-in: [3afec260] user: drh branch: robust-against-damaged-db, size: 14396
2018-10-08
18:58
Merge latest trunk changes into this branch. file: [6da236d4] check-in: [2ac72114] user: dan branch: reuse-schema, size: 14422
2018-06-06
17:03
Merge changes from trunk, including all the 3.24.0 changes plus some later enhancements. file: [4879e471] check-in: [d7299bfe] user: drh branch: begin-concurrent, size: 14414
16:28
Change sqlite3BtreeBeginTrans() to return the BTREE_SCHEMA_COOKIE, for a small speed improvement when starting new transactions. file: [36e7d21a] check-in: [a10662aa] user: drh branch: trunk, size: 14382
2018-05-15
11:45
Merge latest trunk changes with this branch. file: [162c629c] check-in: [ae86cf60] user: dan branch: begin-concurrent, size: 14411
2018-05-03
21:51
Improved security for VACUUM. This check-in combines the fixes of [ab0d99d0b5ede] and [27754b74ddf646] in a way that is less likely to to be broken by future changes. file: [37730af7] check-in: [260fc696] user: drh branch: trunk, size: 14379
2018-05-02
15:00
Prevent VACUUM from running any commands in sqlite_master.sql other than CREATE statements. That is all that should be there anyhow. This fixes a problem discovered by OSSFuzz. Test cases in TH3. file: [593498d6] check-in: [ab0d99d0] user: drh branch: trunk, size: 14136
2018-03-02
17:40
Merge latest trunk changes into this branch. file: [f0b83022] check-in: [36801eff] user: dan branch: begin-concurrent, size: 14144
2018-02-12
13:30
Fix a possible infinite loop in VACUUM that can come up when the schema has been carefully corrupted. Problem discovered by OSSFuzz. Test cases in TH3. file: [762ee9bb] check-in: [27754b74] user: drh branch: trunk, size: 14112
2017-08-09
20:35
Add experimental sqlite3_open_v2() flag SQLITE_OPEN_REUSE_SCHEMA. For sharing identical in-memory schema objects between connections. file: [c31a0fe4] check-in: [a6256980] user: dan branch: reuse-schema, size: 14097
2017-08-01
13:54
Merge recent enhancements from trunk. file: [07eec96f] check-in: [aafe1fec] user: drh branch: begin-concurrent, size: 14089
2017-07-26
19:59
Add the new sqlite3.mDbFlags field. Factor out bits of sqlite3.flags that do not interact with PRAGMA statements into sqlite3.mDbFlags. file: [90839322] check-in: [3808a00f] user: drh branch: trunk, size: 14057
2017-07-20
17:47
Merge all the latest trunk enhancements. file: [ab48f1d3] check-in: [213c61cb] user: drh branch: begin-concurrent, size: 13963
2017-06-16
13:43
Prevent pagesize changes on VACUUM in encrypted databases even when running the VACUUM on an attached database. file: [874c0f2f] check-in: [11693849] user: drh branch: trunk, size: 13931
2017-03-24
15:09
Merge all recent enhancements from trunk. file: [8aa1db0b] check-in: [fd5676fe] user: drh branch: begin-concurrent, size: 13961
2017-02-18
13:47
Add the SQLITE_BUG_COMPATIBLE_20160819 compile-time option to omit the error message when an unrecognized argument is provided to the VACUUM command. file: [1fe4555c] check-in: [49181427] user: drh branch: trunk, size: 13929
2017-01-09
06:33
Upgrade this branch to 3.16 plus the various fixes that appeared after its release. file: [ebcf4579] check-in: [d0e212d0] user: dan branch: begin-concurrent, size: 13363
2016-11-02
14:50
Fix an issue that was causing the new database image to be assembled entirely in heap memory when VACUUMing a database, even if it should use a temp file. This could cause SQLITE_NOMEM errors when vacuuming very large databases on 32-bit systems. file: [33c174b2] check-in: [30288453] user: dan branch: trunk, size: 13331
2016-08-19
15:12
Disable row counting on queries run while doing a VACUUM. file: [913970b9] check-in: [ad35ef11] user: drh branch: vacuum-attached-db, size: 13314
14:20
Add the capability to VACUUM an attached database by specifying the schema name as an argument to the VACUUM command. Since version 2.0, VACUUM has accepted an argument which was silently ignored. Now it has meaning. file: [0fecf4ba] check-in: [29d63059] user: drh branch: vacuum-attached-db, size: 13277
2016-08-18
14:33
Rename the Db.zName field to Db.zDbSName to make it more descriptive and to distinguish it from all of the other "zName" variables scattered throughout the code. file: [f6f10c88] check-in: [92a22f01] user: drh branch: zDbSName, size: 14172
2016-08-11
19:12
Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. file: [ca88e6d3] check-in: [d9f8918c] user: drh branch: begin-concurrent, size: 14201
2016-07-26
04:49
Copy the cache_spill setting from the main database over to the vacuum_db transient database when running a VACUUM. file: [9dd2f5d2] check-in: [c0e7d98e] user: drh branch: trunk, size: 14169
2016-07-25
22:40
In the VACUUM command, set the cache_size of the transient vacuum_db database to be the same as the database being vacuumed. file: [7949183a] check-in: [b78d9954] user: drh branch: trunk, size: 14099
18:50
Add the experimental SQLITE_VACUUM_CACHE_SIZE macro. file: [d60b11b2] check-in: [68ecd8e0] user: drh branch: apple-osx, size: 14171
2016-07-13
23:18
Legacy tests now passing. file: [544ec90a] check-in: [f33526a3] user: drh branch: sqlite3_trace_v2, size: 14032
22:55
First cut at implementing the new sqlite3_trace_v2() interface. file: [459ff7cb] check-in: [cb0062fe] user: drh branch: sqlite3_trace_v2, size: 14032
2016-03-16
19:34
Merge the latest enhancements from trunk. file: [c1a94413] check-in: [a7978ab6] user: drh branch: begin-concurrent, size: 14078
2016-02-13
23:43
Enhance ability to debug out-of-memory errors. file: [feb1eabb] check-in: [6a9c4a3e] user: mistachkin branch: noMemBkpt, size: 14046
2015-08-24
19:56
Change "BEGIN UNLOCKED" to "BEGIN CONCURRENT". file: [983cc375] check-in: [ba1ab858] user: dan branch: begin-concurrent, size: 14068
2015-08-21
20:11
Fix many minor issues in the unlocked transaction code. file: [d35c7291] check-in: [53aaeea6] user: dan branch: begin-concurrent, size: 14066
2015-07-27
19:31
Add an experimental "BEGIN UNLOCKED" command. file: [4e7e18d8] check-in: [80794216] user: dan branch: begin-concurrent, size: 14057
2015-04-01
18:20
When vacuuming an index that uses no collations other than BINARY, assume that the order of index entries will not be changed by the VACUUM. file: [2ddd5cad] check-in: [e403460b] user: dan branch: sorter-opt, size: 14036
2015-02-21
00:19
Keep track of the optimal number of reserved bytes (by looking at reserve byte requests in calls to sqlite3BtreeSetPageSize()) and then change the reserve byte count to the optimal when doing a VACUUM or when using the backup API. file: [9460b9de] check-in: [28c2b726] user: drh branch: trunk, size: 13887
2014-11-07
13:24
Fix harmless typos in comments. file: [9b30ec72] check-in: [94c564da] user: drh branch: trunk, size: 13880
2014-09-06
16:39
Fix typos in comments. No code changes. file: [59f03f92] check-in: [e62aab5e] user: peter.d.reid branch: trunk, size: 13879
2013-10-23
16:03
Get VACUUM and the xfer optimization working with WITHOUT ROWID. file: [3728d749] check-in: [579815ff] user: drh branch: omit-rowid, size: 13878
2013-09-30
11:01
Update and modernize an obsolete comment associated with VACUUM. No changes to code. file: [f313bc97] check-in: [94c914e3] user: drh branch: trunk, size: 13854
2013-06-27
23:54
Refactor names of fields in the sqlite3 object: "activeVdbeCnt" becomes "nVdbeActive". Related fields becomes "nVdbeRead", "nVdbeWrite", and "nVdbeExec". file: [d9c5759f] check-in: [14f79696] user: drh branch: trunk, size: 12657
2013-05-01
20:36
Preserve the application-ID across VACUUM. Updates to the magic number file. file: [ddf21cc9] check-in: [4a190bea] user: drh branch: application-id, size: 12659
2012-10-15
18:02
Hold the mutex on the shared-cache for the duration of a VACUUM operation. file: [2727bdd0] check-in: [629a42d4] user: dan branch: trunk, size: 12588
2012-05-15
18:28
The former sqlite3ResetInternalSchema() routine was really two different routines, selected by parameter, each with a confused mission. So split this routine up into three separate smaller routines, calling each separately as needed. Hopefully this will make further refactoring and schema reset collateral damage containment easier. file: [587a52bb] check-in: [aa0c3493] user: drh branch: shared-schema, size: 12556
2012-02-28
17:57
Fix spurious errors that may occur if an empty database is opened and then initialized as a WAL database by a second connection. file: [bfd53f9b] check-in: [16330a2f] user: dan branch: trunk, size: 12552
2011-10-07
16:57
Add the SQLITE_FCNTL_OVERWRITE file-control. Used by SQLite to indicate to the OS layer that the current transaction will overwrite the entire file. file: [0c0ba224] check-in: [1da87fcd] user: dan branch: trunk, size: 12282
2011-09-30
12:01
Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690]. file: [297f3974] check-in: [9ddfe1e4] user: dan branch: trunk, size: 12460
2011-04-04
23:08
Add a comment to the VACUUM implementation explaining when all schemas are reset and not just the "main" schema. file: [05513dca] check-in: [2aff1b0c] user: drh branch: schema-parse-refactor, size: 12428
2011-04-02
16:28
Begin a series of changes designed to reduce the scope and frequency of invalidating schemas. Design goals are that the internal schema should never be deleted out from under a prepared statement that is running and that all prepared statements should be expired if the schema is invalidated. At the same time, minimize the number of schema invalidations. This change merely revises the sqlite3ResetInternalSchema() function to use -1 as the wildcard for "all" rather than 0, so that we can reset the main schema independently of all the others. file: [3b2b0998] check-in: [6a8ad6e3] user: drh branch: schema-parse-refactor, size: 12340
2010-09-24
09:32
Add experimental branch disallowing VACUUM when there are one or more active SQL statements. file: [924bd1bc] check-in: [c1ebcacd] user: dan branch: experimental, size: 12338
2010-06-11
17:01
Refactor and simplify the logic used to change journalmode. file: [241a8386] check-in: [95cc3f6f] user: drh branch: trunk, size: 12199
2010-05-10
14:10
If an ATTACH command fails due to OP_JournalMode but still attaches the database, make sure VACUUM still detaches it when done. file: [b17355fc] check-in: [6ecdc7ba] user: drh branch: trunk, size: 12203
2010-05-05
04:11
Make sure the page size of the main database is fixed following a failed VACUUM attempt. Otherwise, two consecutive failed VACUUM attempts with attempted page_size changes on encrypted or WAL databases could result in database corruption. file: [90a32e09] check-in: [208e7d5d] user: drh branch: trunk, size: 12042
03:39
Do not attempt to modify the page_size when running VACUUM on a WAL database. file: [15db45c7] check-in: [58a1a59b] user: drh branch: trunk, size: 11997
2010-04-24
14:02
When commands such as ALTER TABLE and VACUUM use SQL internally, make sure they use only the built-in functions and not application-defined overrides for those functions. file: [8e7d9a6f] check-in: [0291ed97] user: drh branch: trunk, size: 11763
2010-03-03
00:02
When TEMP files are in memory, also put the massive TEMP file used by the VACUUM command in memory. This is a cherry-pick merge of [9daf4e7d07] file: [137a2f49] check-in: [e5342234] user: drh branch: branch-3.6.22, size: 11716
2010-03-02
23:34
When TEMP files are in memory, also put the massive TEMP file used by the VACUUM command in memory. file: [b1d542c8] check-in: [9daf4e7d] user: drh branch: trunk, size: 11740
2010-02-25
02:32
Merge in all of the logging enhancements. This is a cherrypick merge of the following check-ins: [103321e37a], [a8076aede3], [6d910245ad], [7c4cca6d1a], [edea3bb740], [1a6d4bb130], [a8c984c1d6], [69a493182f], and [1168763d2c]. file: [1f3f6d60] check-in: [46f406b2] user: drh branch: branch-3.6.22, size: 11622
2010-02-24
19:23
Add a sqlite3_log() call on anonymous constraint failures. Fix the output of test cases having to do with improved reprepare reporting. Fix the VACUUM command to report more helpful error messages when things go wrong. file: [deb50c41] check-in: [69a49318] user: drh branch: trunk, size: 11646
2010-01-12
23:54
Make sure internal queries are well ordered, even when the reverse_unordered_selects pragma is in effect. Ticket [eb942c64a157]. file: [28ee5a49] check-in: [0209f171] user: drh branch: trunk, size: 11057
2009-12-17
03:49
Disable trace when recursively running commands while vacuuming. file: [db6415fd] check-in: [69a1348a] user: drh branch: trunk, size: 11033
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [03309a08] check-in: [f6c045f6] user: drh branch: trunk, size: 10890
2009-10-20
15:01
Fix the VACUUM command so that when the MAIN and TEMP databases have identically named tables, content from the TEMP database does not accidently overwrite MAIN database content. Ticket [d82e3f3721296e905d7e8c9dee718f71a826b0eb]. Note that this bug could potentially lead to database corruption. file: [48e1282b] check-in: [0bbd8d72] user: drh branch: trunk, size: 10955
2009-10-16
14:55
Experimental fix for [f777251dc7]. This may be changed yet. file: [f2347520] check-in: [174477bc] user: dan branch: trunk, size: 10930
2009-09-21
16:06
Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. file: [869d08ea] check-in: [fb6ceed3] user: dan branch: trunk, size: 10608
2009-07-02
07:47
Cause opening a transaction on a sharable b-tree module automatically obtain a read-lock on page 1. This means there is no way for sqlite3BtreeGetMeta() to fail. (CVS 6836) file: [3fe0eebe] check-in: [e3c055f1] user: danielk1977 branch: trunk, size: 10455
2009-06-03
11:25
Define a set of constants to use as the "index" argument to sqlite3BtreeGetMeta and UpdateMeta. This makes some parts of the code easier to follow. (CVS 6709) file: [0e14f371] check-in: [6dbf4eca] user: danielk1977 branch: trunk, size: 10513
2009-05-30
10:46
In vacuum.c use "PagerIsMemdb(X)" instead of "PagerFile(X)->pMethods==0". (CVS 6692) file: [981686c9] check-in: [874295ce] user: danielk1977 branch: trunk, size: 10437
2009-05-05
17:37
Changes to vacuum.c to facilitate full coverage testing. (CVS 6606) file: [e8d17800] check-in: [86628465] user: drh branch: trunk, size: 10532
2009-04-02
20:16
Make sure the VACUUM statement locks down the page_size and auto_vacuum modes after it runs. Otherwise, pragmas might change these settings on a populated database, resulting in problems. (CVS 6442) file: [07121a72] check-in: [85e6a474] user: drh branch: trunk, size: 10345
2009-02-03
16:51
Commit first version of the 'backup' feature. (CVS 6241) file: [4929a585] check-in: [663479b4] user: danielk1977 branch: trunk, size: 10345
2009-01-22
23:04
Fix the VACUUM command so that it does not commit a transaction when it is mistakenly run within a transaction - it should leave the transaction open. (CVS 6200) file: [b78c2bfd] check-in: [75cc709b] user: drh branch: trunk, size: 10373
2008-11-17
19:18
Modifications to avoid unsigned/signed comparisons in various files. (CVS 5914) file: [383d6297] check-in: [8009220c] user: danielk1977 branch: trunk, size: 10402
2008-08-26
21:07
All the page_size pragma to change the page size on a new :memory: database, but not a vacuumed :memory: database. Ticket #3335 (CVS 5617) file: [fd77433d] check-in: [226a9056] user: drh branch: trunk, size: 10408
2008-08-23
16:17
Do not incorrectly detect corruption when an auto-vacuum database is converted to a non-auto-vacuum database within a vacuum. Ticket #3332. (CVS 5603) file: [a5b10ae2] check-in: [cb869946] user: danielk1977 branch: trunk, size: 10170
2008-07-08
19:34
Completely rework the sqlite3SetString() primitive so that it honors the SQLITE_LIMIT_LENGTH and avoids the use of strlen(). (CVS 5374) file: [ef342828] check-in: [8ed04b1e] user: drh branch: trunk, size: 10052
2008-06-17
01:03
Do not allow a VACUUM to try to change the page_size on an encrypted database. (CVS 5225) file: [14eb21b4] check-in: [d49e5020] user: drh branch: trunk, size: 10066
2008-05-21
13:44
Fix the VACUUM command so that it does not modify the changes counts reported by sqlite3_changes() or sqlite3_total_changes(). Update documentation on sqlite3_changes() and sqlite3_total_changes() to state that "DELETE FROM table" records a change count of zero. (CVS 5151) file: [a5c289e5] check-in: [f5d61d7d] user: drh branch: trunk, size: 9748
2008-04-30
16:38
Add comment to speculate when setting journal_mode=OFF on VACUUM does not help performance. No changes to code. (CVS 5071) file: [c3b2b706] check-in: [9c8b4bab] user: drh branch: trunk, size: 9481
2008-03-20
11:04
Allow a VACUUM operation to change the page-size in the same way as it can be used to change a database between auto-vacuum and normal mode. (CVS 4896) file: [3524411b] check-in: [871df0e7] user: danielk1977 branch: trunk, size: 9084
2008-01-03
00:01
Refactoring the VM. The P3 parameter is changed to P4. A P5 parameter is added (though not currently used.) Add routines sqlite3VdbeAddOpX() where X is one of 0, 1, 2, 3, or 4. (CVS 4660) file: [3f34f278] check-in: [027875e4] user: drh branch: trunk, size: 8955
2007-12-05
01:38
Add the ability to change the autovacuum status of an existing database by setting the auto_vacuum pragma then running the VACUUM command. (CVS 4592) file: [25ffbd76] check-in: [bdfc19e8] user: drh branch: trunk, size: 8954
2007-10-20
20:58
Use the 2-argument version of substr() in the SQL contained in the VACUUM and ALTER TABLE commands. Ticket #2737. (CVS 4499) file: [a5e51c77] check-in: [82b08a3d] user: drh branch: trunk, size: 8872
2007-08-29
12:31
Modifications to the malloc failure tests to test transient and persistent failures. (CVS 4321) file: [38745037] check-in: [e38ef81b] user: danielk1977 branch: trunk, size: 8910
2007-08-24
11:43
Remove unnecessary sqlite3MallocDisallow() that was preventing win32 from running. (CVS 4285) file: [5ec133b6] check-in: [eb6c98fc] user: drh branch: trunk, size: 8858
2007-08-21
10:44
Remove unnecessary #includes of "os.h". New mutex implementations. (CVS 4255) file: [318ccae7] check-in: [fbbd5bda] user: drh branch: trunk, size: 8913
2007-08-16
04:30
Half-way through a major refactoring of the memory allocation. I have not even attempted to compile so I am certain there are countless errors. (CVS 4231) file: [f45bd9d3] check-in: [deb7ecd6] user: drh branch: trunk, size: 8929
2007-03-27
16:19
Test handling of IO errors that occur in OsDelete() or OsTruncate() operations. Also use an anonymous file for temporary storage during a VACUUM. (CVS 3729) file: [8bd895d2] check-in: [b24a6e7b] user: danielk1977 branch: trunk, size: 8942
14:44
The -DSQLITE_OMIT_ATTACH=1 option now omits both the ATTACH and VACUUM commands. Ticket #2268. The regression test suite depends on both of these commands and will not run if compiled with this option. (CVS 3727) file: [b74b1107] check-in: [cbebfb89] user: drh branch: trunk, size: 9260
2007-03-06
16:03
Catch an out-of-memory condition in vacuum code. (Bug in (3373)). (CVS 3675) file: [327c6ffa] check-in: [302ec768] user: danielk1977 branch: trunk, size: 9208
2007-01-03
23:37
Clean up memory leaks and uninitialized variables detected by valgrind. Identify all tests where we deliberately derefence freed memory by adding a "-misuse" tag. (CVS 3550) file: [b4569b08] check-in: [70a86270] user: drh branch: trunk, size: 9118
2006-11-18
20:20
Make sure VACUUM cleans up after itself. Ticket #2071. (CVS 3514) file: [b620ffff] check-in: [2fdc147d] user: drh branch: trunk, size: 9118
2006-10-10
13:07
VACUUM now uses a temporary file in the official TEMP folder instead of a file in the same directory as the original database. (CVS 3470) file: [f6a7943f] check-in: [b743429d] user: drh branch: trunk, size: 9036
2006-09-21
11:02
Be more aggressive with the SQLITE_OMIT_VACUUM macro. Saves about 150 bytes of code space. (CVS 3432) file: [f958275b] check-in: [7e618db4] user: drh branch: trunk, size: 10693
2006-09-13
19:21
Remove unused malloc failure test. (Ticket #1976) Also include fixes for other problems discovered while investigating ticket #1976. (CVS 3415) file: [fb65647c] check-in: [f4ab546b] user: drh branch: trunk, size: 10702
2006-09-11
23:45
Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) file: [e2cd4792] check-in: [e4fe736c] user: drh branch: trunk, size: 10966
11:13
Get VACUUM working with virtual tables. (CVS 3404) file: [5dac7938] check-in: [d5ffef38] user: drh branch: trunk, size: 11282
2006-02-24
02:53
Remove unused parameters on internal APIs. Suppress warnings from CodeWarrior. (CVS 3110) file: [5b37d0f4] check-in: [4b22e4b8] user: drh branch: trunk, size: 11005
2006-01-18
16:51
Use a global variable protected by a mutex instead of thread-specific-data to record malloc() failures. (CVS 2972) file: [3865673c] check-in: [ac090f2a] user: danielk1977 branch: trunk, size: 11031
2006-01-13
01:48
Add a high-speed version of sqlite3GetVarint32 to vdbe.c for a 3% performance gain. (CVS 2933) file: [21a3c7f6] check-in: [a64e8251] user: drh branch: trunk, size: 11039
2006-01-11
16:10
Ensure the database attached as part of VACUUM can be detached successfully after a malloc() failure. (CVS 2918) file: [cd56995e] check-in: [8c26893c] user: danielk1977 branch: trunk, size: 11060
2006-01-09
06:29
Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893) file: [f5a06809] check-in: [82b81f69] user: danielk1977 branch: trunk, size: 11515
2006-01-06
14:32
Change the OS interface layer to use traditional direct function call implementations instead of the more complicated virtual function table. Omit the asynchronous I/O demo. (CVS 2870) file: [a7301804] check-in: [2529c2e1] user: drh branch: trunk, size: 11479
2005-12-09
20:02
Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) file: [fbfdd396] check-in: [83a59151] user: drh branch: trunk, size: 11483
14:25
Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808) file: [3cd457f9] check-in: [601c3354] user: danielk1977 branch: trunk, size: 11484
2005-12-06
17:48
Allow VACUUM to detach the auxillary database after malloc() fails. (CVS 2804) file: [4d64ce98] check-in: [6824a78b] user: danielk1977 branch: trunk, size: 11315
12:52
Some elements of the new malloc() failure handling. Not all cases work properly yet. Also, library is not threadsafe if malloc() fails right now. (CVS 2800) file: [b9906200] check-in: [e1606658] user: danielk1977 branch: trunk, size: 11289
2005-11-30
03:20
Restructure the OS interface yet again. This time make the OsFile object a virtual base class which is subclassed for unix, windows, and the crash test simulator. Add the new file "os.c" for common os layer code. Move all OS-specific routines into the sqlite3Os structure. (CVS 2795) file: [c9fe2660] check-in: [bd8740d1] user: drh branch: trunk, size: 10532
2005-11-26
00:25
Modify the OS layer so that I/O routines are called through a virtual function table. The os_test.c module has been replaced by test6.c. The crash tests are busted now and need to be fixed. (CVS 2785) file: [3a9d801b] check-in: [1f69aec2] user: drh branch: trunk, size: 10532
2005-11-04
22:03
VACUUM works even on an empty database. Ticket #1512. (CVS 2760) file: [baae8681] check-in: [1b6bf418] user: drh branch: trunk, size: 10528
2005-11-03
02:15
Add the ignore_check_constraints pragma. VACUUM works even on a database that contains table entries that violate check constraints. (CVS 2757) file: [2ed18a4e] check-in: [be83bfee] user: drh branch: trunk, size: 10479
2005-06-07
09:21
Remove SSE vacuum hook. (CVS 2502) file: [829d9e1a] check-in: [59960a59] user: danielk1977 branch: trunk, size: 10553
2005-05-24
12:01
Move a few things around to make building without the parser easier. (CVS 2479) file: [f4eb8fac] check-in: [5fadb464] user: danielk1977 branch: trunk, size: 10894
2005-05-23
13:00
Retain the error string if an error is generated by SSE during a VACUUM. (CVS 2476) file: [f14521a8] check-in: [f7b76d02] user: danielk1977 branch: trunk, size: 10947
2005-05-22
06:49
Allow schema objects beginning with sqlite_ to be created if the SQLITE_WriteSchema flag is set. (CVS 2470) file: [bc1b36a5] check-in: [afc8ce42] user: danielk1977 branch: trunk, size: 10851
2005-04-28
19:03
Add hooks for the SSE extension. (CVS 2449) file: [84a3beba] check-in: [90f4cf2a] user: drh branch: trunk, size: 10481
2005-02-16
03:27
Get vacuum working on database that used to have autoincrement tables but where all such tables have been dropped. Ticket #1121. (CVS 2344) file: [5cf59800] check-in: [8f7c639d] user: drh branch: trunk, size: 10182
2005-02-14
00:25
Cleanup the vacuum bug fixes in version 2.8. (CVS 2327) file: [12de02a8] check-in: [5658da7e] user: drh branch: version_2, size: 9242
00:21
Fix the vacuum bug in version 2.8. Also prepare for release 2.8.16. (CVS 2326) file: [9a59796f] check-in: [0eaebad5] user: drh branch: version_2, size: 9874
2005-02-12
00:19
Fix a problem with VACUUM that can lead to database corruption. (CVS 2323) file: [ccb34e92] check-in: [63894baf] user: drh branch: trunk, size: 10162
2005-02-05
12:48
Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316) file: [4dbe45a5] check-in: [515e5033] user: danielk1977 branch: trunk, size: 9776
2005-02-03
01:08
Get AUTOINCREMENT and VACUUM working together. Ticket #1095. (CVS 2311) file: [14d1c346] check-in: [332a531d] user: drh branch: trunk, size: 9716
2005-01-08
12:42
Fix a problem with auto-vacuum databases and the VACUUM command. Also add "pages read" and "pages written" statistics to the pager layer. (CVS 2183) file: [1a9db113] check-in: [fb3bf68d] user: danielk1977 branch: trunk, size: 9251
2004-11-22
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [705256e1] check-in: [007be591] user: danielk1977 branch: trunk, size: 9142
2004-11-20
19:18
Omit the maximum loop count on the random name chooser in the VACUUM command. Add a comment to explain why this is safe and does not result in an infinite loop. Ticket #1009. (CVS 2122) file: [d061dd90] check-in: [1241086f] user: drh branch: trunk, size: 8989
19:01
Preserve the default_temp_store pragma across VACUUM in version 2.8. (Version 3.0 already does this.) Ticket #1008. (CVS 2120) file: [e6e07446] check-in: [7fa623f2] user: drh branch: version_2, size: 9972
2004-10-30
20:23
Begin adding the ability to remove unused features at compile-time and still have all the tests pass. (CVS 2033) file: [ecb4a2c6] check-in: [2aa506cc] user: drh branch: trunk, size: 8556
2004-09-17
20:02
Get VACUUM working on databases that have reserved bytes at the end of each page. (CVS 1963) file: [257de362] check-in: [90bb3af6] user: drh branch: trunk, size: 8612
2004-09-06
17:24
Fix a naming conflict between sqlite versions 2 and 3. An open sqlite3 connection now *must* be called "sqlite3". You cannot call it "sqlite". This might break existing code. (CVS 1941) file: [819a3f41] check-in: [3ddf5a9d] user: drh branch: trunk, size: 8579
2004-09-05
00:33
Make VACUUM work when the page size is different than the default 1024. Ticket #890. (CVS 1939) file: [c5f11bf2] check-in: [fa82beca] user: drh branch: trunk, size: 8578
2004-09-02
15:27
Fix VACUUM so that it works on files whose name contains '. Ticket #873 (CVS 1930) file: [47bf6837] check-in: [8dd938e4] user: drh branch: trunk, size: 8333
2004-07-26
23:07
Get VACUUM working with UNIQUE indices. Ticket #829. (CVS 1870) file: [9978a576] check-in: [88a19a43] user: drh branch: trunk, size: 8333
2004-07-24
14:35
Fix more problems with deferred execution of CREATE. Still need to do DROP. There is now a memory leak. (CVS 1865) file: [23ec8c5f] check-in: [6db3f122] user: drh branch: trunk, size: 8041
2004-06-30
09:49
Coverage tests for vacuum.c (CVS 1776) file: [b8546f49] check-in: [152e9940] user: danielk1977 branch: trunk, size: 8013
06:30
Add some tests for overlapping SELECT, COMMIT and ROLLBACK commands. (CVS 1774) file: [4aede0a7] check-in: [d256c149] user: danielk1977 branch: trunk, size: 7756
2004-06-26
08:38
Remove the 'nMaster' argument from various pager and btree functions. (CVS 1737) file: [353c7f69] check-in: [4e207209] user: danielk1977 branch: trunk, size: 7030
2004-06-19
09:08
Make sure ATTACH and DETACH fail if a transaction is active. (CVS 1633) file: [fcb93021] check-in: [c49d8bdc] user: danielk1977 branch: trunk, size: 7033
2004-06-15
11:40
Minor bugfixes and test case adjustments for version 2 test cases to work with version 3. (CVS 1598) file: [f9561c80] check-in: [e21a1813] user: danielk1977 branch: trunk, size: 7033
2004-06-04
19:07
Calling sqlite_interrupt() while VACUUM is running should not cause an error. (CVS 1529) file: [36a19aa8] check-in: [1cf94a7c] user: drh branch: version_2, size: 9978
2004-06-03
16:08
Untested updates to support atomic multi-file transactions (CVS 1526) file: [b921eb77] check-in: [d57e5252] user: danielk1977 branch: trunk, size: 6998
2004-05-31
10:01
Add read-transactions to the btree and vdbe. The compiler doesn't invoke them yet. (CVS 1502) file: [c91acc31] check-in: [6b43633a] user: danielk1977 branch: trunk, size: 6995
08:26
Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) file: [16d1b4ab] check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 6992
2004-05-29
10:43
Ensure vacuum handles table names with spaces in them. (CVS 1491) file: [82ce1fc8] check-in: [0a6689be] user: danielk1977 branch: trunk, size: 7309
10:23
Fix vacuum so that it works with blobs. (CVS 1490) file: [53539c1d] check-in: [4feb4b9a] user: danielk1977 branch: trunk, size: 7295
2004-05-22
09:21
Use the new form of the sqlite3_open() API everywhere. (CVS 1437) file: [8734f897] check-in: [b4492173] user: danielk1977 branch: trunk, size: 9822
2004-05-10
20:27
Improvements to testing of sqlite_interrupt. More checking for interrupt inside of VACUUM. (CVS 1344) file: [d34374a2] check-in: [d596f513] user: drh branch: version_2, size: 9971
10:34
Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1338) file: [c134702e] check-in: [2242423e] user: danielk1977 branch: trunk, size: 9783
2004-05-08
08:23
Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) file: [91ba5a23] check-in: [8af6474c] user: danielk1977 branch: trunk, size: 9772
2004-03-10
18:57
Typecast to work around a bug in {quote: CodeWarrior} Studio v9.1. Ticket #654. (CVS 1292) file: [a4e8464c] check-in: [5864fc69] user: drh branch: trunk, size: 9745
2004-02-25
02:33
Fix the return type of sqliteRunVacuum. Ticket #627. (CVS 1271) file: [db5f58cb] check-in: [9c9f4a86] user: drh branch: trunk, size: 9729
2004-02-12
13:02
VACUUM returns SQLITE_INTERRUPT when interrupted. Ticket #593. (CVS 1228) file: [d9e80c2b] check-in: [2fe9f510] user: drh branch: trunk, size: 9765
2004-02-11
09:46
Refactor the interface to the randomness generator. (CVS 1224) file: [717aa6da] check-in: [f2bdccf4] user: drh branch: trunk, size: 9678
2003-12-07
00:24
Make the VACUUM command run out of the VDBE like all other commands. (Ticket #464). Make the VACUUM command work even if there are VIEWs in the SQLITE_MASTER table that come before tables they reference. (Ticket #515) (CVS 1128) file: [77485a64] check-in: [614cbbaf] user: drh branch: trunk, size: 9655
2003-08-15
13:24
Fix a segfault that occurs in the VACUUM command if run on an empty database with the EMPTY_RESULT_CALLBACKS pragma enabled. Ticket #427. (CVS 1073) file: [e4724ead] check-in: [3563e9cf] user: drh branch: trunk, size: 9616
2003-05-13
00:21
Fix a #ifdefs that are used to comment-out the VACUUM command. (CVS 970) file: [08209846] check-in: [22d53240] user: drh branch: trunk, size: 9538
2003-04-25
15:37
Add tests to insure VACUUM works in the presence of I/O errors. Fix some problems that came to light by these tests. (CVS 935) file: [14ac3073] check-in: [8d3e8793] user: drh branch: trunk, size: 9510
13:22
Make VACUUM work even if multiple processes have the database open at once. (CVS 933) file: [44420de0] check-in: [caa96028] user: drh branch: trunk, size: 9401
02:43
Get VACUUM working again - with test cases. Some other minor cleanups. (CVS 931) file: [67199f3d] check-in: [5afb8800] user: drh branch: trunk, size: 10189
2003-04-18
02:31
The VACUUM command is now functioning (again). Need to do more testing. (CVS 916) file: [e24781e3] check-in: [6e948d9a] user: drh branch: trunk, size: 8772
2003-04-15
01:19
Change some variable names and comments in the new in-memory database file implementation. Partial (non-working) implementation of the VACUUM command. (CVS 904) file: [ac65e957] check-in: [e76787f8] user: drh branch: trunk, size: 6063
2003-04-06
21:08
Split the implementation of COPY, PRAGMA, and ATTACH into separate source code files. (CVS 902) file: [6b9ebf0e] check-in: [73359037] user: drh branch: trunk, size: 1095 Added