Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around cd359550bdc2bf7b.
|
2015-09-05
| ||
| 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) | |
| 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) | |