/ File History
Login

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

History of ext/fts5/fts5_storage.c

2019-03-20
05:45
Fix various harmless compiler warnings seen with MSVC. file: [b24f6916] check-in: [1c0fe5b5] user: mistachkin branch: noWarnings, size: 32933
2019-01-19
15:55
Avoid a division-by-zero error in fts5 caused by a corrupt database. file: [57e3f2b1] check-in: [928e6221] user: dan branch: trunk, size: 32925
2019-01-08
20:02
Use 64-bit math to compute the sizes of memory allocations in extensions. file: [00db5029] check-in: [ca67f2ec] user: drh branch: trunk, size: 32533
2019-01-05
07:17
Fix two more problems with corrupt database handling in fts5. file: [0455c866] check-in: [444c7c99] user: dan branch: trunk, size: 32512
2018-12-21
19:29
Add new sqlite3_prepare_v3() flag SQLITE_PREPARE_NO_VTAB, for preparing statements that are not allowed to use any virtual tables. Use this to prevent circular references in triggers on virtual table shadow tables from causing resource leaks. file: [5862f1b7] check-in: [25666e3d] user: dan branch: prepare-no-vtab, size: 32445
2018-11-05
23:01
Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. file: [d35ccef4] check-in: [31942b3d] user: drh branch: read-only-shadow, size: 32446
2018-02-07
18:02
In extensions rtree, fts3 and fts5, ensure that when dynamic buffers are bound to persistent SQL statements using SQLITE_STATIC, the binding is replaced with an SQL NULL before the buffer is freed. Otherwise, a user may obtain a pointer to the persistent statement using sqlite3_next_stmt() and attempt to access the freed buffer using sqlite3_expanded_sql() or similar. file: [4bec8a1b] check-in: [2a5f813b] user: dan branch: trunk, size: 32394
2017-06-28
17:29
Instead of the new sqlite3_prepare_v3() interface, provide the SQLITE_DBCONFIG_PREPARE_FLAGS interface which sets the flags on the single next call to sqlite3_prepare_v2() or its cousins. file: [a89dc2eb] check-in: [942c3ef8] user: drh branch: dbconfig-prepare-flags, size: 32378
2017-06-01
00:54
Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. file: [fb5ef3c2] check-in: [4a25c588] user: drh branch: prepare_v3, size: 32320
2017-04-08
09:12
Have fts5 close any open blob-handle when a new savepoint is opened. This ensures that fts5 does not prevent DROP TABLE statements (which always open a savepoint) from succeeding. file: [77509860] check-in: [a921ada8] user: dan branch: trunk, size: 32263
2017-02-27
17:06
Improve performance of fts5 writes by writing the "averages" record once at the end of each transaction instead of every time the table is updated. file: [8f0e65cb] check-in: [2b210d69] user: dan branch: trunk, size: 32302
14:52
Add an sqlite3_set_last_insert_rowid() method. Use it to work around fts4 and fts5 modifying the last-insert-rowid unintuitively from within commit processing. file: [1db0b6f8] check-in: [fe41bb56] user: dan branch: set-last-insert-rowid, size: 32493
2016-07-15
19:17
Add the largely untested SQLITE_FTS5_NO_WITHOUT_ROWID compile time option to fts5. For building a dynamically loadable extension that does not use WITHOUT ROWID. file: [de0ed8a0] check-in: [d0a1cf1c] user: dan branch: trunk, size: 32347
2016-03-26
20:11
Fix a problem with OOM handling when setting an fts5 configuration option. file: [e0aa8509] check-in: [53b80a6d] user: dan branch: fts5, size: 32088
2016-03-23
15:04
Explicitly limit the size of fts5 tokens to 32768 bytes. file: [3309c6a8] check-in: [70fc69ee] user: dan branch: trunk, size: 32289
2016-03-21
15:30
Have fts5 cache the structure of its index in main memory. Use "PRAGMA data_version" to figure out when this cache should be invalidated. file: [98e31290] check-in: [902f2217] user: dan branch: trunk, size: 32159
2016-03-18
00:39
Fix FTS5 so that it works with SQLITE_OMIT_AUTORESET. file: [2a38c6fa] check-in: [b199637d] user: drh branch: trunk, size: 32068
2016-03-16
19:48
Have fts5 cache the decoded structure of fts5 indexes in memory. Use "PRAGMA data_version" to detect stale caches. file: [a3361410] check-in: [33ef2210] user: dan branch: fts5-data-version, size: 32135
2016-02-11
17:01
Handle parser stack overflow when parsing fts5 query expressions. Fix some compiler warnings in fts5 code. file: [f8343db9] check-in: [bc3f7900] user: dan branch: trunk, size: 32044
2016-01-23
18:51
Fix an fts5 problem with using both xPhraseFirst() and xPhraseFirstColumn() within a single statement in detail=col mode. file: [2a1f44de] check-in: [72d53699] user: dan branch: fts5-perf, size: 31969
2016-01-15
19:54
Rationalize some code in fts5_storage.c. Add tests to cover recently added branches in fts5. file: [fb2eaec3] check-in: [3b72df40] user: dan branch: trunk, size: 31974
2016-01-06
19:35
Merge latest trunk changes into this branch. file: [f7b2d330] check-in: [e7dcd013] user: dan branch: fts5-offsets, size: 32884
2015-12-31
18:39
Fix the fts5 integrity-check code so that it works with detail=none tables. file: [771dd0fd] check-in: [3a1df69e] user: dan branch: fts5-offsets, size: 32879
2015-12-28
19:55
Change the name of the offsets=0 option to "detail=column". Have the xInst, xPhraseFirst and other API functions work by parsing the original text for detail=column tables. file: [076a3356] check-in: [228b4d10] user: dan branch: fts5-offsets, size: 32365
2015-12-23
16:42
Fix some harmless gcc compiler warnings. Mostly in fts5, but also two in the core code. file: [57c636d8] check-in: [5d44d4a6] user: dan branch: trunk, size: 31352
2015-12-21
18:45
Fix an fts5 integrity-check problem that affects offsets=0 tables with prefix indexes. file: [14e0bb65] check-in: [609a0bc7] user: dan branch: fts5-offsets, size: 32351
2015-12-17
20:36
Add the "offsets=0" option to fts5, to create a smaller index without term offset information. A few things are currently broken on this branch. file: [0dc37a61] check-in: [40b5bbf0] user: dan branch: fts5-offsets, size: 31940
2015-10-27
20:04
Have contentless and external content fts5 tables ignore "OR REPLACE" conflict handling. file: [9ea3d921] check-in: [a85c2a47] user: dan branch: trunk, size: 31347
2015-10-20
15:49
Initialize variables in the fts5 integrity-check code to avoid compiler warnings. file: [8038a54a] check-in: [e979e2cc] user: dan branch: trunk, size: 31279
2015-10-14
21:08
Tests and minor fixes to improve coverage of FTS5 code. file: [9b301157] check-in: [f4de6d45] user: dan branch: trunk, size: 31271
20:34
Fix harmless compiler warnings. file: [c0232c81] check-in: [1c46c194] user: mistachkin branch: trunk, size: 31525
2015-10-02
20:04
Update fts5 to avoid using a statement journal for UPDATE and DELETE operations that affect at most a single row. file: [df061a5c] check-in: [5c83b9db] user: dan branch: trunk, size: 31515
2015-09-03
14:22
Remove some more code from fts5_index.c by consolidating similar functions. file: [120f7b14] check-in: [59ae30b9] user: dan branch: fts5-incompatible, size: 31629
11:00
Fix the fts5 integrity-check so that it works with columnsize=0 tables. file: [4b883f59] check-in: [11b887b1] user: dan branch: fts5-incompatible, size: 32045
2015-08-29
18:46
Add a test for an fts5 tokenizer that supports synonyms by adding multiple entries to the fts index. file: [c888defb] check-in: [98d07d16] user: dan branch: fts5-incompatible, size: 31765
15:44
Another change to the fts5 tokenizer API. file: [9820e7b5] check-in: [fc718684] user: dan branch: fts5-incompatible, size: 31729
2015-08-28
19:56
Change the fts5 tokenizer API to allow more than one token to occupy a single position within a document. file: [9c263323] check-in: [90b85b42] user: dan branch: fts5-incompatible, size: 31685
2015-07-27
11:43
Minor tweak to the SQL schema used by fts5. file: [22ec9b5d] check-in: [427bf09b] user: dan branch: fts5-btree-index, size: 31444
2015-07-15
19:46
Use a WITHOUT ROWID table to index fts5 btree leaves. This is faster to query and only slightly larger than storing btree nodes within an intkey table. file: [877399c5] check-in: [862418e3] user: dan branch: fts5-btree-index, size: 31374
2015-07-14
17:18
Fix some harmless compiler warnings. file: [1c35a38a] check-in: [3de030c9] user: mistachkin branch: trunk, size: 31244
2015-07-02
15:52
Remove "#ifdef SQLITE_ENABLE_FTS5" from individual fts5 source files. Add a single "#if !defined(SQLITE_CORE) || defined(SQLITE_ENABLE_FTS5)" to fts5.c. file: [4cae85b5] check-in: [7819002e] user: dan branch: trunk, size: 31236
2015-06-26
04:34
Initial changes to get FTS5 working with MSVC. file: [3e672a0d] check-in: [ef2052f8] user: mistachkin branch: fts5Msvc, size: 31294
2015-06-23
15:06
Merge latest trunk changes with this branch. Add tests for columnsize=0. file: [b2fa301f] check-in: [ef44c71a] user: dan branch: fts5, size: 31285
2015-06-10
10:45
Fix the fts5 xRename() method. file: [7e77d1b2] check-in: [0f7fd513] user: dan branch: fts5, size: 31275
2015-06-09
20:58
Add the "columnsize=" option to fts5, similar to fts4's "matchinfo=fts3". file: [684ef957] check-in: [aa12f9d9] user: dan branch: fts5, size: 30285
2015-06-06
16:28
Fix handling of fts5 rowid constraints in the absence of a MATCH clause. Add tests to cover recently added branches. file: [770ab523] check-in: [3a9cb648] user: dan branch: fts5, size: 29224
2015-05-30
11:49
Remove the "#include sqlite3Int.h" from fts5Int.h. file: [04e67176] check-in: [e008c3c8] user: dan branch: fts5, size: 28788
2015-05-18
20:34
Improve test coverage of fts5_storage.c. file: [5d2b51ad] check-in: [4dfe2e58] user: dan branch: fts5, size: 28629
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. file: [cb8b585b] check-in: [a684b5e2] user: dan branch: fts5, size: 28701
2015-04-28
18:35
Improve coverage of fts5 tests. file: [ef60fc9d] check-in: [8e8136f2] user: dan branch: fts5, size: 28386
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. file: [d5c3567b] check-in: [e38e2bb6] user: dan branch: fts5, size: 28444
11:31
Further tests for fts5. file: [87f85986] check-in: [ffeb3ef3] user: dan branch: fts5, size: 28400
2015-04-24
19:41
Add the "unindexed" column option to fts5. file: [b3a4cbbc] check-in: [86309961] user: dan branch: fts5, size: 28289
2015-03-04
08:29
Fix a couple of build problems. file: [ac0f0937] check-in: [a5d5468c] user: dan branch: fts5, size: 28009
2015-01-23
17:43
Fix compression of keys stored on internal segment b-tree nodes by fts5. file: [f7c12c9f] check-in: [51444f67] user: dan branch: fts5, size: 27949
2015-01-21
20:30
Further tests and fixes for fts5. file: [d5672296] check-in: [c020a291] user: dan branch: fts5, size: 27984
2015-01-07
19:33
Add the fts5 'optimize' command. file: [8bc9e5b6] check-in: [e749be56] user: dan branch: fts5, size: 27965
17:11
Add the 'rebuild' and 'delete-all' commands. file: [844b9667] check-in: [0cb2fed5] user: dan branch: fts5, size: 27868
2015-01-06
19:08
Remove the iPos parameter from the tokenizer callback. Fix the "tokenchars" and "separators" options on the simple tokenizer. file: [cd72f283] check-in: [65f0262f] user: dan branch: fts5, size: 25904
14:38
Further fixes and test cases related to external content tables. file: [9b6b8afd] check-in: [ce6a899b] user: dan branch: fts5, size: 25959
2015-01-05
20:41
Tests and fixes for fts5 external content tables. file: [68ce8ec9] check-in: [047aaf83] user: dan branch: fts5, size: 25994
2015-01-03
20:44
Add support for external content tables to fts5. file: [b95fcca7] check-in: [17ef5b59] user: dan branch: fts5, size: 25675
2014-12-23
19:18
Fix the fts5 bm25() function so that it matches the documentation. file: [13794781] check-in: [1ac7a8d0] user: dan branch: fts5, size: 23143
2014-12-03
17:27
Begin testing fts5 OOM and IO error handling. file: [bfeedb83] check-in: [2037dba6] user: dan branch: fts5, size: 22924
2014-11-28
20:01
Add a cookie mechanism to ensure that the %_config table is re-read as required. file: [0198c597] check-in: [bb4a37b5] user: dan branch: fts5, size: 22840
2014-11-27
20:03
Add a %_config table to fts5. file: [c28d1a88] check-in: [83491c56] user: dan branch: fts5, size: 22655
2014-08-12
16:07
Cache the value of the "totals" record in memory during transactions. file: [5913aa01] check-in: [05dfdad4] user: dan branch: fts5, size: 21808
2014-08-09
18:22
Fix an uninitialized variable causing a problem during fts5 table initialization. file: [fa3c8fc4] check-in: [a14fa876] user: dan branch: fts5, size: 20991
2014-07-31
17:47
Try to reuse sorter statements in fts5. Does not work due to circular references on VTable object. file: [7036cf22] check-in: [bc14e64b] user: dan branch: save_sorter_stmt, size: 21663
2014-07-25
20:30
Add extension apis xRowCount, xQueryPhrase, xSetAuxdata and xGetAuxdata. And a ranking function that uses all of the above. file: [2866e7e1] check-in: [c4d50428] user: dan branch: fts5, size: 20979
2014-07-23
19:31
Add a snippet() function to fts5. file: [9a2744f4] check-in: [bdc58fd2] user: dan branch: fts5, size: 20952
2014-07-21
15:45
Fix DELETE and UPDATE operations on fts5 tables. file: [7bb34138] check-in: [d44d3a85] user: dan branch: fts5, size: 19038
11:44
Fix the xColumnSize() extension API. file: [f722b080] check-in: [19504c41] user: dan branch: fts5, size: 18300
2014-07-19
15:35
Fixes for the xColumnSize() fts5 extension API. file: [fcf66173] check-in: [43fcb844] user: dan branch: fts5, size: 15993
2014-06-24
16:59
Add simple full-table-scan and rowid lookup support to fts5. file: [7848d8f8] check-in: [3515da85] user: dan branch: fts5, size: 13409
2014-06-23
11:33
Add some code for an experimental fts5 module. Does not work yet. file: [aa1ff4b6] check-in: [1e0648dc] user: dan branch: fts5, size: 12207 Added