SQLite

Timeline
Login

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

39 events for the month beginning 2014-07-01 by user dan

Following month ↑
2014-07-31
18:14
Add a missing call to "test_sqlite3_log" to multiplex.test. (check-in: 0708f9df user: dan tags: trunk)
17:53
Add a comment explaining why fts5 cannot cache "sorter statements". (check-in: e6af3b7a 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: bc14e64b user: dan tags: save_sorter_stmt)
17:36 Edit [47457b0488abcbec|47457b04]: Edit check-in comment. (artifact: 26753b8e user: dan)
17:35
Fix a leaked database handle in pager2.test. (check-in: 47457b04 user: dan tags: trunk)
11:57
Add further tests for the extension APIs with "ORDER BY rank" queries. (check-in: 37a417d2 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: f1b4e1a9 user: dan tags: fts5)
19:41
Add hidden column "rank". Currently this always returns the same value as the bm25() function. (check-in: 4cc048c3 user: dan tags: fts5)
2014-07-29
11:54
Have calls to the xFilter() method of rtree virtual tables ensure that cursor is initialized before proceeding. Fix for [d2889096e7bdeac]. (check-in: 8cc41b0b user: dan tags: trunk)
11:18 Ticket [d2889096] Problem with rtree tables with IN() operators or as the inner loop of a join. status still Open with 6 other changes (artifact: c90fa76d user: dan) ... 1 similar event omitted.
2014-07-28
20:14
Add the "loadfts" program, for performance testing the loading of data into fts3/fts4/fts5 tables. (check-in: 770b9540 user: dan tags: fts5)
2014-07-26
18:38
Add tests and fixes for bm25() function. (check-in: 71d32f53 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: c4d50428 user: dan tags: fts5)
2014-07-23
19:31
Add a snippet() function to fts5. (check-in: bdc58fd2 user: dan tags: fts5)
2014-07-21
15:45
Fix DELETE and UPDATE operations on fts5 tables. (check-in: d44d3a85 user: dan tags: fts5)
14:22
Add the xTokenize extension API. (check-in: 8c6b0aff user: dan tags: fts5)
11:44
Fix the xColumnSize() extension API. (check-in: 19504c41 user: dan tags: fts5)
2014-07-19
20:27
Add simple tests for the xColumnText() extension api. (check-in: 1e9053ab user: dan tags: fts5)
17:57
Update the sqlite3_stmt_busy() function so that it correctly returns true for "ROLLBACK" statements that have been stepped but not yet reset. (check-in: 61cee3c0 user: dan tags: trunk)
15:35
Fixes for the xColumnSize() fts5 extension API. (check-in: 43fcb844 user: dan tags: fts5)
2014-07-18
19:59
Fix issues with position lists and NEAR constraints. (check-in: 16352d36 user: dan tags: fts5)
2014-07-17
15:14
Fix a problem with position list processing for OR queries. (check-in: 5808f30f user: dan tags: fts5)
2014-07-16
20:07
Fixes for tcl list generation in fts5_test(). (check-in: c1f9a4b7 user: dan tags: fts5)
19:15
Begin adding interface for auxiliary functions. (check-in: 1e2a7ba0 user: dan tags: fts5)
2014-07-15
11:59
Add simple tests for new sqlite3BtreeCursorHint() functionality. (check-in: 1efa6ed5 user: dan tags: cursor-hints)
2014-07-14
19:05 Edit [f9dddd008c6ef794|f9dddd00]: Edit check-in comment. (artifact: 0b369381 user: dan)
19:04
In the expression passed to sqlite3BtreeCursorHint() for the inner loops of joins, replace any TK_COLUMN references to columns in the outer loops with TK_REGISTER expressions (Expr.iTable indicates the specific register containing the value). There are no automated tests for this yet. (check-in: f9dddd00 user: dan tags: cursor-hints)
2014-07-10
20:21
Support "ORDER BY rowid ASC". (check-in: b96b5e16 user: dan tags: fts5)
2014-07-09
07:55 Changes to wiki page "Bug Reports" (artifact: d9441625 user: dan)
2014-07-08
16:27
Add support for prefix queries to fts5. (check-in: 75ebd3cd user: dan tags: fts5)
2014-07-05
15:15
Add support for AND, OR and NOT to fts5. (check-in: 8682b87e user: dan tags: fts5)
07:54
Add support for the "colname : <nearset>" syntax to fts5. (check-in: 00466710 user: dan tags: fts5)
2014-07-03
20:39
Add support for NEAR expressions to fts5. (check-in: 250ae8d4 user: dan tags: fts5)
12:18
Change fts3/4 so that the "unicode61" is included in builds by default. It may now be excluded by defining SQLITE_DISABLE_FTS3_UNICODE. (check-in: 0cc0230a user: dan tags: trunk)
2014-07-02
20:18
Add support for phrase queries to fts5. (check-in: 2e5652e6 user: dan tags: fts5)
2014-07-01
20:45
Change the position list format so that its size in bytes is stored at the start of the list itself. (check-in: 62f2ff20 user: dan tags: fts5)
15:22
Add another test to verify that SQLite is using stat4 data for composite primary keys on WITHOUT ROWID tables. (check-in: 0df1fe72 user: dan tags: trunk)
11:54
Ensure that all fields are loaded from the stat4 table for records that correspond to indexes on WITHOUT ROWID tables with composite primary keys. (check-in: 21981e35 user: dan tags: trunk)
Previous month ↓