/ File History
Login

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

History of ext/fts5/fts5_main.c

2019-08-20
19:11
Fix a problem with fts5 "ORDER BY rank" queries when the fts5 table name requires quoting. file: [b2c42f1c] check-in: [00e9a8f2] user: dan branch: trunk, size: 86125
2019-08-05
12:55
Prevent an fts5 table from being its own content table, or part of a view that is the content table. file: [346a1ec0] check-in: [b6d52c93] user: dan branch: trunk, size: 86121
2019-04-13
14:07
Fixes for harmless compiler warnings. file: [abd04720] check-in: [c28c973a] user: drh branch: trunk, size: 85969
2019-03-20
05:45
Fix various harmless compiler warnings seen with MSVC. file: [de317d98] check-in: [1c0fe5b5] user: mistachkin branch: noWarnings, size: 85959
2019-02-04
16:25
Fix problems with SAVEPOINT and related commands within transactions on a corrupt database that include fts5 or some other virtual tables. file: [95d63bbe] check-in: [b0da6e0d] user: dan branch: trunk, size: 85943
2019-01-29
15:30
Avoid a crash when the fts5 snippet() function (or similar) is used with a special query pattern, like '*id' or '*reads'. file: [23956584] check-in: [9d58a157] user: dan branch: trunk, size: 85942
2019-01-22
21:17
Fix a buffer overrun that could occur in fts5 if a prefix query is made on a corrupt database. file: [df4ba0a9] check-in: [1abc4415] user: dan branch: trunk, size: 85901
2019-01-17
17:39
Fix problems with joining two or more fts5_vocab tables that access the same underlying fts5 table. file: [4a7ebaa5] check-in: [49956395] user: dan branch: trunk, size: 85741
2019-01-15
15:18
Have fts5 reject attempts to insert a non-integer, non-null value into a rowid column with SQLITE_MISMATCH. file: [55236fb7] check-in: [4a9483f8] user: dan branch: trunk, size: 85726
2019-01-14
15:35
Fix a problem causing a crash if an fts5vocab table was created to query an fts3/4 FTS index. file: [ea863c28] check-in: [9cd64ce4] user: dan branch: trunk, size: 85507
2019-01-08
20:02
Use 64-bit math to compute the sizes of memory allocations in extensions. file: [90062ccf] check-in: [ca67f2ec] user: drh branch: trunk, size: 85481
2018-11-06
14:03
Only allow shadow table to be written from within a recursive SQL call. Omit the SQLITE_PREPARE_SHADOW flag. Some tests are failing because the tests depend on being able to write to shadow tables. file: [287a1a56] check-in: [d890c658] user: drh branch: read-only-shadow, size: 85445
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: [5318b205] check-in: [31942b3d] user: drh branch: read-only-shadow, size: 85496
2018-09-05
17:45
Fix some test script errors. And an incorrect assert() in fts5. file: [7e52868e] check-in: [f804336f] user: dan branch: alter-table-rename-column, size: 85025
2018-09-03
17:11
Ensure that FTS5 queries of the form "WHERE rowid BETWEEN ? AND ? AND tbl MATCH ? ORDER BY rank" do rowid filtering before sorting. file: [2ee492d7] check-in: [f1138a38] user: dan branch: trunk, size: 85024
2018-04-09
14:26
Fix the fts5 xBestIndex method so that it is not confused by "IS", "!=", "REGEXP", "GLOB" or "LIKE" operators. Fix for ticket [2b8aed9f]. file: [da46761a] check-in: [a0ca4ddb] user: dan branch: trunk, size: 84758
2017-07-17
15:38
Improved the interface to the fts5() extension mechanism for enhanced security. file: [24868f88] check-in: [bc78235f] user: drh branch: branch-3.20, size: 84362
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: [c6412f30] check-in: [942c3ef8] user: drh branch: dbconfig-prepare-flags, size: 84542
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: [f32b3b87] check-in: [4a25c588] user: drh branch: prepare_v3, size: 84419
2017-04-13
09:45
Allow a user column name to be used on the LHS of a MATCH operator in FTS5. file: [1ba0e780] check-in: [6f54ffd1] user: dan branch: trunk, size: 84306
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: [24cafdc4] check-in: [a921ada8] user: dan branch: trunk, size: 83816
2016-05-30
08:28
Fix an FTS5 problem (segfault or incorrect query results) with "... MATCH 'x OR y' ORDER BY rank" queries when either token 'x' or 'y' is completely absent from the dataset. file: [f8528144] check-in: [64ca1a83] user: dan branch: trunk, size: 83825
2016-03-26
20:11
Fix a problem with OOM handling when setting an fts5 configuration option. file: [1e1e6e2d] check-in: [53b80a6d] user: dan branch: fts5, size: 84207
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: [b4a0fc5b] check-in: [33ef2210] user: dan branch: fts5-data-version, size: 83867
2016-03-09
20:54
Add an incremental optimize capability to fts5. Make the 'merge' command independent of the 'automerge' settings. file: [b8501e1a] check-in: [55667144] user: dan branch: trunk, size: 83564
2016-02-17
14:48
Remove the "#ifdef SQLITE_TEST" condition from fts5_test_mi.c. Update fts5_main.c so that if SQLITE_FTS5_TEST_MI is defined when it is built the fts5_test_mi.c entry point is automatically called. This makes it easier to build versions of fts5 that include the matchinfo() demo by default. file: [db24ac71] check-in: [87e6e225] user: dan branch: trunk, size: 83588
2016-02-11
17:01
Handle parser stack overflow when parsing fts5 query expressions. Fix some compiler warnings in fts5 code. file: [0e01ead4] check-in: [bc3f7900] user: dan branch: trunk, size: 83214
2016-02-05
19:18
Further streamlining of fts5 prefix query code. file: [6e23df90] check-in: [ca91bd8a] user: dan branch: trunk, size: 82691
2016-02-01
20:12
Improve performance of fts5 queries. file: [7e8a5f27] check-in: [2334e882] user: dan branch: trunk, size: 82679
2016-01-23
18:51
Fix an fts5 problem with using both xPhraseFirst() and xPhraseFirstColumn() within a single statement in detail=col mode. file: [3886bbfc] check-in: [72d53699] user: dan branch: fts5-perf, size: 82645
2016-01-16
18:58
Add further tests for fts5. Fix some problems with detail=col mode and auxiliary functions. file: [833db0a3] check-in: [de77d602] user: dan branch: trunk, size: 82655
2016-01-15
19:54
Rationalize some code in fts5_storage.c. Add tests to cover recently added branches in fts5. file: [1d116f5c] check-in: [3b72df40] user: dan branch: trunk, size: 82487
2016-01-14
14:15
Fix compiler warnings in fts5. file: [488ceecd] check-in: [5a343cc0] user: dan branch: trunk, size: 82439
2016-01-06
19:35
Merge latest trunk changes into this branch. file: [03bd44e4] check-in: [e7dcd013] user: dan branch: fts5-offsets, size: 82592
2016-01-05
21:04
Rationalize and extend some fts5 test code. Fix bugs revealed by the same. file: [cd5f6f0b] check-in: [fd217fdb] user: dan branch: fts5-offsets, size: 82622
2016-01-04
19:12
Fix an OOM handling problem in fts5 detail=none and detail=col modes. Also a bug in the xInst() API when used with detail=col and column filtering expressions. Update the matchinfo() test function so that 'b' is fast with detail=col tables. file: [15c8b702] check-in: [ee38f9df] user: dan branch: fts5-offsets, size: 82538
2016-01-02
19:01
Changes to run many fts5 tests with detail=none and detail=col tables as well as the default detail=full. Also fixes for the bugs uncovered by running said tests. file: [f33439bd] check-in: [6322a1d9] user: dan branch: fts5-offsets, size: 82243
2015-12-29
19:35
Add the xPhraseFirstColumn() and xPhraseNextColumn() API functions to fts5. For iterating through the set of columns that contain intances of a phrase. file: [23f3912f] check-in: [8c30605b] user: dan branch: fts5-offsets, size: 81262
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: [a71db659] check-in: [228b4d10] user: dan branch: fts5-offsets, size: 79910
2015-12-23
16:42
Fix some harmless gcc compiler warnings. Mostly in fts5, but also two in the core code. file: [e11b5257] check-in: [5d44d4a6] user: dan branch: trunk, size: 78452
2015-12-22
18:54
Updates so that fts5 API functions xInst, xPhraseFirst and xPhraseNext work with the offsets=0 option. file: [b7d6540c] check-in: [69bffc16] user: dan branch: fts5-offsets, size: 78966
2015-12-16
23:30
Fix even more harmless compiler warnings. file: [ef046999] check-in: [1d0e6aa1] user: mistachkin branch: msvcWarn, size: 78482
2015-11-07
01:33
Merge recent enhancements and bug fixes from trunk. file: [7581280e] check-in: [78bc42e6] user: drh branch: sessions, size: 78467
2015-11-06
12:50
Have fts5 load its configuration from the xConnect() method is invoked. This ensures that the very first query run uses the correct value of the 'rank' option. file: [0569cd9f] check-in: [33e6606f] user: dan branch: trunk, size: 78481
2015-10-27
20:04
Have contentless and external content fts5 tables ignore "OR REPLACE" conflict handling. file: [39358d3d] check-in: [a85c2a47] user: dan branch: trunk, size: 77744
2015-10-17
19:49
Handle equality and range constraints on the "term" column of fts5vocab tables. Also have the same module report columns using names instead of indexes. file: [520a2913] check-in: [6020d96a] user: dan branch: trunk, size: 77656
2015-10-14
21:08
Tests and minor fixes to improve coverage of FTS5 code. file: [d3fde32e] check-in: [f4de6d45] user: dan branch: trunk, size: 77511
2015-10-12
19:12
Further tweaks to improve fts5 prefix query performance. file: [bf43550b] check-in: [1c20c1c2] user: dan branch: trunk, size: 77481
2015-10-10
15:57
Remove another instance of strcpy() from FTS5, to mollify OpenBSD. file: [36fa4fe8] check-in: [35e6248a] user: drh branch: trunk, size: 77485
15:11
Omit the use of strcpy() in FTS5 since OpenBSD hates strcpy(). file: [83315036] check-in: [bc24a5bb] user: drh branch: trunk, size: 77380
2015-10-09
11:09
Makefile and fts5 changes so that fts5 works with main.mk. Still does not work with Makefile.in. file: [5125711e] check-in: [6ebac32d] user: dan branch: amalg-json1-fts5, size: 77271
2015-10-08
20:40
Fix further fts5 compilation issues. file: [d159079e] check-in: [0d7f301f] user: dan branch: amalg-json1-fts5, size: 76799
20:11
Fix a couple of errors in fts5 compilation. This branch still does not build with -Wall -Werror. file: [77721fed] check-in: [e9e76e12] user: dan branch: amalg-json1-fts5, size: 76772
19:29
First attempt to add json1 and fts5 to the amalgamation. This check-in does not compile. file: [1ae4d7ec] check-in: [d820a1bd] user: drh branch: amalg-json1-fts5, size: 76770
2015-10-07
17:06
Fix harmless compiler warning in FTS5. file: [aa968289] check-in: [13adcd03] user: mistachkin branch: trunk, size: 76610
2015-10-03
15:38
Update fts5 to support the table function syntax. "... FROM fts5_tbl WHERE fts5_tbl MATCH ?1 AND rank MATCH ?1" can now be written "FROM fts5_tbl(?1, ?2)". file: [fe5243d6] check-in: [41d17d9e] user: dan branch: trunk, size: 76630
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: [fd9ab880] check-in: [5c83b9db] user: dan branch: trunk, size: 76502
2015-09-17
09:48
Fix a crash in FTS5 caused by specifying NULL as the rhs of a MATCH operator. file: [53116cff] check-in: [e8ed62f8] user: dan branch: trunk, size: 73765
2015-09-11
14:15
Fix some compiler warnings in fts5 code. file: [3fa906f6] check-in: [0dc43611] user: dan branch: trunk, size: 73734
2015-09-09
08:15
Fix a bug in preprocessor macros within fts5_main.c. file: [4b04c934] check-in: [0eb2b952] user: dan branch: fts5-incompatible, size: 73697
2015-09-08
19:55
Remove the 0x00 terminators from the end of fts5 doclists stored on disk. file: [3ec19f23] check-in: [00d99006] user: dan branch: fts5-incompatible, size: 73696
2015-09-02
08:22
Fix a problem with fts5 synonyms and the xQueryPhrase() auxiliary function API. file: [e9d08924] check-in: [cf3e45e7] user: dan branch: fts5-incompatible, size: 73564
2015-08-29
15:44
Another change to the fts5 tokenizer API. file: [b00834ac] check-in: [fc718684] user: dan branch: fts5-incompatible, size: 73563
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: [7afdb84a] check-in: [90b85b42] user: dan branch: fts5-incompatible, size: 73515
2015-08-12
15:36
Minor optimization for fts5 API xInst(). file: [fc47ad73] check-in: [efb7c9c5] user: dan branch: trunk, size: 73424
12:11
Add the xPhraseFirst() and xPhraseNext() fts5 APIs, for faster iteration through a single phrases position list. Also optimize xInst() and xInstCount() a bit. file: [c5ff6eb7] check-in: [f7682435] user: dan branch: trunk, size: 73446
2015-08-05
19:35
Add tests for the matchinfo-like test function. Fix problems found in test and fts5 code by doing so. file: [4c8af001] check-in: [9e3aafe4] user: dan branch: trunk, size: 72272
07:43
Remove all references to "docid" within fts5 source code and comments. Replace with "rowid". file: [dbf7a80c] check-in: [dffd358f] user: dan branch: trunk, size: 71911
2015-07-31
17:48
Remove a duplicate "typedef struct Fts5Global Fts5Global;" from fts5_main.c (duplicate is in fts5Int.h). file: [4518fa10] check-in: [54a771fe] user: dan branch: trunk, size: 71911
2015-07-16
20:17
Fix compiler warnings in fts5 code. file: [0de7ba81] check-in: [e9bf275c] user: dan branch: trunk, size: 71949
2015-07-14
17:18
Fix some harmless compiler warnings. file: [8f279999] check-in: [3de030c9] user: mistachkin branch: trunk, size: 71945
2015-07-09
20:46
Improve the performance of docid merges in fts5. file: [2e43726b] check-in: [b2de77a0] user: dan branch: trunk, size: 71933
2015-07-03
19:13
Speed up eof checks on fts5 cursors. file: [37b0055c] check-in: [3df4af5d] user: dan branch: trunk, size: 72200
17:14
Avoid freeing the array of instance matches each time the fts5 xNext() method is called. file: [f35f445d] check-in: [b9b0c1e5] user: dan branch: trunk, size: 72108
2015-07-02
18:16
Add fts5_source_id() SQL function, similar to sqlite_source_id(). file: [3390a455] check-in: [ec257348] user: dan branch: trunk, size: 71986
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: [c24ee96e] check-in: [7819002e] user: dan branch: trunk, size: 71476
2015-06-26
04:34
Initial changes to get FTS5 working with MSVC. file: [c5b2a219] check-in: [ef2052f8] user: mistachkin branch: fts5Msvc, size: 71361
2015-06-25
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. file: [35e90d3d] check-in: [46e86b06] user: dan branch: fts5, size: 71362 Renamed from ext/fts5/fts5.c