Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for src/vacuum.c
2025-06-28
| ||
14:36 | [88d8301771] part of check-in [6e1f97d99b] Merge all the latest trunk fixes and enhancements into the reuse-schema branch. (check-in: [6e1f97d99b] user: drh branch: reuse-schema, size: 16171) | |
2025-06-03
| ||
14:08 | [9e6ca9779e] part of check-in [80dfcc313e] Merge latest trunk changes into this branch. (check-in: [80dfcc313e] user: dan branch: mistake, size: 16163) | |
2025-06-01
| ||
16:10 | [1bacdd0a81] part of check-in [42494f85ac] Fix VACUUM so that it works even when ATTACH_WRITE is disabled. (check-in: [42494f85ac] user: drh branch: trunk, size: 16131) | |
2025-04-21
| ||
13:08 | [2310591bdd] part of check-in [b3a526a887] Merge all the latest trunk enhancements into the reuse-schema branch. (check-in: [b3a526a887] user: drh branch: reuse-schema, size: 16113) | |
12:41 | [d19f42d5ee] part of check-in [2866119c75] Merge all recent trunk enhancements into the begin-concurrent branch. (check-in: [2866119c75] user: drh branch: begin-concurrent, size: 16105) | |
2025-04-10
| ||
10:18 | [d580ceb395] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 16073) | |
2025-03-15
| ||
20:35 | [b2486d14ab] part of check-in [271e0373a8] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [271e0373a8] user: drh branch: reuse-schema, size: 16117) | |
20:25 | [96716e5e81] part of check-in [624225499c] Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: [624225499c] user: drh branch: begin-concurrent, size: 16109) | |
2025-03-05
| ||
18:18 | [fbfc3e074c] part of check-in [373ae3f4de] Always ignore comments in the schema of a database, even if SQLITE_DBCONFIG_ENABLE_COMMENTS is turned off. (check-in: [373ae3f4de] user: drh branch: trunk, size: 16077) | |
2024-08-29
| ||
23:24 | [25e407a6dc] part of check-in [b05d30bec1] Merge all the latest trunk enhancements into the begin-concurrent branch. (check-in: [b05d30bec1] user: drh branch: begin-concurrent, size: 16091) | |
17:42 | [38577d6f45] part of check-in [87aa6fc212] Merge all the latest trunk enhancements into the reuse-schema branch. (check-in: [87aa6fc212] user: drh branch: reuse-schema, size: 16099) | |
2024-08-26
| ||
17:35 | [b763b6457b] part of check-in [0f4e65d73a] Randomize the name of the attached database used to do VACUUM. (check-in: [0f4e65d73a] user: drh branch: trunk, size: 16059) | |
2023-06-22
| ||
14:50 | [5bc8928836] part of check-in [905c6c9ddb] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [905c6c9ddb] user: drh branch: reuse-schema, size: 15806) | |
13:28 | [b1dd6d7386] part of check-in [5bd26fea6a] Merge recent trunk enhancements into the begin-concurrent branch. (check-in: [5bd26fea6a] user: drh branch: begin-concurrent, size: 15798) | |
2023-06-14
| ||
13:45 | [4d77f708c0] part of check-in [330219863c] Add SQLITE_DBCONFIG_RANDOM_SCANORDER. This option causes unconstrained table and index scan to happen in a random order, in order to help detect under-constrained queries in applications. Closed because this feature does not add any new capabilities that are not already available with SQLITE_DBCONFIG_REVERSE_SCANORDER, but it does make the behavior non-deterministic, and hence more difficult to test. (check-in: [330219863c] user: drh branch: random-scanorder, size: 15787) | |
2023-06-07
| ||
08:40 | [604fcdaebe] part of check-in [26c1bb4bd9] Add a C-source spell-checking facility. make misspell (on Nix) (check-in: [26c1bb4bd9] user: larrybr branch: spell-check, size: 15766) | |
2022-11-05
| ||
15:31 | [4c46040e48] part of check-in [224eaf2622] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [224eaf2622] user: drh branch: reuse-schema, size: 15806) | |
2022-11-04
| ||
18:33 | [f6e4772955] part of check-in [b361ee983c] Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: [b361ee983c] user: drh branch: begin-concurrent, size: 15798) | |
2022-10-24
| ||
15:51 | [84ce7f01f8] part of check-in [86cb21ca12] Use the same "PRAGMA synchronous" setting for the output of a "VACUUM INTO" as are configured for the database being vacuumed. (check-in: [86cb21ca12] user: dan branch: trunk, size: 15766) | |
2022-09-28
| ||
17:10 | [7d641f22e0] part of check-in [cf0999d4f8] Prototype implementation of "PRAGMA reset_database". This pragma differs from SQLITE_DBCONFIG_RESET_DATABASE in that the pragma only works if the database is reasonably well-formed, whereas the dbconfig works regardless. (check-in: [cf0999d4f8] user: drh branch: reset-database, size: 15791) | |
2022-05-10
| ||
13:06 | [50f980eee4] part of check-in [9f6d6e6135] Merge all recent trunk changes into the reuse-schema branch. (check-in: [9f6d6e6135] user: drh branch: reuse-schema, size: 15500) | |
12:00 | [5b7888f917] part of check-in [f65bd76760] Merge recent trunk enhancements into the begin-concurrent branch. (check-in: [f65bd76760] user: drh branch: begin-concurrent, size: 15492) | |
2022-05-06
| ||
22:29 | [bb346170b0] part of check-in [dac6d87c71] Perserve the requested reserved-bytes size for the database file when doing a VACUUM. (check-in: [dac6d87c71] user: drh branch: trunk, size: 15460) | |
2021-11-09
| ||
15:06 | [72867c7404] part of check-in [2d0c8f3099] Merge all recent trunk enhancements into the begin-concurrent branch. (check-in: [2d0c8f3099] user: drh branch: begin-concurrent, size: 15441) | |
2021-10-29
| ||
14:04 | [97424abbd3] part of check-in [7623132efe] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [7623132efe] user: drh branch: reuse-schema, size: 15449) | |
13:10 | [6c38ddc52f] part of check-in [efc7e8c99a] Allow "VACUUM INTO" to change the page_size of a database even if the original database is in WAL mode. Enhancement suggested by forum post 033f2c9d1f. (check-in: [efc7e8c99a] user: drh branch: trunk, size: 15409) | |
2021-08-03
| ||
16:31 | [a02ce4cb7c] part of check-in [8d806cf93c] Merge recent trunk enhancements into the begin-concurrent branch. (check-in: [8d806cf93c] user: drh branch: begin-concurrent, size: 15425) | |
2021-07-09
| ||
13:29 | [344acf0354] part of check-in [0e968f9de3] Merge latest trunk changes into this branch. (check-in: [0e968f9de3] user: dan branch: reuse-schema, size: 15433) | |
2021-06-22
| ||
18:32 | [454973a59f] part of check-in [48fdec22c9] Add the sqlite3_changes64() and sqlite3_total_changes64() API functions. (check-in: [48fdec22c9] user: dan branch: trunk, size: 15393) | |
2020-11-26
| ||
11:37 | [9d6ac090ff] part of check-in [ddb97eeef7] Update this branch with latest changes from trunk. (check-in: [ddb97eeef7] user: dan branch: begin-concurrent, size: 15425) | |
2020-09-04
| ||
17:40 | [724188c5af] part of check-in [ca8deb44c7] Update this branch with latest changes from trunk. (check-in: [ca8deb44c7] user: dan branch: reuse-schema, size: 15433) | |
2020-08-25
| ||
19:09 | [492422c146] part of check-in [ad195e3dd8] Add support for the sqlite3_txn_state() interface. (check-in: [ad195e3dd8] user: drh branch: trunk, size: 15393) | |
2020-08-11
| ||
14:55 | [55537753cf] part of check-in [b1a77b7ead] Merge all changes since the 3.32.0 release into the reuse-schema branch. (check-in: [b1a77b7ead] user: drh branch: reuse-schema, size: 15405) | |
2020-07-30
| ||
19:19 | [4f586072e5] part of check-in [e8a6651539] Merge latest trunk changes into this branch. (check-in: [e8a6651539] user: dan branch: begin-concurrent, size: 15397) | |
2020-07-16
| ||
20:10 | [c32e7add30] part of check-in [24eead9204] Allow BEGIN CONCURRENT transactions to contain schema modifications. However, this causes them to conflict with all other transactions. (check-in: [24eead9204] user: dan branch: mistake, size: 15404) | |
2020-06-19
| ||
13:33 | [1c4f8e2f39] part of check-in [9536fa0ae0] Further refactoring of the schema table name. (check-in: [9536fa0ae0] user: drh branch: trunk, size: 15365) | |
2020-06-15
| ||
20:27 | [b196258ea3] part of check-in [61782a7ae3] Provide "sqlite_schema" as an alternative name to the table that holds the database schema. (check-in: [61782a7ae3] user: drh branch: trunk, size: 15365) | |
2020-05-18
| ||
15:41 | [28f9a2430b] part of check-in [9e4a7b3ed8] Merge latest trunk changes into this branch. (check-in: [9e4a7b3ed8] user: dan branch: begin-concurrent, size: 15404) | |
2020-05-16
| ||
19:00 | [593bdeaa13] part of check-in [5af4abe98c] Merge trunk enhancements in the reuse-schema branch. (Actual date of this check-in is 2020-05-18.) (check-in: [5af4abe98c] user: drh branch: reuse-schema, size: 15412) | |
2020-05-07
| ||
01:56 | [de9780b89f] part of check-in [99749d4fd4] Fix the handling of reserve-bytes so that the maximum value of 255 can be used. (check-in: [99749d4fd4] user: drh branch: trunk, size: 15372) | |
2020-04-20
| ||
15:18 | [f25d3b3968] part of check-in [abc1aad74f] The SQLITE_TESTCTRL_RESERVE operator is removed. In its place is the more general SQLITE_FCNTL_RESERVE_BYTES which is an API and which can operator on more than just the main schema. (check-in: [abc1aad74f] user: drh branch: trunk, size: 15373) | |
2020-04-09
| ||
18:29 | [b6a321f6c6] part of check-in [92f71a88c4] Merge recent trunk enhancements into the begin-concurrent branch. (check-in: [92f71a88c4] user: drh branch: begin-concurrent, size: 15403) | |
2020-02-27
| ||
15:20 | [e924c7ba95] part of check-in [3f5650aae6] Merge latest trunk changes into this branch. (check-in: [3f5650aae6] user: dan branch: reuse-schema, size: 15411) | |
2020-02-07
| ||
01:12 | [813b510ba8] part of check-in [5a877221ce] Simplify the code by removing the unsupported and undocumented SQLITE_HAS_CODEC compile-time option (check-in: [5a877221ce] user: drh branch: trunk, size: 15371) | |
2019-05-14
| ||
22:25 | [5b9b4771ff] part of check-in [018f3199b9] Merge all the latest trunk enhancements into the reuse-schema branch. (check-in: [018f3199b9] user: drh branch: reuse-schema, size: 15730) | |
21:51 | [0bbe81da32] part of check-in [5d3a6e18d4] Merge the latest trunk enhancements into begin-concurrent. (check-in: [5d3a6e18d4] user: drh branch: begin-concurrent, size: 15722) | |
2019-04-23
| ||
22:00 | [82dcec9e7b] part of check-in [930842470d] Make no atttempt to generate VDBE code for VACUUM after a syntax error. (check-in: [930842470d] user: drh branch: trunk, size: 15690) | |
2019-04-15
| ||
15:35 | [36b6328b64] part of check-in [5c6c9e7f6f] Merge recent changes from trunk into reuse-schema (check-in: [5c6c9e7f6f] user: drh branch: reuse-schema, size: 15686) | |
14:59 | [247d5d956b] part of check-in [7c328e8894] Merge the latest enhancements from trunk. (check-in: [7c328e8894] user: drh branch: begin-concurrent, size: 15678) | |
2019-04-04
| ||
18:20 | [72690ccb68] part of check-in [02ebc60b9b] Minor fixes to requirements marks. (check-in: [02ebc60b9b] user: drh branch: trunk, size: 15646) | |
15:25 | [d07bc40258] part of check-in [9cac5ac145] 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. (check-in: [9cac5ac145] user: drh branch: trunk, size: 15596) | |
14:00 | [b26da99ec5] part of check-in [13a0ea6466] Only preserve rowid values for VACUUM INTO. Keep the legacy behavior of renumbering rowids for ordinary VACUUM. (check-in: [13a0ea6466] user: drh branch: trunk, size: 15641) | |
2019-03-26
| ||
12:07 | [146227098f] part of check-in [774d0d5288] Merge recent enhancements from trunk. (check-in: [774d0d5288] user: drh branch: begin-concurrent, size: 15573) | |
2019-03-20
| ||
16:03 | [04b2721354] part of check-in [4cd20ca677] Merge latest trunk changes into this branch. (check-in: [4cd20ca677] user: dan branch: reuse-schema, size: 15581) | |
2019-03-19
| ||
20:42 | [532553ee1d] part of check-in [55be6d0a9f] Enhance the VACUUM INTO command so that it works on read-only databases. (check-in: [55be6d0a9f] user: drh branch: trunk, size: 15541) | |
2019-02-05
| ||
19:51 | [7dbed4a756] part of check-in [c089cc4fbe] Merge latest trunk into this branch. (check-in: [c089cc4fbe] user: dan branch: reuse-schema, size: 15330) | |
2019-01-26
| ||
16:34 | [c3b29ca1fa] part of check-in [d536be698d] Roll back the transaction if a write statement fails with OE_Abort but there is no open statement transaction. (check-in: [d536be698d] user: dan branch: rollback-abort, size: 15404) | |
2019-01-02
| ||
16:08 | [b95f6ab523] part of check-in [5bf212f1a7] Merge latest trunk changes into this branch. (check-in: [5bf212f1a7] user: dan branch: begin-concurrent, size: 15322) | |
14:34 | [a9f389f415] part of check-in [6c6fb1c6ea] Raise an error if the argument to VACUUM INTO is an identifier. (check-in: [6c6fb1c6ea] user: drh branch: trunk, size: 15290) | |
2018-12-15
| ||
20:59 | [ae2152420b] part of check-in [06bb80eeb8] Merge latest wal2 changes into this branch. (check-in: [06bb80eeb8] user: dan branch: begin-concurrent-wal2, size: 15268) | |
2018-12-08
| ||
00:43 | [3ffe64ecfc] part of check-in [af172b53b4] Allow the INTO clause of VACUUM to be a text-valued expression. (check-in: [af172b53b4] user: drh branch: vacuum-into, size: 15236) | |
2018-12-07
| ||
23:48 | [5d49497308] part of check-in [92f70e0fa3] Do not allow VACUUM INTO into a file that already exists. (check-in: [92f70e0fa3] user: drh branch: vacuum-into, size: 14775) | |
20:40 | [7b74a106ec] part of check-in [93d92a0a5d] Merge the VACUUM simplification from trunk. (check-in: [93d92a0a5d] user: drh branch: vacuum-into, size: 14495) | |
20:26 | [b25dbace5b] part of check-in [a92c398fc5] Remove a line of code from VACUUM that is no longer needed, due to the change that allows ATTACH to run within a transaction. (check-in: [a92c398fc5] user: drh branch: trunk, size: 14102) | |
17:28 | [76b92b5d6a] part of check-in [036e3320a4] Prototype implementation for the VACUUM INTO command. (check-in: [036e3320a4] user: drh branch: vacuum-into, size: 14818) | |
2018-12-06
| ||
17:06 | [c67085526f] part of check-in [53d3b169d8] 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. (check-in: [53d3b169d8] user: drh branch: trunk, size: 14425) | |
16:50 | [675a4bdae4] part of check-in [9c6dbcfab5] When saving off the value of sqlite3.flags, take care to preserve all 64 bits. (check-in: [9c6dbcfab5] user: drh branch: trunk, size: 14420) | |
2018-11-26
| ||
07:21 | [8747a99e06] part of check-in [28a615a2e0] Merge latest trunk changes into this branch. (check-in: [28a615a2e0] user: dan branch: begin-concurrent, size: 14452) | |
2018-11-17
| ||
18:45 | [87907c331e] part of check-in [9fdd186897] Merge latest trunk changes into this branch. (check-in: [9fdd186897] user: dan branch: reuse-schema1, size: 14460) | |
2018-11-06
| ||
19:26 | [836cadc922] part of check-in [a1d6c6712c] 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. (check-in: [a1d6c6712c] user: drh branch: read-only-shadow, size: 14420) | |
2018-10-30
| ||
00:06 | [3ff33a6736] part of check-in [3afec26014] In the VACUUM command, defer setting writable_schema until after it has been determined that the schema is not corrupt. (check-in: [3afec26014] user: drh branch: robust-against-damaged-db, size: 14396) | |
2018-10-08
| ||
18:58 | [6da236d489] part of check-in [2ac72114a1] Merge latest trunk changes into this branch. (check-in: [2ac72114a1] user: dan branch: reuse-schema, size: 14422) | |
2018-06-06
| ||
17:03 | [4879e47105] part of check-in [d7299bfeb1] Merge changes from trunk, including all the 3.24.0 changes plus some later enhancements. (check-in: [d7299bfeb1] user: drh branch: begin-concurrent, size: 14414) | |
16:28 | [36e7d21a20] part of check-in [a10662aa91] Change sqlite3BtreeBeginTrans() to return the BTREE_SCHEMA_COOKIE, for a small speed improvement when starting new transactions. (check-in: [a10662aa91] user: drh branch: trunk, size: 14382) | |
2018-05-15
| ||
11:45 | [162c629cde] part of check-in [ae86cf60b6] Merge latest trunk changes with this branch. (check-in: [ae86cf60b6] user: dan branch: begin-concurrent, size: 14411) | |
2018-05-03
| ||
21:51 | [37730af754] part of check-in [260fc69653] 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. (check-in: [260fc69653] user: drh branch: trunk, size: 14379) | |
2018-05-02
| ||
15:00 | [593498d6d1] part of check-in [ab0d99d0b5] 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. (check-in: [ab0d99d0b5] user: drh branch: trunk, size: 14136) | |
2018-03-02
| ||
17:40 | [f0b8302219] part of check-in [36801effa9] Merge latest trunk changes into this branch. (check-in: [36801effa9] user: dan branch: begin-concurrent, size: 14144) | |
2018-02-12
| ||
13:30 | [762ee9bbf8] part of check-in [27754b74dd] 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. (check-in: [27754b74dd] user: drh branch: trunk, size: 14112) | |
2017-08-09
| ||
20:35 | [c31a0fe4ca] part of check-in [a625698048] Add experimental sqlite3_open_v2() flag SQLITE_OPEN_REUSE_SCHEMA. For sharing identical in-memory schema objects between connections. (check-in: [a625698048] user: dan branch: reuse-schema, size: 14097) | |
2017-08-01
| ||
13:54 | [07eec96f82] part of check-in [aafe1fec80] Merge recent enhancements from trunk. (check-in: [aafe1fec80] user: drh branch: begin-concurrent, size: 14089) | |
2017-07-26
| ||
19:59 | [90839322fd] part of check-in [3808a00f06] Add the new sqlite3.mDbFlags field. Factor out bits of sqlite3.flags that do not interact with PRAGMA statements into sqlite3.mDbFlags. (check-in: [3808a00f06] user: drh branch: trunk, size: 14057) | |
2017-07-20
| ||
17:47 | [ab48f1d3aa] part of check-in [213c61cb82] Merge all the latest trunk enhancements. (check-in: [213c61cb82] user: drh branch: begin-concurrent, size: 13963) | |
2017-06-16
| ||
13:43 | [874c0f2f15] part of check-in [1169384934] Prevent pagesize changes on VACUUM in encrypted databases even when running the VACUUM on an attached database. (check-in: [1169384934] user: drh branch: trunk, size: 13931) | |
2017-03-24
| ||
15:09 | [8aa1db0b70] part of check-in [fd5676fe7f] Merge all recent enhancements from trunk. (check-in: [fd5676fe7f] user: drh branch: begin-concurrent, size: 13961) | |
2017-02-18
| ||
13:47 | [1fe4555cd8] part of check-in [491814272d] Add the SQLITE_BUG_COMPATIBLE_20160819 compile-time option to omit the error message when an unrecognized argument is provided to the VACUUM command. (check-in: [491814272d] user: drh branch: trunk, size: 13929) | |
2017-01-09
| ||
06:33 | [ebcf45799c] part of check-in [d0e212d08f] Upgrade this branch to 3.16 plus the various fixes that appeared after its release. (check-in: [d0e212d08f] user: dan branch: begin-concurrent, size: 13363) | |
2016-11-02
| ||
14:50 | [33c174b288] part of check-in [3028845329] 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. (check-in: [3028845329] user: dan branch: trunk, size: 13331) | |
2016-08-19
| ||
15:12 | [913970b9d8] part of check-in [ad35ef1162] Disable row counting on queries run while doing a VACUUM. (check-in: [ad35ef1162] user: drh branch: vacuum-attached-db, size: 13314) | |
14:20 | [0fecf4ba5a] part of check-in [29d63059b4] 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. (check-in: [29d63059b4] user: drh branch: vacuum-attached-db, size: 13277) | |
2016-08-18
| ||
14:33 | [f6f10c88f8] part of check-in [92a22f0134] 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. (check-in: [92a22f0134] user: drh branch: zDbSName, size: 14172) | |
2016-08-11
| ||
19:12 | [ca88e6d3f5] part of check-in [d9f8918c5b] Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. (check-in: [d9f8918c5b] user: drh branch: begin-concurrent, size: 14201) | |
2016-07-26
| ||
04:49 | [9dd2f5d276] part of check-in [c0e7d98ef2] Copy the cache_spill setting from the main database over to the vacuum_db transient database when running a VACUUM. (check-in: [c0e7d98ef2] user: drh branch: trunk, size: 14169) | |
2016-07-25
| ||
22:40 | [7949183a9c] part of check-in [b78d99548a] In the VACUUM command, set the cache_size of the transient vacuum_db database to be the same as the database being vacuumed. (check-in: [b78d99548a] user: drh branch: trunk, size: 14099) | |
18:50 | [d60b11b2fe] part of check-in [68ecd8e042] Add the experimental SQLITE_VACUUM_CACHE_SIZE macro. (check-in: [68ecd8e042] user: drh branch: apple-osx, size: 14171) | |
2016-07-13
| ||
23:18 | [544ec90a66] part of check-in [f33526a341] Legacy tests now passing. (check-in: [f33526a341] user: drh branch: sqlite3_trace_v2, size: 14032) | |
22:55 | [459ff7cb3c] part of check-in [cb0062feb0] First cut at implementing the new sqlite3_trace_v2() interface. (check-in: [cb0062feb0] user: drh branch: sqlite3_trace_v2, size: 14032) | |
2016-03-16
| ||
19:34 | [c1a94413f8] part of check-in [a7978ab6d2] Merge the latest enhancements from trunk. (check-in: [a7978ab6d2] user: drh branch: begin-concurrent, size: 14078) | |
2016-02-13
| ||
23:43 | [feb1eabb20] part of check-in [6a9c4a3ebf] Enhance ability to debug out-of-memory errors. (check-in: [6a9c4a3ebf] user: mistachkin branch: noMemBkpt, size: 14046) | |
2015-08-24
| ||
19:56 | [983cc37547] part of check-in [ba1ab858e2] Change "BEGIN UNLOCKED" to "BEGIN CONCURRENT". (check-in: [ba1ab858e2] user: dan branch: begin-concurrent, size: 14068) | |
2015-08-21
| ||
20:11 | [d35c7291e9] part of check-in [53aaeea6c9] Fix many minor issues in the unlocked transaction code. (check-in: [53aaeea6c9] user: dan branch: begin-concurrent, size: 14066) | |
2015-07-27
| ||
19:31 | [4e7e18d889] part of check-in [8079421604] Add an experimental "BEGIN UNLOCKED" command. (check-in: [8079421604] user: dan branch: begin-concurrent, size: 14057) | |
2015-04-01
| ||
18:20 | [2ddd5cad2a] part of check-in [e403460b96] 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. (check-in: [e403460b96] user: dan branch: sorter-opt, size: 14036) | |
2015-02-21
| ||
00:19 | [9460b9de7b] part of check-in [28c2b72628] 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. (check-in: [28c2b72628] user: drh branch: trunk, size: 13887) | |
2014-11-07
| ||
13:24 | [9b30ec7293] part of check-in [94c564da4c] Fix harmless typos in comments. (check-in: [94c564da4c] user: drh branch: trunk, size: 13880) | |
2014-09-06
| ||
16:39 | [59f03f92bc] part of check-in [e62aab5e92] Fix typos in comments. No code changes. (check-in: [e62aab5e92] user: peter.d.reid branch: trunk, size: 13879) | |
2013-10-23
| ||
16:03 | [3728d74919] part of check-in [579815fff1] Get VACUUM and the xfer optimization working with WITHOUT ROWID. (check-in: [579815fff1] user: drh branch: omit-rowid, size: 13878) | |
2013-09-30
| ||
11:01 | [f313bc9712] part of check-in [94c914e3fa] Update and modernize an obsolete comment associated with VACUUM. No changes to code. (check-in: [94c914e3fa] user: drh branch: trunk, size: 13854) | |
2013-06-27
| ||
23:54 | [d9c5759f4c] part of check-in [14f7969634] Refactor names of fields in the sqlite3 object: "activeVdbeCnt" becomes "nVdbeActive". Related fields becomes "nVdbeRead", "nVdbeWrite", and "nVdbeExec". (check-in: [14f7969634] user: drh branch: trunk, size: 12657) | |
2013-05-01
| ||
20:36 | [ddf21cc957] part of check-in [4a190bea18] Preserve the application-ID across VACUUM. Updates to the magic number file. (check-in: [4a190bea18] user: drh branch: application-id, size: 12659) | |
2012-10-15
| ||
18:02 | [2727bdd088] part of check-in [629a42d47a] Hold the mutex on the shared-cache for the duration of a VACUUM operation. (check-in: [629a42d47a] user: dan branch: trunk, size: 12588) | |
2012-05-15
| ||
18:28 | [587a52bb88] part of check-in [aa0c3493d3] 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. (check-in: [aa0c3493d3] user: drh branch: shared-schema, size: 12556) | |
2012-02-28
| ||
17:57 | [bfd53f9bd2] part of check-in [16330a2f72] Fix spurious errors that may occur if an empty database is opened and then initialized as a WAL database by a second connection. (check-in: [16330a2f72] user: dan branch: trunk, size: 12552) | |
2011-10-07
| ||
16:57 | [0c0ba22423] part of check-in [1da87fcdac] 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. (check-in: [1da87fcdac] user: dan branch: trunk, size: 12282) | |
2011-09-30
| ||
12:01 | [297f39745e] part of check-in [9ddfe1e413] Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690]. (check-in: [9ddfe1e413] user: dan branch: trunk, size: 12460) | |
2011-04-04
| ||
23:08 | [05513dca03] part of check-in [2aff1b0ca8] Add a comment to the VACUUM implementation explaining when all schemas are reset and not just the "main" schema. (check-in: [2aff1b0ca8] user: drh branch: schema-parse-refactor, size: 12428) | |
2011-04-02
| ||
16:28 | [3b2b0998f4] part of check-in [6a8ad6e31e] 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. (check-in: [6a8ad6e31e] user: drh branch: schema-parse-refactor, size: 12340) | |
2010-09-24
| ||
09:32 | [924bd1bcee] part of check-in [c1ebcacd9b] Add experimental branch disallowing VACUUM when there are one or more active SQL statements. (check-in: [c1ebcacd9b] user: dan branch: experimental, size: 12338) | |
2010-06-11
| ||
17:01 | [241a838672] part of check-in [95cc3f6fde] Refactor and simplify the logic used to change journalmode. (check-in: [95cc3f6fde] user: drh branch: trunk, size: 12199) | |
2010-05-10
| ||
14:10 | [b17355fc10] part of check-in [6ecdc7ba2b] If an ATTACH command fails due to OP_JournalMode but still attaches the database, make sure VACUUM still detaches it when done. (check-in: [6ecdc7ba2b] user: drh branch: trunk, size: 12203) | |
2010-05-05
| ||
04:11 | [90a32e098c] part of check-in [208e7d5d3a] 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. (check-in: [208e7d5d3a] user: drh branch: trunk, size: 12042) | |
03:39 | [15db45c738] part of check-in [58a1a59be8] Do not attempt to modify the page_size when running VACUUM on a WAL database. (check-in: [58a1a59be8] user: drh branch: trunk, size: 11997) | |
2010-04-24
| ||
14:02 | [8e7d9a6fd0] part of check-in [0291ed974d] 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. (check-in: [0291ed974d] user: drh branch: trunk, size: 11763) | |
2010-03-03
| ||
00:02 | [137a2f494e] part of check-in [e534223435] 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] (check-in: [e534223435] user: drh branch: branch-3.6.22, size: 11716) | |
2010-03-02
| ||
23:34 | [b1d542c891] part of check-in [9daf4e7d07] When TEMP files are in memory, also put the massive TEMP file used by the VACUUM command in memory. (check-in: [9daf4e7d07] user: drh branch: trunk, size: 11740) | |
2010-02-25
| ||
02:32 | [1f3f6d608c] part of check-in [46f406b202] 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]. (check-in: [46f406b202] user: drh branch: branch-3.6.22, size: 11622) | |
2010-02-24
| ||
19:23 | [deb50c41c3] part of check-in [69a493182f] 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. (check-in: [69a493182f] user: drh branch: trunk, size: 11646) | |
2010-01-12
| ||
23:54 | [28ee5a4963] part of check-in [0209f17180] Make sure internal queries are well ordered, even when the reverse_unordered_selects pragma is in effect. Ticket [eb942c64a157]. (check-in: [0209f17180] user: drh branch: trunk, size: 11057) | |
2009-12-17
| ||
03:49 | [db6415fd0f] part of check-in [69a1348a3c] Disable trace when recursively running commands while vacuuming. (check-in: [69a1348a3c] user: drh branch: trunk, size: 11033) | |
2009-11-10
| ||
01:30 | [03309a08d5] part of check-in [f6c045f649] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f649] user: drh branch: trunk, size: 10890) | |
2009-10-20
| ||
15:01 | [48e1282bbd] part of check-in [0bbd8d72ec] 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. (check-in: [0bbd8d72ec] user: drh branch: trunk, size: 10955) | |
2009-10-16
| ||
14:55 | [f234752090] part of check-in [174477bca0] Experimental fix for [f777251dc7]. This may be changed yet. (check-in: [174477bca0] user: dan branch: trunk, size: 10930) | |
2009-09-21
| ||
16:06 | [869d08eaab] part of check-in [fb6ceed388] Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. (check-in: [fb6ceed388] user: dan branch: trunk, size: 10608) | |
2009-07-02
| ||
07:47 | [3fe0eebea6] part of check-in [e3c055f167] 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) (check-in: [e3c055f167] user: danielk1977 branch: trunk, size: 10455) | |
2009-06-03
| ||
11:25 | [0e14f371ea] part of check-in [6dbf4eca00] 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) (check-in: [6dbf4eca00] user: danielk1977 branch: trunk, size: 10513) | |
2009-05-30
| ||
10:46 | [981686c910] part of check-in [874295ce71] In vacuum.c use "PagerIsMemdb(X)" instead of "PagerFile(X)->pMethods==0". (CVS 6692) (check-in: [874295ce71] user: danielk1977 branch: trunk, size: 10437) | |
2009-05-05
| ||
17:37 | [e8d1780043] part of check-in [866284654c] Changes to vacuum.c to facilitate full coverage testing. (CVS 6606) (check-in: [866284654c] user: drh branch: trunk, size: 10532) | |
2009-04-02
| ||
20:16 | [07121a727b] part of check-in [85e6a4740d] 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) (check-in: [85e6a4740d] user: drh branch: trunk, size: 10345) | |
2009-02-03
| ||
16:51 | [4929a585ef] part of check-in [663479b417] Commit first version of the 'backup' feature. (CVS 6241) (check-in: [663479b417] user: danielk1977 branch: trunk, size: 10345) | |
2009-01-22
| ||
23:04 | [b78c2bfdef] part of check-in [75cc709be4] 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) (check-in: [75cc709be4] user: drh branch: trunk, size: 10373) | |
2008-11-17
| ||
19:18 | [383d6297bd] part of check-in [8009220c36] Modifications to avoid unsigned/signed comparisons in various files. (CVS 5914) (check-in: [8009220c36] user: danielk1977 branch: trunk, size: 10402) | |
2008-08-26
| ||
21:07 | [fd77433d0c] part of check-in [226a905678] 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) (check-in: [226a905678] user: drh branch: trunk, size: 10408) | |
2008-08-23
| ||
16:17 | [a5b10ae21f] part of check-in [cb869946d6] 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) (check-in: [cb869946d6] user: danielk1977 branch: trunk, size: 10170) | |
2008-07-08
| ||
19:34 | [ef34282800] part of check-in [8ed04b1e26] Completely rework the sqlite3SetString() primitive so that it honors the SQLITE_LIMIT_LENGTH and avoids the use of strlen(). (CVS 5374) (check-in: [8ed04b1e26] user: drh branch: trunk, size: 10052) | |
2008-06-17
| ||
01:03 | [14eb21b480] part of check-in [d49e502001] Do not allow a VACUUM to try to change the page_size on an encrypted database. (CVS 5225) (check-in: [d49e502001] user: drh branch: trunk, size: 10066) | |
2008-05-21
| ||
13:44 | [a5c289e561] part of check-in [f5d61d7d98] 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) (check-in: [f5d61d7d98] user: drh branch: trunk, size: 9748) | |
2008-04-30
| ||
16:38 | [c3b2b70677] part of check-in [9c8b4babb2] Add comment to speculate when setting journal_mode=OFF on VACUUM does not help performance. No changes to code. (CVS 5071) (check-in: [9c8b4babb2] user: drh branch: trunk, size: 9481) | |
2008-03-20
| ||
11:04 | [3524411bfb] part of check-in [871df0e7c3] 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) (check-in: [871df0e7c3] user: danielk1977 branch: trunk, size: 9084) | |
2008-01-03
| ||
00:01 | [3f34f27880] part of check-in [027875e4d4] 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) (check-in: [027875e4d4] user: drh branch: trunk, size: 8955) | |
2007-12-05
| ||
01:38 | [25ffbd766f] part of check-in [bdfc19e838] 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) (check-in: [bdfc19e838] user: drh branch: trunk, size: 8954) | |
2007-10-20
| ||
20:58 | [a5e51c7737] part of check-in [82b08a3dc2] Use the 2-argument version of substr() in the SQL contained in the VACUUM and ALTER TABLE commands. Ticket #2737. (CVS 4499) (check-in: [82b08a3dc2] user: drh branch: trunk, size: 8872) | |
2007-08-29
| ||
12:31 | [38745037c6] part of check-in [e38ef81b85] Modifications to the malloc failure tests to test transient and persistent failures. (CVS 4321) (check-in: [e38ef81b85] user: danielk1977 branch: trunk, size: 8910) | |
2007-08-24
| ||
11:43 | [5ec133b69e] part of check-in [eb6c98fc10] Remove unnecessary sqlite3MallocDisallow() that was preventing win32 from running. (CVS 4285) (check-in: [eb6c98fc10] user: drh branch: trunk, size: 8858) | |
2007-08-21
| ||
10:44 | [318ccae7c4] part of check-in [fbbd5bda54] Remove unnecessary #includes of "os.h". New mutex implementations. (CVS 4255) (check-in: [fbbd5bda54] user: drh branch: trunk, size: 8913) | |
2007-08-16
| ||
04:30 | [f45bd9d3aa] part of check-in [deb7ecd65f] 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) (check-in: [deb7ecd65f] user: drh branch: trunk, size: 8929) | |
2007-03-27
| ||
16:19 | [8bd895d29e] part of check-in [b24a6e7b02] 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) (check-in: [b24a6e7b02] user: danielk1977 branch: trunk, size: 8942) | |
14:44 | [b74b110773] part of check-in [cbebfb8960] 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) (check-in: [cbebfb8960] user: drh branch: trunk, size: 9260) | |
2007-03-06
| ||
16:03 | [327c6ffa38] part of check-in [302ec76857] Catch an out-of-memory condition in vacuum code. (Bug in (3373)). (CVS 3675) (check-in: [302ec76857] user: danielk1977 branch: trunk, size: 9208) | |
2007-01-03
| ||
23:37 | [b4569b08aa] part of check-in [70a862702d] 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) (check-in: [70a862702d] user: drh branch: trunk, size: 9118) | |
2006-11-18
| ||
20:20 | [b620ffff5a] part of check-in [2fdc147d00] Make sure VACUUM cleans up after itself. Ticket #2071. (CVS 3514) (check-in: [2fdc147d00] user: drh branch: trunk, size: 9118) | |
2006-10-10
| ||
13:07 | [f6a7943f1f] part of check-in [b743429dd5] 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) (check-in: [b743429dd5] user: drh branch: trunk, size: 9036) | |
2006-09-21
| ||
11:02 | [f958275b35] part of check-in [7e618db457] Be more aggressive with the SQLITE_OMIT_VACUUM macro. Saves about 150 bytes of code space. (CVS 3432) (check-in: [7e618db457] user: drh branch: trunk, size: 10693) | |
2006-09-13
| ||
19:21 | [fb65647c36] part of check-in [f4ab546b2e] Remove unused malloc failure test. (Ticket #1976) Also include fixes for other problems discovered while investigating ticket #1976. (CVS 3415) (check-in: [f4ab546b2e] user: drh branch: trunk, size: 10702) | |
2006-09-11
| ||
23:45 | [e2cd47929d] part of check-in [e4fe736cfb] Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) (check-in: [e4fe736cfb] user: drh branch: trunk, size: 10966) | |
11:13 | [5dac7938d7] part of check-in [d5ffef3870] Get VACUUM working with virtual tables. (CVS 3404) (check-in: [d5ffef3870] user: drh branch: trunk, size: 11282) | |
2006-02-24
| ||
02:53 | [5b37d0f436] part of check-in [4b22e4b847] Remove unused parameters on internal APIs. Suppress warnings from CodeWarrior. (CVS 3110) (check-in: [4b22e4b847] user: drh branch: trunk, size: 11005) | |
2006-01-18
| ||
16:51 | [3865673cc6] part of check-in [ac090f2ab3] Use a global variable protected by a mutex instead of thread-specific-data to record malloc() failures. (CVS 2972) (check-in: [ac090f2ab3] user: danielk1977 branch: trunk, size: 11031) | |
2006-01-13
| ||
01:48 | [21a3c7f6f7] part of check-in [a64e8251a6] Add a high-speed version of sqlite3GetVarint32 to vdbe.c for a 3% performance gain. (CVS 2933) (check-in: [a64e8251a6] user: drh branch: trunk, size: 11039) | |
2006-01-11
| ||
16:10 | [cd56995ece] part of check-in [8c26893c65] Ensure the database attached as part of VACUUM can be detached successfully after a malloc() failure. (CVS 2918) (check-in: [8c26893c65] user: danielk1977 branch: trunk, size: 11060) | |
2006-01-09
| ||
06:29 | [f5a068096b] part of check-in [82b81f69c7] Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893) (check-in: [82b81f69c7] user: danielk1977 branch: trunk, size: 11515) | |
2006-01-06
| ||
14:32 | [a7301804d4] part of check-in [2529c2e11f] 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) (check-in: [2529c2e11f] user: drh branch: trunk, size: 11479) | |
2005-12-09
| ||
20:02 | [fbfdd3967f] part of check-in [83a5915155] Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) (check-in: [83a5915155] user: drh branch: trunk, size: 11483) | |
14:25 | [3cd457f91b] part of check-in [601c335463] Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808) (check-in: [601c335463] user: danielk1977 branch: trunk, size: 11484) | |
2005-12-06
| ||
17:48 | [4d64ce98a4] part of check-in [6824a78bc7] Allow VACUUM to detach the auxillary database after malloc() fails. (CVS 2804) (check-in: [6824a78bc7] user: danielk1977 branch: trunk, size: 11315) | |
12:52 | [b990620052] part of check-in [e1606658f1] 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) (check-in: [e1606658f1] user: danielk1977 branch: trunk, size: 11289) | |
2005-11-30
| ||
03:20 | [c9fe266091] part of check-in [bd8740d1ae] 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) (check-in: [bd8740d1ae] user: drh branch: trunk, size: 10532) | |
2005-11-26
| ||
00:25 | [3a9d801b64] part of check-in [1f69aec285] 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) (check-in: [1f69aec285] user: drh branch: trunk, size: 10532) | |
2005-11-04
| ||
22:03 | [baae868128] part of check-in [1b6bf4188e] VACUUM works even on an empty database. Ticket #1512. (CVS 2760) (check-in: [1b6bf4188e] user: drh branch: trunk, size: 10528) | |
2005-11-03
| ||
02:15 | [2ed18a4e9c] part of check-in [be83bfee02] Add the ignore_check_constraints pragma. VACUUM works even on a database that contains table entries that violate check constraints. (CVS 2757) (check-in: [be83bfee02] user: drh branch: trunk, size: 10479) | |
2005-06-07
| ||
09:21 | [829d9e1a6d] part of check-in [59960a5915] Remove SSE vacuum hook. (CVS 2502) (check-in: [59960a5915] user: danielk1977 branch: trunk, size: 10553) | |
2005-05-24
| ||
12:01 | [f4eb8facbf] part of check-in [5fadb464eb] Move a few things around to make building without the parser easier. (CVS 2479) (check-in: [5fadb464eb] user: danielk1977 branch: trunk, size: 10894) | |
2005-05-23
| ||
13:00 | [f14521a803] part of check-in [f7b76d02e0] Retain the error string if an error is generated by SSE during a VACUUM. (CVS 2476) (check-in: [f7b76d02e0] user: danielk1977 branch: trunk, size: 10947) | |
2005-05-22
| ||
06:49 | [bc1b36a56d] part of check-in [afc8ce42b6] Allow schema objects beginning with sqlite_ to be created if the SQLITE_WriteSchema flag is set. (CVS 2470) (check-in: [afc8ce42b6] user: danielk1977 branch: trunk, size: 10851) | |
2005-04-28
| ||
19:03 | [84a3bebac2] part of check-in [90f4cf2ad5] Add hooks for the SSE extension. (CVS 2449) (check-in: [90f4cf2ad5] user: drh branch: trunk, size: 10481) | |
2005-02-16
| ||
03:27 | [5cf5980031] part of check-in [8f7c639da0] Get vacuum working on database that used to have autoincrement tables but where all such tables have been dropped. Ticket #1121. (CVS 2344) (check-in: [8f7c639da0] user: drh branch: trunk, size: 10182) | |
2005-02-14
| ||
00:25 | [12de02a8de] part of check-in [5658da7e5a] Cleanup the vacuum bug fixes in version 2.8. (CVS 2327) (check-in: [5658da7e5a] user: drh branch: version_2, size: 9242) | |
00:21 | [9a59796f3d] part of check-in [0eaebad5a0] Fix the vacuum bug in version 2.8. Also prepare for release 2.8.16. (CVS 2326) (check-in: [0eaebad5a0] user: drh branch: version_2, size: 9874) | |
2005-02-12
| ||
00:19 | [ccb34e92fd] part of check-in [63894baf1b] Fix a problem with VACUUM that can lead to database corruption. (CVS 2323) (check-in: [63894baf1b] user: drh branch: trunk, size: 10162) | |
2005-02-05
| ||
12:48 | [4dbe45a5c4] part of check-in [515e5033a5] Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316) (check-in: [515e5033a5] user: danielk1977 branch: trunk, size: 9776) | |
2005-02-03
| ||
01:08 | [14d1c34623] part of check-in [332a531d06] Get AUTOINCREMENT and VACUUM working together. Ticket #1095. (CVS 2311) (check-in: [332a531d06] user: drh branch: trunk, size: 9716) | |
2005-01-08
| ||
12:42 | [1a9db113a0] part of check-in [fb3bf68d0e] 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) (check-in: [fb3bf68d0e] user: danielk1977 branch: trunk, size: 9251) | |
2004-11-22
| ||
13:35 | [705256e111] part of check-in [007be591b7] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591b7] user: danielk1977 branch: trunk, size: 9142) | |
2004-11-20
| ||
19:18 | [d061dd908a] part of check-in [1241086f23] 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) (check-in: [1241086f23] user: drh branch: trunk, size: 8989) | |
19:01 | [e6e07446bc] part of check-in [7fa623f24a] Preserve the default_temp_store pragma across VACUUM in version 2.8. (Version 3.0 already does this.) Ticket #1008. (CVS 2120) (check-in: [7fa623f24a] user: drh branch: version_2, size: 9972) | |
2004-10-30
| ||
20:23 | [ecb4a2c6f1] part of check-in [2aa506ccb0] Begin adding the ability to remove unused features at compile-time and still have all the tests pass. (CVS 2033) (check-in: [2aa506ccb0] user: drh branch: trunk, size: 8556) | |
2004-09-17
| ||
20:02 | [257de36230] part of check-in [90bb3af6cd] Get VACUUM working on databases that have reserved bytes at the end of each page. (CVS 1963) (check-in: [90bb3af6cd] user: drh branch: trunk, size: 8612) | |
2004-09-06
| ||
17:24 | [819a3f411c] part of check-in [3ddf5a9d1c] 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) (check-in: [3ddf5a9d1c] user: drh branch: trunk, size: 8579) | |
2004-09-05
| ||
00:33 | [c5f11bf25e] part of check-in [fa82becae7] Make VACUUM work when the page size is different than the default 1024. Ticket #890. (CVS 1939) (check-in: [fa82becae7] user: drh branch: trunk, size: 8578) | |
2004-09-02
| ||
15:27 | [47bf6837d3] part of check-in [8dd938e480] Fix VACUUM so that it works on files whose name contains '. Ticket #873 (CVS 1930) (check-in: [8dd938e480] user: drh branch: trunk, size: 8333) | |
2004-07-26
| ||
23:07 | [9978a5760c] part of check-in [88a19a4386] Get VACUUM working with UNIQUE indices. Ticket #829. (CVS 1870) (check-in: [88a19a4386] user: drh branch: trunk, size: 8333) | |
2004-07-24
| ||
14:35 | [23ec8c5f31] part of check-in [6db3f122aa] Fix more problems with deferred execution of CREATE. Still need to do DROP. There is now a memory leak. (CVS 1865) (check-in: [6db3f122aa] user: drh branch: trunk, size: 8041) | |
2004-06-30
| ||
09:49 | [b8546f4921] part of check-in [152e9940b9] Coverage tests for vacuum.c (CVS 1776) (check-in: [152e9940b9] user: danielk1977 branch: trunk, size: 8013) | |
06:30 | [4aede0a704] part of check-in [d256c14943] Add some tests for overlapping SELECT, COMMIT and ROLLBACK commands. (CVS 1774) (check-in: [d256c14943] user: danielk1977 branch: trunk, size: 7756) | |
2004-06-26
| ||
08:38 | [353c7f69db] part of check-in [4e20720984] Remove the 'nMaster' argument from various pager and btree functions. (CVS 1737) (check-in: [4e20720984] user: danielk1977 branch: trunk, size: 7030) | |
2004-06-19
| ||
09:08 | [fcb930215a] part of check-in [c49d8bdc3e] Make sure ATTACH and DETACH fail if a transaction is active. (CVS 1633) (check-in: [c49d8bdc3e] user: danielk1977 branch: trunk, size: 7033) | |
2004-06-15
| ||
11:40 | [f9561c8095] part of check-in [e21a181376] Minor bugfixes and test case adjustments for version 2 test cases to work with version 3. (CVS 1598) (check-in: [e21a181376] user: danielk1977 branch: trunk, size: 7033) | |
2004-06-04
| ||
19:07 | [36a19aa877] part of check-in [1cf94a7c41] Calling sqlite_interrupt() while VACUUM is running should not cause an error. (CVS 1529) (check-in: [1cf94a7c41] user: drh branch: version_2, size: 9978) | |
2004-06-03
| ||
16:08 | [b921eb7788] part of check-in [d57e5252c8] Untested updates to support atomic multi-file transactions (CVS 1526) (check-in: [d57e5252c8] user: danielk1977 branch: trunk, size: 6998) | |
2004-05-31
| ||
10:01 | [c91acc3161] part of check-in [6b43633a96] Add read-transactions to the btree and vdbe. The compiler doesn't invoke them yet. (CVS 1502) (check-in: [6b43633a96] user: danielk1977 branch: trunk, size: 6995) | |
08:26 | [16d1b4ab97] part of check-in [b8ed812c92] Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) (check-in: [b8ed812c92] user: danielk1977 branch: trunk, size: 6992) | |
2004-05-29
| ||
10:43 | [82ce1fc8ec] part of check-in [0a6689be84] Ensure vacuum handles table names with spaces in them. (CVS 1491) (check-in: [0a6689be84] user: danielk1977 branch: trunk, size: 7309) | |
10:23 | [53539c1d1f] part of check-in [4feb4b9a71] Fix vacuum so that it works with blobs. (CVS 1490) (check-in: [4feb4b9a71] user: danielk1977 branch: trunk, size: 7295) | |
2004-05-22
| ||
09:21 | [8734f89742] part of check-in [b449217318] Use the new form of the sqlite3_open() API everywhere. (CVS 1437) (check-in: [b449217318] user: danielk1977 branch: trunk, size: 9822) | |
2004-05-10
| ||
20:27 | [d34374a2d6] part of check-in [d596f513c3] Improvements to testing of sqlite_interrupt. More checking for interrupt inside of VACUUM. (CVS 1344) (check-in: [d596f513c3] user: drh branch: version_2, size: 9971) | |
10:34 | [c134702e02] part of check-in [2242423e31] Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1338) (check-in: [2242423e31] user: danielk1977 branch: trunk, size: 9783) | |
2004-05-08
| ||
08:23 | [91ba5a23ec] part of check-in [8af6474c49] 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) (check-in: [8af6474c49] user: danielk1977 branch: trunk, size: 9772) | |
2004-03-10
| ||
18:57 | [a4e8464c9f] part of check-in [5864fc6937] Typecast to work around a bug in {quote: CodeWarrior} Studio v9.1. Ticket #654. (CVS 1292) (check-in: [5864fc6937] user: drh branch: trunk, size: 9745) | |
2004-02-25
| ||
02:33 | [db5f58cb53] part of check-in [9c9f4a867a] Fix the return type of sqliteRunVacuum. Ticket #627. (CVS 1271) (check-in: [9c9f4a867a] user: drh branch: trunk, size: 9729) | |
2004-02-12
| ||
13:02 | [d9e80c2b36] part of check-in [2fe9f5101c] VACUUM returns SQLITE_INTERRUPT when interrupted. Ticket #593. (CVS 1228) (check-in: [2fe9f5101c] user: drh branch: trunk, size: 9765) | |
2004-02-11
| ||
09:46 | [717aa6da40] part of check-in [f2bdccf4bb] Refactor the interface to the randomness generator. (CVS 1224) (check-in: [f2bdccf4bb] user: drh branch: trunk, size: 9678) | |
2003-12-07
| ||
00:24 | [77485a64a6] part of check-in [614cbbafa1] 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) (check-in: [614cbbafa1] user: drh branch: trunk, size: 9655) | |
2003-08-15
| ||
13:24 | [e4724eade0] part of check-in [3563e9cf9d] 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) (check-in: [3563e9cf9d] user: drh branch: trunk, size: 9616) | |
2003-05-13
| ||
00:21 | [0820984615] part of check-in [22d5324073] Fix a #ifdefs that are used to comment-out the VACUUM command. (CVS 970) (check-in: [22d5324073] user: drh branch: trunk, size: 9538) | |
2003-04-25
| ||
15:37 | [14ac307320] part of check-in [8d3e879349] 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) (check-in: [8d3e879349] user: drh branch: trunk, size: 9510) | |
13:22 | [44420de0f0] part of check-in [caa960289f] Make VACUUM work even if multiple processes have the database open at once. (CVS 933) (check-in: [caa960289f] user: drh branch: trunk, size: 9401) | |
02:43 | [67199f3d62] part of check-in [5afb88008f] Get VACUUM working again - with test cases. Some other minor cleanups. (CVS 931) (check-in: [5afb88008f] user: drh branch: trunk, size: 10189) | |
2003-04-18
| ||
02:31 | [e24781e38d] part of check-in [6e948d9aae] The VACUUM command is now functioning (again). Need to do more testing. (CVS 916) (check-in: [6e948d9aae] user: drh branch: trunk, size: 8772) | |
2003-04-15
| ||
01:19 | [ac65e95785] part of check-in [e76787f877] Change some variable names and comments in the new in-memory database file implementation. Partial (non-working) implementation of the VACUUM command. (CVS 904) (check-in: [e76787f877] user: drh branch: trunk, size: 6063) | |
2003-04-06
| ||
21:08 | Added: [6b9ebf0ef5] part of check-in [73359037ea] Split the implementation of COPY, PRAGMA, and ATTACH into separate source code files. (CVS 902) (check-in: [73359037ea] user: drh branch: trunk, size: 1095) | |