/ Timeline
Login

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

100 descendants of [fb10bbb9]

2015-06-27
23:55
Make greater use of BtCursor.curIntKey. check-in: 63998471 user: drh tags: trunk
22:49
Add the BtCursor.curIntKey field and use it for a small size reduction and performance boost. check-in: 4a17df13 user: drh tags: trunk
20:55
Enhancements to the previous check-in to make it a little smaller and faster. check-in: 291d9e0c 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: 1956a4ce 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: 7f65b96b 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: 9383a688 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: bee94dc3 user: drh tags: trunk
2015-06-26
20:45
Treat compilation of FTS5 for the loadable extension specially with MSVC. check-in: 7c610276 user: mistachkin tags: trunk
20:25
Merge fts5 branch into trunk. check-in: d27d9965 user: dan tags: trunk
20:14
Merge latest trunk with this branch. Closed-Leaf check-in: 8671b9e1 user: dan tags: fts5
20:13
Remove unnecessary lines from fts3.h and main.mk. check-in: c1b268ce user: dan tags: fts5
20:08
Fix a segfault that could follow an OOM error in fts5. check-in: 713239b8 user: dan tags: fts5
19:33
Merge latest trunk changes with this branch. check-in: 2a1af0f2 user: dan tags: fts5
18:50
Fix some cases in the fts5 code where a corrupt database could cause a buffer overread. check-in: 360c57bb user: dan tags: fts5
17:10
Merge changes to get FTS5 working with MSVC. check-in: 954231d2 user: mistachkin tags: fts5
16:55
Merge upstream changes. Get the test fixture working with FTS5. Fix compiler warnings. Closed-Leaf check-in: bfcd1608 user: mistachkin tags: fts5Msvc
16:42
Remove fts5 initialization code from core file main.c. check-in: c91a93b3 user: dan tags: fts5
16:17
Add FTS5 DLL target for MSVC. check-in: be85b824 user: mistachkin tags: fts5Msvc
04:34
Initial changes to get FTS5 working with MSVC. check-in: ef2052f8 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: 31752207 user: dan tags: fts5
20:16
Merge latest trunk changes into this branch. check-in: fcd8f7ce 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: 46e86b06 user: dan tags: fts5
2015-06-23
18:47
Improve test coverage of fts5. check-in: df5ccea8 user: dan tags: fts5
15:06
Merge latest trunk changes with this branch. Add tests for columnsize=0. check-in: ef44c71a user: dan tags: fts5
2015-06-10
10:45
Fix the fts5 xRename() method. check-in: 0f7fd513 user: dan tags: fts5
2015-06-09
20:58
Add the "columnsize=" option to fts5, similar to fts4's "matchinfo=fts3". check-in: aa12f9d9 user: dan tags: fts5
2015-06-06
19:23
Fix a comment in fts5.h. check-in: e964b587 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: 3a9cb648 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: 32cbc0ed user: dan tags: fts5
2015-06-03
11:23
Fix an fts5 problem in extracting columns from position lists containing large varints. check-in: 4ea015ab user: dan tags: fts5
2015-06-02
19:38
Change the fts5 multi-column syntax to use parenthesis instead of square brackets. check-in: ab85a6fc user: dan tags: fts5
18:07
Merge latest trunk changes with this branch. check-in: c9ffda4a 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: 80fe305b user: dan tags: fts5
2015-06-01
19:17
Improve performance of the fts5 AND operator. check-in: b43e9a5b 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: ec69e09a user: dan tags: fts5
2015-05-30
11:49
Remove the "#include sqlite3Int.h" from fts5Int.h. check-in: e008c3c8 user: dan tags: fts5
2015-05-29
19:00
Add extra tests and fixes for multi-column matches. check-in: ae6794ff 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: 0fc0ea20 user: dan tags: fts5
2015-05-28
19:57
Optimizations for fts5 queries that match against a specific column. check-in: b29ac50a user: dan tags: fts5
14:37
Remove some dead code from fts5. Add auxiliary function api tests to the same. check-in: 0f9df202 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: aef89d9f user: dan tags: fts5
2015-05-25
11:46
Avoid redundant loads from the %_data table in the fts5 code. check-in: 02069782 user: dan tags: fts5
2015-05-23
15:43
Avoid making redundant copies of position-lists within the fts5 code. check-in: 5165de54 user: dan tags: fts5
2015-05-22
07:44
Increase test coverage of fts5_vocab.c. check-in: 065ab83a user: dan tags: fts5
06:08
Improve test coverage of fts5_unicode2.c. check-in: fea8a4db user: dan tags: fts5
2015-05-20
09:27
Improve test coverage of fts5_tokenize.c. check-in: 0e91a6a5 user: dan tags: fts5
2015-05-19
19:37
Add tests for fts5 tokenizers. check-in: 4f90ba20 user: dan tags: fts5
11:38
Update Makefile.in so that the amalgamation files built by "make sqlite3.c" include fts5. check-in: 2870a805 user: dan tags: fts5
11:32
Fix a memory leak that could follow an OOM condition in fts5. check-in: de9f8ef6 user: dan tags: fts5
2015-05-18
20:34
Improve test coverage of fts5_storage.c. check-in: 4dfe2e58 user: dan tags: fts5
18:24
Fix a bug in test script fts5fault4.test. check-in: a5080593 user: dan tags: fts5
18:03
Add a test for an untested branch in fts5_expr.c. check-in: ce08206b user: dan tags: fts5
17:50
Improve test coverage of fts5_config.c. check-in: 47dbfadb user: dan tags: fts5
2015-05-16
20:04
Further test coverage improvements for fts5. check-in: 927d9a64 user: dan tags: fts5
2015-05-15
18:13
Improve test coverage of fts5_index.c. check-in: 7aea8c6d user: dan tags: fts5
12:18
Add test cases. And some fixes. check-in: adee7885 user: dan tags: fts5
2015-05-13
18:12
Merge latest trunk changes with this branch. check-in: b5f0e8c5 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: aa34bf66 user: dan tags: fts5
2015-05-09
18:28
Allow the fts5vocab table to optionally provide data on a per-column basis. check-in: 39222761 user: dan tags: fts5
2015-05-08
20:21
Add the fts5vocab module, for direct access to the fts5 index. check-in: 6bf93e3b user: dan tags: fts5
09:21
Improve the error message returned by FTS5 if it encounters an unknown file format. check-in: f369caec 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: a684b5e2 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: c4456dc5 user: dan tags: fts5
2015-05-01
20:38
Further improvements to test coverage of fts5 code. check-in: d4331943 user: dan tags: fts5
12:14
Improve test coverage of fts5.c. check-in: add4f468 user: dan tags: fts5
2015-04-29
20:54
Improve fts5 tests. check-in: c1f07a3a user: dan tags: fts5
2015-04-28
20:24
Fix an fts5 bug in handling writes while there are active cursors. check-in: 07f70955 user: dan tags: fts5
18:35
Improve coverage of fts5 tests. check-in: 8e8136f2 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: e38e2bb6 user: dan tags: fts5
11:31
Further tests for fts5. check-in: ffeb3ef3 user: dan tags: fts5
2015-04-25
20:29
Improve coverage of fts5_index.c slightly. check-in: e5aaa013 user: dan tags: fts5
18:56
Add tests for fts5. check-in: e748651c user: dan tags: fts5
2015-04-24
20:18
Merge latest trunk changes with this branch. check-in: 1c78d892 user: dan tags: fts5
19:41
Add the "unindexed" column option to fts5. check-in: 86309961 user: dan tags: fts5
15:56
Add extra tests for corrupt database handling in fts5. check-in: 41449f7a user: dan tags: fts5
06:02
Fix an fts5 build problem in main.mk. check-in: 60045ced user: dan tags: fts5
2015-04-22
20:58
Add extra OOM tests for fts5. check-in: 2dd59b57 user: dan tags: fts5
20:14
Fix problems with doclist-indexes involving very large rowids. check-in: 1e599409 user: dan tags: fts5
09:40
Update this branch with latest trunk changes. check-in: 9797482d user: dan tags: fts5
2015-04-21
20:13
Fix a problem in fts5fault1.test. check-in: a21d60cb user: dan tags: fts5
19:07
Fix an fts5 problem with large deletes. check-in: e50e8031 user: dan tags: fts5
2015-04-20
18:48
Fix some fts5 problems with very large position lists. check-in: 2ea8f9cb 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: 50fae1f0 user: dan tags: fts5
16:01
Fix a problem preventing doclist indexes from being loaded. check-in: b29109a0 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: 9341c070 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: bdb8e82a 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: 49c1e745 user: dan tags: fts5
2015-03-21
15:45
Merge trunk changes with this branch. check-in: 14274391 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: ce972f6a user: dan tags: fts5
2015-03-11
14:51
Add an optimization to the fts5 unicode tokenizer code. check-in: f5db4892 user: dan tags: fts5
2015-03-10
19:24
Avoid redundant string comparisons while merging fts5 segment b-trees. check-in: 5c46820d user: dan tags: fts5
2015-03-07
15:46
Fix some compiler warnings caused by signed/unsigned pointer conversions. check-in: cccee7b5 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: 3ee7b5a9 user: dan tags: fts5
2015-03-04
08:29
Fix a couple of build problems. check-in: a5d5468c user: dan tags: fts5
2015-02-27
09:41
Further minor optimizations to flushing fts5 data to disk. check-in: a07dcca9 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: bb104b36 user: dan tags: fts5
2015-02-26
20:49
Optimize copying data from fts5 in-memory hash tables to top level segments. check-in: 8e3ca632 user: dan tags: fts5
14:54
Fix an fts5 bug in large incremental merges. check-in: 208e3cb6 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: 7eb022d7 user: dan tags: fts5
2015-02-02
11:58
Ensure generated header file fts5parse.h is included in sqlite3.c. check-in: bc7be2fc user: dan tags: fts5
11:32
Fix some problems with building fts5 and fts3 together using the amalgamation. check-in: fb10bbb9 user: dan tags: fts5