database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-07 02:42:48 +03:00
Code Activity
30,215 Commits 1,570 Branches 184 Tags
tcl-init
Commit Graph

1674 Commits

Author SHA1 Message Date
dan
cdc1f049bf Modify the interface to the blocking wal-checkpoint functionality. 
FossilOrigin-Name: 72787c010c8944e8fcf9c98aa4482f129142d8e9
 2010-11-18 12:11:05 +00:00
dan
a58f26f93f Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file. 
FossilOrigin-Name: 7e3fc2c833a5baa08820c499867b6902bdc2ed5a
 2010-11-16 18:56:51 +00:00
dan
4e76cc3650 Updates to FTS4 to improve performance and make more accurate cost estimates for prefix terms. 
FossilOrigin-Name: d0a450ce78e99f55c862f26f9332786660007a0a
 2010-10-20 18:56:04 +00:00
drh
075ed30a9f Avoid taking locks on unused database connections when committing a 
read transaction.

FossilOrigin-Name: c0ee614fd988f445c4884a37f494479bdd669185
 2010-10-14 01:17:30 +00:00
shaneh
bd2aaf9ab1 Fix some compiler warnings under MSVC. 
FossilOrigin-Name: afdc82a99eba260aed8ae2cca4bcec629f384098
 2010-09-01 02:38:21 +00:00
drh
d4187c716c Provide hints to the btree layer during the creation of transient tables 
when it is possible for those tables to use a hash rather than a binary tree.
No use is current made of those hints, though assert() statement verify
their accuracy.

FossilOrigin-Name: 4fead8e714c7e50a9d246467e62bc846ef6180a0
 2010-08-30 22:15:45 +00:00
drh
75c014c321 Remove the sqlite3BtreeFactor() wrapper routine. All modules now call 
sqlite3BtreeOpen() directly.

FossilOrigin-Name: 0900e35348f4b9bf327d6ae2884c4ddbb6345d8d
 2010-08-30 15:02:28 +00:00
dan
f48c355b33 Fix for ticket [5e10420e8d]. 
FossilOrigin-Name: 255f1eefa373153942c67b18b22177933657911d
 2010-08-23 15:41:24 +00:00
drh
5f77b2e0ea Fix the ptrmapPageno() routine so that it works correctly for an input of 1. 
FossilOrigin-Name: 699a9bf28377f43f58c509878cce60cb906dbf48
 2010-08-21 15:09:37 +00:00
drh
6b47fcacb4 Remove a NEVER from balance_quick() that can occur in WAL mode on 
a corrupt database file.

FossilOrigin-Name: b273891ab05a18b68a76c870ea3be9f1a56c40a9
 2010-08-19 14:22:42 +00:00
drh
e22e03e210 Fix two asserts in the btree logic so that they work correctly even for 
maximum-size index entries for 32K and 64K pages.

FossilOrigin-Name: e127192d106bd7e036caacf01bf7725eeaa85dbe
 2010-08-18 21:19:03 +00:00
shaneh
1df2db7fd1 Fix some compiler warnings in the MSVC build. 
FossilOrigin-Name: 1f5662b7db5d623c8d99c45a8d97a0aa4427593f
 2010-08-18 02:28:48 +00:00
drh
43b18e1e55 Suppress harmless compiler warning. 
FossilOrigin-Name: 3f8c068a41b01f59d7f5d56f3bced78587f4d26c
 2010-08-17 19:40:08 +00:00
drh
9b78f79183 Adjustments for better 64K page size handling. 
FossilOrigin-Name: faf1974e2de321bfefb68b81d702ae69771933ef
 2010-08-14 21:21:24 +00:00
drh
8fb8b53728 Change sqlite3PagerPagecount() to return void, since the return value was 
always SQLITE_OK and was never used.

FossilOrigin-Name: 7dd78eb7974ec7c40af3fcf2b125ca5bc0766b5c
 2010-08-14 17:12:04 +00:00
drh
5d433ce2ab Minor simplifications to btree.c in support of full-coverage testing. 
FossilOrigin-Name: 364df6c7735447cc2187923918a35bf62d82decc
 2010-08-14 16:02:52 +00:00
drh
b2eced5de2 Increase the maximum page size from 32k to 64k. 
FossilOrigin-Name: 45362437d491fbe0f033a67b398f8ba68cbf1b3b
 2010-08-12 02:41:12 +00:00
drh
b9b49bf36b Do not read the database file size on a SAVEPOINT rollback any more since 
after checkin [65b8636ac6e5] the in-header-size field is always valid.

FossilOrigin-Name: fbe70e1106bcc5086ceb9d8f39cc39baf3643092
 2010-08-05 03:21:39 +00:00
dan
59257dc615 When opening a write-transaction on a database file that has been appended to or truncated by a pre-3.7.0 client, update the database-size field in the database header. Fix for [51ae9cad31]. 
FossilOrigin-Name: 65b8636ac6e5d3e4502d4f576ddf9350d5df3022
 2010-08-04 11:34:31 +00:00
dan
a550f2decd In shared-cache mode, do not allow one connection to checkpoint a database while a second connection is reading or writing the same shared-cache. 
FossilOrigin-Name: e75b52d156905ce16bedb94f65c01a4640bdfa75
 2010-08-02 10:47:05 +00:00
drh
b975598ea0 Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and 
all memory from sqlite3_malloc() is freed by sqlite3_free().

FossilOrigin-Name: ac1f37a647e9ed1c00a901d26d9956a86c40117a
 2010-07-24 16:34:37 +00:00
dan
2411dea3ca Change code in OP_Rewind to avoid a valgrind warning following an error in the btree layer. This change does not fix any bug, just a warning. 
FossilOrigin-Name: 4f62dbcfc96855f69e71d163bfc051d9db08cca9
 2010-07-03 05:56:09 +00:00
shaneh
5eba1f60fe Fix some warnings when compiling under MSVC. 
FossilOrigin-Name: 708338773919fa024abbba55180654beb60e6d84
 2010-07-02 17:05:03 +00:00
dan
ba3cbf3d4b Add coverage test cases. Have sqlite3_backup_step() transform SQLITE_IOERR_NOMEM to SQLITE_NOMEM before returning. 
FossilOrigin-Name: 5e19bc360e098ec06a72f4a86254d8e62e93ea57
 2010-06-30 04:29:03 +00:00
drh
b28e59bbbb Bug fix: Only trust the database size number at offset 28 if the change 
counter at offset 24 matches the version number counter at offset 92.
This prevents corruption in the case of two applications writing to the
database where one is an older version of SQLite and the other is a newer
version.

FossilOrigin-Name: f80c3f922a114e738613955a939db46cf0847038
 2010-06-17 02:13:39 +00:00
dan
f9b7671066 If an attempt to get a read-lock on the WAL fails with SQLITE_BUSY_RECOVER, call the busy-handler at the btree level. 
FossilOrigin-Name: ce64496509a213c08c9dedae2a7a456b393d22e5
 2010-06-01 14:12:45 +00:00
dan
5cf53537a8 Support compile-time option SQLITE_OMIT_WAL, for building without WAL support. 
FossilOrigin-Name: 9b230c43dfa112e3e1589f9775926807bd36b36e
 2010-05-01 16:40:20 +00:00
drh
7ed91f2344 Refactor wal.c to use the VFS. This check-in compiles and links and works 
ok as long as you leave WAL turned off, but WAL does not work.

FossilOrigin-Name: 62db5fa3b61be885b2d94e9b9ce3877b2c588350
 2010-04-29 22:34:07 +00:00
dan
8b5444bfae Fix a problem with identifying a corrupt database in WAL mode. 
FossilOrigin-Name: c8658da44671e9c43c90ee4857bbe82c55d40f25
 2010-04-27 14:37:47 +00:00
dan
ede6eb8d1d Further tests and changes related to switching between WAL and rollback modes. 
FossilOrigin-Name: 1236318477787a612f02cc98caf2931bd2e99d94
 2010-04-22 06:27:04 +00:00
dan
b978002743 Tests for (and changes to) the code to switch between WAL and rollback modes. 
FossilOrigin-Name: 9f4f933f2c6596064fcfc7fb5add87e8c5b57448
 2010-04-21 18:37:57 +00:00
dan
a470aeb4ac If, after obtaining a SHARED lock, there exists a *-wal file in the file-system, use WAL mode. This is necessary to recover from a crash that damages the first page of the database file. 
FossilOrigin-Name: 33cabf271b8f4dda508a610bf59964273fe2cb84
 2010-04-21 11:43:38 +00:00
dan
e04dc88be5 Use the read and write version fields of the database header to mark a database as operating in wal-mode. 
FossilOrigin-Name: 96bef18c1411c3e0348295886f105e1646c46320
 2010-04-20 18:53:15 +00:00
drh
d14133e3f4 When rolling back a savepoint to the beginning of the transaction, make sure 
to initialize the database size in the btree layer correctly even if the
database size field of the header is zeroed.

FossilOrigin-Name: a3540c6acf2bb6bdd44c101b63f17ca85e6b68ed
 2010-04-07 20:29:56 +00:00
drh
c2a4bab462 If the size of the database according to the header is larger than the 
actual database file size, report that the database is corrupt.

FossilOrigin-Name: 8eb1f2443f2712920452b7ed3fb835c7f3221191
 2010-04-02 12:46:45 +00:00
drh
1f5b467f13 Restore the size information in the BtShared structure when a transaction 
rolls back.

FossilOrigin-Name: 802aeb30c9baf4059fa84f4693f290f80d3a4085
 2010-04-01 02:22:19 +00:00
drh
8d8626fe2b Report corruption if a database contains a reference that is out of range 
according to the filesize-in-header database size.

FossilOrigin-Name: a91db0b1cd0b0fbadc5c8fe2eb8863629b411d87
 2010-03-31 20:29:06 +00:00
drh
97b59a56d2 Increase test coverage following the introduction of the new 
filesize-in-header logic.

FossilOrigin-Name: dbc2c3c0144d2c76aec04f80892302c532947dc8
 2010-03-31 02:31:33 +00:00
drh
b1299158c7 Continuing refinements to the filesize-in-header enhancement. 
FossilOrigin-Name: 79e22b95038c50b9b7f35e09262805ff6338b59b
 2010-03-30 22:58:33 +00:00
drh
bf59283ba2 Add a NEVER macro around a test in btree.c that can not longer be true. 
FossilOrigin-Name: c117f99236a009778bb7878da464918554391f0a
 2010-03-30 15:51:12 +00:00
drh
25a80ad0b1 The btree layer now tracks when a database is empty at the start of a 
transaction and rolls back to that state.

FossilOrigin-Name: 01ef6c1944507c188a83a434ff00e98ad767f744
 2010-03-29 21:13:12 +00:00
drh
5e0ccc216d Fix issues with the io.test script. There is still a problem with a 
ROLLBACK TO not working on an initially empty database files.  And much
more testing is needed.

FossilOrigin-Name: 09786e2a51817d572a01ae7f3621f03fd27fc363
 2010-03-29 19:36:52 +00:00
drh
dd3cd977cc Experimental changes that cause SQLite to use bytes 28..31 of the database 
header to determine the database size, rather than using the actual database
size.  This allows database space to be preallocated.

FossilOrigin-Name: b844ac6fcb72595a71e5c5283ec461309a87ba79
 2010-03-27 17:12:36 +00:00
shaneh
1da207e676 Minor changes to silence compiler warnings on various MSVC builds. 
FossilOrigin-Name: 115c978b6bbc110119a1b2f178cc30b33aaa27ef
 2010-03-09 14:41:12 +00:00
dan
2ed11e7b18 Avoid a buffer overwrite that can occur with a corrupt database if secure-delete is enabled. 
FossilOrigin-Name: 7bdb1e05faceddbb0b8e3efee7d070ad8c4611a3
 2010-02-26 15:09:19 +00:00
drh
383d30f483 Avoid incorrect compiler warnings by doing a couple of needless 
variable initializations.

FossilOrigin-Name: 8f29490da62df07ea922b03cab52b6edd2669edb
 2010-02-26 13:07:37 +00:00
shaneh
84f4b2f237 Minor changes to silence some compiler warnings with MSVC. 
FossilOrigin-Name: 4927c62d6214d93e582bf1266215ed3519630c15
 2010-02-26 01:46:54 +00:00
dan
887d4b2b43 Add experimental fix for corruption detection problem. This may well be revised yet. 
FossilOrigin-Name: 1cc4be7ebc463921827e61da724f0de946c061f6
 2010-02-25 12:09:16 +00:00
drh
9978c97ec5 Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging 
output for CORRUPT, and CANTOPEN errors.

FossilOrigin-Name: 7c4cca6d1a23a6d1591b62f58c3716a944969947
 2010-02-23 17:36:32 +00:00
shaneh
195475d839 Changes to pragma integrity_check to check rowid order. Tests of same in corruptE.test. 
FossilOrigin-Name: cae47c5b09cb122689bcb020a66ce14982cc4aa8
 2010-02-19 04:28:08 +00:00