1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-12 13:01:09 +03:00

19158 Commits

Author SHA1 Message Date
danielk1977
94daf7fdff Test auto-vacuum mode for crash-proofness. Also fix a bug related to the same. (CVS 2077)
FossilOrigin-Name: 839ad771a6e781426c0fd624a4d1c91a5fcf8546
2004-11-08 09:26:09 +00:00
danielk1977
599fcbae56 Auto-vacuum: Account for the page reserved for windows locking (PENDING_BYTE). (CVS 2076)
FossilOrigin-Name: d6335698696c7b651bbc436c5177d87eb57a8934
2004-11-08 07:13:13 +00:00
drh
e497f0051f Reindex tests added and bugs fixed. (CVS 2075)
FossilOrigin-Name: ad433ec2b6bd34e33dfe119668f38fbb978e889d
2004-11-07 13:01:49 +00:00
danielk1977
ef73ee9a46 Auto-vacuum: Ensure pages to be removed by database truncation are in the journal file. Also fix an sqlite3pager_movepage() bug. (CVS 2074)
FossilOrigin-Name: 081676e491760a45325e2349b177d6382faab9f5
2004-11-06 12:26:07 +00:00
drh
eee46cf35c Compile and pass the quick regression tests with autovacuum disabled. (CVS 2073)
FossilOrigin-Name: 89b9026a5371f1c5589f04e3b69171ec1f605b7b
2004-11-06 00:02:48 +00:00
drh
4343fea20f First cut at a REINDEX command. Basic testing only. No documentation. (CVS 2072)
FossilOrigin-Name: 11dba47e61279bdf3be6f64a6259b877f3bf6155
2004-11-05 23:46:15 +00:00
drh
b17131a084 Use sqlite3NestedParse to implement DROP INDEX. (CVS 2071)
FossilOrigin-Name: 0f81aa5b057eab908b46b70ea9e9a42bc2ee8c21
2004-11-05 22:18:49 +00:00
drh
063336a55e Use sqlite3NestedParse to implement CREATE INDEX. (CVS 2070)
FossilOrigin-Name: 47d8ebdaaddcb7a05e1917dd1dee2029c34228a4
2004-11-05 20:58:39 +00:00
drh
4794f73524 Create table now works with sqlite3NestedParse. This changed uncovered
a latent bug in xprintf which is also fixed. (CVS 2069)

FossilOrigin-Name: b0506bdd701339d63166ada065445776dd499588
2004-11-05 17:17:50 +00:00
danielk1977
d761c0c9fd Do not truncate a database file until after fsync() has been called on the journal. (CVS 2068)
FossilOrigin-Name: cfee7f4a004c5e57d58edcf9de3ded0a199940a3
2004-11-05 16:37:02 +00:00
danielk1977
951af8050b Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067)
FossilOrigin-Name: b9d5f007fc32d4f471e0e11cc4baadb100612878
2004-11-05 15:45:09 +00:00
danielk1977
87a6e7318f Auto-vacuum bug: Don't set meta(3) to a pointer-map page number when deleting a table. (CVS 2066)
FossilOrigin-Name: 44a015b3a3bbecc4ec1e02bb371d3274e2b6edf3
2004-11-05 12:58:25 +00:00
danielk1977
cb1a7eb0df Fix allocation of tables in an auto-vacuum database when the required root-page is on the free-list. (CVS 2065)
FossilOrigin-Name: 4e2433378e06210f0274c317c6d12b48236211fe
2004-11-05 12:27:02 +00:00
danielk1977
63e3e9f81a Don't code an OP_Statement within sqlite3NestedParse(). Also a correction
to the UPDATE statement used within destroyRootPage(). (CVS 2064)

FossilOrigin-Name: fdcc31f0c6106dacfed6612b173fe4be3c02546a
2004-11-05 09:19:27 +00:00
danielk1977
e7de6f25a8 When using sqlite3NestedParse() to modify the sqlite_master table, do not code OP_Callback. (CVS 2063)
FossilOrigin-Name: 296a298c484aac981e7e490a0cb4159717fc4ea4
2004-11-05 06:02:06 +00:00
drh
7a638581b2 Another bug fix from two check-ins ago. (CVS 2062)
FossilOrigin-Name: c46eef2f6d32b8546e1441e7e6f103e6ad97f1f4
2004-11-05 05:23:59 +00:00
drh
958390005b Fix a bug in the previous check-in. (CVS 2061)
FossilOrigin-Name: 9d259d48defda57ab0bd66460bd2ba7f3a2695e9
2004-11-05 05:20:40 +00:00
drh
4e0cff6080 More use of sqlite3NestedParse. This version of the code does not work. (CVS 2060)
FossilOrigin-Name: ac2d5a605c873cac68bfde4bbe3797608a47b21e
2004-11-05 05:10:28 +00:00
drh
f197484617 Begin using sqlite3NestedParse() to generate sections of code. (CVS 2059)
FossilOrigin-Name: 2d302931a69d1add1dae9f820133872b4fefe93e
2004-11-05 03:56:00 +00:00
danielk1977
a64a035f7e Fix bug introduced with (2057). (CVS 2058)
FossilOrigin-Name: aed2e623ec9c4044696dc2d6f7f4c53216b45479
2004-11-05 01:45:13 +00:00
danielk1977
467d4707ff Pop the value pushed by OP_Destroy if SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2057)
FossilOrigin-Name: b0c103340ad27533d3e5b2f1b18557fd9c8b55df
2004-11-05 01:24:12 +00:00
drh
205f48e635 Incremental check-in of changes that will ultimately lead to a
working autoincrement. (CVS 2056)

FossilOrigin-Name: 10c3d88305e404b9e4cc4eef0b8e5dc7864a5937
2004-11-05 00:43:11 +00:00
drh
40e016e492 All tests pass when SQLITE_OMIT_INTEGRITY_CHECK is defined. (CVS 2055)
FossilOrigin-Name: 158a2d16a8630e3b5892120f6ea68f2b0dc47eb3
2004-11-04 14:47:11 +00:00
danielk1977
a0bf265269 Support root-page allocation/deallocation in auto-vacuum databases. Still a few problems. (CVS 2054)
FossilOrigin-Name: 1da361fae82d420be63c53f8e3efaccac24f348a
2004-11-04 14:30:04 +00:00
drh
798da52ce7 All tests pass even if OMIT_TRIGGER is defined. (CVS 2053)
FossilOrigin-Name: c33b3a613751057e8a46fdcd428b8448329d414d
2004-11-04 04:42:28 +00:00
drh
bf8aa33bba Fix a #ifdef in util.c. Ticket #984. (CVS 2052)
FossilOrigin-Name: da045bd183335a112f9a6c805c12efe12d0a25ca
2004-11-04 04:34:14 +00:00
danielk1977
003ba061da Add support for table allocation (not deallocation) in auto-vacuum databases. (CVS 2051)
FossilOrigin-Name: 571de52376f52999268ba5e0cd05c6c6eff1ebbf
2004-11-04 02:57:33 +00:00
drh
6bf895708c Update tests to work even if some features of the library are disabled. (CVS 2050)
FossilOrigin-Name: b11fc9b3f3a2711f98e7e45724aa1d30081197f3
2004-11-03 16:27:01 +00:00
drh
a71aa00102 More work on optionally removing unused features at compile-time. (CVS 2049)
FossilOrigin-Name: a82980fd70285820c64b42393ef85a9e21addc5d
2004-11-03 13:59:04 +00:00
danielk1977
a19df67c58 Auto-vacuum bug: Deallocate pointer-map pages when shrinking a database file. (CVS 2048)
FossilOrigin-Name: bec6a65acaa8bfd8fe2cb475ba2e992a1993e4e7
2004-11-03 11:37:07 +00:00
danielk1977
f5fdda8208 Auto-vacuum bug: Correctly manipulate page cache hash-table entries in sqlite3pager_movepage(). (CVS 2046)
FossilOrigin-Name: 719c1b79671c8cd7c5a6b5967ad4265b65e433d3
2004-11-03 08:44:05 +00:00
drh
52fb6d71f5 The makefile now runs mkkeywordhash.c. Keywords that are unused are
omitted from the keyword hash table. (CVS 2045)

FossilOrigin-Name: 007aec11333432e08d1091b728773011e9078bc3
2004-11-03 03:59:57 +00:00
danielk1977
4fa03bde07 Auto-vacuum bugfix: Do not attempt to move a pointer-map page during auto-vacuum. (CVS 2044)
FossilOrigin-Name: bd50fbb5fecd1829c87e8ca72c458c71f590274b
2004-11-03 03:52:37 +00:00
danielk1977
e80463bc7d Fix an auto-vacuum bug that occurs when a btree cell is promoted to the parent page during a delete. (CVS 2043)
FossilOrigin-Name: b7d953e1195897de4869ec241a65e8a3d1320efb
2004-11-03 03:01:16 +00:00
drh
cfe4a990ce Get btree.c to compile with -DNDEBUG=1. (CVS 2040)
FossilOrigin-Name: 8378c144c1e1cedb7deea271fa274182d08198b8
2004-11-02 18:05:09 +00:00
danielk1977
f78fc0818c Fix an auto-vacuum bug for btree entries that span more than one overflow page. (CVS 2039)
FossilOrigin-Name: 40249ed19cd53cb61f9575d8165316faf2627479
2004-11-02 14:40:32 +00:00
drh
06f502170e Require that the page size be a power of 2. (CVS 2038)
FossilOrigin-Name: c33b34dbe9657b151b9ab00a6b50a255fae623f8
2004-11-02 14:24:33 +00:00
danielk1977
687566d786 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)
FossilOrigin-Name: d12481f09cbe51c7ea499bc22afec5de3af14ad4
2004-11-02 12:56:41 +00:00
danielk1977
afcdd02f6a Add code to create/update the btree 'pointer-map' for auto-vacuum mode. (CVS 2035)
FossilOrigin-Name: bebd967f3627220c3ce0352c8ca9c7c17b722ce6
2004-10-31 16:25:42 +00:00
drh
b7f9164e98 Insert #ifdefs that can optionally remove features at compiletime resulting
in a database engine with a smaller footprint. (CVS 2034)

FossilOrigin-Name: be661acfa849bb0d5692797dd221f5a8a457f8ad
2004-10-31 02:22:47 +00:00
drh
27d258a3ec Begin adding the ability to remove unused features at compile-time and still
have all the tests pass. (CVS 2033)

FossilOrigin-Name: 2aa506ccb003a25555b414772002d0130db93052
2004-10-30 20:23:09 +00:00
drh
0b2110c9f5 Fix a bug in the ".databases" command of the command-line shell.
Ticket #973 (CVS 2030)

FossilOrigin-Name: 507d8e6f5cff308116289b27b3138e5bbfd55352
2004-10-26 00:08:10 +00:00
drh
722e95ac65 Minor optimizations in the pragma module. (CVS 2029)
FossilOrigin-Name: 63efd50a1608eb4ccac44a233c0f77c3956f9fa0
2004-10-25 20:33:44 +00:00
drh
40f20f7d2a Tighter encoding of the keyword hash table in the tokenizer. (CVS 2028)
FossilOrigin-Name: 7b9886f8d4db366bc7dbf25495f0d3b907d25689
2004-10-23 05:10:18 +00:00
drh
f404083e56 Add the experimental and scary pragma "writable_schema". (CVS 2027)
FossilOrigin-Name: 39f7870a54d90d5163fcad3f08cd63699c4bb567
2004-10-22 20:29:21 +00:00
drh
887dc4c275 Fix alignment problems in btree and pager and allow page sizes that are
not a multiple of 8. (CVS 2026)

FossilOrigin-Name: 0539c2d2b8e16efcbe4db3afeae9c7b426e11b05
2004-10-22 16:22:57 +00:00
drh
6138df56e7 Reinsert code deleted by (1998) that we thought was unused but was in fact
needed.  Fix for ticket #966. (CVS 2025)

FossilOrigin-Name: 370ca539506a431dbe77dcb644215886760f34e9
2004-10-19 16:40:59 +00:00
drh
2090a0ed48 Optimizations to the tokenizer. (CVS 2011)
FossilOrigin-Name: e5540ce047e0215904005bc9df4ff0d1d0a3c1d1
2004-10-07 19:03:01 +00:00
drh
74ad7fe980 Additional parser optimizations. (CVS 2010)
FossilOrigin-Name: 618dee121e41d8e5c9b4d5c167475b11ddcda2d7
2004-10-07 03:06:28 +00:00
drh
8e64d1caad In the command-line shell in CSV move, put strings in C-style double-quotes.
Ticket #911. (CVS 2009)

FossilOrigin-Name: 1376a0bb8d864de755c614b2ecce4342155fd09b
2004-10-07 00:32:39 +00:00