/ Timeline
Login
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.

100 check-ins occurring around 25ee3000e94d60d8.

2015-09-10
03:29
Fix the json_tree() scan for the case when a path is supplied. Add new json1 test cases. check-in: 6adc7de7 user: drh tags: trunk
01:22
No-op the sqlite3_memory_alarm() interface in a different way, that does not break legacy memory behavior. This is a re-do of check-in [5d3f5df4da9f40d5]. check-in: 8250e2a4 user: drh tags: trunk
2015-09-09
23:54
Fix harmless compiler warning in FTS5. check-in: 86146a73 user: mistachkin tags: trunk
19:44
Fix an assert() enabled by SQLITE_ENABLE_EXPENSIVE_ASSERT in wal.c. check-in: 8d2ed150 user: dan tags: trunk
19:27
Fix a possible NULL pointer deref when using SQLITE_ENABLE_MEMORY_MANAGEMENT. check-in: 89bfdbfe user: drh tags: trunk
17:23
Fix harmless compiler warning. check-in: 280fd3a4 user: mistachkin tags: trunk
17:17
Fix harmless compiler warnings in FTS5. check-in: 2cdb1877 user: mistachkin tags: trunk
13:28
When running a CREATE TABLE AS, make the initial temporary sqlite_master entry for the new table a real record rather than a NULL, in case the query after the AS actually tries to read the sqlite_master table. Fix for ticket [acd12990885d9276]. check-in: 4a18d8bd user: drh tags: trunk
08:15
Fix a bug in preprocessor macros within fts5_main.c. check-in: 0eb2b952 user: dan tags: fts5-incompatible
2015-09-08
21:16
Remove an unused local variable from Lemon. check-in: fe9ffe5e user: drh tags: trunk
21:12
Enhance the DBSTAT virtual table with a new hidden table "schema" that if set will cause the table to report on the specified schema rather than on "main". Also: Fix a faulty assert in sqlite3_context_db_handle(). check-in: 6beb512c user: drh tags: trunk
20:26
Eponymous virtual tables exist in the "main" schema only. Enforce this rule. check-in: 06f90bb2 user: drh tags: trunk
19:55
Remove the 0x00 terminators from the end of fts5 doclists stored on disk. check-in: 00d99006 user: dan tags: fts5-incompatible
17:31
Fix the help message that sqlite3_analyzer.exe generates for invalid arguments. check-in: 33a14e7b user: drh tags: trunk
2015-09-07
23:40
Minor tweaks to Lemon. check-in: 98667722 user: drh tags: trunk
20:22
Merge parser enhancements and other improvements and bug fixes from trunk. check-in: 9cf3e51b user: drh tags: begin-concurrent
20:11
Enhance the Lemon parser generator to add SHIFTREDUCE states that reduce the sizes of some of the parser tables. check-in: 99b992fa user: drh tags: trunk
20:02
Fix an unreachable branch in the new parse automaton. Closed-Leaf check-in: e9d604b4 user: drh tags: lemon-update
19:52
Change the parser engine so that it (once again) waits for a lookahead token before reducing, even in a SHIFTREDUCE action. check-in: 2c17a135 user: drh tags: lemon-update
18:23
For the Lemon-generated parser, add a new action type SHIFTREDUCE and use it to further compress the parser tables and improve parser performance. check-in: 531c3974 user: drh tags: lemon-update
14:22
In the "parse.out" output file from Lemon, show addition the complete text of rules on reduce actions. check-in: b6ffb7e4 user: drh tags: trunk
08:14
Use macros to make the code in fts5_index.c easier to read. check-in: 67ff5ae8 user: dan tags: fts5-incompatible
02:23
Improved "Parser Statistics" output (the -s option) for the Lemon parser generator. check-in: 809503e4 user: drh tags: trunk
2015-09-06
10:31
Improved memory barrier that should work with MinGW on older versions of Windows. check-in: 47dc24bd user: drh tags: trunk
02:51
Add a memory barrier to the mutex initialization logic, try to work around an issue reported by WebKit. check-in: 11a9a786 user: drh tags: trunk
2015-09-05
22:36
Omit all use of Expr nodes for TK_AS, as those nodes no longer served a useful purpose and in fact interferred with the query planner. check-in: 7ab0b258 user: drh tags: trunk
19:52
Experiment with a different fts5 leaf page format that allows faster seeks. check-in: a1f4c3b5 user: dan tags: fts5-incompatible
19:21
Fix an unreachable conditional in the WHERE clause analysis logic. check-in: 24924a58 user: drh tags: trunk
19:07
Get STAT4 range scan estimates work again when the bounds are determined by date/time functions. check-in: d2761357 user: drh tags: trunk
2015-09-04
18:03
Fix over-length source code lines in Lemon. check-in: 1efece95 user: drh tags: trunk
17:32
Add support for CREATE INDEX statements that use deterministic expressions rather than only column names. check-in: 2131a5ca user: drh tags: trunk
17:22
Merge the latest trunk changes, and especially the fix for allowing strings as identifiers in CREATE INDEX statements. check-in: a9b84885 user: drh tags: begin-concurrent
16:39
Remove the EXCLUSIVE and CONCURRENT tokens from the tokenizer. Let the BEGIN statement be followed by an ID, but throw a syntax error if the ID is anything other than EXCLUSIVE or CONCURRENT. check-in: c0bf92ec user: drh tags: begin-concurrent
13:02
Merge trunk enhancements, and espeically the fix for allowing strings as column identifers in CREATE INDEX statements. Closed-Leaf check-in: 5ff85529 user: drh tags: index-expr
12:54
Continue to support the (broken) legacy syntax of allowing strings for column names in CREATE INDEX statements and in UNIQUE and PRIMARY KEY constraints. check-in: 3d3df79b user: drh tags: trunk
11:13
Enhance showfts5.tcl so that it can optionally display the number of terms in each segment. check-in: d648ddd9 user: dan tags: trunk
10:31
Modify the fts5 custom tokenizer interface to permit synonym support. The fts5_api.iVersion value is now set to 2. Existing fts5 custom tokenizers (if there are such things) will need to be updated to use the new api version. check-in: 0b7e4ab8 user: dan tags: trunk
10:24
Merge latest trunk changes. Closed-Leaf check-in: 443a5eb8 user: dan tags: fts5-incompatible
04:31
Simplification of the LRU list handling in pcache1. check-in: 05a3a2cd user: drh tags: trunk
2015-09-03
20:52
Merge performance enhancements from trunk. This branch now runs (slightly) faster than the 3.8.11.1 release, though still slightly slower than trunk. check-in: c490bfb1 user: drh tags: begin-concurrent
20:43
Change the pcache module to keep track of the total number of references to all pages rather than the number of pages references, for a performance improvement and size reduction. check-in: f00a9e1e user: drh tags: trunk
19:48
Rearrange code in fts5_expr.c so that synonym support does not slow down the common case. check-in: 80188281 user: dan tags: fts5-incompatible
18:57
Merge enhancements from trunk. check-in: 4b49fe99 user: dan tags: fts5-incompatible
18:20
A simple optimization and size reduction in sqlite3PagerAcquire(). check-in: 618d8dd4 user: drh tags: trunk
18:05
Add documentation for fts5 synonym support. check-in: 58aa1f43 user: dan tags: fts5-incompatible
17:54
Change the Pager.hasBeenUsed flag into Pager.hasHeldSharedLock in order to take it off the critical path in sqlite3PagerAcquire(). check-in: b79096be user: drh tags: trunk
15:37
Add tests to improve coverage of fts5_varint.c. check-in: 89f24f31 user: dan tags: fts5-incompatible
15:17
Changes from ENABLE_CONCURRENT (default off) to OMIT_CONCURRENT (default on). This is not a clear-cut decision and might be changed back. check-in: f8ae9bfd user: drh tags: begin-concurrent
14:48
Merge recent trunk enhancements. check-in: 6a513c05 user: drh tags: sessions
14:39
Merge enhancements from trunk. check-in: 25ee3000 user: drh tags: cursor-hints
14:31
Merge enhancements from trunk. check-in: d01658ad user: drh tags: apple-osx
14:22
Remove some more code from fts5_index.c by consolidating similar functions. check-in: 59ae30b9 user: dan tags: fts5-incompatible
14:18
Merge enhancements from trunk. check-in: 1ab10cbf user: drh tags: index-expr
14:04
Merge trunk optimizations. check-in: 71e7299e user: drh tags: begin-concurrent
13:46
Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to help with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). check-in: 847387ec user: drh tags: trunk
11:17
Remove dead code from fts5_index.c. check-in: 8a0a9b01 user: dan tags: fts5-incompatible
11:00
Fix the fts5 integrity-check so that it works with columnsize=0 tables. check-in: 11b887b1 user: dan tags: fts5-incompatible
10:27
Fix a memory leak in fts5_expr.c. check-in: 399932a1 user: dan tags: fts5-incompatible
04:28
Factor out and simplify code in pragma.c for pragmas that return a single row with a single column that is an integer or text value. check-in: d7f4bdf5 user: drh tags: trunk
03:29
For PRAGMAs, factor out the code that sets the result set column names into a subroutine. check-in: 0ea6e5c9 user: drh tags: trunk
2015-09-02
21:00
Optimizations to the printf formatter. check-in: a3b35dde user: drh tags: trunk
19:48
Further tests to raise coverage of fts5 synonym code to 100%. Fix a dropped error code in the same. check-in: bdedd838 user: dan tags: fts5-incompatible
18:56
Fix an issue with fts5 synonyms and NEAR(...) queries. check-in: f2e59070 user: dan tags: fts5-incompatible
18:40
Add and use the sqlite3VdbeChangeOpcode() routine. Simplify the implementation of the other sqlite3VdbeChange*() routines. check-in: 0a5b00e4 user: drh tags: trunk
18:19
Add the sqlite3VdbeAddGoto(v,i) routine as a shorthand for sqlite3VdbeAddOp2(v,OP_Goto,0,i). check-in: be78f413 user: drh tags: trunk
17:55
Change sqlite3_sql() so that it always returns the SQL text of the prepared statement, if the text is available, even if the the prepared statement was generated using sqlite3_prepare() instead of sqlite3_prepare_v2(). Also include some minor comment fixes and code simplifications. check-in: 2f5472cf user: drh tags: trunk
17:34
Fix a problem with fts5 synonyms and phrase queries. Also fix an OOM handling bug in fts5. check-in: a4c35fa2 user: dan tags: fts5-incompatible
16:51
Small simplification to the EXPLAIN QUERY PLAN logic. check-in: d1592d20 user: drh tags: trunk
15:37
Use sqlite3XPrintf() instead of sqlite3StrAccumAppend() in a few places for better performance and a smaller footprint. check-in: 82355e41 user: drh tags: trunk
14:56
The sqlite3_memory_alarm() interface has been deprecated and undocumented for almost 8 years (since version 3.5.3). Change it into a no-op. check-in: 5d3f5df4 user: drh tags: trunk
14:17
Fix a problem handling OOM conditions within fts5 queries that feature synonyms. check-in: 11fa9808 user: dan tags: fts5-incompatible
12:52
This change is not correct for the boundary case of nCellKey==0. Was: Small performance gain and size reduction in sqlite3VdbeIdxKeyCompare(). Closed-Leaf check-in: 6e0298cd user: drh tags: mistake
08:22
Fix a problem with fts5 synonyms and the xQueryPhrase() auxiliary function API. check-in: cf3e45e7 user: dan tags: fts5-incompatible
2015-09-01
23:51
Very minor optimizations in the unix VFS. check-in: 6db3ff45 user: drh tags: trunk
22:29
Performance improvement in sqlite3VarintLen(). check-in: adf9fefb user: drh tags: trunk
20:09
Small size reduction and performance increase in sqlite3DbMallocSize(). check-in: 8a80967f user: drh tags: trunk
19:51
Reduce the number of calls to sqlite3BeginBenignMalloc(). check-in: 0bee6583 user: drh tags: trunk
18:52
Merge recent enhancements from trunk. check-in: cb772366 user: drh tags: sessions
18:44
Fix a problem that occurs when more than 4 synonyms for a term appear within a single row. check-in: cd359550 user: dan tags: fts5-incompatible
18:40
Merge the latest trunk enhancements. check-in: 4af79477 user: drh tags: apple-osx
18:31
Merge enhancements from trunk. check-in: 29570a60 user: drh tags: cursor-hints
18:08
Add tests for fts5 synonyms implemented by adding extra terms to queries. And fixes for the same. check-in: dbcb7380 user: dan tags: fts5-incompatible
18:01
Merge the latest trunk enhancements. check-in: 3dea0474 user: drh tags: begin-concurrent
17:48
Fixes so that it builds without warnings both with and without SQLITE_ENABLE_CONCURRENT. check-in: 5ed2a445 user: drh tags: begin-concurrent
13:17
Rename SQLITE_FUNC_VARYING to SQLITE_FUNC_SLOCHNG - a more descriptive name for what that bit means. check-in: ff5137a6 user: drh tags: index-expr
00:42
Remove unreachable branches. check-in: fd4da231 user: drh tags: index-expr
2015-08-31
23:09
Fix a bug in error reporting when a UNIQUE index on expressions fails its uniqueness test. check-in: 5a2c0e90 user: drh tags: index-expr
21:16
Not only date/time functions, but also functions like sqlite_version() and changes() need to be prohibited from use inside of indexes. check-in: 48713130 user: drh tags: index-expr
20:06
Begin changes to allow synonym support by adding multiple terms to a query (an alternative to adding multiple terms to the FTS index). check-in: ad7feaed user: dan tags: fts5-incompatible
19:38
Always assume that indexed expressions can generate a NULL. Get indexed expressions working for the case of two or more expressions in the same index. check-in: cc60321a user: drh tags: index-expr
18:13
Case should not be significant when comparing function names. check-in: e2f1caf1 user: drh tags: index-expr
17:34
Make the distinction between truly deterministic functions and date/time functions which only return the same answer for a single query. Only truly deterministic functions are allowed in indexes. Add new expression index test cases. check-in: c77554b5 user: drh tags: index-expr
15:58
Improved analysis and usage of indexed expressions in the query planner. check-in: f8893696 user: drh tags: index-expr
14:27
Merge the latest enhancements from trunk. check-in: 7bde6d4d user: drh tags: index-expr
2015-08-29
19:41
Enhance the json_extract() function so that if given multiple PATH arguments it will return a JSON array with all of the answers. Also update comments within the json1 extension to reflect stricter interpretation of JSON and PATH arguments. check-in: 1da60c3d user: drh tags: trunk
19:03
Link the json1 extension into the command-line shell by default. check-in: 2e8e239c user: drh tags: trunk
18:46
Add a test for an fts5 tokenizer that supports synonyms by adding multiple entries to the fts index. check-in: 98d07d16 user: dan tags: fts5-incompatible
18:30
New test cases for the json1 extension. check-in: daff4832 user: drh tags: trunk
17:22
Fix the build with -DSQLITE_OMIT_VIRTUALTABLE. check-in: 752918de user: drh tags: trunk
16:02
Do not consider an empty string to be valid JSON. Add some additional JSON test cases. check-in: fd19ff02 user: drh tags: trunk