1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-04-20 08:47:46 +03:00

1192 Commits

Author SHA1 Message Date
drh
b851b2c938 Disable F_FULLSYNC if the sychronous pragma is not set to FULL. (CVS 2372)
FossilOrigin-Name: 58b8733b96165126ee8514f2ce0f88d249792847
2005-03-10 14:11:12 +00:00
danielk1977
5fd057af68 Fix a file corruption bug in CREATE INDEX in auto-vacuum databases. (CVS 2368)
FossilOrigin-Name: 64c4c717d35c8fce9b4be073196c507f6d471188
2005-03-09 13:09:43 +00:00
danielk1977
1722181328 Ensure a database file is not truncated without an exclusive lock.
Fix for ticket #1114. (CVS 2332)

FossilOrigin-Name: dcbc983355d3207615b52b0724405a024a1a5955
2005-02-15 03:38:05 +00:00
danielk1977
3c407374fc Check that read-only pages are not being modified (disabled by default). (CVS 2331)
FossilOrigin-Name: 8514a4feb2a86e93c4251c491d394e861bb65edb
2005-02-15 02:54:14 +00:00
drh
7bec505e26 Add the (highly experimental) omit_readlock pragma that disables the use
of readlocks on read-only databases that are connected using ATTACH. (CVS 2317)

FossilOrigin-Name: 2155448d2128119f74241da0ea07d6713b71765c
2005-02-06 02:45:41 +00:00
danielk1977
b3bce66232 Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286)
FossilOrigin-Name: b1b50f315873a8614920d1e3af4a07fb29a7ff6a
2005-01-29 08:32:43 +00:00
danielk1977
32554c10d0 Test script changes: Bug fix and cleanup on ioerr tests. Also, don't use TCL "file copy" command on windows. (CVS 2264)
FossilOrigin-Name: 764b55adb5dff944db36d0d19ce5e7cc758b3a9e
2005-01-22 03:39:39 +00:00
danielk1977
93758c8dcc Exclude a few more lines of code using OMIT macros. (CVS 2253)
FossilOrigin-Name: c6fc49e61033419e78b6b10638d57f4942087961
2005-01-21 08:13:14 +00:00
danielk1977
b84f96f854 Extend the influence of a couple of SQLITE_OMIT_** macros a little bit. (CVS 2243)
FossilOrigin-Name: 5b1a9bf6aa5a5c466b88f649e322e81b8466851f
2005-01-20 11:32:23 +00:00
danielk1977
2683665406 Have sqlite3pager_get() return SQLITE_CORRUPT for a page number greater than 2^31. (CVS 2222)
FossilOrigin-Name: feb49d10e83ecc186024d4e96b64ef92cf876715
2005-01-17 01:33:13 +00:00
danielk1977
aca790ace3 Test cases to improve coverage of pager.c. (CVS 2205)
FossilOrigin-Name: 0428a1480126f7e73dc1e24b6fbfa185d2d83dd3
2005-01-13 11:07:52 +00:00
danielk1977
2812956b18 Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2190)
FossilOrigin-Name: 8ced491588764b1e1066787d0abf3cde8b60970b
2005-01-11 10:25:06 +00:00
danielk1977
42741be968 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)
FossilOrigin-Name: fb3bf68d0e83b463c7e2f95b4502ba6f8158c074
2005-01-08 12:42:39 +00:00
drh
3b7b78b312 Fix a memory leak in pager.c. (CVS 2151)
FossilOrigin-Name: 0ad4ed87ce1112663ca94805dea167372485396a
2004-11-24 01:16:43 +00:00
danielk1977
ae82558bd0 Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143)
FossilOrigin-Name: 557be3ff5b1c46a3f3836ea3a9d9dede5dc46998
2004-11-23 09:06:55 +00:00
danielk1977
45901d622c Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087)
FossilOrigin-Name: 0747b55882cf218c03b443e1eadec9eb19889554
2004-11-10 15:27:38 +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
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
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
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
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
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
9c105bb990 Fixes to the OsUnlock() interface. Correctly leave a SHARED lock behind
when requested.  Honor the error code that OsUnlock() returns.
Ticket #913 and #938. (CVS 1997)

FossilOrigin-Name: c4697503d0ad080290b91e96dfc9a1a63f2df7e6
2004-10-02 20:38:28 +00:00
drh
eb206256f1 Use type i64 instead of off_t for file offsets since off_t is giving
portability problems.  Ticket #924. (CVS 1992)

FossilOrigin-Name: 8972c004dc825f668d952e7d082a89046b9260f1
2004-10-01 02:00:31 +00:00
drh
76ff3a0e09 Optimizations to vdbeaux.c and printf.c (CVS 1980)
FossilOrigin-Name: eabc77c99b3e78b4c620a1736d9acfa6cb1e7b67
2004-09-24 22:32:30 +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
92f02c31d4 Transactions commit on the last sqlite3_step(), not on sqlite3_finalize().
This allows the sqlite3_step() to return SQLITE_BUSY if the commit is
blocked by a lock.  Ticket #885. (CVS 1928)

FossilOrigin-Name: d1b29156558f1c576002cdb2544dffaa693da39b
2004-09-02 14:57:08 +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
fdb38064b0 Fix a pager bug that might have made multi-database commits non-atomic
if a power failure occurred at just the wrong moment. (CVS 1900)

FossilOrigin-Name: b6eb4bf8c7763ef73723fc3d3697af435c19bae4
2004-08-21 19:20:42 +00:00
drh
2889ae7248 Add the SQLITE_BUSY_RESERVED_LOCK compile-time option. (CVS 1894)
FossilOrigin-Name: 25fe7a42ec2e06e659d7a0a6664789114c007e17
2004-08-19 13:29:15 +00:00
drh
cb4c40ba0e Make sure the database file is correctly truncated after a ROLLBACK that
occurs after a statement abort. (CVS 1893)

FossilOrigin-Name: 6afe467d146828d67ad17af21604c2e691aa5dff
2004-08-18 19:09:43 +00:00
drh
2b74d70a38 Better debug logging of the pager. (CVS 1892)
FossilOrigin-Name: 1cc0323f2597584b3f3239e8948ac3ff3db8da03
2004-08-18 16:05:18 +00:00
drh
34f4732b06 Be more agressive about not creating or opening the TEMP database if there
are no TEMP tables. (CVS 1891)

FossilOrigin-Name: 6b2b6b2dbd821070a2781685c4b63a50bc8f5cae
2004-08-18 15:58:22 +00:00
drh
dc3ff9c34c Avoid creating a TEMP database unless it is absolutely necessary. (CVS 1890)
FossilOrigin-Name: 5914a11caa4c6e778cd7ca010427897c8f971552
2004-08-18 02:10:15 +00:00
drh
1d64fc1a5e Do not invoke the busy callback when trying to promote a lock from SHARED
to RESERVED.  This avoids a deadlock. (CVS 1879)

FossilOrigin-Name: d33771a303d9c20dd477b1a973024ff763203211
2004-08-07 23:54:48 +00:00
drh
25d6543de5 Fix bugs associated with the codec. (CVS 1846)
FossilOrigin-Name: b0a3becd82b9a4203c23f35dc5a5fd725e046f21
2004-07-22 15:02:25 +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
drh
d5b447d9ac The OsFile under Unix records a pointer back to the pager. This is intended
to be used for an externalized locking patch. (CVS 1821)

FossilOrigin-Name: 511ee6392472d250b542961d1f715cc7453598e6
2004-07-19 22:08:09 +00:00
danielk1977
13073931a3 Coverage improvements for malloc and vdbemem.c (CVS 1781)
FossilOrigin-Name: a98dd004c4d328eb44a71fecdbf8c5ab416dc524
2004-06-30 11:54:06 +00:00
danielk1977
96fb0dd55a Coverage tests for vacuum.c (CVS 1776)
FossilOrigin-Name: 152e9940b919a53fcd0da4091dbf75ab8ef15b38
2004-06-30 09:49:22 +00:00
danielk1977
8191bff0c2 Fix some problems with multi-file transaction rollback. (CVS 1751)
FossilOrigin-Name: 06e8e30b249c10512a225d6c7a5fcb5c666595e6
2004-06-28 04:52:30 +00:00
danielk1977
c3e8f5ef52 A few more warning fixes. (CVS 1750)
FossilOrigin-Name: 81e4994045697470bcfd692a794731c8291a8a30
2004-06-28 01:16:46 +00:00
danielk1977
b5548a8b20 Fix a problem where a file was not being closed after a malloc() failure. (CVS 1741)
FossilOrigin-Name: 3c8512bc549e10ee131cb7f2d4e74d96e9de74a0
2004-06-26 13:51:33 +00:00
danielk1977
40b38dcdf8 Remove the 'nMaster' argument from various pager and btree functions. (CVS 1737)
FossilOrigin-Name: 4e20720984e1fd6822ead785d758374d2704b7fb
2004-06-26 08:38:24 +00:00
danielk1977
75edc16f07 Fix a bug in the new full-sync journal format. (CVS 1733)
FossilOrigin-Name: 02bd3acd7efde9cc6b67c97e98db9f4b62d27877
2004-06-26 01:48:18 +00:00