SQLite

All files named ”test/autovacuum.test”
Login

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

History for test/autovacuum.test

2021-10-15
23:02
[00671369bb] part of check-in [bb6f2b8b48] Demostrate a prototype sqlite3_autovacuum_pages() interface. (check-in: [bb6f2b8b48] user: drh branch: autovacuum-pages-callback, size: 20037)
2017-06-08
11:14
[0831cd34e1] part of check-in [b30dfba811] Ensure pointer map entries are always added when a row that does use overflow pages replaces one that does not in an auto-vacuum database. Fix for [fda22108]. (check-in: [b30dfba811] user: dan branch: trunk, size: 20103)
2016-03-14
16:16
[92c24eedbd] part of check-in [1c70aa5c01] Test script changes to support testing the SQLite Encryption Extension. (check-in: [1c70aa5c01] user: drh branch: see-testing, size: 19880)
2013-11-05
13:33
[941892505d] part of check-in [54b2219297] Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 19654)
2013-03-27
19:53
[ad9f74649c] part of check-in [0e3d511927] Modify various test cases so that they work if the file is extended in units of the system page-size. (check-in: [0e3d511927] user: dan branch: two-mappings, size: 19606)
2012-09-15
18:45
[9f22a7733f] part of check-in [cfaa7bc128] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (check-in: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 19653)
2011-08-02
00:57
[fcaf4616ae] part of check-in [9007586fda] Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. (check-in: [9007586fda] user: mistachkin branch: winopen-retry-logic, size: 19638)
2010-07-08
09:44
[bb7c0885e6] part of check-in [f553c8ed04] Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a]. (check-in: [f553c8ed04] user: dan branch: trunk, size: 19666)
2009-04-06
17:50
[25f891bc34] part of check-in [def3a01691] Test cases and minor code changes to increase coverage of btree.c. (CVS 6456) (check-in: [def3a01691] user: danielk1977 branch: trunk, size: 19625)
2008-09-10
10:57
[61260e2574] part of check-in [300a64b725] Fix some test script details so that the test suite runs with an SQLITE_DEFAULT_AUTOVACUUM=2 build. (CVS 5686) (check-in: [300a64b725] user: danielk1977 branch: trunk, size: 18883)
2008-08-02
03:50
[e3428031ad] part of check-in [f1e44eb323] Additional coverage testing. Fix a segfault following OOM in sqltie3_load_extension(). (CVS 5523) (check-in: [f1e44eb323] user: drh branch: trunk, size: 18860)
2007-04-07
15:03
[4339e66003] part of check-in [0af764a026] For filesystem databases, do not store a list of pages in the statement journal in main memory. (CVS 3825) (check-in: [0af764a026] user: danielk1977 branch: trunk, size: 18416)
2007-04-02
14:19
[05f528c3bf] part of check-in [7313688bd0] Cover an extra case in sqlite3PagerMovepage(). (CVS 3796) (check-in: [7313688bd0] user: danielk1977 branch: trunk, size: 18127)
2006-08-12
12:33
[5f5d843ff8] part of check-in [0f667c4abd] Require whitespace or punctuation between a numeric literal and an identifier or keyword. Ticket #1912. (CVS 3345) (check-in: [0f667c4abd] user: drh branch: trunk, size: 16392)
2006-06-20
11:01
[493ba914a0] part of check-in [c6ea353bd9] Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) (check-in: [c6ea353bd9] user: danielk1977 branch: trunk, size: 16399)
2006-03-24
03:36
[eee7e67d80] part of check-in [1c582dd113] Make sure the rootpage values in the symbol table are correctly updated when dropping tables and indices in autocommit mode. Ticket #1728. (CVS 3150) (check-in: [1c582dd113] user: drh branch: trunk, size: 16325)
2006-03-23
23:29
[12bb130cf7] part of check-in [21446df642] Get autovacuum and in-memory databases working together. Ticket #1727. (CVS 3148) (check-in: [21446df642] user: drh branch: trunk, size: 15315)
2006-01-16
16:24
[0dd22b0e1f] part of check-in [c058f483a5] Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) (check-in: [c058f483a5] user: danielk1977 branch: trunk, size: 15107)
2005-09-16
09:52
[9471d58a08] part of check-in [9115e0621d] Fix an auto-vacuum problem with the PENDING_BYTE page. Also link the Tcl variable sqlite_pending_byte to the internal pending-byte location when in test mode. (CVS 2700) (check-in: [9115e0621d] user: danielk1977 branch: trunk, size: 15096)
2005-09-08
10:37
[d2d0b2b86f] part of check-in [21adf4bd99] The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) (check-in: [21adf4bd99] user: drh branch: trunk, size: 14892)
2005-03-09
13:09
[cf2719b176] part of check-in [64c4c717d3] Fix a file corruption bug in CREATE INDEX in auto-vacuum databases. (CVS 2368) (check-in: [64c4c717d3] user: danielk1977 branch: trunk, size: 14904)
2005-01-24
10:25
[8ba29face8] part of check-in [d5233e0747] Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) (check-in: [d5233e0747] user: danielk1977 branch: trunk, size: 14151)
2005-01-21
03:12
[a87871f297] part of check-in [bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab14] user: danielk1977 branch: trunk, size: 14151)
2005-01-15
12:45
[a15021f685] part of check-in [0ae29538cc] Enhance the performance of auto-vacuum databases by reducing the number of pointer-map entries written during tree balancing. Also fix bugs in balance_quick(). (CVS 2216) (check-in: [0ae29538cc] user: danielk1977 branch: trunk, size: 14144)
2004-11-22
05:26
[a4e8da39a6] part of check-in [9df837c039] Have tests pass when SQLITE_OMIT_MEMORYDB is defined. (CVS 2131) (check-in: [9df837c039] user: danielk1977 branch: trunk, size: 14123)
2004-11-14
04:04
[d0517eb9fa] part of check-in [59a0a8b7ce] Changes toward reducing code size when SQLITE_OMIT_UTF16 is enabled. (CVS 2099) (check-in: [59a0a8b7ce] user: drh branch: trunk, size: 14135)
2004-11-10
15:27
[e52b8fab3b] part of check-in [0747b55882] Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087) (check-in: [0747b55882] user: danielk1977 branch: trunk, size: 14057)
2004-11-08
12:32
[dbc4a52e44] part of check-in [9d4a60bbd6] A few more auto-vacuum tests. (CVS 2079) (check-in: [9d4a60bbd6] user: danielk1977 branch: trunk, size: 13877)
2004-11-05
15:45
[e70d46d598] part of check-in [b9d5f007fc] Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067) (check-in: [b9d5f007fc] user: danielk1977 branch: trunk, size: 9379)
12:58
[7878efa672] part of check-in [44a015b3a3] Auto-vacuum bug: Don't set meta(3) to a pointer-map page number when deleting a table. (CVS 2066) (check-in: [44a015b3a3] user: danielk1977 branch: trunk, size: 8353)
12:27
[b2ba86ec6a] part of check-in [4e2433378e] Fix allocation of tables in an auto-vacuum database when the required root-page is on the free-list. (CVS 2065) (check-in: [4e2433378e] user: danielk1977 branch: trunk, size: 7258)
2004-11-04
14:30
[a5b11269da] part of check-in [1da361fae8] Support root-page allocation/deallocation in auto-vacuum databases. Still a few problems. (CVS 2054) (check-in: [1da361fae8] user: danielk1977 branch: trunk, size: 4321)
02:57
[9211914801] part of check-in [571de52376] Add support for table allocation (not deallocation) in auto-vacuum databases. (CVS 2051) (check-in: [571de52376] user: danielk1977 branch: trunk, size: 4322)
2004-11-03
09:30
[832bcbb008] part of check-in [2eacd38620] Comment the autovacuum.test script. No code or test-case changes. (CVS 2047) (check-in: [2eacd38620] user: danielk1977 branch: trunk, size: 3691)
03:01
[176a9a5417] part of check-in [b7d953e119] Fix an auto-vacuum bug that occurs when a btree cell is promoted to the parent page during a delete. (CVS 2043) (check-in: [b7d953e119] user: danielk1977 branch: trunk, size: 2413)
2004-11-02
14:40
[9ab4fcfb98] part of check-in [40249ed19c] Fix an auto-vacuum bug for btree entries that span more than one overflow page. (CVS 2039) (check-in: [40249ed19c] user: danielk1977 branch: trunk, size: 2556)
12:56
Added: [77eec318b1] part of check-in [d12481f09c] Code to auto-vacuum the database if all root pages happen to be in the right place. Not active by default and largely untested. (CVS 2037) (check-in: [d12481f09c] user: danielk1977 branch: trunk, size: 2517)