/ Timeline
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

38 check-ins using file src/main.c version f780d73b

New FTS1 test data based on enron emails. (CVS 3421) check-in: 01651a32 user: drh tags: trunk
Remove file containing real email addresses. Ticket #1978. (CVS 3420) check-in: 373a575f user: drh tags: trunk
Minor build fixes. (CVS 3419) check-in: 3564b07c user: adamd tags: trunk
Enhanced I/O error simulation. (CVS 3418) check-in: 86931854 user: drh tags: trunk
The FTS1 tables have a new automatic column named "offset" that returns a string containing byte offset information for all matching terms. Also added a large test case based on SQLite mailing list entries. (CVS 3417) check-in: f25cfa1a user: drh tags: trunk
Modify the ".dump" command in the command-line shell so that it works with virtual tables. (CVS 3416) check-in: afd40184 user: drh tags: trunk
Remove unused malloc failure test. (Ticket #1976) Also include fixes for other problems discovered while investigating ticket #1976. (CVS 3415) check-in: f4ab546b user: drh tags: trunk
In FTS1: Retain the Query structure as part of the cursor. It will be used laster as part of snippet generation. (CVS 3414) check-in: 607d928c user: drh tags: trunk
Earlier refactoring changed name in fts1.c but not fts1.h. (CVS 3413) check-in: d4edb803 user: shess tags: trunk
Minor code cleanup in FTS1. (CVS 3412) check-in: fca59281 user: drh tags: trunk
Implementation of "column:" modifiers in FTS1 queries. (CVS 3411) check-in: 820634f7 user: drh tags: trunk
Module spec parser enhancements for FTS1. Now able to cope with column names in the spec that are SQL keywords or have special characters, etc. Also added support for additional control lines. Column names can be followed by a type specifier (which is ignored.) (CVS 3410) check-in: adb780e0 user: drh tags: trunk
Fix the FTS1 test cases and add new tests. Comments added to the FTS1 code. (CVS 3409) check-in: 528036c8 user: drh tags: trunk
Allow virtual tables to contain multiple full-text-indexed columns. Added a magic column "_all" which can be used for querying all columns in a table at once.    For now, each posting list stores position/offset information for multiple columns. We may implement separate posting lists for separate columns at some future point. (CVS 3408) check-in: 366a70b0 user: adamd tags: trunk
Answer queries for a particular rowid in a full-text table by looking up that rowid directly rather than by performing a table scan. (CVS 3407) check-in: 877d5558 user: adamd tags: trunk
Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) check-in: e4fe736c user: drh tags: trunk
Re-use deleted rowids for new segments. This has a somewhat surprising impact on performance, I believe because it keeps the index smaller (by keeping rowids smaller), and also because it improves locality in the table (deleting a row means we've already touched the pages leading to that rowid). (CVS 3405) check-in: 2f5f6290 user: shess tags: trunk
Get VACUUM working with virtual tables. (CVS 3404) check-in: d5ffef38 user: drh tags: trunk
Add a rudimentary tokenizer and parser to FTS1 for parsing the module arguments during initialization. Recognized arguments include a tokenizer selector and a list of virtual table columns. (CVS 3403) check-in: 227dc3fe user: drh tags: trunk
Add pzErr parameters to the xConnect and xCreate methods of virtual tables in order to provide better error reporting. This is an interface change for virtual tables. Prior virtual table implementations will need to be modified and recompiled. (CVS 3402) check-in: f44b8bae user: drh tags: trunk
Add a new zErrMsg field to the sqlite3_vtab structure to support returning error messages from virtual table constructors. This change means that virtual table implementations compiled as loadable extensions for version 3.3.7 will need to be recompile for version 3.3.8 and will not be usable by both versions at one. The virtual table mechanism is still considered experimental so we feel justified in breaking backwards compatibility in this way. Additional interface changes might occurs in the future. (CVS 3401) check-in: 36693a5c user: drh tags: trunk
Add some simple test cases for the OR and NOT logic of the fts1 module. Fix lots of bugs discovered while developing these test cases. (CVS 3400) check-in: 70bcff02 user: drh tags: trunk
Add support for OR and NOT terms in fts1. (CVS 3399) check-in: ae502657 user: drh tags: trunk
Write doclists using a segmented technique to amortize costs better. New items for a term are merged with the term's segment 0 doclist, until that doclist exceeds CHUNK_MAX. Then the segments are merged in exponential fashion, so that segment 1 contains approximately 2*CHUNK_MAX data, segment 2 4*CHUNK_MAX, and so on. (CVS 3398) check-in: b6b93a33 user: shess tags: trunk
Add HAVE_GMTIME_R and HAVE_LOCALTIME_R flags and use them if defined. Unable to modify the configure script to test for gmtime_r and localtime_r, however, because on my SuSE 10.2 system, autoconf generates a configure script that does not work. Bummer. Ticket #1906 (CVS 3397) check-in: 862302ea user: drh tags: trunk
Bug fix in date/time computations. Ticket #1964. Some unrelated comment typos are also fixed and got accidently checked in at the same time. (CVS 3396) check-in: c81eaa0d user: drh tags: trunk
Improvements to the documentation of the return codes for sqlite3_step(). Tickets #1633, #1366, #1178, #906, and probably others too. (CVS 3395) check-in: 508248e7 user: drh tags: trunk
Include io.h on Windows to quell a build warning about access() having no prototype. (CVS 3394) check-in: b3eb1732 user: adamd tags: trunk
A minor change to fts1.c to fix broken build. (CVS 3393) check-in: 55a03b96 user: adamd tags: trunk
Fix a bug in the new misc6.test script. Fix error messages when not compiled with memory debugging enabled. Ticket #1957. (CVS 3392) check-in: 9fb92024 user: drh tags: trunk
Make sure strings returned by sqlite3_value_text() and sqlite3_value_text16() are always '\000'-terminated. (CVS 3391) check-in: 2c63588b user: drh tags: trunk
Fix bugs in test scripts so that fulltest will pass. (CVS 3390) check-in: 367bd837 user: drh tags: trunk
Changes to the Makefile.in so that MinGW users can build a DLL. Ticket #1955. (CVS 3389) check-in: 7279ddd0 user: drh tags: trunk
Add a TRACE macro to the FTS1 module for troubleshooting. Turned off by default. (CVS 3388) check-in: d4923e98 user: drh tags: trunk
Do not call the xDisconnect method on a virtual table while xUpdate is pending. Instead, defer the xDisconnect until after xUpdate completes. (CVS 3387) check-in: 61148f4c user: drh tags: trunk
Test for busted TCL builds that do not support 64-bit integers and print a warning message to users that test failures may be a result of the bad TCL build and not some problem with SQLite. Ticket #1953. (CVS 3386) check-in: ca864ee9 user: drh tags: trunk
Convert static variables into constants in the FTS module. (CVS 3385) check-in: 098cbafc user: drh tags: trunk
Automatically register the FTS module if it is compiled into the build. (CVS 3384) check-in: 8a96bdb7 user: drh tags: trunk