Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 descendants and 50 ancestors of f3ac136843205f618826cb50635631dbf238e2bd
2013-02-05
| ||
16:03 | Change the BLOCK_SIZE, AUTOFLUSH and AUTOCHECKPOINT lsm_config() options to work in KB instead of bytes. This matches the user guide. check-in: 340c9dcd22 user: dan tags: trunk | |
09:52 | Add test file lsm3.test, which should have been added a few days ago. check-in: 5dfd8651df user: dan tags: trunk | |
09:51 | Fix bugs on this branch. check-in: 0cbb5cc2cd user: dan tags: mmap-on-demand | |
2013-02-04
| ||
19:04 | Map and unmap parts of the database file on an LRU basis to limit the amount of address space consumed at any one time (for 32-bit address spaces). It looks like this might be slower than read() and write() anyway... check-in: d1b1a9e969 user: dan tags: mmap-on-demand | |
2013-02-02
| ||
16:45 | Fix LSM single-process mode so that it holds an exclusive lock on the database file - preventing connections from within external processes. check-in: d6bd08ca0e user: dan tags: trunk | |
2013-02-01
| ||
19:49 | Simplifications and clarifications to lsmusr.wiki. check-in: 33eca2e1f4 user: dan tags: trunk | |
2013-01-31
| ||
05:58 | Add the definition of sqlite4_stricmp() to sqlite.h.in. Avoid multiple declarations the u8 and similar typedefs in the amalgmation. check-in: d966049dd6 user: drh tags: trunk | |
05:36 | Change all occurrences of sqlite4StrICmp to sqlite4_stricmp and change sqlite4StrNICmp to sqlite4_strnicmp. check-in: b6d0a62048 user: drh tags: trunk | |
05:27 | Publish routines sqlite4_stricmp() and sqlite4_strnicmp() that do simple unicode case folding. Use these routines for all internal case-insensitive string comparisons. check-in: 19e9278b9c user: drh tags: trunk | |
2013-01-28
| ||
08:56 | Merge block-redirects branch with trunk. This changes the lsm file format. check-in: 647229e983 user: dan tags: trunk | |
2013-01-26
| ||
20:18 | Handle calls to lsm_work() with the nPage parameter set to not greater than zero. Remove some dead code. Leaf check-in: 520f3729b8 user: dan tags: block-redirects | |
19:17 | Fix problems with redirected blocks in compressed databases. check-in: 930b7e4507 user: dan tags: block-redirects | |
17:24 | Remove an inaccurate assert() from lsm_sorted.c. check-in: 259878e357 user: dan tags: block-redirects | |
16:44 | Fix a problem to do with an lsm_seek(LSM_SEEK_LE) on a level that is currently undergoing a merge. Add more complex assert statements to catch any similar problems. check-in: ca4dc40190 user: dan tags: block-redirects | |
2013-01-25
| ||
21:23 | Fix an off-by-one error in the value data decoder logic that prevented DEFAULT VALUE from working correctly in some instances. Also fix some nearby code formatting issues. check-in: 98d35b06cd user: drh tags: trunk | |
20:46 | Fix a problem in the range-delete code. check-in: 96badcb933 user: dan tags: block-redirects | |
2013-01-24
| ||
18:24 | Fix a string type compile warning. check-in: 11b2bf1628 user: stephan tags: trunk | |
16:45 | Improve the integrity-check assert that ensures all blocks in the file are accounted for. Roll any in-memory free-list records into the end of the main segment when executing lsm_work(nmerge=1). check-in: e5edba9caa user: dan tags: block-redirects | |
2013-01-23
| ||
18:13 | Keep the contents of Segment structures up to date at all times, so that none of the page numbers contained within are subject to redirection. check-in: a89abc2117 user: dan tags: block-redirects | |
2013-01-22
| ||
20:07 | Several block-redirect related bugfixes. check-in: a56a334333 user: dan tags: block-redirects | |
2013-01-21
| ||
19:50 | Add tests for block-redirects to lsmtest. check-in: eec16b0f2f user: dan tags: block-redirects | |
16:53 | If a free-list-only segment is generated while a merge of the top-level segment is underway, add the new segment to the merge inputs immediately. Also, if auto-checkpoints are enabled, schedule a checkpoint after each block is moved within an lsm_work(nmerge=1) call. check-in: 89b4286682 user: dan tags: block-redirects | |
14:23 | Fix LSM_INFO_PAGE_DUMP so that it works with redirected blocks. check-in: deb0ccacd4 user: dan tags: block-redirects | |
10:02 | Fix some bugs surrounding block redirects. check-in: 73976dbcbe user: dan tags: block-redirects | |
2013-01-20
| ||
02:52 | Fix typos in the VARINT documentation. check-in: eccdf70b22 user: drh tags: trunk | |
02:38 | Fix a typo on the key-encoding documentation. check-in: b1ae0ca8c3 user: drh tags: trunk | |
00:07 | Enable the AUTOINCREMENT feature. check-in: 5442b20bf6 user: drh tags: trunk | |
2013-01-19
| ||
20:07 | Change the lsm file-format to allow a small number of blocks belonging to the oldest segment in the database to be moved without modifying their content. This makes it easier to compact a database file to the minimum required size. check-in: 09251cee6a user: dan tags: block-redirects | |
19:49 | Insert a value in place of NULL in an INTEGER PRIMARY KEY, even if the IPK column is omitted from the VALUES list in the INSERT statement. check-in: 4d1b506594 user: drh tags: trunk | |
16:14 | Inserting NULL into a INTEGER PRIMARY KEY fills that key with the next available integer value. The sqlite4_last_insert_rowid() function now works for those cases. check-in: 697ee9faad user: drh tags: trunk | |
02:38 | Change the hexadecimal digits generated by the hex() and quote() functions to lower-case. check-in: 3025370e1f user: drh tags: trunk | |
02:16 | Fix for queries that use and inequality on ROWID in the WHERE clause. check-in: 32de931aa1 user: drh tags: trunk | |
2013-01-18
| ||
23:15 | Add support for multiple VALUES in a single INSERT statement. check-in: 4ea88c4882 user: drh tags: trunk | |
20:43 | Remove obsolete shell test scripts from the tool/ subdirectory. check-in: 51b9711376 user: drh tags: trunk | |
20:28 | Bring the command-line shell up-to-date with recent changes in SQLite3. Add test cases for the command-line shell. check-in: 918553d16e user: drh tags: trunk | |
15:58 | Display the 'age' of each level in lsmview. check-in: 33cc91541c user: dan tags: trunk | |
10:46 | Truncate the database file when the number of connections drops from one to zero. check-in: dc4fa92596 user: dan tags: trunk | |
2013-01-17
| ||
19:13 | Fix an lsm bug causing it to choose the wrong block to reuse. check-in: 2ff461b422 user: dan tags: trunk | |
12:22 | Truncate away any free blocks at the end of the database file when the system is shutdown (last connection disconnects). check-in: 2351f01937 user: dan tags: trunk | |
2013-01-15
| ||
17:39 | Fix a typo in lsmusr.wiki. check-in: ace47a5829 user: dan tags: trunk | |
2013-01-14
| ||
17:05 | Fix problems with the matchinfo functions used by the bm25(f) implementation. check-in: 739cd82fca user: dan tags: trunk | |
2013-01-13
| ||
05:30 | Avoid using keyword "near" as a variable name in fts5.c. check-in: 278cfaeb70 user: dan tags: trunk | |
2013-01-12
| ||
15:50 | Many fts5 related fixes. check-in: e21b7b67b5 user: dan tags: trunk | |
15:13 | Get the amalgamation build working again. check-in: 0078080de5 user: drh tags: trunk | |
2013-01-09
| ||
18:15 | Merge matchinfo branch with trunk. check-in: dbbce4e438 user: dan tags: trunk | |
18:09 | Fix a few compiler warnings and test failures. Leaf check-in: 201233ee64 user: dan tags: matchinfo | |
17:16 | Fixes for snippet function and tests. Add API to determine the number of tokens in an FTS query phrase. check-in: 0d5a640f1f user: dan tags: matchinfo | |
2013-01-08
| ||
20:35 | Add tests and many fixes for snippet implementation. Some tests are still failing. check-in: a257d81d4b user: dan tags: matchinfo | |
11:45 | Fix an fts5 problem to do with initializing the global size record. Also have the checksum routine ignore size records when calculating the index checksum. check-in: e7b52edf68 user: dan tags: matchinfo | |
2013-01-07
| ||
19:52 | Add an implementation of snippet() and its associated mi apis to fts5. check-in: 8d94102cd3 user: dan tags: matchinfo | |
2013-01-04
| ||
18:37 | Allow an fts5 tokenizer to split a single document into multiple streams (i.e. sub-fields within a single column value). Modify the matchinfo APIs so that a ranking function may handle streams and/or columns separately or otherwise. check-in: f3ac136843 user: dan tags: matchinfo | |
2013-01-03
| ||
20:35 | Add comment describing format of row and global size records. check-in: 7cfa40b5c1 user: dan tags: matchinfo | |
18:13 | Fill in more of the matchinfo functions so that the BM25 function works. check-in: 0e439483d7 user: dan tags: matchinfo | |
2013-01-02
| ||
20:01 | Add an implementation of BM25 to fts5func.c. Other changes to matchinfo related things. check-in: 03f26d8c60 user: dan tags: matchinfo | |
2013-01-01
| ||
19:56 | Add APIs to allow fts5 to be augmented with ranking and snippet functions. Does not work yet. check-in: a235305d42 user: dan tags: matchinfo | |
18:41 | Fix a memory leak in fts5.c. check-in: 7bc0e58875 user: dan tags: trunk | |
18:24 | Add files "mem.h" and "mem.c". These are not currently linked into the build and have never been tested. At the moment they should be considered working notes, not real code. The code contained in these files might get folded into the build, or it might be deleted. check-in: e9efc61a51 user: drh tags: trunk | |
10:24 | Fix a problem that occurs with transactions that use more than 32MB of shared memory. check-in: bc0f61fc3b user: dan tags: trunk | |
09:07 | Avoid leaking shared-memory pages when rolling back a large transaction. check-in: d9a06d9403 user: dan tags: trunk | |
2012-12-30
| ||
12:03 | Add support for the "columnname : phrase" syntax to fts5. check-in: 069e299d06 user: dan tags: trunk | |
11:45 | Add support for prefix queries to fts5. Still no support for prefix indexes, just prefix queries using the regular term index. check-in: dd018f834a user: dan tags: trunk | |
2012-12-29
| ||
15:16 | Add fts5rnd1.test, a modified version of fts3rnd.test that works with fts5. check-in: 29d07b13f0 user: dan tags: trunk | |
09:56 | Add support for the AND, OR and NOT operators to fts5. check-in: c2efd983b0 user: dan tags: trunk | |
2012-12-28
| ||
20:01 | Add support for NEAR queries to fts5. check-in: ed403fecf2 user: dan tags: trunk | |
18:57 | Add support for phrase queries to fts5. check-in: 0780ef9305 user: dan tags: trunk | |
2012-12-27
| ||
18:01 | Fill in some functions so that a tiny subset of fts5 queries work. check-in: fb07003744 user: dan tags: trunk | |
2012-12-26
| ||
19:40 | Modify where.c and so on to handle fts scans. Opcodes do not work yet. check-in: 58a5617da3 user: dan tags: trunk | |
2012-12-24
| ||
15:32 | Fixes for updates and deletes on tables with fts5 indexes. check-in: 8161b13910 user: dan tags: trunk | |
2012-12-22
| ||
19:59 | More work on updating an fts5 index. Add a pragma that checks if the index and table contents match. check-in: 4693eb7bcc user: dan tags: trunk | |
2012-12-21
| ||
19:58 | Add update function to fts5.c. check-in: 49eff5d82d user: dan tags: trunk | |
2012-12-20
| ||
18:41 | Add "tokenizer=xxx" syntax to fts5. check-in: e0748900db user: dan tags: trunk | |
2012-12-19
| ||
20:01 | Add the "CREATE INDEX idx ON tbl USING nm(...)" syntax. check-in: 8ac71062f5 user: dan tags: trunk | |
2012-12-18
| ||
15:47 | Add support for NEAR to the fts expression parser. check-in: b1a2a17679 user: dan tags: trunk | |
2012-12-17
| ||
20:18 | Add a test for the "colname:phrase" syntax to fts5expr1.test. check-in: c472cae982 user: dan tags: trunk | |
19:36 | Add new files fts5.c and fts5func.c. check-in: bd4efbb2f7 user: dan tags: trunk | |
2012-12-03
| ||
20:19 | Add support for testing against mdb. check-in: 5181638475 user: dan tags: trunk | |
14:22 | Add lsmperf.wiki to the links on index.wiki. check-in: 6de140a17f user: dan tags: trunk | |
13:41 | Add www/lsmperf.wiki. check-in: 938bb92e37 user: dan tags: trunk | |
2012-11-30
| ||
19:00 | Reduce the number of times malloc() is called when inserting a new entry. Ensure pointers to all shared-memory chunks are loaded when a read-transaction is opened. check-in: 7ead7175e2 user: dan tags: trunk | |
2012-11-29
| ||
19:14 | Avoid reading and checksumming an entire meta-page every time a write transaction is opened. check-in: d4c5a3bad7 user: dan tags: trunk | |
18:25 | Allow freelist-only age=1 segments to be written even if there are already NMERGE age=1 segments. check-in: 88205b2bc6 user: dan tags: trunk | |
09:48 | In mmap-mode, ensure a checkpointer has the entire database file mapped before calling msync(). check-in: a9f8129cce user: dan tags: trunk | |
2012-11-28
| ||
19:39 | Further updates to multi-threaded tests. check-in: f43bee2c1b user: dan tags: trunk | |
14:54 | Fix an mmap mode bug. Improve upon multi-threaded setups in lsmtest_tdb3.c. check-in: 21db5f73f5 user: dan tags: trunk | |
2012-11-23
| ||
16:41 | Fix a problem in compressed database mode causing pages to be incorrectly marked as dirty. check-in: b55b092602 user: dan tags: trunk | |
2012-11-22
| ||
16:14 | Fix some "unsafe" pointer casts in lsm_config(). check-in: f58fb32e42 user: dan tags: trunk | |
2012-11-17
| ||
13:17 | Fix another out-of-order writes problem. check-in: 1b21fb4494 user: dan tags: trunk | |
10:51 | Avoid writing pages to disk out of sequential order (one problem still remains). check-in: ee694a32e4 user: dan tags: trunk | |
2012-11-15
| ||
18:45 | Update the lsm code so that it matches lsmusr.wiki. check-in: 8915d39dab user: dan tags: trunk | |
14:19 | Add words to lsmusr.wiki. check-in: 2077c9d152 user: dan tags: trunk | |
2012-11-14
| ||
20:09 | Updates to lsmusr.wiki. check-in: 1ea9187820 user: dan tags: trunk | |
18:23 | Improvements to lsmusr.wiki. check-in: e47b5e3ae6 user: dan tags: trunk | |
2012-11-13
| ||
20:16 | Further documentation updates. check-in: 414ed6da4e user: dan tags: trunk | |
18:44 | Add lsmapi.wiki. And the script that generates it from lsm.h - tool/mklsmapi.tcl. check-in: 2377f4f991 user: dan tags: trunk | |
14:03 | Add table of contents to lsmusr.wiki. check-in: 71b26d318d user: dan tags: trunk | |
2012-11-12
| ||
20:19 | Fix small issues in lsmusr.wiki. check-in: 3904797435 user: dan tags: trunk | |
19:41 | Updates to lsmusr.wiki. check-in: f7ef6cec1f user: dan tags: trunk | |
2012-11-09
| ||
20:14 | Minor changes to lsmusr.wiki. Add the lsm_csr_cmp() function. check-in: 9d39c3a354 user: dan tags: trunk | |
2012-11-08
| ||
21:30 | Add lsmusr.wiki. User documentation for lsm. check-in: c50bcdc37d user: dan tags: trunk | |
11:59 | Set a flag on levels that consist entirely of freelist entries. Use this flag to avoid counter-productive merges during database optimization. check-in: 48bd83a17a user: dan tags: trunk | |
2012-11-07
| ||
20:08 | Remove the LSM_WORK_OPTIMIZE flag. Add free-list management related tests and fixes. check-in: 91912a39ca user: dan tags: trunk | |