/ File History
Login

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

History of src/btree.h

2019-04-15
14:59
Merge the latest enhancements from trunk. file: [36dbef45] check-in: [7c328e88] user: drh branch: begin-concurrent, size: 15679
2019-03-29
15:21
Remove the unused P5 flag from the OP_Rewind opcode. file: [c11446f0] check-in: [c2edbf3b] user: drh branch: trunk, size: 15636
2019-03-08
15:30
Merge all the latest enhancements from trunk. file: [f5c65a8c] check-in: [667cce3d] user: drh branch: begin-concurrent-pnu, size: 15755
2019-02-04
21:10
Early detection of implausibly sized records to avoid unnecessary large memory allocations. file: [63b94fb3] check-in: [2c8769c6] user: drh branch: trunk, size: 15712
2018-07-10
15:45
Merge latest trunk changes into this branch. file: [1ed41c71] check-in: [e9a3e864] user: dan branch: begin-concurrent, size: 15703
2018-06-22
20:51
Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. file: [febb2e81] check-in: [5f04b016] user: dan branch: exp-window-functions, size: 15660
2018-06-07
20:35
Merge latest trunk changes with this branch. file: [7b557914] check-in: [25102203] user: dan branch: exp-window-functions, size: 15622
2018-06-06
17:03
Merge changes from trunk, including all the 3.24.0 changes plus some later enhancements. file: [1d6402da] check-in: [d7299bfe] user: drh branch: begin-concurrent, size: 15627
16:28
Change sqlite3BtreeBeginTrans() to return the BTREE_SCHEMA_COOKIE, for a small speed improvement when starting new transactions. file: [ab639c4b] check-in: [a10662aa] user: drh branch: trunk, size: 15584
2018-05-23
20:55
Add support for "ROWS BETWEEN <expr> PRECEDING AND <expr> FOLLOWING" window frames. file: [d46a8e31] check-in: [3a203660] user: dan branch: exp-window-functions, size: 15617
2018-05-15
11:45
Merge latest trunk changes with this branch. file: [373828f7] check-in: [ae86cf60] user: dan branch: begin-concurrent, size: 15622
2018-05-07
18:41
Activate the cell-overwrite optimization for index b-trees. file: [448f15b9] check-in: [a68697d1] user: drh branch: trunk, size: 15579
2018-03-28
15:41
Update this branch with latest trunk changes. file: [6fb019c0] check-in: [df52e89f] user: dan branch: server-process-edition, size: 14932
2018-03-02
17:40
Merge latest trunk changes into this branch. file: [0cd74575] check-in: [36801eff] user: dan branch: begin-concurrent, size: 14873
2017-12-29
15:04
Change the function name to sqlite_unsupported_offset(X). Only enable the function if compiled with -DSQLITE_ENABLE_OFFSET_SQL_FUNC. The makefiles add that definition to shell builds. file: [0866c0a0] check-in: [7a7f826e] user: drh branch: location-function, size: 14830
2017-12-16
20:20
Add an experimental location(X) SQL function that attempt to return the location of the payload within the database for the record that contains column X. location(X) returns NULL if X is not an ordinary table column or if SQLite cannot figure out the location because it is using a covering index. file: [e9d22d04] check-in: [51be9558] user: drh branch: location-function, size: 14788
2017-09-22
20:18
Merge in all the trunk enhancements of the previous 7 months. The LIKE optimization has stopped working when there is an ESCAPE - that problem will be addressed in a subsequent check-in. file: [90eae6df] check-in: [8d2a1cca] user: drh branch: est_count_pragma, size: 14807
2017-08-28
17:19
Merge recent enhancements from trunk. file: [feafd064] check-in: [d53108e7] user: drh branch: begin-concurrent, size: 14794
2017-08-16
19:20
Avoid a test for CURTYPE_BTREE in sqlite3VdbeCursorMoveto() in order to reduce the size and improve the performance of OP_Column. file: [32ef5d3f] check-in: [f078deb2] user: drh branch: trunk, size: 14751
2017-07-20
17:47
Merge all the latest trunk enhancements. file: [e8045998] check-in: [213c61cb] user: drh branch: begin-concurrent, size: 14749
2017-07-13
21:06
Make the freelist format a separate feature from the page-level locking. Freelist format is now configure using "PRAGMA freelist_format". file: [d1f64c56] check-in: [dcc40797] user: dan branch: server-process-edition, size: 14808
2017-05-30
18:34
Change sqlite3BtreeNext() and sqlite3BtreePrevious() so that they return SQLITE_DONE if they have already reached the end (or beginning) of the table. This gives a performance increase and size reduction. file: [3edc5329] check-in: [e972a386] user: drh branch: trunk, size: 14706
2017-05-15
17:34
Merge the latest changes from trunk. file: [14e99cc2] check-in: [14ea8400] user: drh branch: begin-concurrent, size: 14749
2017-04-09
19:23
Do not expose the name of the internal Mem object in the public interface defined by sqlite3.h. file: [80f518c0] check-in: [19dd753f] user: drh branch: trunk, size: 14706
2017-03-24
15:09
Merge all recent enhancements from trunk. file: [d0476656] check-in: [fd5676fe] user: drh branch: begin-concurrent, size: 14749
2017-02-17
19:24
The analyze_as_needed pragma now responds to table size growth and will automatically rerun the analysis after each 10x size increase. file: [bf64dfee] check-in: [bfbdd074] user: drh branch: auto-analyze, size: 14706
2017-01-27
16:24
Merge all recent enhancements from trunk. file: [fef38999] check-in: [fe86ff54] user: drh branch: est_count_pragma, size: 14722
2017-01-18
20:14
Add temporary code to record and report on the set of b-tree pages read and written by the current transaction. This is likely still buggy. file: [a25d8121] check-in: [2a8f6c89] user: dan branch: transaction-pages, size: 14783
2017-01-10
20:04
Changes to allow some multi-row UPDATE statements to avoid the two-pass approach. file: [e6d35280] check-in: [46db23cc] user: dan branch: onepass-update, size: 14666
2017-01-09
06:33
Upgrade this branch to 3.16 plus the various fixes that appeared after its release. file: [9306cfe4] check-in: [d0e212d0] user: dan branch: begin-concurrent, size: 14637
2016-11-30
16:39
Merge all the latest changes from trunk. file: [14931e08] check-in: [7ca58a07] user: drh branch: est_count_pragma, size: 14650
2016-11-25
19:18
Refactor the sqlite3BtreeKey() and sqlite3BtreeData() internal interfaces into sqlite3BtreePayload() and sqlite3BtreePayloadChecked(), respectively. This is a continuation of the optimization started by check-in [2d831074cf]. The result is a slightly smaller and faster binary. file: [2349a588] check-in: [49ebc219] user: drh branch: trunk, size: 14594
2016-11-15
04:00
Change the OP_Last opcode so that it is a no-op if the cursor is already pointing at the end of the b-tree. file: [01ec4584] check-in: [66347385] user: drh branch: trunk, size: 14580
2016-11-10
21:19
Break up the sqlite3BtreeMovetoUnpacked() routine into an eponymous routine and sqlite3BtreeMovetoIntkey(). Each routine specializes in a single kind of btree. file: [f62e4c55] check-in: [9a64a4f2] user: drh branch: split-moveto, size: 14606
2016-11-09
00:10
Enhance the OP_IdxInsert opcode to optionally accept unpacked key material. file: [63030306] check-in: [89d958ab] user: drh branch: unpacked-IdxInsert, size: 14536
2016-10-20
22:02
Experimental est_count pragma. file: [012576c1] check-in: [340822af] user: drh branch: est_count_pragma, size: 14448
2016-09-10
19:51
Changes to give a warning-free build with SQLITE_OMIT_INCRBLOB and SQLITE_OMIT_SHARED_CACHE. file: [d05b2fcc] check-in: [711c5917] user: drh branch: trunk, size: 14392
2016-08-11
19:12
Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. file: [c2315463] check-in: [d9f8918c] user: drh branch: begin-concurrent, size: 14359
2016-07-09
16:14
Fix various internal #defines to conform to new C-language naming restrictions, specifically that private-use macros names must not begin with "_". file: [075c4570] check-in: [5471aca0] user: drh branch: trunk, size: 14316
2016-07-06
10:12
Add the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED sqlite3_db_status() parameter. file: [aee84823] check-in: [118321c8] user: dan branch: dbstatus-prop-cache-used, size: 14301
2016-06-04
20:37
Change the sqlite3BtreeKeySize() interface into sqlite3BtreeIntegerKey() and make it only work for table btrees. Change sqlite3BtreeDataSize() into sqlite3BtreePayloadSize() and make it work for all btrees. Combine sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() into a single sqlite3BtreePayloadFetch() routine. These changes seem to make the b-tree interface more rational and they reduce both binary size and CPU usage. file: [2107a263] check-in: [bef35e18] user: drh branch: btree-refactor, size: 14216
2016-05-21
20:03
Simplify the sqlite3BtreeInsert() interface by gathering the five arguments describing the content to be inserted into the new BtreePayload structure, and thus reducing the number of parameters from eight to four. file: [1342a9b2] check-in: [55f348cd] user: drh branch: trunk, size: 14287
2016-03-16
19:34
Merge the latest enhancements from trunk. file: [248919b5] check-in: [a7978ab6] user: drh branch: begin-concurrent, size: 13014
2016-02-22
23:44
Remove code not needed now that synchronous=OFF database files no longer trigger the use of a master journal. file: [a5008b9a] check-in: [aa9f4c62] user: drh branch: trunk, size: 12971
2016-02-02
02:53
Merge recent enhancements from trunk. file: [3c4f3fc0] check-in: [347f6a80] user: drh branch: begin-concurrent, size: 13052
2016-01-27
16:26
Change the name of the BTREE_IDXDELETE flag to BTREE_AUXDELETE, to better reflect its purpose. file: [368ceeb4] check-in: [1d3bf6be] user: drh branch: fordelete-assert, size: 13009
2016-01-21
17:06
Add a new hint bit on the flags parameter of sqlite3BtreeDelete(). The new BTREE_IDXDELETE bit indicates that the call is to delete an index entry corresponding to a table row that has already been deleted. file: [c5dfbbc5] check-in: [ac2cbadd] user: drh branch: btree-fordelete-flag, size: 13017
15:55
Improved comments on the FORDELETE hint. No logic changes. file: [52613736] check-in: [a3cec529] user: drh branch: trunk, size: 12788
2016-01-14
15:46
Merge the latest enhancements and fixes from trunk. file: [8b91bee0] check-in: [fccc5f20] user: dan branch: begin-concurrent, size: 12196
2016-01-07
16:06
Have the vdbe layer call sqlite3BtreeEnter() on all b-trees in use from within sqlite3VdbeExec() even in SQLITE_THREADSAFE=0 builds. This ensures that BtShared.db is set correctly. file: [68ef3017] check-in: [d0214602] user: dan branch: shared-cache-fix, size: 12153
2015-12-17
17:30
Reduce the size of the VdbeCursor object by a pointer (the pBt pointer used for ephemeral tables). file: [778f36cd] check-in: [98b710c3] user: drh branch: optimize-vdbecursor, size: 12193
2015-11-20
13:49
Merge all the latest enhancements and fixes from trunk. file: [beef3127] check-in: [41c8b8e3] user: drh branch: begin-concurrent, size: 12196
2015-11-12
14:57
First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. file: [2d76dee4] check-in: [549d42be] user: drh branch: cache_spill=N, size: 12153
2015-11-05
22:30
Improvements and simplifications to the equality seek logic. Tests are adjusted so that they all pass now. file: [1b8bf281] check-in: [997ce6c9] user: drh branch: seekeq-experiment, size: 12111
2015-10-30
17:17
Merge the sqlite3_db_cacheflush() enhancements and other changes from trunk. file: [86b2232c] check-in: [f2cde4cf] user: drh branch: begin-concurrent, size: 12181
2015-10-27
13:24
Split out sqlite3BtreeCursorHintFlags() from sqlite3BtreeCursorHint() the interface for improved performance. file: [b512723e] check-in: [b3ec9a0d] user: drh branch: cursor-hints, size: 12138
2015-10-26
20:11
Merge the BTREE_FORDELETE enhancement with this branch. file: [1957827f] check-in: [20da0849] user: dan branch: cursor-hints, size: 12336
2015-10-23
11:50
Remove an unused #define from whereInt.h. Add comments describing the new sqlite3BtreeCursor() flags. file: [cf936d96] check-in: [4c0ba8be] user: dan branch: btree-fordelete-flag, size: 10619
2015-10-22
20:54
Modifications to pass a flag to internal routine sqlite3BtreeCursor() when a cursor that is used solely for deleting b-tree entries, or for obtaining the components of keys to delete from other b-trees, is opened. file: [ccc48943] check-in: [cdc92919] user: dan branch: btree-fordelete-flag, size: 10164
2015-09-15
19:16
Merge enhancements from trunk. file: [cd4946a0] check-in: [fc4d1de8] user: drh branch: begin-concurrent, size: 10003
17:31
Merge enhancements from trunk. file: [9cc758f0] check-in: [66fe0683] user: drh branch: cursor-hints, size: 11677
2015-09-12
19:26
Experimental change to use a single-pass approach for DELETE statements on non-virtual tables that do not fire triggers or require foriegn-key processing. file: [40189aef] check-in: [eaeb2b80] user: dan branch: onepass-delete, size: 9960
2015-08-19
20:27
When committing an unlocked transaction, relocate newly allocated database pages within the file to avoid conflicting with committed transactions. There are lots of things still to fix in this code. file: [00d4cdb7] check-in: [3bbc31d5] user: dan branch: begin-concurrent, size: 9998
2015-08-14
23:57
Always provide the BTREE_BULKLOAD hint, even when SQLITE_ENABLE_CURSOR_HINTS is not defined, as that hint gives a 4% performance increase. file: [6310645b] check-in: [83a84435] user: drh branch: cursor-hints, size: 11672
15:05
Refactor the sqlite3BtreeCursorHint() interface for improved maintainability. file: [a1f058c4] check-in: [fc3fb5cd] user: drh branch: cursor-hints, size: 11954
2015-08-13
20:07
Merge in all the trunk changes from the previous year. This breaks the cursor-hint mechanism, but provides a baseline for trouble-shooting. file: [88803367] check-in: [82a7a61b] user: drh branch: cursor-hints, size: 10054
2015-08-10
20:22
Add the sqlite3_experimental_log_open() interface. This is for diagnostic use only and is not intended to ever go on trunk. file: [4c2590d2] check-in: [ac5d2e9d] user: drh branch: experimentalIoLog, size: 10026
2015-07-29
12:14
Only allow UNLOCKED transactions to commit if none of the pages read by the transaction have been modified since it was opened. file: [40bd41ef] check-in: [0b971842] user: dan branch: begin-concurrent, size: 9954
2015-07-27
19:31
Add an experimental "BEGIN UNLOCKED" command. file: [550e8447] check-in: [80794216] user: dan branch: begin-concurrent, size: 9994
2015-03-20
14:57
Provide the BTREE_SEEK_EQ hint to the b-tree layer. file: [969adc94] check-in: [e750830f] user: drh branch: seek-eq, size: 9955
2015-02-21
00:19
Keep track of the optimal number of reserved bytes (by looking at reserve byte requests in calls to sqlite3BtreeSetPageSize()) and then change the reserve byte count to the optimal when doing a VACUUM or when using the backup API. file: [9cbbb92a] check-in: [28c2b726] user: drh branch: trunk, size: 9348
2014-12-19
19:28
Experimental "PRAGMA data_version" command for detecting when another process has changed the database file. file: [94277c1d] check-in: [43db1f44] user: drh branch: data_version_pragma, size: 9403
2014-11-13
13:42
When a transaction or savepoint rollback occurs, save the positions of all open read-cursors so that they can be restored following the rollback operation. Cherry-pick of check-in [dd03a2802f3f27] file: [a4afc6b0] check-in: [402780a9] user: drh branch: branch-3.8.7, size: 9043
2014-11-12
14:56
When a transaction or savepoint rollback occurs, save the positions of all open read-cursors so that they can be restored following the rollback operation. file: [e31a3a3e] check-in: [dd03a280] user: dan branch: trunk, size: 9077
2014-11-11
22:55
Enhance ROLLBACK so that pending queries are allowed to continue as long as the schema does not change. This is a cherry-pick of check-in [b5df5ac052]. file: [97c4d0ef] check-in: [d4b2d5d0] user: drh branch: branch-3.8.7, size: 9044
01:33
Experimental changes that permit read operations to continue after a ROLLBACK, as long as the schema is unchanged. file: [d24fc2f3] check-in: [fa6e6a9a] user: drh branch: read-after-rollback, size: 9078
2014-11-04
12:11
Add the SQLITE_CONFIG_PCACHE_HDRSZ option for sqlite3_config(). file: [49b408be] check-in: [6eb03e62] user: drh branch: trunk, size: 9069
2014-08-22
23:33
Another performance tweak: Split the sqlite3BtreeCursorHasMoved() routine into two with the second routine named sqlite3BtreeCursorRestore(). The first now only reports whether or not the cursor has moved and the second tries to restore the cursor. This allows the sqlite3VdbeCursorMoveto() routine to be refactored to avoid stack pointer movements, for a noticable performance gain. file: [a79aa6a7] check-in: [ce123b5c] user: drh branch: trunk, size: 9035
2014-05-21
08:21
Fix the sqlite3_db_readonly() API so that it reports true if the database is readonly because the file format write version (byte 18 of the header) is too large. file: [4245a349] check-in: [8d8af114] user: drh branch: trunk, size: 8993
2014-03-31
22:03
Merge in the latest changes and fixes from trunk. file: [d79306df] check-in: [f6211540] user: drh branch: overflow-pgno-cache, size: 8953
2014-03-19
14:10
First attempt at getting block-sort to work. This is an incremental check-in. There are many problems still to be worked out. file: [232836cb] check-in: [59742dd4] user: drh branch: orderby-planning, size: 8952
2014-03-14
11:46
Fix a harmless compiler warning that crops up with SQLITE_MAX_MMAP_SIZE=0. file: [da1b69b4] check-in: [1277932b] user: drh branch: trunk, size: 8905
2014-03-11
20:33
Enable the b-tree cursor object's overflow page-number cache, which is normally enabled only for incr-blob cursors, for all cursors. file: [6b0c1a3f] check-in: [da591985] user: dan branch: overflow-pgno-cache, size: 8870
2014-02-12
21:31
Remove the "rowid cache" that sought to remember the largest rowid for a table and thereby speed up OP_NewRowid. That cache was ineffective. Removing it results in a performance increase of 0.4%, less memory usage, and a slightly smaller library size. file: [9e0f97c0] check-in: [56bc5ce8] user: drh branch: trunk, size: 8869
2014-02-05
17:08
Make the root page of an ephemeral index be page 1 instead of page 2. file: [f1c65e05] check-in: [a332908b] user: drh branch: subquery-codegen-refactor, size: 9063
2013-12-07
20:39
If the SQLITE_ENABLE_CURSOR_HINTS macro is defined, then invoke the sqlite3BtreeCursorHint() interface to provide hints to the storage engine about rows that need not be returned. Hints can be disabled using SQLITE_TESTCTRL_OPTIMIZATIONS with SQLITE_CursorHints (0x2000). Cursor hints are not used by the built-in storage engine of SQLite but might be useful to applications that provide their own storage engine. The current code is work-in-progrss and contains bugs. file: [450f1c60] check-in: [3a9bec52] user: drh branch: cursor-hints, size: 9080
2013-11-21
21:59
Changes some offset and amount parameters from "int" to "u32" to avoid harmless signed/unsigned comparison warnings. file: [a61ddebc] check-in: [4e8c5d07] user: drh branch: trunk, size: 8981
2013-08-16
20:42
Add the cache_spill pragma. file: [bfe0e8c5] check-in: [cdb181c0] user: drh branch: cache_spill, size: 8981
2013-05-01
19:49
Allocate 4 bytes of unused header space for an "Application ID". Add the "PRAGMA application_id" command to set and query this identifier. Add the "magic.txt" file to show how the posix file command might use this application id. file: [6fa8a3ff] check-in: [28c9e7fd] user: drh branch: application-id, size: 8985
2013-03-25
23:09
Memory-mapped I/O is now on by default. The "PRAGMA mmap_limit(N)" can be used to issue a hint to the VFS to limit mmap space to N bytes. The VFS is free to ignore that hint if desired. However, if "PRAGMA mmap_limit(0)" is used, xFetch is never called. file: [d9490cd3] check-in: [1b37c4ef] user: drh branch: experimental-mmap, size: 8949
2013-03-19
19:28
Add the sqlite3_io_methods.xMremap() method to the VFS interface. Also "PRAGMA mmap_size". file: [d3259057] check-in: [6183f1bd] user: dan branch: experimental-mmap, size: 8939
2012-10-13
19:58
Ensure that when the source of a backup is a database that is zero bytes in size, the final destination database consists of at least one page. Truncating it to zero bytes is equivalent to zeroing the schema cookie and change counter, which can cause problems for existing clients. file: [3ad7964d] check-in: [af5c9ee4] user: dan branch: zero-byte-backup-fix, size: 8897
2012-10-01
12:44
Omit the sqlite3GetReservedNoMutex() routine in build configurations where it is not used. file: [078f76b2] check-in: [f193dbb6] user: drh branch: trunk, size: 8863
2012-09-28
20:23
Avoid calling sqlite3BtreeEnter() in a corner case where the corresponding database handle mutex (sqlite3.mutex) may not be held. This prevents a potential deadlock or crash that can occur if the backup API, shared-cache mode and SQLITE_HAVE_CODEC are all in use. file: [5e6482bc] check-in: [89b8c377] user: dan branch: trunk, size: 8801
2012-08-06
18:50
When reusing pages as part of creating a new index, allocate the leaves from each free-list trunk page in ascending order, instead of trying to maximize localization for each individual allocation. This increases the chance that pages will be written to disk in ascending order by a large CREATE INDEX statement, improving overall performance. file: [4aee02e8] check-in: [d045f8b2] user: dan branch: sorter-coalesce-writes, size: 8756
2012-05-27
00:11
Fix corner-case problems with shared-cache for in-memory databases. file: [7b6af44e] check-in: [997ef5f6] user: drh branch: shared-cache-memdb, size: 8584
2012-02-13
16:43
Change the ROLLBACK command so that pending statements to not block it. The pending statements instead return SQLITE_ABORT upon next access. Note: This causes separate shared-cache connections in read_uncommitted mode to abort as well. file: [48a013f8] check-in: [9b66c79e] user: drh branch: nonblocking-rollback, size: 8550
2012-01-17
15:29
Remove the undocumented PRAGMA omit_readlock hack. file: [46e9f046] check-in: [96900c47] user: drh branch: trunk, size: 8546
2011-08-26
00:34
Create a new pager type, PAGER_SORTER, for use in the external merge sort. Such pagers are always held in memory but do report when they are under memory pressure by calling pagerStress. file: [9ddf0422] check-in: [c71d7320] user: drh branch: trunk, size: 8696
2011-05-11
14:57
Only open a read-only connection to shared-memory if the "readonly_shm=1" option is specified as part of the database file URI (and if a read-write connection fails). file: [d796dc40] check-in: [671ba5fc] user: dan branch: wal-readonly, size: 8688
2011-04-23
15:54
Have the ATTACH command do URI interpretation in the same way as sqlite3_open() and sqlite3_open_v2() do. file: [f5d775cd] check-in: [68240e75] user: dan branch: uri, size: 8616
2011-04-06
22:05
Fix a performance regression: Keep two btree masks in each prepared statement; one for btrees used and another for btrees that require locks. Only try to lock the btrees identified by the second mask. file: [11753dd4] check-in: [614de91a] user: drh branch: trunk, size: 8555
2011-04-05
17:31
Remove the mutex counter and the logic that attempts to verify that btree mutexes are held continuously. We are not making that assumption at this time. file: [221e186c] check-in: [242ce7cf] user: drh branch: trunk, size: 8484
2011-04-04
18:22
Add a description of access rules for the Schema object and lots of asserts to verify that the access rules are followed. file: [c0e0ff5c] check-in: [ae8374af] user: drh branch: schema-parse-refactor, size: 8566
00:14
Remove the BtreeMutexArray object - use the Vdbe.btreeMask field to accomplish the same result. Add a generation counter to btree mutexes in order to assert that mutexes are never temporarily dropped over a range of instructions in order to do deadlock avoidance in some subroutine. Lock all btrees in any Vdbe program that uses OP_ParseSchema. file: [a840a20c] check-in: [d81708f7] user: drh branch: trunk, size: 8470
2011-03-29
15:40
Fix a problem whereby following an IO error in CommitPhaseTwo() of a multi-file transaction the b-tree layer could be left in TRANS_WRITE state, causing problems later on. file: [8d36f774] check-in: [dbe569a0] user: dan branch: trunk, size: 9061
2010-11-19
18:51
Merge the checkpoint_fullfsync pragma and the superlock demonstration into the checkpoint-v2 experimental branch. file: [e2f2cd99] check-in: [ebf74015] user: drh branch: blocking-checkpoint, size: 9056
18:23
Add the checkpoint_fullfsync pragma which enables F_FULLFSYNC on checkpoint operations only, not during ordinary commit fsyncs. file: [10f9296b] check-in: [a0698673] user: drh branch: trunk, size: 9037
2010-11-18
12:11
Modify the interface to the blocking wal-checkpoint functionality. file: [1d62748e] check-in: [72787c01] user: dan branch: blocking-checkpoint, size: 9052
2010-11-16
18:56
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. file: [d1144d38] check-in: [7e3fc2c8] user: dan branch: blocking-checkpoint, size: 9038
2010-08-30
22:15
Provide hints to the btree layer during the creation of transient tables for when it is possible for those tables to use a hash rather than a binary tree. No use is currently made of those hints, though assert() statement verify their accuracy. file: [2d1a83ad] check-in: [4fead8e7] user: drh branch: trunk, size: 9033
2010-08-02
10:47
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. file: [b4ba2fdf] check-in: [e75b52d1] user: dan branch: trunk, size: 8804
2010-04-20
18:53
Use the read and write version fields of the database header to mark a database as operating in wal-mode. file: [dd83041e] check-in: [96bef18c] user: dan branch: wal, size: 8734
2010-03-30
22:58
Continuing refinements to the filesize-in-header enhancement. file: [ad6cff92] check-in: [79e22b95] user: drh branch: trunk, size: 8679
2010-02-12
18:18
Allow the secure-delete setting to be changed at run-time using a pragma. The SQLITE_SECURE_DELETE compile-time option determines the default setting. file: [0e193b7e] check-in: [f72f8a87] user: drh branch: trunk, size: 8645
2009-11-18
23:01
Performance improvement by avoiding unnecessary calls to memset(). file: [7944a9da] check-in: [85940468] user: drh branch: trunk, size: 8603
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [ddd915fd] check-in: [f6c045f6] user: drh branch: trunk, size: 8563
2009-07-22
00:35
Further simplifications to btree.c, especially the sqlite3BtreeKey() and sqlite3BtreeData() functions. New assert() statements added to verify that these routines are called correctly. (CVS 6917) file: [577448a8] check-in: [96cfd079] user: drh branch: trunk, size: 8625
2009-07-09
05:07
Restore (btree_set_cache_size) to test3.c. This is used on unix for the tcl "crash tests". Make some functions no longer used outside of btree.c static. (CVS 6869) file: [e53a10fd] check-in: [1d96ce8c] user: danielk1977 branch: trunk, size: 8568
2009-07-06
18:56
Make the sqlite3BtreeMoveto function static, since it is only used from within btree.c. Remove unused function lockBtreeWithRetry from btree.c. (CVS 6850) file: [e761619e] check-in: [30d5ec62] user: danielk1977 branch: trunk, size: 8602
2009-07-02
07:47
Cause opening a transaction on a sharable b-tree module automatically obtain a read-lock on page 1. This means there is no way for sqlite3BtreeGetMeta() to fail. (CVS 6836) file: [8cae6364] check-in: [e3c055f1] user: danielk1977 branch: trunk, size: 8698
2009-06-03
11:25
Define a set of constants to use as the "index" argument to sqlite3BtreeGetMeta and UpdateMeta. This makes some parts of the code easier to follow. (CVS 6709) file: [f70b694e] check-in: [6dbf4eca] user: danielk1977 branch: trunk, size: 8661
2009-05-28
11:05
Workaround the need for internal API sqlite3BtreeCursorDb(). It was only being used for an assert() statement, which can be done differently. (CVS 6683) file: [3748683b] check-in: [5904af6e] user: danielk1977 branch: trunk, size: 7842
2009-05-04
11:42
Speed up INSERT operations that add data to UNIQUE or PRIMARY KEY indexes by rationalizing duplicate seek operations. (CVS 6599) file: [58d876d3] check-in: [cac4f3d8] user: danielk1977 branch: trunk, size: 7890
2009-04-10
12:55
Changes to ensure that when running in shared-cache mode with a non-threadsafe build, the correct busy-handler callback is always invoked. (CVS 6481) file: [99fcc7e8] check-in: [683e4bd7] user: danielk1977 branch: trunk, size: 7874
2009-04-02
20:16
Make sure the VACUUM statement locks down the page_size and auto_vacuum modes after it runs. Otherwise, pragmas might change these settings on a populated database, resulting in problems. (CVS 6442) file: [8007018c] check-in: [85e6a474] user: drh branch: trunk, size: 8065
2009-03-18
10:33
Fix some cases where executing SQL from within a user-function callback could cause problems related to statement-transactions. (CVS 6355) file: [e302c574] check-in: [a60f4191] user: danielk1977 branch: trunk, size: 8069
2009-03-17
22:33
Move the rowid cache out of VdbeCursor and into BtCursor. When multiple BtCursors are open on the same table, set their rowid cache all at the same time. Ticket #3731. (CVS 6354) file: [8ed34391] check-in: [18978583] user: drh branch: trunk, size: 8165
2009-02-24
10:01
Optimize queries of the form "SELECT count(*) FROM <tbl>" by adding a sqlite3BtreeCount() interface to the btree layer. (CVS 6316) file: [96a019c9] check-in: [d4aa6593] user: danielk1977 branch: trunk, size: 8061
2009-02-03
16:51
Commit first version of the 'backup' feature. (CVS 6241) file: [4eab72af] check-in: [663479b4] user: danielk1977 branch: trunk, size: 7980
2009-01-24
11:30
Fix some minor compiler warnings. Added sqlite3Isalpha() for use in the soundex() function. (CVS 6203) file: [07359623] check-in: [bfc71edc] user: drh branch: trunk, size: 7936
2008-12-17
17:30
Add the savepoint feature. This feature is largely untested at this point. (CVS 6036) file: [4f141cf7] check-in: [34b56600] user: danielk1977 branch: trunk, size: 7989
2008-10-27
13:59
Make sqlite3_count_changes() and total_changes() work with "DELETE FROM ". (CVS 5844) file: [179c3ea8] check-in: [e68e4282] user: danielk1977 branch: trunk, size: 7943
2008-10-08
17:58
After an OP_NullRow is executed on a cursor, cause any subsequent OP_Next or OP_Prev to behave as if there were no more rows to traverse. Ticket #3424. (CVS 5782) file: [903682f2] check-in: [af679f61] user: danielk1977 branch: trunk, size: 7937
2008-08-13
19:11
Additional changes toward fixing ticket #3292. (CVS 5562) file: [6371c5e5] check-in: [0b92cbf5] user: drh branch: trunk, size: 7887
2008-07-11
21:02
Detect and handles the case where a row is modified or deleted while it is being read during SELECT processing. (CVS 5399) file: [03256ed7] check-in: [c80a5d09] user: drh branch: trunk, size: 7886
16:15
Additional test coverage for the btree module. Remove the failsafe() macro and replace it with ALWAYS() and NEVER(). (CVS 5395) file: [0063e985] check-in: [d7e2f0d2] user: drh branch: trunk, size: 7837
2008-07-10
00:32
Remove unused code. Test coverage enhancements. Modify the algorithm used to select column names for VIEWs of joins so that the constructed column names omits the underlying table names. (CVS 5386) file: [9373128f] check-in: [636cd723] user: drh branch: trunk, size: 8022
2008-05-29
03:01
Omit declaration for functions that are only used by asserts if asserts aren't being used (NDEBUG). (CVS 5173) file: [b1bd7e0b] check-in: [5afc445a] user: shane branch: trunk, size: 8077
2008-04-26
13:39
Use "(void)" function arguments in declarations instead of "()". Both are legal but some pedantic compilers complain about the latter. Ticket #3086. (CVS 5050) file: [8826591b] check-in: [a4149ca3] user: drh branch: trunk, size: 7739
2008-03-25
17:23
Modify the {quote: IdxDelete} opcode so that it takes an array of registers rather than a record formed using {quote: MakeRecord.} This avoids a needless packing and unpacking of the record to be deleted. (CVS 4916) file: [c66cb17c] check-in: [ee381b43] user: drh branch: trunk, size: 7735
09:47
Use a vdbe memory cell to allocate the space required for vdbe cursors. (CVS 4912) file: [e02869e1] check-in: [04715364] user: danielk1977 branch: trunk, size: 7616
00:22
Removed the direct btree tests - part of the ongoing effort to test by calling only public interfaces. Modify the sqlite3VdbeRecordCompare interface to used a pre-parsed second key - resulting in a 13% performance improvement on speed1p.test. (CVS 4911) file: [ca065a59] check-in: [0e1d84f2] user: drh branch: trunk, size: 7502
2007-12-07
18:55
In shared-cache mode, make sure the busy hander invoked is the busy handler associated with the database connection that caused the lock contention in the first place. (CVS 4598) file: [19dcf5ad] check-in: [c9eb6591] user: drh branch: trunk, size: 7642
2007-09-03
15:19
Honor the SQLITE_OPEN_ flags passed into sqlite3_open_v2(). Some test cases added but more are needed. Ticket #2616. (CVS 4376) file: [d0736ebc] check-in: [020a2b10] user: drh branch: trunk, size: 7695
2007-08-30
01:19
Fix for the sqlite3AbortOtherActiveVdbes() problem. (CVS 4328) file: [32fad0f0] check-in: [e40d40a5] user: drh branch: trunk, size: 7629
2007-08-29
17:43
Improvements to mutex asserts. The quick test runs to completion without assertion faults. (CVS 4324) file: [a90328ee] check-in: [2732af0e] user: drh branch: trunk, size: 7583
04:00
Better asserts(). But now some of the tests are busted again. (CVS 4320) file: [7391b9e7] check-in: [e8060f85] user: drh branch: trunk, size: 7425
00:33
More locking fixes. Now makes it all the way through quick.test. There are errors but no assertion faults. Progress. (CVS 4319) file: [21cea645] check-in: [844d40b8] user: drh branch: trunk, size: 7356
2007-08-28
23:28
The shared_err test runs with no errors. But a potential deadlock has been discovered and is still unfixed. (CVS 4317) file: [03895d1d] check-in: [f84550be] user: drh branch: trunk, size: 7286
02:27
Work toward correct btree locking in a multithreaded environment. (CVS 4307) file: [a8fb26c5] check-in: [b8cc493b] user: drh branch: trunk, size: 7262
2007-08-22
02:56
A complete run of quick.test with mutex debugging enabled. (CVS 4266) file: [76c89673] check-in: [783e07d5] user: drh branch: trunk, size: 6540
2007-08-21
19:33
The sqlite3_value object now carries an sqlite3* pointer to use for recording malloc failures. This eliminates the need to pass sqlite3* pointers into many internal interfaces. Also added more mutexing. (CVS 4263) file: [aeb85d6a] check-in: [92872761] user: drh branch: trunk, size: 6448
2007-08-20
22:48
Work toward multithreading support. Currently crashes quickly on a test. (CVS 4253) file: [52510556] check-in: [1315bd8e] user: drh branch: trunk, size: 6400
2007-08-17
01:14
Begin adding mutexes. Compiles without SQLITE_OMIT_SHARED_CACHE but we get an assertion fault on the shared cache testing. (CVS 4239) file: [91ee529d] check-in: [4c1e9ffe] user: drh branch: trunk, size: 6372
2007-05-08
21:45
Remove compiler warnings in the amalgamation. (CVS 3960) file: [1d527bf6] check-in: [c5754530] user: drh branch: trunk, size: 5622
14:51
Add the max_page_count pragma used to limit the maximum size of a database file. Untested. (CVS 3948) file: [8444af0c] check-in: [b1b74f06] user: drh branch: trunk, size: 5726
2007-05-05
18:49
Fix a header problem introduced in the previous check-in. (CVS 3929) file: [845543b5] check-in: [bece7a6b] user: drh branch: trunk, size: 5684
2007-05-04
18:36
Test interaction of incremental io and other database writes. (CVS 3922) file: [a9cd72b0] check-in: [4516416b] user: danielk1977 branch: trunk, size: 5772
2007-05-02
16:48
Cache the location of overflow pages in cursors used for incremental blob IO. (CVS 3899) file: [2c187d60] check-in: [349f1ea7] user: danielk1977 branch: trunk, size: 5778
01:34
Begin adding the zeroblob API to support incremental blob i/o. (CVS 3894) file: [b2ef1ccc] check-in: [7a01836d] user: drh branch: trunk, size: 5726
2007-05-01
17:49
First approximation of incremental blob IO API. (CVS 3892) file: [9a219f01] check-in: [c444836e] user: danielk1977 branch: trunk, size: 5689
2007-04-26
14:42
Add largely untested code for the incremental vacuum function. (CVS 3876) file: [4c0b5855] check-in: [f6a6d2b8] user: danielk1977 branch: trunk, size: 5619
2007-03-30
14:06
Refactoring the btree and pager routines into distinct two-phase commit routines. We've always done a two-phase commit - this change is just making that more apparent in the code. (CVS 3762) file: [9b2cc0d1] check-in: [66b3ad09] user: drh branch: trunk, size: 5376
2007-03-29
05:51
Change BtreeMoveto so that it can be biased to the right or to the center. Use a right bias when appending and a center bias when searching. This gives about a 15% reduction in calls to sqlite3VdbeRecordCompare. (CVS 3741) file: [540dcbbf] check-in: [ad4a6b1a] user: drh branch: trunk, size: 5326
2007-01-27
02:24
Limit the number of errors returned by PRAGMA integrity_check to 100 by default. Specify an alternative limit using an argument to the pragma. Ticket #2176. (CVS 3609) file: [066444ee] check-in: [d564a039] user: drh branch: trunk, size: 5310
2006-06-27
16:34
Prevent databases from being DETACHed while they are in use. Fix for #1873. (CVS 3312) file: [061c50e3] check-in: [70a48b25] user: danielk1977 branch: trunk, size: 5307
2006-02-11
01:25
Add support and documentation for the fullfsync pragma. Also include some other unrelated documentation updates. (CVS 3080) file: [40055cfc] check-in: [f2069d0b] user: drh branch: trunk, size: 5260
2006-01-07
13:21
In shared-cache mode, lock all required tables before beginning to execute the body of the statement program. (CVS 2881) file: [5663c4f4] check-in: [23b587b0] user: danielk1977 branch: trunk, size: 5264
2006-01-06
13:00
Add some simple tests and fixes for shared-schema locking. (CVS 2869) file: [f7ba8e2f] check-in: [d054bed1] user: danielk1977 branch: trunk, size: 5219
2006-01-05
11:34
Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) file: [96b8c00c] check-in: [deeda0dc] user: danielk1977 branch: trunk, size: 5180
2005-12-30
16:28
Add part of the btree layer of the shared-cache feature. (CVS 2848) file: [d6481f92] check-in: [2afcad99] user: danielk1977 branch: trunk, size: 5123
2005-12-16
15:24
Verify that the rollback-hook is invoked correctly when a malloc() failure occurs. (CVS 2824) file: [8ff86378] check-in: [83c8ae5b] user: danielk1977 branch: trunk, size: 5025
2005-08-27
16:36
Disable synchronous writes to the master journal when PRAGMA synchronous=OFF for all database files. Ticket #1375. (CVS 2630) file: [1ed56126] check-in: [644b96aa] user: drh branch: trunk, size: 5049
2005-03-21
04:04
Add function to recover from a malloc() failure. (CVS 2414) file: [41a71ce0] check-in: [1f9d10d7] user: danielk1977 branch: trunk, size: 5019
2005-02-06
02:45
Add the (highly experimental) omit_readlock pragma that disables the use of readlocks on read-only databases that are connected using ATTACH. (CVS 2317) file: [2e2cc923] check-in: [2155448d] user: drh branch: trunk, size: 4979
2005-01-12
07:15
Tests to improve coverage of vdbemem.c. (CVS 2200) file: [74d19cf4] check-in: [319bb4a9] user: danielk1977 branch: trunk, size: 4833
2004-11-05
15:45
Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067) file: [861e40b7] check-in: [b9d5f007] user: danielk1977 branch: trunk, size: 4754
2004-11-04
14:30
Support root-page allocation/deallocation in auto-vacuum databases. Still a few problems. (CVS 2054) file: [3166388f] check-in: [1da361fa] user: danielk1977 branch: trunk, size: 4437
2004-07-23
00:01
First cut at a analysis tool for version 3.0 databases. (CVS 1862) file: [94dfec0a] check-in: [7c7f698b] user: drh branch: trunk, size: 4423
2004-07-22
02:40
Changes in support of using a codec. (CVS 1844) file: [fab5e800] check-in: [b77bec35] user: drh branch: trunk, size: 4418
01:19
Initial implementation of variable page sizes and the temp_store pragma. (CVS 1843) file: [02fd2c26] check-in: [4cf6e9db] user: drh branch: trunk, size: 4382
2004-06-26
08:38
Remove the 'nMaster' argument from various pager and btree functions. (CVS 1737) file: [934d0ad3] check-in: [4e207209] user: danielk1977 branch: trunk, size: 4184
2004-06-14
06:03
Ensure the master journal directory is synced. Also, change the master journal format to store journal file names. (CVS 1583) file: [32f96abe] check-in: [73cd0aab] user: danielk1977 branch: trunk, size: 4188
2004-06-04
06:22
Move the 'busy-callback' logic to the pager layer. (CVS 1527) file: [589427ac] check-in: [ff70b6d2] user: danielk1977 branch: trunk, size: 4094
2004-06-03
16:08
Untested updates to support atomic multi-file transactions (CVS 1526) file: [7b682341] check-in: [d57e5252] user: danielk1977 branch: trunk, size: 4059
2004-05-31
10:01
Add read-transactions to the btree and vdbe. The compiler doesn't invoke them yet. (CVS 1502) file: [1e2beb41] check-in: [6b43633a] user: danielk1977 branch: trunk, size: 4004
08:26
Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) file: [61d670f4] check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 4000
2004-05-30
20:46
Various speed enhancements. (CVS 1498) file: [51270689] check-in: [a0db15bb] user: drh branch: trunk, size: 3923
2004-05-18
10:06
Fix many problems with manifest types and column affinity. Most things are working now. (CVS 1393) file: [b65140b5] check-in: [ad4a9641] user: danielk1977 branch: trunk, size: 3927
2004-05-12
19:18
Implement a B+tree option (all data stored on leaves). (CVS 1365) file: [6f51ad0f] check-in: [b8f70d17] user: drh branch: trunk, size: 3815
15:15
Btree uses signed integers for the rowid. The intToKey() and keyToInt() macros are now no-ops. (CVS 1364) file: [55495692] check-in: [fb3c8030] user: drh branch: trunk, size: 3732
2004-05-11
00:58
Updates to sqlite3BtreeKeyFetch() and sqlite3BtreeDataFetch(). (CVS 1347) file: [578dc465] check-in: [a675ac49] user: drh branch: trunk, size: 3732
2004-05-10
23:29
Work toward getting the new btree.c integrated with vdbe.c. (CVS 1345) file: [91343fe6] check-in: [bc5a2daf] user: drh branch: trunk, size: 3662
2004-05-09
23:23
Add a temporary sqlite2BtreeKeyCompare() function to help get regression tests passing again. (CVS 1332) file: [7c3939a2] check-in: [d8d1c91e] user: danielk1977 branch: trunk, size: 3669
00:40
All tests in btree.test now pass (but only because I commented out the btree_integrity_check test.) (CVS 1328) file: [825034a6] check-in: [ee706e9c] user: drh branch: trunk, size: 3732
2004-05-08
20:07
More btree.c bug fixes. (CVS 1327) file: [e111dde0] check-in: [e9f84ff3] user: drh branch: trunk, size: 3732
08:23
Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) file: [07a16dbb] check-in: [8af6474c] user: danielk1977 branch: trunk, size: 3706
2004-05-07
23:50
More bug fixes in btree.c. (CVS 1322) file: [ba5d3bfa] check-in: [a80939ef] user: drh branch: trunk, size: 3401
13:30
New btree.c module compiles and links. (CVS 1320) file: [49b255b2] check-in: [dcd6b55f] user: drh branch: trunk, size: 3369
2004-04-26
14:10
Pager tests working. (CVS 1308) file: [858659c6] check-in: [910067a2] user: drh branch: trunk, size: 3102
2004-02-10
02:57
Make the pager accessible from the btree structure always, not just during debugging. (CVS 1219) file: [41cb3ff6] check-in: [9c6b4758] user: drh branch: trunk, size: 6639
2003-06-01
01:10
Add the ability to INSERT or UPDATE using the "rowid" column even on tables that lack an integer primary key. (CVS 991) file: [9b7c09f1] check-in: [903adbe8] user: drh branch: trunk, size: 6639
2003-04-25
13:28
Work around a name collision problem on windows. (CVS 934) file: [23c50e00] check-in: [c3b1f84d] user: drh branch: trunk, size: 6639
13:22
Make VACUUM work even if multiple processes have the database open at once. (CVS 933) file: [6488448d] check-in: [caa96028] user: drh branch: trunk, size: 6639
02:43
Get VACUUM working again - with test cases. Some other minor cleanups. (CVS 931) file: [dc899dd3] check-in: [5afb8800] user: drh branch: trunk, size: 6680
2003-04-16
01:28
Remove some unnecessary code and complication from the btree interface. (CVS 909) file: [529c98cb] check-in: [35cc7c7d] user: drh branch: trunk, size: 6599
2003-04-06
20:44
Simplify the BTree interface by shortening names. Added two new methods for accessing the current filename and for changing the name of the database file. (CVS 900) file: [5cb87154] check-in: [185d8dc8] user: drh branch: trunk, size: 6665
2003-04-01
21:16
Add infrastructure to suport multiple btree implementations (CVS 894) file: [024d2dd2] check-in: [79b3aed2] user: paul branch: trunk, size: 6643
2003-03-19
03:14
Modifications to the VDBE to support more than one database file. (CVS 878) file: [8209bfad] check-in: [875da9ee] user: drh branch: trunk, size: 2594
2003-02-12
14:09
Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 863) file: [36a7a26a] check-in: [792a9e15] user: drh branch: trunk, size: 2522
2002-12-04
13:40
Add the sqliteBtreePrevious() routine to the BTree module API. This is in anticipation of implementing reverse order searching of a table. (CVS 794) file: [17710339] check-in: [0ad1d938] user: drh branch: trunk, size: 2477
2002-08-11
20:10
Fix for ticket #9: Add the ability to read little-endian database files from a big-endian machine and vice versa. (CVS 704) file: [0ca6c263] check-in: [ce4b943b] user: drh branch: trunk, size: 2430
2002-02-19
15:00
Optimize simple min() and max() queries. (CVS 382) file: [8abeabfe] check-in: [cc5abfe3] user: drh branch: trunk, size: 2401
13:39
Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) file: [9fd16f33] check-in: [c6e9048e] user: drh branch: trunk, size: 2358
2002-02-03
19:15
Reenable testing code even if NDEBUG is defined. (CVS 367) file: [b131caa4] check-in: [0090c279] user: drh branch: trunk, size: 2352
17:37
Put in PRAGMA SANITY_CHECK in place of VACUUM. (CVS 365) file: [53476ad4] check-in: [7c65029e] user: drh branch: trunk, size: 2351
2002-02-02
18:49
Get the ABORT conflict resolution algorithm working. (CVS 362) file: [a94bef69] check-in: [9be4d4c6] user: drh branch: trunk, size: 2355
2002-01-04
03:09
An attempt to delete a single row using a WHERE clause that specifies the rowid would result in an error if the rowid did not exist. This problem has been resolved. (CVS 338) file: [9ead7f54] check-in: [011be9a9] user: drh branch: trunk, size: 2249
2001-12-15
14:22
Comment and documentation changes. (CVS 331) file: [8767bd4e] check-in: [e8595579] user: drh branch: trunk, size: 2207
2001-11-07
14:22
Incremental update. We are in the middle of modifying the index system to support range queries without doing a complete table scan. (CVS 303) file: [0250a0a5] check-in: [e6ca23fa] user: drh branch: trunk, size: 2107
2001-09-27
03:22
Added basic support for enforcement of UNIQUE on indices and primary keys. Support for addition constraints is to follow. (CVS 267) file: [57d653ef] check-in: [34c42967] user: drh branch: trunk, size: 2068
2001-09-23
02:35
Fixes to the locking and rollback behavior. (CVS 261) file: [5e553186] check-in: [337b3d3b] user: drh branch: trunk, size: 1991
2001-09-16
00:13
Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [fcb08daa] check-in: [4e926efe] user: drh branch: trunk, size: 1979
2001-09-14
18:54
Added a PRAGMA statement. Took out the special comment parsing. (CVS 245) file: [a3d9c20f] check-in: [5e372460] user: drh branch: trunk, size: 2528
2001-09-13
14:46
The BTree changes are now integrated and the whole thing compiles and links. I have not yet tried to run it, though. (CVS 239) file: [2427961c] check-in: [a0a1e701] user: drh branch: trunk, size: 2486
13:46
The code is in place to replace GDBM with BTree. But I have not yet attempted to compile it. I am sure the code contains bugs. (CVS 238) file: [1fe9710a] check-in: [6ecc8b20] user: drh branch: trunk, size: 2419
2001-08-20
00:33
Restore btree to the main line. (CVS 237) file: [66172842] check-in: [2e6aff98] user: drh branch: trunk, size: 2375
2001-07-02
17:51
BTree and pager are working pretty well now. (CVS 234) file: [5fb5799b] check-in: [a84fb078] user: drh branch: trunk, size: 2323
2001-06-30
21:53
Implemented the sqliteBtreeSanityCheck() test function. (CVS 232) file: [987d8065] check-in: [42486880] user: drh branch: trunk, size: 2309
2001-06-28
01:54
Got a lot of BTree tests working. Still lots more needed. (CVS 230) file: [d327e9ad] check-in: [9cfeeb58] user: drh branch: trunk, size: 2260
2001-06-25
02:11
More tests and bug fixes in btree.c (CVS 229) file: [2ce445f0] check-in: [6b9b298b] user: drh branch: trunk, size: 2227
2001-06-22
19:15
The BTree code compiles and links now, but it does not work yet. (CVS 226) file: [40ae2c9b] check-in: [b31c4902] user: drh branch: trunk, size: 2227
2001-06-08
00:21
incremental update (CVS 223) file: [f9adc22e] check-in: [7108b699] user: drh branch: trunk, size: 2113
2001-06-02
02:40
continued work on btree (CVS 222) file: [4a50996c] check-in: [d07e0e80] user: drh branch: trunk, size: 1963
2001-05-24
21:06
Continued work on btree (CVS 219) file: [a0ef9051] check-in: [18500cdc] user: drh branch: trunk, size: 1870
2001-04-17
20:09
Begin adding BTree code (CVS 213) file: [f21c240d] check-in: [bdb1c425] user: drh branch: trunk, size: 2097 Added