Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 descendants of 19504c4108472d2a
|
2015-07-01
| ||
| 01:31 | Change integrity_check to analyze the cells of a page in reverse order, as this will tend to insert the cells into the analysis heap in increasing order by address, which is the most efficient way to load a min-heap. (check-in: 59ad912c4c user: drh tags: trunk) | |
|
2015-06-30
| ||
| 17:28 | Make use of the _byteswap_ushort() and _byteswap_ulong() compiler intrinsics for MSVC, when available. (check-in: fe144dd73f user: mistachkin tags: trunk) | |
| 16:29 | Merge all the latest enhancements from trunk. This merge include FTS5 and a number of notable performance enhancements. (check-in: 39936b33b0 user: drh tags: sessions) | |
| 15:10 | Make use of built-in bswap32() and bswap16() functions in GCC/Clang for a significant performance improvement there. (check-in: 8bfcda3d10 user: drh tags: trunk) | |
| 14:01 | Only use __builtin_bswap16() with GCC 4.8 and later. (Closed-Leaf check-in: ce8177e3e6 user: drh tags: bswap-functions) | |
| 13:28 | Remove the use of htonl() in the previous check-in due to linkage issues. Add the get2byteAligned() macro and use it for access to the cell offsets on btree pages for about a 1% performance gain. (check-in: 79ff36b717 user: drh tags: bswap-functions) | |
| 12:47 | Make use of htonl() and __builtin_bswap32() for faster implementations of sqlite3Get4byte() and sqlite3Put4byte(). (check-in: bc27ebd7f7 user: drh tags: bswap-functions) | |
| 11:07 | Change an unreachable branch into an assert() in sqlite3PagerAcquire() and optimize sqlite3PcacheOpenSavepoint() by factoring out rarely used code into a subroutine. (check-in: b406b20ecd user: drh tags: trunk) | |
| 03:57 | Optimization to the sqlite3PcacheFetch() logic. (check-in: d9a0481ce0 user: drh tags: trunk) | |
| 03:34 | Put all variable declarations for sqlite3PagerWrite() at the beginning of the block. Syntax only - no logic changes. (check-in: a0fa6b3ba5 user: drh tags: trunk) | |
| 03:18 | Implement sqlite3Strlen30() using strlen() from the C library. (check-in: 8001aa52bd user: drh tags: trunk) | |
| 03:13 | Change sqlite3ApiExit() so that its first argument is never NULL. (check-in: 791b706ec6 user: drh tags: trunk) | |
| 02:47 | Put BtCursor objects on a singly-linked list instead of a doubly-linked list. Add the BTCF_Multiple flag. Only invoke saveAllCursors() when using a cursor that has BTCF_Multiple set. (check-in: 429ccef2b3 user: drh tags: trunk) | |
| 01:25 | Convert several 5-year-old and older NEVER() macros into assert(). (check-in: ed54c14ea8 user: drh tags: trunk) | |
|
2015-06-29
| ||
| 23:01 | From sqlite3BtreeInsert(), bypass the btreeMoveto() routine for table inserts and go directly to sqlite3BtreeMovetoUnpacked(). (check-in: 53fe685d56 user: drh tags: trunk) | |
| 20:53 | Add a bypass path in sqlite3PagerWrite() for pages with the PGHDR_WRITEABLE bit set, for about a 1% performance increase. (check-in: ba425a6abb user: drh tags: trunk) | |
| 19:08 | Combine subjRequiresPage() and subjournalPage() into a single subjournalPageIfRequired() routine. (check-in: 3b65eb56c4 user: drh tags: trunk) | |
| 18:29 | Add the PGHDR_WRITEABLE bit for PgHdr.flags which is used to distinguish between pages that are on the dirty list and pages that are safe to modify. (check-in: 7c4ef7b7c8 user: drh tags: trunk) | |
| 18:14 | Fix over-length source code lines in pager.c. (check-in: 14de3d3926 user: drh tags: trunk) | |
| 15:41 | Fix minor problems in the ota demo application. (check-in: 6aaaec6e63 user: dan tags: trunk) | |
| 14:11 | Simplifications and performance improvement in pager_write(). (check-in: ab7aeeead3 user: drh tags: trunk) | |
| 04:21 | Add the new PGHDR_CLEAN bit to PgHdr.flags in pcache.c. This bit is always the opposite of PGHDR_DIRTY. Use the extra bit to avoid a comparison for a small performance boost. (check-in: 8619fc346d user: drh tags: trunk) | |
| 03:28 | Very small size reduction and performance increase in sqlite3BitvecTest(). (check-in: 9b3a7281bd user: drh tags: trunk) | |
| 00:52 | Move an assert() and testcase() into their correct position within getAndInitPage(). (check-in: 18115164e1 user: drh tags: trunk) | |
| 00:21 | Use tail recursion in pcache1Unpin() to get a small size reduction and speed improvement. (check-in: fde70472ae user: drh tags: trunk) | |
|
2015-06-28
| ||
| 17:33 | Comment typo fix and minor cleanup in the pager. No logic changes. (check-in: 94ef170128 user: drh tags: trunk) | |
| 02:58 | Avoid unnecessary calls to sqlite3VdbeSerialTypeLen() for integer serial types, for a small size reduction and a speed increase. (check-in: 9cd30d33b1 user: drh tags: trunk) | |
|
2015-06-27
| ||
| 23:55 | Make greater use of BtCursor.curIntKey. (check-in: 63998471d0 user: drh tags: trunk) | |
| 22:49 | Add the BtCursor.curIntKey field and use it for a small size reduction and performance boost. (check-in: 4a17df139a user: drh tags: trunk) | |
| 20:55 | Enhancements to the previous check-in to make it a little smaller and faster. (check-in: 291d9e0c32 user: drh tags: trunk) | |
| 19:45 | Performance improvements in moveToChild() by shifting some work over to getAndInitPage(). Net improvement is about 800K cycles at cost of 30 bytes. (check-in: 1956a4ce8e user: drh tags: trunk) | |
| 15:51 | Manually inline the call from getAndInitPage() to btreeGetPage() for a savings of 2.5 million cycles at a cost of less than 100 bytes. (check-in: 7f65b96b40 user: drh tags: trunk) | |
| 14:59 | Add releasePageNotNull() as an alternative to releasePage() when the argument is guaranteed to be non-NULL, and use it for a small performance gain. (check-in: 9383a68870 user: drh tags: trunk) | |
| 03:58 | Add the Mempage.aDataOfst field and use it in sqlite3BtreeMovetoUnpacked() for about a 2 million cycle gain. (check-in: bee94dc351 user: drh tags: trunk) | |
|
2015-06-26
| ||
| 20:45 | Treat compilation of FTS5 for the loadable extension specially with MSVC. (check-in: 7c610276bb user: mistachkin tags: trunk) | |
| 20:25 | Merge fts5 branch into trunk. (check-in: d27d9965b5 user: dan tags: trunk) | |
| 20:14 | Merge latest trunk with this branch. (Closed-Leaf check-in: 8671b9e137 user: dan tags: fts5) | |
| 20:13 | Remove unnecessary lines from fts3.h and main.mk. (check-in: c1b268ced3 user: dan tags: fts5) | |
| 20:08 | Fix a segfault that could follow an OOM error in fts5. (check-in: 713239b8cf user: dan tags: fts5) | |
| 19:33 | Merge latest trunk changes with this branch. (check-in: 2a1af0f29e user: dan tags: fts5) | |
| 18:50 | Fix some cases in the fts5 code where a corrupt database could cause a buffer overread. (check-in: 360c57bbb8 user: dan tags: fts5) | |
| 17:10 | Merge changes to get FTS5 working with MSVC. (check-in: 954231d29d user: mistachkin tags: fts5) | |
| 16:55 | Merge upstream changes. Get the test fixture working with FTS5. Fix compiler warnings. (Closed-Leaf check-in: bfcd16089c user: mistachkin tags: fts5Msvc) | |
| 16:42 | Remove fts5 initialization code from core file main.c. (check-in: c91a93b343 user: dan tags: fts5) | |
| 16:17 | Add FTS5 DLL target for MSVC. (check-in: be85b82499 user: mistachkin tags: fts5Msvc) | |
| 04:34 | Initial changes to get FTS5 working with MSVC. (check-in: ef2052f81e user: mistachkin tags: fts5Msvc) | |
|
2015-06-25
| ||
| 20:36 | Fix Makefile.in to account for recent changes. Update fts5 test scripts so that they do not run if SQLITE_ENABLE_FTS5 is not defined. (check-in: 3175220747 user: dan tags: fts5) | |
| 20:16 | Merge latest trunk changes into this branch. (check-in: fcd8f7ce60 user: dan tags: fts5) | |
| 20:10 | Add a script to combine all fts5 code into a single file - fts5.c - that can be used to build an SQLite loadable extension. (check-in: 46e86b0637 user: dan tags: fts5) | |
|
2015-06-23
| ||
| 18:47 | Improve test coverage of fts5. (check-in: df5ccea80e user: dan tags: fts5) | |
| 15:06 | Merge latest trunk changes with this branch. Add tests for columnsize=0. (check-in: ef44c71a22 user: dan tags: fts5) | |
|
2015-06-10
| ||
| 10:45 | Fix the fts5 xRename() method. (check-in: 0f7fd51325 user: dan tags: fts5) | |
|
2015-06-09
| ||
| 20:58 | Add the "columnsize=" option to fts5, similar to fts4's "matchinfo=fts3". (check-in: aa12f9d9b7 user: dan tags: fts5) | |
|
2015-06-06
| ||
| 19:23 | Fix a comment in fts5.h. (check-in: e964b58774 user: dan tags: fts5) | |
| 16:28 | Fix handling of fts5 rowid constraints in the absence of a MATCH clause. Add tests to cover recently added branches. (check-in: 3a9cb64813 user: dan tags: fts5) | |
|
2015-06-05
| ||
| 19:05 | Make use of range constraints on the rowid field of an fts5 table in full-text queries. (check-in: 32cbc0ed36 user: dan tags: fts5) | |
|
2015-06-03
| ||
| 11:23 | Fix an fts5 problem in extracting columns from position lists containing large varints. (check-in: 4ea015ab98 user: dan tags: fts5) | |
|
2015-06-02
| ||
| 19:38 | Change the fts5 multi-column syntax to use parenthesis instead of square brackets. (check-in: ab85a6fc4f user: dan tags: fts5) | |
| 18:07 | Merge latest trunk changes with this branch. (check-in: c9ffda4abb user: dan tags: fts5) | |
| 17:57 | Reimplement [ec69e09a] so that each call to the xNext() method does not involve two iterations of the match expression tree (only one). (check-in: 80fe305b3e user: dan tags: fts5) | |
|
2015-06-01
| ||
| 19:17 | Improve performance of the fts5 AND operator. (check-in: b43e9a5b7a user: dan tags: fts5) | |
| 09:15 | Change fts5 expression processing to avoid linear scans of long doclists caused by phrases that match specific columns only. (check-in: ec69e09a55 user: dan tags: fts5) | |
|
2015-05-30
| ||
| 11:49 | Remove the "#include sqlite3Int.h" from fts5Int.h. (check-in: e008c3c8e2 user: dan tags: fts5) | |
|
2015-05-29
| ||
| 19:00 | Add extra tests and fixes for multi-column matches. (check-in: ae6794ffa2 user: dan tags: fts5) | |
| 15:55 | Add syntax to fts5 used to specify that a phrase or NEAR group should match a subset of columns. For example "[col1 col2 ...] : <phrase>". (check-in: 0fc0ea2092 user: dan tags: fts5) | |
|
2015-05-28
| ||
| 19:57 | Optimizations for fts5 queries that match against a specific column. (check-in: b29ac50af0 user: dan tags: fts5) | |
| 14:37 | Remove some dead code from fts5. Add auxiliary function api tests to the same. (check-in: 0f9df202cc user: dan tags: fts5) | |
|
2015-05-26
| ||
| 18:22 | Simplifications and minor optimizations to fts5 prefix queries that cannot use a prefix index. (check-in: aef89d9f6a user: dan tags: fts5) | |
|
2015-05-25
| ||
| 11:46 | Avoid redundant loads from the %_data table in the fts5 code. (check-in: 02069782f8 user: dan tags: fts5) | |
|
2015-05-23
| ||
| 15:43 | Avoid making redundant copies of position-lists within the fts5 code. (check-in: 5165de548b user: dan tags: fts5) | |
|
2015-05-22
| ||
| 07:44 | Increase test coverage of fts5_vocab.c. (check-in: 065ab83a6c user: dan tags: fts5) | |
| 06:08 | Improve test coverage of fts5_unicode2.c. (check-in: fea8a4db9d user: dan tags: fts5) | |
|
2015-05-20
| ||
| 09:27 | Improve test coverage of fts5_tokenize.c. (check-in: 0e91a6a520 user: dan tags: fts5) | |
|
2015-05-19
| ||
| 19:37 | Add tests for fts5 tokenizers. (check-in: 4f90ba20e2 user: dan tags: fts5) | |
| 11:38 | Update Makefile.in so that the amalgamation files built by "make sqlite3.c" include fts5. (check-in: 2870a80593 user: dan tags: fts5) | |
| 11:32 | Fix a memory leak that could follow an OOM condition in fts5. (check-in: de9f8ef6eb user: dan tags: fts5) | |
|
2015-05-18
| ||
| 20:34 | Improve test coverage of fts5_storage.c. (check-in: 4dfe2e5871 user: dan tags: fts5) | |
| 18:24 | Fix a bug in test script fts5fault4.test. (check-in: a508059305 user: dan tags: fts5) | |
| 18:03 | Add a test for an untested branch in fts5_expr.c. (check-in: ce08206b5c user: dan tags: fts5) | |
| 17:50 | Improve test coverage of fts5_config.c. (check-in: 47dbfadb99 user: dan tags: fts5) | |
|
2015-05-16
| ||
| 20:04 | Further test coverage improvements for fts5. (check-in: 927d9a64e1 user: dan tags: fts5) | |
|
2015-05-15
| ||
| 18:13 | Improve test coverage of fts5_index.c. (check-in: 7aea8c6d99 user: dan tags: fts5) | |
| 12:18 | Add test cases. And some fixes. (check-in: adee788586 user: dan tags: fts5) | |
|
2015-05-13
| ||
| 18:12 | Merge latest trunk changes with this branch. (check-in: b5f0e8c5b4 user: dan tags: fts5) | |
| 17:15 | Change fts5 doclist-index structures to be trees instead of flat lists. This only makes a difference for databases that contain millions of instances of the same token. (check-in: aa34bf666c user: dan tags: fts5) | |
|
2015-05-09
| ||
| 18:28 | Allow the fts5vocab table to optionally provide data on a per-column basis. (check-in: 3922276135 user: dan tags: fts5) | |
|
2015-05-08
| ||
| 20:21 | Add the fts5vocab module, for direct access to the fts5 index. (check-in: 6bf93e3b56 user: dan tags: fts5) | |
| 09:21 | Improve the error message returned by FTS5 if it encounters an unknown file format. (check-in: f369caec14 user: dan tags: fts5) | |
|
2015-05-07
| ||
| 19:29 | Change to storing all keys in a single merge-tree structure instead of one main structure and a separate one for each prefix index. This is a file-format change. Also introduce a mechanism for managing file-format changes. (check-in: a684b5e2d9 user: dan tags: fts5) | |
|
2015-05-02
| ||
| 20:35 | Reorganize some of the fts5 expression parsing code. Improve test coverage of the same. (check-in: c4456dc5f5 user: dan tags: fts5) | |
|
2015-05-01
| ||
| 20:38 | Further improvements to test coverage of fts5 code. (check-in: d4331943df user: dan tags: fts5) | |
| 12:14 | Improve test coverage of fts5.c. (check-in: add4f4681c user: dan tags: fts5) | |
|
2015-04-29
| ||
| 20:54 | Improve fts5 tests. (check-in: c1f07a3aa9 user: dan tags: fts5) | |
|
2015-04-28
| ||
| 20:24 | Fix an fts5 bug in handling writes while there are active cursors. (check-in: 07f7095539 user: dan tags: fts5) | |
| 18:35 | Improve coverage of fts5 tests. (check-in: 8e8136f2dc user: dan tags: fts5) | |
|
2015-04-27
| ||
| 16:21 | Change the fts5 content= option so that it matches fts5 columns with the underlying table columns by name, not by their position within the CREATE TABLE statement. (check-in: e38e2bb637 user: dan tags: fts5) | |
| 11:31 | Further tests for fts5. (check-in: ffeb3ef3cf user: dan tags: fts5) | |
|
2015-04-25
| ||
| 20:29 | Improve coverage of fts5_index.c slightly. (check-in: e5aaa01306 user: dan tags: fts5) | |
| 18:56 | Add tests for fts5. (check-in: e748651c94 user: dan tags: fts5) | |
|
2015-04-24
| ||
| 20:18 | Merge latest trunk changes with this branch. (check-in: 1c78d8920f user: dan tags: fts5) | |
| 19:41 | Add the "unindexed" column option to fts5. (check-in: 8630996134 user: dan tags: fts5) | |
| 15:56 | Add extra tests for corrupt database handling in fts5. (check-in: 41449f7a0b user: dan tags: fts5) | |
| 06:02 | Fix an fts5 build problem in main.mk. (check-in: 60045cedef user: dan tags: fts5) | |
|
2015-04-22
| ||
| 20:58 | Add extra OOM tests for fts5. (check-in: 2dd59b5762 user: dan tags: fts5) | |
| 20:14 | Fix problems with doclist-indexes involving very large rowids. (check-in: 1e5994097e user: dan tags: fts5) | |
| 09:40 | Update this branch with latest trunk changes. (check-in: 9797482ded user: dan tags: fts5) | |
|
2015-04-21
| ||
| 20:13 | Fix a problem in fts5fault1.test. (check-in: a21d60cb2a user: dan tags: fts5) | |
| 19:07 | Fix an fts5 problem with large deletes. (check-in: e50e8031d6 user: dan tags: fts5) | |
|
2015-04-20
| ||
| 18:48 | Fix some fts5 problems with very large position lists. (check-in: 2ea8f9cbe6 user: dan tags: fts5) | |
|
2015-04-15
| ||
| 18:49 | Logically store updates as (insert+delete) within the FTS tree. This allows keys to be annihilated more quickly under some circumstances. (check-in: 50fae1f000 user: dan tags: fts5) | |
| 16:01 | Fix a problem preventing doclist indexes from being loaded. (check-in: b29109a083 user: dan tags: fts5) | |
|
2015-04-14
| ||
| 20:15 | Begin changing fts5 to use a delete flag so that delete markers may be annihilated more quickly. (check-in: 9341c070bb user: dan tags: fts5) | |
|
2015-04-11
| ||
| 18:25 | Have fts5 integrity check verify that prefix indexes contain the same values as returned by prefix queries on the main terms index. (check-in: bdb8e82ab6 user: dan tags: fts5) | |
| 16:23 | Improve fts5 integrity-check so that it checks that DESC queries return the same as ASC. Change the poslist format slightly to make room for a delete-flag. (check-in: 49c1e74522 user: dan tags: fts5) | |
|
2015-03-21
| ||
| 15:45 | Merge trunk changes with this branch. (check-in: 142743918f user: dan tags: fts5) | |
| 15:37 | When scanning the full-text index as part of the fts5 integrity-check, also run a point query for every term and verify that these results are consistent with those found by the linear scan. (check-in: ce972f6aab user: dan tags: fts5) | |
|
2015-03-11
| ||
| 14:51 | Add an optimization to the fts5 unicode tokenizer code. (check-in: f5db489250 user: dan tags: fts5) | |
|
2015-03-10
| ||
| 19:24 | Avoid redundant string comparisons while merging fts5 segment b-trees. (check-in: 5c46820d9b user: dan tags: fts5) | |
|
2015-03-07
| ||
| 15:46 | Fix some compiler warnings caused by signed/unsigned pointer conversions. (check-in: cccee7b5b1 user: dan tags: fts5) | |
| 11:50 | Fix the bm25() function so that it multiplies scores by -1 before returning them. This means better matches have a lower numerical score, so "ORDER BY rank" (not "ORDER BY rank DESC") does what you want. (check-in: 3ee7b5a9f9 user: dan tags: fts5) | |
|
2015-03-04
| ||
| 08:29 | Fix a couple of build problems. (check-in: a5d5468c05 user: dan tags: fts5) | |
|
2015-02-27
| ||
| 09:41 | Further minor optimizations to flushing fts5 data to disk. (check-in: a07dcca9ef user: dan tags: fts5) | |
| 07:23 | Fix suffix and prefix compression of terms in top-level fts5 segments. And a crash that could follow an OOM condition. (check-in: bb104b3646 user: dan tags: fts5) | |
|
2015-02-26
| ||
| 20:49 | Optimize copying data from fts5 in-memory hash tables to top level segments. (check-in: 8e3ca6323a user: dan tags: fts5) | |
| 14:54 | Fix an fts5 bug in large incremental merges. (check-in: 208e3cb6b6 user: dan tags: fts5) | |
|
2015-02-25
| ||
| 19:24 | Instead of the 4-byte fields, use regular varints for the poslist-size field in fts5_hash.c. (check-in: 7eb022d7e5 user: dan tags: fts5) | |
|
2015-02-02
| ||
| 11:58 | Ensure generated header file fts5parse.h is included in sqlite3.c. (check-in: bc7be2fcfd user: dan tags: fts5) | |
| 11:32 | Fix some problems with building fts5 and fts3 together using the amalgamation. (check-in: fb10bbb9f9 user: dan tags: fts5) | |
| 09:40 | Merge latest trunk changes with this branch. (check-in: 76212f2c9a user: dan tags: fts5) | |
|
2015-01-31
| ||
| 15:23 | Minor optimizations to fts5 writes. (check-in: 1fffe51fa9 user: dan tags: fts5) | |
|
2015-01-29
| ||
| 20:59 | Fix some problems with transactions that both read and write an fts5 table. (check-in: 0e225b1535 user: dan tags: fts5) | |
|
2015-01-27
| ||
| 20:41 | Fix a problem with fts5 doclist-indexes that occured if the first rowid of the first non-term page of a doclist is zero. (check-in: f704bc059e user: dan tags: fts5) | |
|
2015-01-24
| ||
| 19:57 | Have fts5 store rowids in ascending order. Query speed is virtually the same regardless of rowid order, and ascending order makes some insert optimizations easier. (check-in: 5206ca6005 user: dan tags: fts5) | |
|
2015-01-23
| ||
| 17:43 | Fix compression of keys stored on internal segment b-tree nodes by fts5. (check-in: 51444f67c0 user: dan tags: fts5) | |
| 06:50 | Remove some redundant code from fts5. (check-in: 939b7a5de2 user: dan tags: fts5) | |
|
2015-01-22
| ||
| 19:13 | Add further tests and fixes for fts5. (check-in: 5b29589715 user: dan tags: fts5) | |
|
2015-01-21
| ||
| 20:30 | Further tests and fixes for fts5. (check-in: c020a291ed user: dan tags: fts5) | |
| 18:23 | Fix an fts5 issue with loading doclist-indexes for a term that is the last thing on its leaf page. (check-in: e0d614425f user: dan tags: fts5) | |
| 17:20 | Merge trunk changes with this branch. (check-in: f8699a1a3b user: dan tags: fts5) | |
| 16:10 | Add further tests for fts5 backend. (check-in: 09dabb3b9e user: dan tags: fts5) | |
| 06:36 | Merge latest trunk changes with this branch. (check-in: b3348b1e07 user: dan tags: fts5) | |
|
2015-01-20
| ||
| 20:34 | Add extra fault injection tests to fts5. (check-in: f45a0dc0a8 user: dan tags: fts5) | |
|
2015-01-19
| ||
| 11:15 | Handle the case where a tokenizer determines that there are zero tokens in an fts5 query term. (check-in: 75f3d17f86 user: dan tags: fts5) | |
|
2015-01-17
| ||
| 20:01 | Ensure an up to date copy of the fts5 configuration has been loaded into memory before attempting to modify the same configuration. (check-in: f30afd209a user: dan tags: fts5) | |
| 17:48 | Improve the performance of the fts5 porter tokenizer implementation. (check-in: 96ea600440 user: dan tags: fts5) | |
|
2015-01-13
| ||
| 17:25 | Fix prefix indexes so that they work in characters, not bytes. (check-in: af8d43a4a0 user: dan tags: fts5) | |
|
2015-01-12
| ||
| 17:58 | Optimize the unicode61 tokenizer so that it handles ascii text faster. Make it the default tokenizer. Change the name of the simple tokenizer to "ascii". (check-in: f22dbccad9 user: dan tags: fts5) | |
|
2015-01-10
| ||
| 20:34 | Fix some documentation issues in fts5. (check-in: 512e1bdb40 user: dan tags: fts5) | |
|
2015-01-07
| ||
| 19:33 | Add the fts5 'optimize' command. (check-in: e749be563d user: dan tags: fts5) | |
| 17:11 | Add the 'rebuild' and 'delete-all' commands. (check-in: 0cb2fed525 user: dan tags: fts5) | |
|
2015-01-06
| ||
| 19:08 | Remove the iPos parameter from the tokenizer callback. Fix the "tokenchars" and "separators" options on the simple tokenizer. (check-in: 65f0262fb8 user: dan tags: fts5) | |
| 14:38 | Further fixes and test cases related to external content tables. (check-in: ce6a899baf user: dan tags: fts5) | |
|
2015-01-05
| ||
| 20:41 | Tests and fixes for fts5 external content tables. (check-in: 047aaf830d user: dan tags: fts5) | |
|
2015-01-03
| ||
| 20:44 | Add support for external content tables to fts5. (check-in: 17ef5b59f7 user: dan tags: fts5) | |
|
2015-01-02
| ||
| 14:55 | Allow the rank column to be remapped on a per-query basis by including a term similar to "rank match 'bm25(10,2)'" in a where clause. (check-in: 1cd15a1759 user: dan tags: fts5) | |
|
2015-01-01
| ||
| 18:03 | Merge latest trunk changes with this branch. (check-in: 4b3651677e user: dan tags: fts5) | |
| 16:46 | Add a version of the unicode61 tokenizer to fts5. (check-in: d09f7800cf user: dan tags: fts5) | |
|
2014-12-29
| ||
| 15:59 | Move all fts5 test files to new directory "ext/fts5/test". (check-in: 7f148edb30 user: dan tags: fts5) | |
| 11:24 | Fixes to built-in tokenizers. (check-in: b33fe0dd89 user: dan tags: fts5) | |
|
2014-12-23
| ||
| 19:18 | Fix the fts5 bm25() function so that it matches the documentation. (check-in: 1ac7a8d0af user: dan tags: fts5) | |
|
2014-12-22
| ||
| 21:01 | Fixes and simplifications for the snippet() and highlight() functions. (check-in: ca5d44042a user: dan tags: fts5) | |
|
2014-12-19
| ||
| 20:53 | Remove the fts5_test() aux function. Test aux functions using the tcl interface instead. (check-in: 67e3ffd950 user: dan tags: fts5) | |
|
2014-12-18
| ||
| 20:01 | Fix a problem with prefix queries and the AND operator. (check-in: 38b3c65e3e user: dan tags: fts5) | |
| 18:25 | Fix various problems in fts5 revealed by fault-injection tests. (check-in: e358c3de5c user: dan tags: fts5) | |
|
2014-12-03
| ||
| 17:27 | Begin testing fts5 OOM and IO error handling. (check-in: 2037dba62f user: dan tags: fts5) | |
|
2014-12-02
| ||
| 20:18 | Add a configuration option to remap the "rank" column to an auxiliary fts5 function. (check-in: b5f5971283 user: dan tags: fts5) | |
|
2014-12-01
| ||
| 20:05 | Add code to parse a rank() function specification. And a tcl interface to add auxiliary functions to fts5. (check-in: 9c1697a2aa user: dan tags: fts5) | |
|
2014-11-28
| ||
| 20:01 | Add a cookie mechanism to ensure that the %_config table is re-read as required. (check-in: bb4a37b53d user: dan tags: fts5) | |
|
2014-11-27
| ||
| 20:03 | Add a %_config table to fts5. (check-in: 83491c5666 user: dan tags: fts5) | |
|
2014-11-24
| ||
| 16:24 | Add the auxiliary highlight() function to fts5. (check-in: 059092379f user: dan tags: fts5) | |
|
2014-11-15
| ||
| 20:07 | Fix the customization interfaces so that they match the documentation. (check-in: fba0b5fc7e user: dan tags: fts5) | |
|
2014-08-25
| ||
| 19:58 | Add documentation for tokenizer api to fts5.h. Also add a script to extract extension API docs and format them as html. (check-in: e240d467e6 user: dan tags: fts5) | |
|
2014-08-18
| ||
| 19:30 | Add an "automerge=0" mode that disables auto-merging and falls back to fts4-style crisis merges. (check-in: 2397404e15 user: dan tags: fts5) | |
|
2014-08-12
| ||
| 16:07 | Cache the value of the "totals" record in memory during transactions. (check-in: 05dfdad445 user: dan tags: fts5) | |
| 08:36 | Automatically resize the hash table used by fts5. (check-in: f1cb48f412 user: dan tags: fts5) | |
|
2014-08-11
| ||
| 20:26 | Simplify the way position lists are copied when merging data. (check-in: 9f8d678a0e user: dan tags: fts5) | |
| 19:44 | Replace the hash table borrowed from fts3. (check-in: 617e2fac1c user: dan tags: fts5) | |
|
2014-08-09
| ||
| 18:22 | Fix an uninitialized variable causing a problem during fts5 table initialization. (check-in: a14fa876f0 user: dan tags: fts5) | |
| 18:02 | Use multiple memory allocations for a single Fts5Structure object. This is probably less efficient but much easier to get right. (check-in: 2821825f7a user: dan tags: fts5) | |
|
2014-08-07
| ||
| 18:47 | Add "segment promotion" to fts5. This prevents the FTS index from growing indefinitely as data is added and deleted. (check-in: ba359d78e1 user: dan tags: fts5) | |
|
2014-08-06
| ||
| 20:04 | Avoid writing delete markers to the oldest segment in an FTS index. (check-in: 1baeb1cee6 user: dan tags: fts5) | |
| 16:30 | Add support for savepoints to fts5. (check-in: 3b19eba042 user: dan tags: fts5) | |
|
2014-08-05
| ||
| 19:35 | Use doclist indexes for AND queries as well as phrases. (check-in: 5d38e6edc4 user: dan tags: fts5) | |
| 19:00 | Use doclist-indexes with "ORDER BY rowid ASC" fts5 queries as well. (check-in: d028ba6589 user: dan tags: fts5) | |
|
2014-08-04
| ||
| 20:07 | Fix fts5_index.c to use doclist-indexes when possible. Only some cases work so far. (check-in: 90b82d3ef6 user: dan tags: fts5) | |
|
2014-08-02
| ||
| 20:49 | Start changing things to use doclist indexes as required. code is not activated yet. (check-in: b8864da95d user: dan tags: fts5) | |
|
2014-08-01
| ||
| 20:13 | Add a special case to the integrity-check code to check that the final integer in a doclist index is as expected. (check-in: c98934155c user: dan tags: fts5) | |
| 19:27 | Have the fts5 integrity-check verify that doclist indexes match the contents of the leaf pages that they index. (check-in: 37a7d3035e user: dan tags: fts5) | |
| 11:16 | Add "doclist index" records to the database. These are to make navigating within very large doclists faster. They are not yet used by queries. (check-in: 89377421ff user: dan tags: fts5) | |
|
2014-07-31
| ||
| 17:53 | Add a comment explaining why fts5 cannot cache "sorter statements". (check-in: e6af3b7a3c user: dan tags: fts5) | |
| 17:47 | Try to reuse sorter statements in fts5. Does not work due to circular references on VTable object. (Leaf check-in: bc14e64bdf user: dan tags: save_sorter_stmt) | |
| 11:57 | Add further tests for the extension APIs with "ORDER BY rank" queries. (check-in: 37a417d27e user: dan tags: fts5) | |
|
2014-07-30
| ||
| 20:26 | Fix things so that the fts5 extension API works with "ORDER BY rank" queries. (check-in: f1b4e1a98d user: dan tags: fts5) | |
| 19:41 | Add hidden column "rank". Currently this always returns the same value as the bm25() function. (check-in: 4cc048c365 user: dan tags: fts5) | |
|
2014-07-28
| ||
| 20:14 | Add the "loadfts" program, for performance testing the loading of data into fts3/fts4/fts5 tables. (check-in: 770b9540c1 user: dan tags: fts5) | |
|
2014-07-26
| ||
| 18:38 | Add tests and fixes for bm25() function. (check-in: 71d32f53e8 user: dan tags: fts5) | |
|
2014-07-25
| ||
| 20:30 | Add extension apis xRowCount, xQueryPhrase, xSetAuxdata and xGetAuxdata. And a ranking function that uses all of the above. (check-in: c4d50428ab user: dan tags: fts5) | |
|
2014-07-23
| ||
| 19:31 | Add a snippet() function to fts5. (check-in: bdc58fd28a user: dan tags: fts5) | |
|
2014-07-21
| ||
| 15:45 | Fix DELETE and UPDATE operations on fts5 tables. (check-in: d44d3a8518 user: dan tags: fts5) | |
| 14:22 | Add the xTokenize extension API. (check-in: 8c6b0aff34 user: dan tags: fts5) | |
| 11:44 | Fix the xColumnSize() extension API. (check-in: 19504c4108 user: dan tags: fts5) | |