Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 ancestors of [0f3de2d3]
|
2015-09-16
| ||
| 17:46 | Add a "flush" to force incremental output to releasetest-out.txt while running the test/releasetest.tcl. script. check-in: 0f3de2d3 user: drh tags: trunk | |
| 12:31 | Fix typo in fts5.h. check-in: 07721c6c user: dan tags: trunk | |
|
2015-09-15
| ||
| 14:39 | Add test cases to cover fts5 integrity-check code. check-in: 1d018c35 user: dan tags: trunk | |
| 13:42 | Reformat some code to make it easier to merge with sessions. No logic changes. check-in: eade355f user: drh tags: trunk | |
| 11:58 | Fix a problem with fts5 "ORDER BY rowid DESC" queries and large terms. check-in: b26d8f79 user: dan tags: trunk | |
|
2015-09-14
| ||
| 19:51 | Improve test coverage of fts5_index.c. check-in: c1f76686 user: dan tags: trunk | |
| 19:26 | Testability improvements for the ONEPASS_MULTI enhancement. check-in: d2df93f2 user: drh tags: trunk | |
| 14:49 | Fix a typo in an SQLITE_USER_AUTHENTICATION macro. check-in: 379455af user: drh tags: trunk | |
| 14:45 | Use symbolic names ONEPASS_OFF, ONEPASS_SINGLE, and ONEPASS_MULTI for the various modes of the one-pass optimization. check-in: 16e56bda user: drh tags: trunk | |
| 14:08 | Fix a compiler warning and providing missing VdbeCoverage() calls. check-in: 2edd2e5e user: drh tags: trunk | |
| 11:09 | Use a single-pass approach for DELETE statements on non-virtual tables that do not require trigger or foreign key processing. check-in: 8b93cc59 user: dan tags: trunk | |
| 09:23 | Avoid calling sqlite3VdbeCursorMoveto() from more than one point in vdbe.c. Doing so prevents it from being inlined as part of OP_Column. Closed-Leaf check-in: 166d5af8 user: dan tags: onepass-delete | |
|
2015-09-13
| ||
| 20:15 | Add static VFS mutexes to the primary header file comments. check-in: 9a867d9f user: mistachkin tags: trunk | |
|
2015-09-12
| ||
| 19:50 | Fix compiler warnings in delete.c. check-in: 0a4d285e user: dan tags: onepass-delete | |
| 19:27 | Fix API documentation typos. Emphasize that the sqlite3_config() routine is not threadsafe. check-in: 786333e0 user: drh tags: trunk | |
| 19:26 | Experimental change to use a single-pass approach for DELETE statements on non-virtual tables that do not fire triggers or require foriegn-key processing. check-in: eaeb2b80 user: dan tags: onepass-delete | |
| 18:57 | Import common changes from the mutex initialization branch. check-in: 334720c0 user: mistachkin tags: trunk | |
|
2015-09-11
| ||
| 20:54 | Update evidence marks due to wording changes in requirements text. No changes to code. check-in: 86781093 user: drh tags: trunk | |
| 18:05 | Fix harmless compiler warnings. check-in: bfc7b84b user: mistachkin tags: trunk | |
| 15:32 | More test cases in test/json102.test corresponding to new examples in the json1 documentation. check-in: f599a42e user: drh tags: trunk | |
| 14:15 | Fix some compiler warnings in fts5 code. check-in: 0dc43611 user: dan tags: trunk | |
| 01:22 | Updates to the sqlite3_value_subtype() and sqlite3_result_subtype() documentation and to test cases for json1 dealing with those interfaces. check-in: d6cadbe9 user: drh tags: trunk | |
| 00:26 | Add new interfaces sqlite3_value_subtype() and sqlite3_result_subtype(). Update the json1.c extension to take advantages of those interfaces to avoid the goofy '$$' path syntax and to allow nested calls to json_array() and json_object() that work as expected. check-in: db4152ae user: drh tags: trunk | |
| 00:06 | Take out the goofy '$$' path syntax. Instead, use subtypes to communicate when a string is JSON. Add the json() function that validates and minifies the JSON and sets the appropriate subtype. Closed-Leaf check-in: 8a80d645 user: drh tags: subtypes | |
|
2015-09-10
| ||
| 20:40 | Make the sqlite3_value_subtype() and sqlite3_result_subtype() interfaces available to loadable extensions. check-in: c6fca0be user: drh tags: subtypes | |
| 20:34 | Experimental implementation of sqlite3_result_subtype() and sqlite3_value_subtype() interfaces. check-in: 7b5be299 user: drh tags: subtypes | |
| 19:22 | Fix a potential NULL pointer deref in the testing logic of pcache1. NB: The -DSQLITE_TEST compile-time option is needed to hit the problem. check-in: f5580f08 user: drh tags: trunk | |
| 17:23 | Modify the fts5 leaf page format to permit faster seek operations. This is a file-format change. Any existing databases can be upgraded by running the fts5 'rebuild' command. check-in: 0c0c4ae9 user: dan tags: trunk | |
| 17:20 | Create separate "path" and "root" columns in the json_each() and json_tree() virtual tables. "Root" is the 2nd parameter and is fixed. "Path" varies as json_tree() walks the hierarchy. check-in: 127cce3e user: drh tags: trunk | |
| 16:39 | Increment the fts5 version value to indicate that the on-disk format has changed. Closed-Leaf check-in: 99de5e36 user: dan tags: fts5-incompatible | |
| 16:19 | Fix a segfault in fts5 that could occur if the database contents were corrupt. check-in: 4931e37d user: dan tags: fts5-incompatible | |
| 15:52 | Merge latest changes from trunk. Including fts5_expr.c fixes. check-in: 716e7e74 user: dan tags: fts5-incompatible | |
| 15:49 | Update description of on-disk format in fts5_index.c. check-in: 85aac7b8 user: dan tags: fts5-incompatible | |
| 15:24 | Make the sqlite3ext.h header file responsive to -DSQLITE_OMIT_LOAD_EXTENSION. check-in: 47a46a9f user: drh tags: trunk | |
| 15:22 | Disable tests for json_each() and json_tree() on builds where virtual tables are not supported check-in: bb8ee3b1 user: drh tags: trunk | |
| 15:20 | Fix the --help option on test/releasetest.tcl. Also fix the final error count so that it includes a count of subtest crashes. check-in: 9ecf684d user: drh tags: trunk | |
| 10:40 | Revert an accidentally committed makefile change. check-in: 402704b1 user: dan tags: fts5-incompatible | |
| 10:01 | Fix an fts5 problem that could occur if a term and the first associated rowid are on different leaf pages. check-in: ffe2796a user: dan tags: fts5-incompatible | |
| 05:40 | Change the array of 16-bit offsets at the end of each page to an array of varints. check-in: fab245be user: dan tags: fts5-incompatible | |
| 04:17 | Attempt to declare sqlite3MemoryBarrier() correctly for all possible build configurations. check-in: da8a288f user: drh tags: trunk | |
| 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: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 | |
| 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: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 | |
| 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 | |
| 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 | |