Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
79 check-ins using file tool/showdb.c version b018a8a6
2015-01-01
| ||
16:46 | Add a version of the unicode61 tokenizer to fts5. (check-in: d09f7800 user: dan tags: fts5) | |
2014-12-29
| ||
15:59 | Move all fts5 test files to new directory "ext/fts5/test". (check-in: 7f148edb user: dan tags: fts5) | |
11:24 | Fixes to built-in tokenizers. (check-in: b33fe0dd user: dan tags: fts5) | |
2014-12-23
| ||
19:18 | Fix the fts5 bm25() function so that it matches the documentation. (check-in: 1ac7a8d0 user: dan tags: fts5) | |
2014-12-22
| ||
21:01 | Fixes and simplifications for the snippet() and highlight() functions. (check-in: ca5d4404 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: 67e3ffd9 user: dan tags: fts5) | |
2014-12-18
| ||
20:01 | Fix a problem with prefix queries and the AND operator. (check-in: 38b3c65e user: dan tags: fts5) | |
18:25 | Fix various problems in fts5 revealed by fault-injection tests. (check-in: e358c3de user: dan tags: fts5) | |
2014-12-03
| ||
17:27 | Begin testing fts5 OOM and IO error handling. (check-in: 2037dba6 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: b5f59712 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: 9c1697a2 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: bb4a37b5 user: dan tags: fts5) | |
2014-11-27
| ||
20:03 | Add a %_config table to fts5. (check-in: 83491c56 user: dan tags: fts5) | |
2014-11-24
| ||
16:24 | Add the auxiliary highlight() function to fts5. (check-in: 05909237 user: dan tags: fts5) | |
2014-11-15
| ||
20:07 | Fix the customization interfaces so that they match the documentation. (check-in: fba0b5fc 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: e240d467 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: 2397404e user: dan tags: fts5) | |
2014-08-12
| ||
16:07 | Cache the value of the "totals" record in memory during transactions. (check-in: 05dfdad4 user: dan tags: fts5) | |
08:36 | Automatically resize the hash table used by fts5. (check-in: f1cb48f4 user: dan tags: fts5) | |
2014-08-11
| ||
20:26 | Simplify the way position lists are copied when merging data. (check-in: 9f8d678a user: dan tags: fts5) | |
19:44 | Replace the hash table borrowed from fts3. (check-in: 617e2fac user: dan tags: fts5) | |
2014-08-09
| ||
18:22 | Fix an uninitialized variable causing a problem during fts5 table initialization. (check-in: a14fa876 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: 2821825f 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: ba359d78 user: dan tags: fts5) | |
2014-08-06
| ||
20:04 | Avoid writing delete markers to the oldest segment in an FTS index. (check-in: 1baeb1ce user: dan tags: fts5) | |
16:30 | Add support for savepoints to fts5. (check-in: 3b19eba0 user: dan tags: fts5) | |
2014-08-05
| ||
19:35 | Use doclist indexes for AND queries as well as phrases. (check-in: 5d38e6ed user: dan tags: fts5) | |
19:00 | Use doclist-indexes with "ORDER BY rowid ASC" fts5 queries as well. (check-in: d028ba65 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: 90b82d3e 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: b8864da9 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: c9893415 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: 37a7d303 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: 89377421 user: dan tags: fts5) | |
2014-07-31
| ||
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) | |
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-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) | |
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-10
| ||
20:21 | Support "ORDER BY rowid ASC". (check-in: b96b5e16 user: dan tags: fts5) | |
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) | |
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) | |
2014-06-28
| ||
19:06 | Add an OOM fault injection test for the new code on this branch. (Closed-Leaf check-in: c96de490 user: dan tags: stat4-skipscan) | |
17:35 | Add further tests to skipscan5.test. (check-in: 4b8230e8 user: dan tags: stat4-skipscan) | |
16:06 | Add header comments on new routines. Rework the sqlite3Stat4Column() routine so that is (in theory) able to deal with corrupt samples. (check-in: ef5cdf94 user: drh tags: stat4-skipscan) | |
15:26 | Fix a problem with using stat4 samples of type text when estimating the rows visited by a range-query/skip-scan loop. (check-in: dfb09db6 user: dan tags: stat4-skipscan) | |
14:28 | Change the VDBE to export the sqlite3MemCompare() routine and thus free where.c from the dependency on vdbeInt.h. (check-in: d186d1ac user: drh tags: stat4-skipscan) | |
14:25 | Merge fixes from trunk with this branch. (check-in: 6af219d1 user: dan tags: stat4-skipscan) | |
2014-06-27
| ||
20:14 | Fix a couple of problems in estimating the number of rows visited by a range query that uses a skip-scan. (check-in: 219736f5 user: dan tags: stat4-skipscan) | |
2014-06-26
| ||
22:17 | Add some more IN operator tests. (check-in: fb32e374 user: mistachkin tags: trunk) | |
21:32 | Fix compilation issue when STAT4 is not enabled. (check-in: 74a5454a user: mistachkin tags: stat4-skipscan) | |
21:28 | Revise the affinity returned for expressions flagged as 'generic'. Fix for [9a8b09f8e6]. (check-in: 92f7ad43 user: mistachkin tags: trunk) | |
20:21 | Attempt to use sqlite_stat4 data to estimate the number of rows visited by a range query that uses a skip-scan. This code is largely untested. (check-in: 01dc8102 user: dan tags: stat4-skipscan) | |
12:31 | Fix minor problems in term matching. (check-in: 94eeb077 user: dan tags: fts5) | |
2014-06-25
| ||
20:28 | Begin adding query support to fts5. (check-in: 47a9f3cc user: dan tags: fts5) | |
2014-06-24
| ||
20:19 | Fix showstat4.c so that it decodes typecodes 8 and 9 correctly. (check-in: 9ca737c0 user: drh tags: trunk) | |
16:59 | Add simple full-table-scan and rowid lookup support to fts5. (check-in: 3515da85 user: dan tags: fts5) | |
00:59 | Add the showstat4.exe utility program for decoding and displaying the content of the sqlite_stat4 table in a database. (check-in: b4d9f605 user: drh tags: trunk) | |
2014-06-23
| ||
23:28 | Add the .fullschema command to the sqlite3.exe utility. This command shows the schema and the content of the sqlite_stat tables, all in one go. Useful when reporting problems with the query planner. (check-in: ebec4892 user: drh tags: trunk) | |
11:33 | Add some code for an experimental fts5 module. Does not work yet. (check-in: 1e0648dc user: dan tags: fts5) | |
10:18 | Fix a problem with SQLITE_OMIT_WSD builds. (check-in: 07dda49c user: dan tags: trunk) | |
10:04 | Fix a problem with SQLITE_OMIT_WAL builds. (check-in: 612b6d1b user: dan tags: trunk) | |
2014-06-20
| ||
13:55 | Improved display of record data in the "NNNbd" output of the showdb.exe utility program. (check-in: f735c249 user: drh tags: trunk) | |