/ 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 fd4da2318cc032d7.

2015-09-04
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
15:44
Another change to the fts5 tokenizer API. check-in: fc718684 user: dan tags: fts5-incompatible
00:54
Change the json1.c module so that it throws an error if any of the JSON selector paths are malformed. check-in: 3aa0855f user: drh tags: trunk
2015-08-28
20:07
Back out the json_check() routine. Instead, throw an error if the input to a json function (other than json_valid()) is not valid JSON. check-in: dc9ce7b1 user: drh tags: trunk
19:56
Change the fts5 tokenizer API to allow more than one token to occupy a single position within a document. check-in: 90b85b42 user: dan tags: fts5-incompatible
16:41
Fix compiler warnings in rbu code. check-in: 0fdc36fe user: dan tags: trunk
16:18
When searching the wal file for a frame, do not search that part that was already checkpointed when the transaction was opened. check-in: a84cf4f5 user: dan tags: trunk
15:50
Merge latest trunk into this branch. Closed-Leaf check-in: ab93024d user: dan tags: wal-read-change
15:35
Fix a potential segfault in the VFS logic that checks for fail renames out from under SQLite. check-in: 650111f6 user: drh tags: apple-osx
13:27
Disable the read-only WAL-mode database tests on the apple-osx branch because read-only WAL-mode databases are specifically disallowed by Apple-specific changes. check-in: bd911496 user: drh tags: apple-osx
09:27
Merge latest trunk changes with this branch. check-in: 57bc0194 user: dan tags: begin-concurrent
03:48
Add the json_check() function, which returns its argument if the argument is well-formed JSON or which throws an error otherwise. check-in: 64abb65d user: drh tags: trunk
03:33
Enhance the json_insert(), json_replace(), and json_set() functions with the ability to add JSON instead of text if the argument is text and if the PATH begins with '$$' instead of just '$'. check-in: 44f103d8 user: drh tags: trunk
02:12
Merge trunk enhancements into the apple-osx branch. Most tests works, but there are yet a few issues to be resolved. check-in: da864658 user: drh tags: apple-osx
2015-08-27
23:42
Fix the OR-optimization so that it always ignores subplans that do not use an index. check-in: cf452028 user: drh tags: index-expr
23:18
Fix the OR-optimization so that it always ignores subplans that do not use an index. check-in: 66f92a16 user: drh tags: trunk
20:33
Fix EXPLAIN QUERY PLAN output for indexed-expressions. Fix another obscure fault in the WHERE term scanner. check-in: 73d361ce user: drh tags: index-expr
19:57
Add header comments for new methods in pager.c. check-in: 437c7e21 user: dan tags: begin-concurrent
19:56
Fix problems in the indexed-expression handling in the optimizer. check-in: 03375017 user: drh tags: index-expr
19:22
Add test cases for concurrent transactions and long-lived SELECT statements. check-in: fd4798cb user: dan tags: begin-concurrent
18:24
Activate the ability to use expressions in indexes in a query. There are some test failures, but mostly this seems to work. check-in: 42f93f58 user: drh tags: index-expr
17:42
Fix a problem whereby concurrent transactions would not consider pages read by the transaction before the first write statement. check-in: fc17f731 user: dan tags: begin-concurrent
16:07
Merge changes from trunk. check-in: c80e9e8e user: drh tags: index-expr
15:58
Adjustments to the WHERE term scanning, to better handle scanning terms of an index. check-in: 5611130a user: drh tags: index-expr
2015-08-26
21:08
Reduce the size of the WhereScan object by 24 bytes while also clarifying its operation. check-in: cbc3c9a8 user: drh tags: trunk
18:54
Fix an assert() in pager.c that could fail in a concurrent transaction. check-in: 69394dda user: dan tags: begin-concurrent
18:04
Merge enhancements from trunk. check-in: ec6ddb3d user: drh tags: index-expr
18:02
Fix a problem allowing some conflicting transactions to be committed. check-in: a0566382 user: dan tags: begin-concurrent
14:01
Evaluate expressions only once when the same expression is used in both the result set and in the ORDER BY clause. check-in: c2f3bbad user: drh tags: trunk
11:40
Refactor With.a.zErr into With.a.zCteErr. No logic changes. check-in: 58ba7363 user: drh tags: trunk
11:34
Update the TreeView output for compound SELECT statements so that all entries are shown vertically aligned rather than each successive entry being indented. check-in: 65a89187 user: drh tags: trunk
2015-08-25
19:42
Move sqlite3IndexColumnAffinity() inside of SQLITE_ENABLE_STAT3_OR_STAT4. check-in: b3732a4e user: drh tags: trunk
19:24
Merge trunk enhancements. check-in: e8b02902 user: drh tags: index-expr
19:20
Use the sqlite3IndexColumnAffinity() routine to quickly and correctly find the affinity of an index column. check-in: 1ee089a7 user: drh tags: trunk
19:10
Add miscellaneous test cases for concurrent transactions. check-in: 779b1d0e user: dan tags: begin-concurrent
17:16
If "PRAGMA integrity_check" is run while the database is being written by a CONCURRENT transaction, do not consider unreferenced pages to be an error. They may be part of the free-page list, which is not visible at the b-tree layer when running a CONCURRENT transaction. check-in: f32b57b4 user: dan tags: begin-concurrent