SQLite

Timeline
Login

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

37 events for the month beginning 2015-01-01 by user dan

Following month ↑
2015-01-31
20:42
Have ota use imposter tables to write to indexes instead of the sqlite3_index_writer() interface. The error handling in this version is broken in a few small ways. (check-in: cdaeab46 user: dan tags: ota-update)
15:23
Minor optimizations to fts5 writes. (check-in: 1fffe51f user: dan tags: fts5)
2015-01-29
20:59
Fix some problems with transactions that both read and write an fts5 table. (check-in: 0e225b15 user: dan tags: fts5)
19:13 Edit [53429689d4fcf472|53429689]: Edit check-in comment. (artifact: 503c81f3 user: dan)
19:12
Ensure that "PRAGMA wal_checkpoint = TRUNCATE|FULL|RESTART" block on other connections and truncate the wal file as required even if the entire wal file has already been checkpointed. (check-in: 53429689 user: dan tags: trunk)
11:52
Optimize range constraints on the rowid column of fts3/4 tables even if there is no MATCH clause in the query. (check-in: 85dc1262 user: dan tags: trunk)
2015-01-28
15:30
When a "full", "restart" or "truncate" checkpoint is attempted, return SQLITE_BUSY if a reader prevents the checkpointer from copying any frames at all into the database file. (check-in: f2700040 user: dan tags: ota-update)
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: f704bc05 user: dan tags: fts5)
19:01
Fix a bug in the fts3 snippet() function causing it to omit leading separator characters from snippets that begin with the first token in a column. (check-in: adc9283d user: dan tags: trunk)
18:43
Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function. (check-in: 245e8730 user: dan tags: trunk)
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: 5206ca60 user: dan tags: fts5)
2015-01-23
17:43
Fix compression of keys stored on internal segment b-tree nodes by fts5. (check-in: 51444f67 user: dan tags: fts5)
06:50
Remove some redundant code from fts5. (check-in: 939b7a5d user: dan tags: fts5)
2015-01-22
19:13
Add further tests and fixes for fts5. (check-in: 5b295897 user: dan tags: fts5)
2015-01-21
20:30
Further tests and fixes for fts5. (check-in: c020a291 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: e0d61442 user: dan tags: fts5)
17:20
Merge trunk changes with this branch. (check-in: f8699a1a user: dan tags: fts5)
17:00
Fix an assert() that may fail following an OOM error. (check-in: 5f592359 user: dan tags: trunk)
16:10
Add further tests for fts5 backend. (check-in: 09dabb3b user: dan tags: fts5)
06:36
Merge latest trunk changes with this branch. (check-in: b3348b1e user: dan tags: fts5)
2015-01-20
20:34
Add extra fault injection tests to fts5. (check-in: f45a0dc0 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: 75f3d17f 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: f30afd20 user: dan tags: fts5)
17:48
Improve the performance of the fts5 porter tokenizer implementation. (check-in: 96ea6004 user: dan tags: fts5)
2015-01-13
17:25
Fix prefix indexes so that they work in characters, not bytes. (check-in: af8d43a4 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: f22dbcca user: dan tags: fts5)
2015-01-10
20:34
Fix some documentation issues in fts5. (check-in: 512e1bdb user: dan tags: fts5)
2015-01-07
19:33
Add the fts5 'optimize' command. (check-in: e749be56 user: dan tags: fts5)
17:11
Add the 'rebuild' and 'delete-all' commands. (check-in: 0cb2fed5 user: dan tags: fts5)
2015-01-06
21:31
Fix a problem in the unix implementation of FCNTL_SIZE_HINT on systems that do not support posix_fallocate(). (check-in: af20eae1 user: dan tags: trunk)
19:08
Remove the iPos parameter from the tokenizer callback. Fix the "tokenchars" and "separators" options on the simple tokenizer. (check-in: 65f0262f user: dan tags: fts5)
14:38
Further fixes and test cases related to external content tables. (check-in: ce6a899b user: dan tags: fts5)
2015-01-05
20:41
Tests and fixes for fts5 external content tables. (check-in: 047aaf83 user: dan tags: fts5)
2015-01-03
20:44
Add support for external content tables to fts5. (check-in: 17ef5b59 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: 1cd15a17 user: dan tags: fts5)
2015-01-01
18:03
Merge latest trunk changes with this branch. (check-in: 4b365167 user: dan tags: fts5)
16:46
Add a version of the unicode61 tokenizer to fts5. (check-in: d09f7800 user: dan tags: fts5)
Previous month ↓