Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
291 check-ins using file tool/getlock.c version f4c39b6513
|
2012-06-28
| ||
| 08:15 | Disable mmap() on 32-bit hosts. check-in: 3a4aa407a7 user: dan tags: trunk | |
| 01:09 | Add a makefile target for the "varint" command-line tool that converts integers into varints and varints into integer for debugging. check-in: 1a65f02fae user: drh tags: trunk | |
|
2012-06-27
| ||
| 22:36 | Display a hex dump of the row content of each page in lsmview.tcl. Add the "Export" button to lsmview.tcl. check-in: 13d59a9f43 user: drh tags: trunk | |
| 21:46 | Correction to the usage comment on the "show" command of "lsmtest". check-in: 6b2b23de4f user: drh tags: trunk | |
| 20:28 | Move tdb_lsm_config_str and test_lsm_config_str out of the "#ifdef LSM_MUTEX_PTHREADS" block. check-in: c1e0b6a7e8 user: dan tags: trunk | |
| 18:31 | Update the lsmview.tcl script to work with embedded b-trees. check-in: fdf301afe7 user: dan tags: trunk | |
| 16:34 | Merge embedded-btree branch with trunk. check-in: 5eed33bc57 user: dan tags: trunk | |
| 16:10 | Remove a broken assert from lsm_sorted.c. Leaf check-in: 50e87e23bb user: dan tags: embedded-btree | |
| 16:02 | Testing finds no cases where separator runs are faster than embedded btrees. So discard the separator runs related code. check-in: afcbe561ff user: dan tags: embedded-btree | |
| 13:56 | Purge talk of sqlite4_prepare_v2() from the documentation. Also attach the original SQL to a prepared statement, even for internally generated statements. check-in: bd2216554b user: drh tags: trunk | |
| 12:28 | Fixes to the amalgamation in order to enable a fossil4 build. check-in: 4539458ce3 user: drh tags: trunk | |
| 10:22 | Ensure that "expensive-assert" code only runs when LSM_DEBUG_EXPENSIVE is defined. check-in: 2be9bac408 user: dan tags: embedded-btree | |
|
2012-06-26
| ||
| 20:39 | Merge trunk changes. check-in: 209c12ae0b user: dan tags: embedded-btree | |
| 20:17 | Updates to the design and storage documents. check-in: f19a93d9f9 user: drh tags: trunk | |
| 19:45 | Fix a bug causing an infinite loop if there are open cursors when the in-memory tree is flushed to disk. check-in: d409cd8c8a user: dan tags: embedded-btree | |
| 18:47 | Remove more traces of SQLITE_WSD. Everything is in pEnv now, with the except of the global state of the alternative memory allocators mem3 and mem5. check-in: 859a51036f user: drh tags: trunk | |
| 18:24 | Add a stack of named storage engines, with the ability to push or pop storage engines using sqlite4_env_config(). check-in: 5df080a1aa user: drh tags: trunk | |
| 18:10 | Fix another problem with mmap and using a background thread. check-in: ec39163b79 user: dan tags: embedded-btree | |
| 15:43 | Add LSM_CONFIG_NMERGE parameter. Add code to lsmtest so that lsm configurations can be specified in string form. check-in: 0fcabb513b user: dan tags: embedded-btree | |
| 14:51 | Add version information to the start of the sqlite4_kv_methods object. Begin adding documentation on adding external storage engines. check-in: 568d9dca50 user: drh tags: trunk | |
| 00:05 | Expose the sqlite4_kvstore object and its relatives in the public interface. check-in: 26f71bad46 user: drh tags: trunk | |
|
2012-06-25
| ||
| 23:17 | Update the porting guide to include sqlite4_log() and sqlite4_randomness() in the set of functions requiring an sqlite4_env object. check-in: 7dcd06d12a user: drh tags: trunk | |
| 23:15 | Add the sqlite4_env parameter to sqlite4_log(). check-in: e8814a06a8 user: drh tags: trunk | |
| 22:52 | Make the initialization of the global built-in function table threadsafe. check-in: 366e83e3d7 user: drh tags: trunk | |
| 19:46 | Complete removal of sqlite4_config(). All code now uses sqlite4_env_config() instead. check-in: 33bf91ee7c user: drh tags: trunk | |
| 19:34 | Merge the sqlite4_env api changes onto trunk. There is still a lot of work to be done, but it at least now passes most tests. check-in: 4192f826d1 user: drh tags: trunk | |
| 19:28 | Fixes to the kvwrap test interface. At this point, most tests pass, though there are still massive memory leaks. Major unresolved issues: (1) the global function. (2) API for substituting new storage engines. Leaf check-in: dee2172b52 user: drh tags: sqlite4_env | |
| 19:16 | Fix another remapping related problem. check-in: 3e50bb0a22 user: dan tags: embedded-btree | |
| 18:53 | Initialize the random number generator in sqlite4_initialize(). check-in: a34def59f7 user: drh tags: sqlite4_env | |
| 18:40 | Fix a problem with stale pointers after remapping a file. check-in: 49cfd9043b user: dan tags: embedded-btree | |
| 10:02 | Fix various glitches to do with iterating through b-tree structures. check-in: a983d57868 user: dan tags: embedded-btree | |
|
2012-06-23
| ||
| 20:22 | Scan the embedded b-trees instead of the separator runs when merging in separator keys from a lower level. check-in: 90c0d5d8fe user: dan tags: embedded-btree | |
| 17:26 | Tests run to completion now - no more assertion faults. But still lots of errors and memory leaks. check-in: 272ebdd8c0 user: drh tags: sqlite4_env | |
| 10:04 | Add untested functions to save and restore b-tree cursor positions. check-in: cc0b45d17e user: dan tags: embedded-btree | |
|
2012-06-22
| ||
| 20:29 | Continuing work on sqlite4_env and getting it to be used everywhere. The changes here are mostly having to do with mutexes. They compile, but there are errors. This is an incremental check-in so that I can change to work on another project where an issue has just come up. check-in: 1d65209131 user: drh tags: sqlite4_env | |
| 18:06 | Merge trunk changes. check-in: df818c275b user: dan tags: embedded-btree | |
| 17:57 | Add functions to iterate through b-tree keys. Also a complex assert statement to check that b-trees are correct with respect to the main run content. check-in: 29d761c438 user: dan tags: embedded-btree | |
| 16:55 | Modify sqlite4_mem_methods to remove xRoundup, add the Benign methods, and for all methods to take an environment pointer as their first argument. check-in: 949cb749fe user: drh tags: trunk | |
| 14:58 | Add the sqlite4_env parameter to sqlite4_threadsafe(). check-in: d3fa91fcba user: drh tags: trunk | |
| 14:38 | Update sqlite4_snprintf() documentation to conform to the implementation. Add the sqlite4_env pointer to sqlite4_randomness(). check-in: 3d9d348099 user: drh tags: trunk | |
| 14:11 | Add sqlite4_env pointers to BenignMalloc() interfaces. check-in: 1d55f52a68 user: drh tags: trunk | |
| 13:55 | Hash objects track and use the sqlite4_env environment object. check-in: 51ce2f2c5a user: drh tags: trunk | |
| 13:41 | Update the KVStore and KVCursor objects so that they track and use the run-time environment in which they were created. check-in: dfb7327a6b user: drh tags: trunk | |
| 13:07 | Add (incomplete) notes on porting an application from SQLite3 to SQLite4. check-in: 4d0c4d3194 user: drh tags: trunk | |
| 13:02 | Refactor the sqlite4_snprintf() interface to be closer to (but not exactly the same as) the design of snprintf() from the standard library. Make the StrAccum object aware of sqlite4_env. check-in: 8f6298ae15 user: drh tags: trunk | |
| 10:31 | The same errors seen in the malloc-refactor branch are also on trunk, so go ahead and merge the malloc-refactor changes back into trunk. The errors were not caused by the refactoring, apparently. check-in: 91ba00572b user: drh tags: trunk | |
| 10:26 | "make test" now runs to completion. But there are 5 errors and a big memory leak. Leaf check-in: 4360e4fcf7 user: drh tags: malloc-refactor | |
| 02:37 | Begin refactoring the memory allocation logic to always require an environment pointer. This code will compile but does not run. check-in: 196691d50e user: drh tags: malloc-refactor | |
|
2012-06-21
| ||
| 20:22 | Experimentally try embedding b-tree pages in sorted runs instead of creating an external separators run. This slows down the rate at which blocks can be cycled during incremental merging, but also makes database writes more contiguous. check-in: 97fe6585f1 user: dan tags: embedded-btree | |
| 19:13 | Get the amalgmation build working. check-in: 2d7bf1c174 user: drh tags: trunk | |
|
2012-06-20
| ||
| 18:44 | Do not crash if a NULL pointer is passed to lsm_work(). check-in: 9c5b3be405 user: dan tags: trunk | |
| 18:12 | Fix errors in log1.test. check-in: e68d4c19fc user: dan tags: trunk | |
| 18:08 | Avoid creating the first page of a separators run until the first key is actually ready. check-in: 370c91e3fb user: dan tags: trunk | |
| 15:21 | Fix another issue to do with non-default page sizes. check-in: 081b0b60d9 user: dan tags: trunk | |
| 15:06 | Make the page-size and block-size of a database read-only after the database has first been opened (even if it is has not been written to). check-in: d3bdb27143 user: dan tags: trunk | |
| 09:02 | Fix a crash that can occur if there are multiple clients and one calls lsm_work() on an empty database. check-in: f148e2d69e user: dan tags: trunk | |
|
2012-06-19
| ||
| 20:13 | Fix an issue with opening a database with a page-size other than the default. check-in: a3bb493051 user: dan tags: trunk | |
| 19:20 | Fix typo in lsm.h. check-in: eac6a6e736 user: dan tags: trunk | |
| 19:18 | Add OOM tests. check-in: af626f504f user: dan tags: trunk | |
| 17:12 | Fix a memory leak. And a crash that can follow an OOM condition. check-in: 0b88b3e607 user: dan tags: trunk | |
| 15:49 | Fix a bug in saving the free-list. check-in: 1b963352fc user: dan tags: trunk | |
| 11:06 | Add the lsm_env.xFullpath method. check-in: a44d3a0079 user: dan tags: trunk | |
| 09:33 | Add the lsm_env.xFileid method. check-in: 2c1cb6d1df user: dan tags: trunk | |
|
2012-06-18
| ||
| 11:58 | Add an option to lsmtest to log all writes and syncs to a file. And a mode to play back the writes and syncs in a log file. check-in: 3ac27ad615 user: dan tags: trunk | |
| 09:49 | Sometimes (quite infrequently), SQLite will call OP_Next or OP_Prev on a cursor that points at EOF (usually because it has been opened but not positioned). SQLite expects SQLITE_NOTFOUND here, but lsm considers this a misuse. Add a workaround to catch this case in kvlsm.c. check-in: 33f7f3d0ca user: dan tags: trunk | |
|
2012-06-16
| ||
| 20:17 | Use LSM_SEEK_LEFAST to allocate rowids and table numbers. check-in: 17cbef9640 user: dan tags: trunk | |
| 17:57 | Fix a typo in key_encoding.txt. check-in: 16087468ca user: dan tags: trunk | |
| 15:15 | Wiki-ify more of the design document. check-in: 2918b534a9 user: drh tags: trunk | |
| 01:51 | Largely replace sqlite4_config() and sqlite4_status() with sqlite4_env_config() and sqlite4_env_status(). Hold status information in the sqlite4_env object. The old sqlite4_config() interface is still used by test_storage2.c. check-in: 069df232c7 user: drh tags: trunk | |
| 00:52 | Expand the sqlite4_env_config() functionality, moving it towards becoming a replacement for sqlite4_config(). check-in: bc03d8b6ae user: drh tags: trunk | |
|
2012-06-15
| ||
| 19:45 | The sqlite4_initialize() and sqlite3_shutdown() routines now apply to a specific sqlite4_env object, not to the entire process. check-in: 816caf4560 user: drh tags: trunk | |
| 19:25 | Remove LSM_INFO_CKPT. check-in: 265f78a59f user: dan tags: trunk | |
| 19:15 | Remove the sqlite4_temp_directory global variable. check-in: 621d0959d3 user: drh tags: trunk | |
| 18:44 | Add a link to env.wiki to the homepage. check-in: a9320cba9e user: drh tags: trunk | |
| 18:32 | Add notes on the sqlite4_env run-time environment object. check-in: bd88d085ab user: drh tags: trunk | |
| 18:28 | Ensure that the restrictions on lsm_csr_next() and lsm_csr_prev() calls are enforced. check-in: b8afdc063a user: dan tags: trunk | |
| 17:40 | Remove more VFS code. check-in: e08d204b2c user: drh tags: trunk | |
| 17:19 | Begin removing the VFS. check-in: 153c39d376 user: drh tags: trunk | |
| 17:01 | Combine the lsm_cursor and MultiCursor structures. check-in: d5d71903fc user: dan tags: trunk | |
| 15:41 | Remove the source files for the obsolete sqlite4_get_table() implementation. check-in: bc1ff706e6 user: drh tags: trunk | |
| 15:21 | Remove tests cases that are specific to shared-cache, since SQLite4 does not have shared cache. check-in: 3db6e07474 user: drh tags: trunk | |
| 15:03 | Remove all FTS1 and FTS2 test scripts. check-in: 540af0b093 user: drh tags: trunk | |
| 14:50 | Remove the sqlite4_soft_heap_limit() and sqlite4_release_memory() interfaces. check-in: 74885d9cbf user: drh tags: trunk | |
| 14:08 | One more OOM related fix for lsm_log.c. check-in: 2069291793 user: dan tags: trunk | |
| 14:07 | Changes to lsm_log.c to avoid crashing following an OOM condition. check-in: acfbe5d203 user: dan tags: trunk | |
|
2012-06-14
| ||
| 20:43 | Add LSM_SEEK_LEFAST. But do not enable it in OP_NewRowid yet, as it causes too many test cases to fail. check-in: 91a802eedd user: dan tags: trunk | |
| 19:02 | Make sure the constructors for KVStore objects have access to the sqlite3_env object. check-in: 22e89b1dc1 user: drh tags: trunk | |
| 18:01 | Avoid storing a pointer to an lsm_env object in any structure that may be shared by more than one connection. check-in: d8018604ee user: dan tags: trunk | |
| 15:04 | Fix an out-of-bounds read problem. check-in: 8785d13b06 user: dan tags: trunk | |
| 14:05 | Remove some unused variables. check-in: 9b06d41f7b user: dan tags: trunk | |
| 11:38 | Fix another memory leak. check-in: ba35f9d68a user: dan tags: trunk | |
| 09:54 | Fix a test problem in lsmtest6.c. And some dropped return codes in lsm. check-in: 084e4c1ad8 user: dan tags: trunk | |
|
2012-06-13
| ||
| 20:24 | Continue adding OOM tests. check-in: 7f7d7bc687 user: dan tags: trunk | |
| 17:41 | Fix another memory leak. check-in: 9834ea1d9d user: dan tags: trunk | |
| 17:36 | Fix long standing memory leak. check-in: 3380b739e1 user: dan tags: trunk | |
| 16:38 | Fix further problems revealed by OOM injection tests. check-in: d6ce76ed01 user: dan tags: trunk | |
|
2012-06-12
| ||
| 20:20 | Extra tests. check-in: a65d1ea34d user: dan tags: trunk | |
| 17:43 | Start adding OOM injection tests to lsmtest. Fix issues along the way. check-in: d089a0f97e user: dan tags: trunk | |
|
2012-06-11
| ||
| 19:51 | Improve documentation in lsm_file.c. Fix other problems. check-in: 9afb7862e4 user: dan tags: trunk | |
| 16:35 | Changes so that phantom runs work in mmap mode. check-in: 57e0f3288d user: dan tags: trunk | |
| 16:00 | Fix the way meta-pages are handled in lsm_file.c. check-in: d352b485a6 user: dan tags: trunk | |
|
2012-06-09
| ||
| 20:08 | Simplify the code that selects runs to merge to use an algorithm more like an ordinary merge sort. Store the number of times each level has been merged in the checkpoint blob. Add a way to elect to use mmap() instead of read()/write() for IO at runtime. check-in: e1816661f1 user: dan tags: trunk | |
|
2012-06-05
| ||
| 19:38 | Remove Database.pCkptMutex. Fix a problem with database files larger than 2GB. check-in: 84ea6f9a68 user: dan tags: trunk | |
| 15:32 | Add new methods to struct lsm_env: xUnlink and xSectorSize. check-in: 549b270c77 user: dan tags: trunk | |
| 11:52 | Improve the "lsmtest speed" command. check-in: 2d2ca7bb25 user: dan tags: trunk | |
|
2012-06-04
| ||
| 19:52 | Switch to using the C interface when building leveldb into lsmtest. check-in: 0ad3b38e01 user: dan tags: trunk | |
| 18:14 | Embed checksums in selected WRITE and DELETE records to limit the size of allocations and reads that may be made during recovery as a result of garbage in log files. check-in: 66d3f705c6 user: dan tags: trunk | |
| 14:23 | Fix a problem with holding lsm cursors open when the in-memory tree is flushed to disk. check-in: dc75aaa181 user: dan tags: trunk | |
| 09:26 | Add an option to lsmview.tcl to display database keys and values using hex notation. check-in: ac42c5dbca user: dan tags: trunk | |
|
2012-06-02
| ||
| 19:25 | Change the 'lsmtest crash' command to accept a glob pattern as an argument. check-in: a64905f08e user: dan tags: trunk | |
| 18:55 | Fix some of the lsmtest crash recovery tests. Update the code in lsm_log.c so that if synchronous=FULL, each transaction in the log file is stored on its own set of disk sectors. check-in: 960afb3114 user: dan tags: trunk | |
|
2012-06-01
| ||
| 19:47 | Fix test infrastructure for lsmtest power failure tests. check-in: 5666f70625 user: dan tags: trunk | |
| 14:29 | Fix a problem displaying pointers in lsmview.tcl. check-in: f0adbf3613 user: dan tags: trunk | |
| 13:17 | Further improvements to lsmview.tcl. check-in: acd617edb0 user: dan tags: trunk | |
|
2012-05-31
| ||
| 20:07 | Enhance lsmview.tcl so that it may be passed a database name on the command line. check-in: d34cc3832d user: dan tags: trunk | |
| 19:11 | Add lsm_info() options to obtain the list of pages for an array, and to dump the contents of a page in human readable form. check-in: 0bdcfc3932 user: dan tags: trunk | |
|
2012-05-30
| ||
| 20:17 | Fix a problem with log-wrapping triggered by an asynchronous checkpoint. check-in: 99b6b9ade5 user: dan tags: trunk | |
| 18:41 | Log-file related fixes for savepoint rollback. check-in: 23794ed181 user: dan tags: trunk | |
| 17:10 | Simplify the internals of lsm_log.c a bit. check-in: af5842b48f user: dan tags: trunk | |
| 12:02 | Avoid overwriting runs that may still be in use when performing background work. check-in: 771940c9cc user: dan tags: trunk | |
|
2012-05-29
| ||
| 18:03 | Fix a problem causing a block to be added to the freelist and reused as part of the same write. check-in: d515a162a2 user: dan tags: trunk | |
| 16:08 | Fix a crash when attempting to close a database handle on which lsm_open() has failed. check-in: d1817c36d2 user: dan tags: trunk | |
| 16:02 | Fix checkpointing of databases that contain large numbers of levels. check-in: e867c0cea0 user: dan tags: trunk | |
|
2012-05-28
| ||
| 19:20 | Fix a bug causing the generation of very large database files. check-in: 4550832dec user: dan tags: trunk | |
| 18:25 | Remove the "append-list" from the shared data and checkpoint formats. check-in: 75b9eec7fb user: dan tags: trunk | |
|
2012-05-23
| ||
| 11:49 | Fix problems with log wrapping. check-in: d2c9dc4ffa user: dan tags: trunk | |
|
2012-05-22
| ||
| 19:46 | Add missing test/test_lsm.c file. check-in: 385799592f user: dan tags: trunk | |
| 19:45 | Further progress and test cases for logging. check-in: 20ec785d0a user: dan tags: trunk | |
|
2012-05-21
| ||
| 20:13 | Further work on logging and thread-safety in lsm. check-in: 2f9b09b9b8 user: dan tags: trunk | |
| 09:02 | Further work on LSM log files. Add the sqlite4_kvstore_control() interface. The only use of this so far is to allow applications to retrieve the lsm_db* handle associated with a database backup. This is useful for testing. check-in: ad1c1793fc user: dan tags: trunk | |
|
2012-05-19
| ||
| 10:03 | Update log file format comments in lsm_log.c. Store the current log file offset as a part of each checkpoint record. check-in: 802871916a user: dan tags: trunk | |
|
2012-05-18
| ||
| 16:13 | Truncate any log file to zero bytes in size as part of a clean database shutdown. check-in: 50a7df2a67 user: dan tags: trunk | |
| 15:04 | Logging related fix for databases with multiple clients. check-in: e607910f65 user: dan tags: trunk | |
| 09:20 | Fix a bug in log recovery checksums. check-in: 48bb7fd595 user: dan tags: trunk | |
|
2012-05-17
| ||
| 20:01 | Re-enable logging. Still buggy. check-in: 279f148134 user: dan tags: trunk | |
|
2012-05-11
| ||
| 11:07 | Fix typos in the design.wiki document. check-in: 4afc8d05d7 user: drh tags: trunk | |
|
2012-05-09
| ||
| 16:58 | Fix problems with multi-threaded lsm tests. check-in: 41a5660c29 user: dan tags: trunk | |
| 14:35 | Mark checkpointed b-tree pages as read-only when they are reloaded from disk. Fix other lsm problems related to [8e27d1f99c]. check-in: 4c8557b77c user: dan tags: trunk | |
| 11:46 | Minor tweak to the decimal_floating_point.txt note. check-in: df636b697a user: drh tags: trunk | |
| 11:37 | Tweaks to the design summary document. check-in: a36eae7be6 user: drh tags: trunk | |
| 09:23 | Fix crash in debugging function lsmLogMessage(). check-in: 009cce0921 user: dan tags: trunk | |
|
2012-05-08
| ||
| 23:38 | Begin adding documentation in the www/ directory. check-in: 6df890f9b0 user: drh tags: trunk | |
| 20:02 | Re-enable writing separators and main runs to the same block. check-in: 8e27d1f99c user: dan tags: trunk | |
| 14:19 | Fix a problem in lsmtest4.c. check-in: e52e8a370d user: dan tags: trunk | |
| 11:51 | Fix lsmtest "rollback" tests. Fix a memory leak in lsm_shared.c. check-in: 788cb6b961 user: dan tags: trunk | |
|
2012-05-07
| ||
| 19:53 | Enable the fenceposting code in lsmtest_mem.c. Fix a bug in lsm_mem.c. Remove traces of the old mutex API. check-in: adca302324 user: dan tags: trunk | |
| 18:57 | Fix compilation problem in lsmtest. check-in: e5c56f655f user: dan tags: trunk | |
| 18:39 | Use lsm_env instead of lsm_mutex_methods. check-in: ee29d7847d user: dan tags: trunk | |
| 17:33 | Remove lsm_vfs. Use lsm_env instead. check-in: a9c6261d5d user: dan tags: trunk | |
| 16:47 | Ensure that all allocations made by the LSM module use the supplied malloc functions supplied by the user. check-in: 1029e6cce7 user: dan tags: trunk | |
| 12:06 | Import code for the "lsmtest" test utility. check-in: 49ff55e1a6 user: dan tags: trunk | |
| 08:57 | Remove unused functions dflt_malloc() and friends from lsm_mem.c. check-in: 7a603fa454 user: dan tags: trunk | |
|
2012-05-05
| ||
| 16:33 | Update the original rowset code so that it works with variable length keys. Remove the placeholder keyset code. check-in: 51d37b1626 user: dan tags: trunk | |
| 08:31 | Remove the sqlite4.pVfs variable. check-in: ba6ca06478 user: dan tags: trunk | |
| 08:14 | Expand the set of sqlite3 tests run by src4.test. check-in: 6610b8134e user: dan tags: trunk | |
|
2012-05-04
| ||
| 19:01 | Fix a crash in "? IN (SELECT ... ORDER BY ... LIMIT)" expressions. Also a crash in lsm_csr_valid(). check-in: b688877924 user: dan tags: trunk | |
| 16:05 | Fix a crash that can occur if the index specified by an INDEXED BY clause cannot be used. check-in: 7b6ffb0a0b user: dan tags: trunk | |
| 13:00 | Fix a crash in scalar sub-selects that have ORDER BY clauses. check-in: 927b8c3427 user: dan tags: trunk | |
| 09:09 | Update the explainIndexRange() function. check-in: 9dac245adf user: dan tags: trunk | |
|
2012-05-03
| ||
| 20:07 | Remove a bad assert(). Fix rowid related crashes in triggers and foreign keys. check-in: 8bcdfe884e user: dan tags: trunk | |
| 17:18 | Remove the update, commit, rollback and wal hooks. check-in: d38792589b user: dan tags: trunk | |
| 16:34 | If both UNIQUE and PRIMARY KEY constraints are attached to the same set of columns, make sure the single index SQLite creates is the PRIMARY KEY (so that the table doesn't end up with an IPK). check-in: add223fab0 user: dan tags: trunk | |
| 16:04 | Fix for "DISTINCT rowid" queries that have more than one datasource in the FROM clause. check-in: 47b30670d4 user: dan tags: trunk | |
| 15:04 | Continuing work on cutting over the lsm_env logic in LSM. check-in: d8e75dd125 user: drh tags: trunk | |
| 09:57 | Update boundary1.test. check-in: 2e9888ce58 user: dan tags: trunk | |
|
2012-05-02
| ||
| 20:09 | Fix the commit and rollback hook callbacks. Remove more dead code. check-in: 9ca276ac06 user: dan tags: trunk | |
| 19:19 | Fix warnings and other code issues. check-in: 6860a3b80c user: dan tags: trunk | |
| 15:49 | Fix automatic indexes. check-in: d32ba91d2b user: dan tags: trunk | |
|
2012-05-01
| ||
| 20:01 | Improve the EXPLAIN QUERY PLAN output a little. check-in: 6c6ce37269 user: dan tags: trunk | |
| 18:18 | Remove an incorrect assert() from where.c. check-in: 51563f07cb user: dan tags: trunk | |
| 17:12 | Remove the RowSet object. Implement enough of KeySet so that everything works (UPDATE, DELETE and the "or-optimization" for WHERE clauses). The "or-optimization" is still inefficient. check-in: f53a618a2a user: dan tags: trunk | |
| 11:34 | Fix bugs in where.c and vdbe.c that occur when using a non-PK index to optimize an inequality on the PK fields. check-in: 6baa42724c user: dan tags: trunk | |
| 10:29 | Fix a typo in [989bd130d7]. check-in: 93167e13de user: dan tags: trunk | |
|
2012-04-30
| ||
| 19:27 | Fix a crash occuring in lsm following a failed call to open(). And another in "BEGIN EXCLUSIVE". check-in: 989bd130d7 user: dan tags: trunk | |
| 18:39 | Fix a problem with aggregate queries that do not use any column values in the expression-list. e.g. "SELECT count(*) FROM ...". check-in: e44d955795 user: dan tags: trunk | |
| 16:49 | Fix for WHERE terms of the form "a IN (SELECT x FROM tbl)" for cases where there is a UNIQUE index on tbl.x that is not used by the query. check-in: d8e2b6be11 user: dan tags: trunk | |
| 11:56 | Fix some lsm problems with modifying the database while there are active cursors. check-in: cb9f166a72 user: dan tags: trunk | |
| 08:54 | Fix some problems with sqlite4_changes() and DELETE statements. check-in: 5f5ca72866 user: dan tags: trunk | |
|
2012-04-28
| ||
| 17:59 | Update scripts fkey3.test and fkey4.test. check-in: ebe7972eb3 user: dan tags: trunk | |
| 17:50 | Fix problems with foreign key actions. check-in: b7f7cd27ac user: dan tags: trunk | |
| 16:03 | Update some test cases in triggerC.test. check-in: 76ea2fc0e8 user: dan tags: trunk | |
| 15:03 | Fix a problem with updating primary key fields. Change the error message generated when a PRIMARY KEY constraint is violated to match SQLite 3. check-in: f61bb092cb user: dan tags: trunk | |
| 02:39 | Refactor the memory-printf components of LSM to be in a more manageable form. More work is needed here. check-in: 5ae95088ab user: drh tags: trunk | |
|
2012-04-27
| ||
| 23:16 | Work towards converting LSM to use the lsm_env structure and avoid all use of global and static variables. The check-in works, but the changes are only beginning have for the most part have not been cut over yet. This is merely an incremental check-in. check-in: d28f9b6503 user: drh tags: trunk | |
| 19:45 | Restore the initial value of the database deferred FK constraint counter if a statement transaction is rolled back. check-in: 145889c3c9 user: dan tags: trunk | |
| 19:20 | Fix a bug in OP_IsUnique. check-in: 17b729a2fd user: dan tags: trunk | |
| 16:30 | Update some savepoint related test cases so that they work with sqlite 4. check-in: cc3e890839 user: dan tags: trunk | |
| 15:01 | Fix an lsm problem with rollback. check-in: eae7182230 user: dan tags: trunk | |
|
2012-04-26
| ||
| 19:59 | Progress towards working savepoints. Fixes to LSM transaction handling. check-in: 365620b19d user: dan tags: trunk | |
| 11:30 | Fix various compiler warnings. Begin fixing savepoint logic. check-in: 76cd35aad6 user: dan tags: trunk | |
|
2012-04-25
| ||
| 19:00 | Do not attempt to reindex the primary key index. Add an xMakeKey callback for the RTRIM collation. check-in: 146284d2de user: dan tags: trunk | |
| 17:24 | Remove support for "oid" and "_rowid_". Only support "rowid" on tables that have an implicit primary key. check-in: e40c75ec8d user: dan tags: trunk | |
| 16:18 | If necessary, convert text to the correct encoding before invoking a collation sequence xMakeKey callback. check-in: e56fd972d1 user: dan tags: trunk | |
| 12:16 | Add the "blessing" boilerplate, with correct dates, to the top of each LSM source file. check-in: d71f9ef975 user: drh tags: trunk | |
| 11:21 | Add lsm source files. check-in: 46ae3fcec6 user: dan tags: trunk | |
| 09:59 | Fixes for DESC indexes. check-in: 704936cfc8 user: dan tags: trunk | |
|
2012-04-24
| ||
| 19:44 | Added clarification for the key-encoding of text. check-in: efe3d2e0e7 user: drh tags: trunk | |
| 18:47 | Correct a buggy assert() in insert.c. check-in: 35e984dde5 user: dan tags: trunk | |
| 17:54 | Updates to test scripts and main.mk. check-in: 99459e1ea9 user: dan tags: trunk | |
| 11:26 | Move the test C code from the src/ to the test/ subdirectories. check-in: 26f16cc588 user: drh tags: trunk | |
| 11:16 | Clean up the top-level directory by removing the configure script at its associated files. (We'll add back in autoconfig later.) And moving AWK scripts into the tool/ directory. check-in: 5c7177fa33 user: drh tags: trunk | |
| 00:34 | Remove the bitvec.c module as it was no longer being used. check-in: 68df3f5ea7 user: drh tags: trunk | |
|
2012-04-23
| ||
| 23:02 | Change the sqlite4_config() interface so that it applies to a particular sqlite4_env object. check-in: 6a87af6545 user: drh tags: trunk | |
| 21:08 | Get rid of sqlite4_open_v2() and sqlite4_open16(). Change sqlite4_open() to take an sqlite4_env pointer and a zero-terminated varargs list of options. No options are currently recognized. check-in: b94314c297 user: drh tags: trunk | |
| 19:49 | Towards an sqlite4_env object that defines the run-time environment. This is not a complete check-in, just an incremental change (hopefully) in the right direction. check-in: 88ac7f6772 user: drh tags: trunk | |
| 18:38 | Fix a problem to do with copying from the sorter to a temporary table in select.c. check-in: 187316a0dc user: dan tags: trunk | |
| 16:50 | Change the tcl interface so that tcl scripts may specify collation sequence xMkKey callbacks. check-in: 6ebe82280d user: dan tags: trunk | |
| 15:49 | Remove the OS/2 interface logic. check-in: 9a64e0bc7e user: drh tags: trunk | |
| 14:54 | Fix a bug in the nocase collation xMkKey function. check-in: fe9ccd646d user: dan tags: trunk | |
| 14:26 | Remove the VDBE merge sorter. check-in: 1073bb477e user: drh tags: trunk | |
| 14:11 | Add an xMkKey callback to the built-in collation sequence "nocase". Fix a bug in encoding text values with collation sequences into database keys. check-in: 6c9adc9acc user: dan tags: trunk | |
| 12:47 | Remove the sqlite4_get_table() API. check-in: ff68adaca1 user: drh tags: trunk | |
| 12:07 | Allow multiple NULL values in a UNIQUE index. check-in: 4dbb499c39 user: dan tags: trunk | |
| 11:45 | Fix a bug in CREATE INDEX where the number of columns in the index is fewer than the number of columns in the primary key. check-in: b0ac144cf5 user: drh tags: trunk | |
| 09:40 | Fix for compound EXCEPT queries. check-in: 2dc7b22339 user: dan tags: trunk | |
|
2012-04-21
| ||
| 19:59 | Additional comments on the key encoder. Remove an unused variable. check-in: fdaed18ddf user: drh tags: trunk | |
| 19:19 | Fix an off-by-one problem with encoding real values into index keys. Add a test for sorting numeric values. check-in: 7017d07fea user: dan tags: trunk | |
| 18:55 | Fixes to the text of the key encoding definition in key_encoding.txt. check-in: ee5b8b8d11 user: drh tags: trunk | |
| 17:33 | Get some more aggregate queries working. check-in: 7aace3e09f user: dan tags: trunk | |
| 13:56 | Get rid of the page-cache and scratch memory allocators. check-in: 9346a42e0d user: drh tags: trunk | |
| 13:18 | Remove the alternative pcache mechanism. check-in: bf89aa0f37 user: drh tags: trunk | |
| 13:00 | All filenames are now URI capable. There is no provision for disabling URI filenames. check-in: 735870610b user: drh tags: trunk | |
| 12:49 | Remove the last traces of shared cache mode. check-in: 27e0994174 user: drh tags: trunk | |
| 00:40 | Remove cruft: (1) The sqlite4_prepare_v2() function becomes sqlite4_prepare and all other prepare functions are removed. (2) sqlite4_extended_result_codes() is removed. Extended result codes are now always enabled. (3) The sqlite4_busy_handler() and sqlite4_busy_timeout() functions are removed. check-in: e454574981 user: drh tags: trunk | |
|
2012-04-20
| ||
| 20:41 | Move development back to trunk. check-in: 76ca8d1bee user: drh tags: trunk | |
| 20:38 | Changes so that things work without SQLITE_ENABLE_LSM. Closed-Leaf check-in: 49e419f4e8 user: dan tags: primary-keys | |
| 20:15 | Fix the sqlite4RefillIndex() function. This removes the broken (and disabled) merge-sort code. check-in: 9ac54fff5f user: dan tags: primary-keys | |
| 18:35 | Changes to where.c to use the PK columns appended to each auxiliary index entry. check-in: 4c1dca78b3 user: dan tags: primary-keys | |
| 14:21 | A fix to sqlite4VdbeDecodeIntKey(). check-in: b05e622090 user: drh tags: primary-keys | |
|
2012-04-19
| ||
| 18:51 | Fix a problem with inequality constraints and indexes. check-in: 14d96763cc user: dan tags: primary-keys | |
| 18:33 | Fixes for scans on indexes other than the primary key. check-in: ed6ac6860b user: dan tags: primary-keys | |
|
2012-04-18
| ||
| 18:27 | Add file kvlsm.c, a KVStore wrapper around lsm. check-in: 174119bec7 user: dan tags: primary-keys | |
|
2012-04-17
| ||
| 18:49 | Comment out some tests in select1.test that depend on "PRAGMA full_column_names" and "PRAGMA short_column_names". check-in: 946fe6504a user: dan tags: primary-keys | |
| 18:47 | Fix a couple of issues with ORDER BY. check-in: 34138a088b user: dan tags: primary-keys | |
| 09:10 | Enforce NOT NULL on all PRIMARY KEY columns. check-in: 035fdd3f5e user: dan tags: primary-keys | |
| 08:23 | Fix more problems with triggers and triggers on views. check-in: 77b33bff0a user: dan tags: primary-keys | |
| 05:36 | Fix an issue with sub-transaction rollback. check-in: 123a055a36 user: dan tags: primary-keys | |
|
2012-04-16
| ||
| 19:04 | Get most of the trigger logic working again. Still some problems. check-in: b480943c48 user: dan tags: primary-keys | |
|
2012-04-14
| ||
| 19:38 | Fixes to foreign key logic. And other things. check-in: 69cf7caf80 user: dan tags: primary-keys | |
|
2012-04-13
| ||
| 19:17 | Fix sub-transaction commit in kvmem.c. Also various aspects of constraint handling. check-in: 365eb3c6de user: dan tags: primary-keys | |
| 16:45 | Fix a problem in kvmemRemoveNode() causing a pUp (parent node) pointer to be set incorrectly. check-in: 7faa762755 user: dan tags: primary-keys | |
| 10:35 | Add placeholder code to make ROLLBACK (and OR ROLLBACK constraints) work a bit. check-in: 367fdc8463 user: dan tags: primary-keys | |
| 05:50 | Ensure that kvmemSeek() does not come to rest on a deleted node. check-in: 21991a932a user: dan tags: primary-keys | |
|
2012-04-12
| ||
| 19:52 | Further fixes to things. check-in: 81fab25002 user: dan tags: primary-keys | |
| 11:49 | Fix a problem in kvmemRemoveNode. check-in: f3c424ddf3 user: dan tags: primary-keys | |
|
2012-04-11
| ||
| 18:48 | Fix some problems with REPLACE and other conflict handling. check-in: ff493aaa41 user: dan tags: primary-keys | |
| 15:01 | Fix various bugs. check-in: a70fb0629b user: dan tags: primary-keys | |
|
2012-04-10
| ||
| 19:52 | Changes to support "real" user-defined primary keys. This is quite broken at present. check-in: 3841829752 user: dan tags: primary-keys | |
|
2012-03-01
| ||
| 14:47 | Minor changes so that the code builds on Mac. check-in: a03018e6b8 user: drh tags: trunk | |
|
2012-02-23
| ||
| 17:56 | Modify the key encoding so that integer values use one less byte of space. check-in: af96bd359f user: drh tags: trunk | |
|
2012-02-22
| ||
| 14:20 | Add the "kvdump" pragma for debugging. check-in: 4746d99cc1 user: drh tags: trunk | |
| 13:15 | CREATE INDEX runs, though index queries does not work yet so there is no way to test that the index was correctly created. check-in: 70f15a5352 user: drh tags: trunk | |
| 02:44 | Remove the OP_Destroy opcode. Add an implementation for OP_Clear. check-in: 15cf832dfc user: drh tags: trunk | |
| 00:11 | Remove the OP_CreateTable and OP_CreateIndex opcodes, which are not required with the key/value backend. check-in: 31b1faa995 user: drh tags: trunk | |
|
2012-02-21
| ||
| 20:03 | Only the bare basics work. But we might as well go ahead and call this the trunk since we are unlikely to ever need to bisect back into this massive rewrite effort. check-in: a101b3e1c4 user: drh tags: trunk | |
| 20:01 | Inserting multiple rows into a table and querying via full-table scan is now working. Leaf check-in: 6838c8a3a7 user: drh tags: remove-btree | |
| 19:57 | Improved storage tracing output. check-in: d4c10f88ad user: drh tags: remove-btree | |
| 19:32 | CREATE TABLE and a single row INSERT followed by SELECT now working. Still lots of stuff that doesn't work, though. check-in: 65f1e9a86f user: drh tags: remove-btree | |
| 19:20 | Fix to kvmemSeek(). check-in: 05d897a0ae user: drh tags: remove-btree | |
| 17:11 | Incremental check-in. Compiles but does not work. check-in: 829f7f1a65 user: drh tags: remove-btree | |
| 15:19 | Incremental check-in. Trying to get it running. check-in: c055a35d1e user: drh tags: remove-btree | |
| 14:50 | The testfixture now compiles. check-in: e85db5d81b user: drh tags: remove-btree | |
|
2012-02-20
| ||
| 19:49 | Incremental check-in. Compiles but still does not run. check-in: cc977cdcc6 user: drh tags: remove-btree | |
| 18:46 | Progress on transaction control. check-in: d5755d3561 user: drh tags: remove-btree | |
|
2012-02-17
| ||
| 20:33 | Incremental check-in. The shell compiles and runs. Now trying to get it to work. check-in: 2843c28b82 user: drh tags: remove-btree | |
| 16:23 | Add the kv_trace and trace pragmas. check-in: e37bee4f61 user: drh tags: remove-btree | |
| 12:45 | Compiles and links. check-in: 5c44baf3fe user: drh tags: remove-btree | |
| 12:12 | Incremental check-in - working toward getting it to compile. check-in: 18d380e9a6 user: drh tags: remove-btree | |
|
2012-02-16
| ||
| 22:17 | Incremental check-in. Does not compile. check-in: 3165b1b5fb user: drh tags: remove-btree | |
|
2012-02-08
| ||
| 21:47 | This is an incremental check-in for the massive change that removes the old b-tree layer and substitutes a uniform key-value namespace. Nothing works at this point. This check-in is just a checkpoint. check-in: 87d659d624 user: drh tags: remove-btree | |
|
2012-01-26
| ||
| 22:11 | Always call OP_MakeKey before OP_MakeRecord prior to adding content to an index. check-in: 29c1ec8e6b user: drh tags: trunk | |
| 20:53 | Fix the data codec so that it handles Inf and NaN. Make sure OP_MakeKey is only called with an index cursor. check-in: bfa05539ea user: drh tags: trunk | |
| 18:22 | Adjust the initial values on the key encoding to provide auxiliary key space before and after the rows of each table. check-in: af6351afdd user: drh tags: trunk | |
| 16:34 | First cut at a complete codec for both key and data. Data decoding is untested. check-in: 8e27a5ca62 user: drh tags: trunk | |
|
2012-01-25
| ||
| 17:40 | Progress on the key encoder. Text value are still not encoded for keys. check-in: 4b07acf688 user: drh tags: trunk | |
| 03:33 | Add the vdbecodec.c source file including stub functions for all encoders and decoders. Initial implementation for the data encoder. check-in: 6c42bd8b4f user: drh tags: trunk | |
|
2012-01-24
| ||
| 20:48 | Remove lots more unused code. check-in: dcf2f7b862 user: drh tags: trunk | |
| 14:22 | Fix the spelling of "lexicographical". check-in: a20f69592c user: drh tags: trunk | |
| 13:58 | Add the database_design.txt document. check-in: b3390b2d58 user: drh tags: trunk | |
| 13:38 | Many code simplifications. Removing support for shared-cache mode, VACUUM, multiplexor, test_stat, progress handler, etc. check-in: 3ebe674aed user: drh tags: trunk | |
|
2012-01-23
| ||
| 18:23 | Change sqlite4_create_collate() to take comparison, key-generator, and destructor functions. Omit _create_collate16() and _create_collate_v2(). check-in: 9feaae9f84 user: drh tags: trunk | |
| 17:22 | A few more tweaks for moving the version number from 3 to 4. check-in: 4dc43e1c6b user: drh tags: trunk | |
| 17:12 | Add the varint.c module, but do not yet link it into the build. check-in: 3fc5c75369 user: drh tags: trunk | |
| 16:22 | Rename all of the interfaces from "sqlite3" to "sqlite4" check-in: 9191010833 user: drh tags: trunk | |
| 16:01 | Add tracing to the KV interface. Create KV parallels to all btrees. check-in: cda3f53d63 user: drh tags: trunk | |
|
2012-01-21
| ||
| 21:01 | All storage APIs have at least one test now. check-in: 9e3883a529 user: drh tags: trunk | |
| 19:00 | Begin adding more test cases. Fix problems as they are discovered. check-in: 4af50ccf11 user: drh tags: trunk | |
| 18:09 | Storage code compiles and links. Initial bits of code for TCL interface. check-in: 921bb26d2a user: drh tags: trunk | |
| 16:33 | Check-in untested code and design notes for an in-memory storage subsystem. check-in: b713405686 user: drh tags: trunk | |
|
2012-01-20
| ||
| 01:21 | Add extensions and a Makefile. check-in: 5371cead94 user: drh tags: trunk | |
| 01:19 | Initial check-in of code - a copy of SQLite3 check-in: cc3802d407 user: drh tags: trunk | |