drh
8237d45ed8
Fix a long-standing bug in btree.c in the sqlite3BtreePrevious() routine.
...
The problem has gone unnoticed before now because it only occurs when you
use the OP_Prev opcode on a B+Tree. (CVS 2140)
FossilOrigin-Name: 3d2536c479c943b3a55047898068625f91c872ae
2004-11-22 19:07:09 +00:00
danielk1977
299b187d76
Back out changes allowing writes to tables that have open cursors. (CVS 2133)
...
FossilOrigin-Name: 91acd87e52509a8f78894d0f4b625b54376cac21
2004-11-22 10:02:10 +00:00
danielk1977
03aded4924
Have tests pass when SQLITE_OMIT_MEMORYDB is defined. (CVS 2131)
...
FossilOrigin-Name: 9df837c03939cdcb31856ac17b2425a6dd92d7b2
2004-11-22 05:26:27 +00:00
drh
42cac6dacb
Correct use of usableSize versus pageSize in btree.c. Ticket #1010 . (CVS 2125)
...
FossilOrigin-Name: 5a4013ec9cabb2c933cbf45495f5d1e8b3b20da5
2004-11-20 20:31:11 +00:00
danielk1977
c7dc75334f
Extra tests and resulting bugfixes for btree cursors. (CVS 2106)
...
FossilOrigin-Name: e1530854c9004c25f5ffa21f9cfb9c44c83cc7f0
2004-11-17 10:22:03 +00:00
danielk1977
ed326d7047
Perform deletes in a single pass. (CVS 2104)
...
FossilOrigin-Name: a2e1c35b327e33684ab19e5f65727c42c7b2949c
2004-11-16 15:50:19 +00:00
danielk1977
6a43f9b3ff
Allow btree cursors to persist through BtreeDelete() calls. (CVS 2103)
...
FossilOrigin-Name: 6ad5fc8e1a119b750a82fc1426704164a2042d57
2004-11-16 04:57:24 +00:00
danielk1977
ce9a7b1e57
Code toward having btree cursors persist when their table is written too. Doesn't work properly yet. (CVS 2097)
...
FossilOrigin-Name: 5eaa18d43f2996a9d354bb4fb9c81e267e98be29
2004-11-13 13:19:56 +00:00
danielk1977
e6efa74b9f
Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085)
...
FossilOrigin-Name: 8e5c2e5df8b824f7efb27e776240f005c6f1f0ff
2004-11-10 11:55:10 +00:00
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
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
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
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
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
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
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
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
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
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
684917c269
Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000)
...
FossilOrigin-Name: 81ff8107ad63113782cf5a9ba7a512496114ba08
2004-10-05 02:41:42 +00:00
drh
44f87bdc56
Comment changes in btree.c. No changes to code. (CVS 1988)
...
FossilOrigin-Name: b15abf984fa06ae968d92fa9533dab20dcebd323
2004-09-27 13:19:51 +00:00
drh
3127653b1c
Bug fix in btree.c in cases where usableSize!=pageSize. Ticket #925 . (CVS 1987)
...
FossilOrigin-Name: cb3e12372d96f5a24f5a5d79645c705775bc63ff
2004-09-27 12:20:52 +00:00
drh
fe63d1c98b
More changes directed at getting things to work on 64-bit platforms. (CVS 1949)
...
FossilOrigin-Name: 39755d216608e9d12e1055433549f820f63608a7
2004-09-08 20:13:04 +00:00
drh
f2a611c988
Make VACUUM work when the page size is different than the default 1024.
...
Ticket #890 . (CVS 1939)
FossilOrigin-Name: fa82becae7e41c47a6387061932f692c6f9f472e
2004-09-05 00:33:43 +00:00
drh
ad3e010547
Fix a comment. (CVS 1938)
...
FossilOrigin-Name: af44ddeea110576bf9c475b5e6e3540ee50c5edf
2004-09-03 23:32:18 +00:00
drh
2e38c32b67
Modify btree.c so that is allocates big data structures using malloc()
...
instead of allocating from the stack. Stack allocations cause problems
for embedded systems and pthreads implementations that only allocate a
limited amount of stack space. (CVS 1937)
FossilOrigin-Name: 4595292f936bdbec10734f42682824e91ff71d11
2004-09-03 18:38:44 +00:00
drh
66cbd1543b
Work around a bug in the Borland C++ compiler. Ticket #881 . (CVS 1927)
...
FossilOrigin-Name: 18af6ba580a5ad50a20955bfe2ebce8e30b1d39e
2004-09-01 16:12:25 +00:00
drh
855eb1cf02
Simplifications and optimizations. Also: disable the corrupt.test for now. (CVS 1924)
...
FossilOrigin-Name: 8fd65e704888a8e2f4a712a94fd0e3f866c10ef3
2004-08-31 13:45:11 +00:00
drh
ee696e2218
Better detection and handling of corrupt database files. (CVS 1922)
...
FossilOrigin-Name: 8f5b199e845fa7ae3444ef69bd840716d305cf73
2004-08-30 16:52:17 +00:00
drh
ae15787643
If meta(3)>0 then make the database readonly for now. This allows the current
...
database to interact with future releases that might include autovacuum. (CVS 1888)
FossilOrigin-Name: 7619bf4771781005da23a3e9d7b00de405e27a64
2004-08-14 19:20:09 +00:00
drh
8dcd7cab83
Attempting to open a locked table for writing should fail immediately.
...
Ticket #842 . (CVS 1880)
FossilOrigin-Name: fc879a9b1d05ddb8f8c552c1d334597e41b29b27
2004-08-08 19:43:29 +00:00
drh
3e27c02625
First cut at a analysis tool for version 3.0 databases. (CVS 1862)
...
FossilOrigin-Name: 7c7f698b2eda7b1b34f5ca7fe104145d8bbd8f56
2004-07-23 00:01:38 +00:00
drh
2011d5f5e5
Changes in support of using a codec. (CVS 1844)
...
FossilOrigin-Name: b77bec35742f07d79da3e85baee09a90c1494415
2004-07-22 02:40:37 +00:00
drh
90f5ecb39d
Initial implementation of variable page sizes and the temp_store pragma. (CVS 1843)
...
FossilOrigin-Name: 4cf6e9db757931aba2f300b7869305434d6f2d2b
2004-07-22 01:19:35 +00:00
drh
6d08b4d647
Add the '%ifdef' capability to lemon. Other minor changes. (CVS 1836)
...
FossilOrigin-Name: 522ff721ccc33c4b89072fed4e451f0df82e8140
2004-07-20 12:45:22 +00:00
danielk1977
bc6ada4103
Fixes for compiler warnings. Also more coverage. (CVS 1775)
...
FossilOrigin-Name: fa19c77bf045787faa4cdc40bcfbd9eeae8594ae
2004-06-30 08:20:16 +00:00
drh
db96db107c
Remove some pointless asserts from btree.c. (CVS 1768)
...
FossilOrigin-Name: 73eec675059f6d2178c6175268e80750378bf07b
2004-06-30 01:07:01 +00:00