Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
145 check-ins for the month beginning 2015-09-01 by user drh
Following month ↑
2015-09-30
| ||
14:50 | Merge recent enhancements from trunk, and especially the fix for ticket [1b266395d6bc10]. check-in: b2face9a user: drh tags: sessions | |
14:30 | Add a corrupt database to test/fuzzdata3.db to validate the previous check-in. check-in: e796c0ef user: drh tags: trunk | |
14:19 | Fix an assert() in btree.c that is only true for non-corrupt databases. check-in: 29f7227f user: drh tags: trunk | |
2015-09-29
| ||
17:51 |
This condition was not always true after all.....
Change an always-true condition in the virtual table transaction interface into an assert(). Closed-Leaf check-in: 3e15dea5 user: drh tags: mistake | |
17:20 | Use symbolic names XN_ROWID and XN_EXPR in place of the (-1) and (-2) magic numbers in Index.aiColumn[]. Add asserts to help verify that Index.aiColumn[] is always used correctly. Fix one place in FK processing where Index.aiColumn[] was not being used correctly. check-in: 7d272aa6 user: drh tags: trunk | |
15:50 | Remove dead code, replacing with assert() statements that make sure the code really was dead. Closed-Leaf check-in: 0e317dda user: drh tags: vtab-onepass | |
13:25 | Create the sqlite3IsToplevel(Parse*) interface to check to see if a top-level VDBE is being coded (versus a trigger) and use that interface. check-in: 59662cd2 user: drh tags: vtab-onepass | |
12:32 | Fix compiler warnings. check-in: d1a07838 user: drh tags: vtab-onepass | |
2015-09-28
| ||
23:45 | Avoid unnecessary cursors and seeking when running a DELETE against a WITHOUT ROWID table. Leaf check-in: 70ec88b2 user: drh tags: delete-without-rowid-opt | |
17:05 | Extra information provided by .wheretrace on input flags to the query planner and on the result of sqlite3WhereOkOnePass(). check-in: c5566bb3 user: drh tags: trunk | |
15:08 | Add test cases to the ONEPASS optimization corruption problem fixed by the previous check-in. check-in: 5c14d447 user: drh tags: trunk | |
14:40 | Fix a database corruption bug caused by the ONEPASS optimization added in check-in [8b93cc5937000535]. Bug detected (prior to release) by sqllogictest. Test cases to follow. check-in: 9d057f52 user: drh tags: trunk | |
2015-09-26
| ||
17:44 | Enable adding JSON1 by appending the json1.c source file to the amalgamation and compiling with -DSQLITE_ENABLE_JSON1 check-in: 33404b20 user: drh tags: trunk | |
11:15 | Fix a memory leak that can occur following a syntax error in CREATE VIEW. check-in: f4704035 user: drh tags: trunk | |
03:31 | Fix the title of the documentation on sqlite3_value_subtype(). This is a comment change only. check-in: b7902354 user: drh tags: trunk | |
03:23 | Expand the header comment to clarify the purpose for the sqlite3MemoryBarrier() function. check-in: b89495ae user: drh tags: trunk | |
01:28 | Remove an assert in the windows worker-thread logic that can fail in a race condition. check-in: d7bfb960 user: drh tags: trunk | |
2015-09-25
| ||
23:40 | Fix threads.c so that setting sqlite3FaultSim(200) using the SQLITE_TESTCTRL_FAULT_INSTALL callback causes both unix and windows worker threads to be sequential and deterministic, so that they can be tested reliably. check-in: 2d867c05 user: drh tags: trunk | |
20:49 | Fix PRAGMA integrity_check so that it works with a UNIQUE index over expressions. check-in: 113181ce user: drh tags: trunk | |
20:18 | Fix a faulty assert() on the benign-malloc controller callback in test_malloc.c. Leaf check-in: 64f2cb8d user: drh tags: malloc-testing | |
16:29 | Disable the SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS mechanism and replace it with SQLITE_TESTCTRL_BENIGN_MALLOC_CTRL, which gives better control. check-in: 2c57b2f3 user: drh tags: malloc-testing | |
13:42 | Report an error if the number of named columns in a VIEW is different from the number of result columns in the SELECT statement that implements the VIEW. check-in: 6e4ac0be user: drh tags: trunk | |
01:09 | Fix a problem computing affinities for indexes during skip-scan code generation when SQLITE_ENABLE_STAT4 is on. Bug introduced by check-in [1ee089a72d789002]. check-in: 1350dd42 user: drh tags: trunk | |
2015-09-24
| ||
18:47 | Enhance the query planner so that it is able to use indexed expressions to help fulfill an ORDER BY clause. check-in: 668fc1eb user: drh tags: trunk | |
17:38 | Fix over-length source code lines in where.c. No logic changes. check-in: 1c8c5380 user: drh tags: trunk | |
15:17 | Merge all recent trunk enhancements and fixes into the begin-concurrent branch. check-in: c63c1e15 user: drh tags: begin-concurrent | |
15:06 | Merge trunk changes into the cursor-hints branch. check-in: fbe63762 user: drh tags: cursor-hints | |
14:43 | Merge recent trunk enhancements into the apple-osx branch. check-in: 4dd06d8b user: drh tags: apple-osx | |
14:26 | Merge all the latest trunk enhancements into the sessions branch. check-in: c91065f8 user: drh tags: sessions | |
12:40 | Strengthen the implementations of xShmMemoryBarrier on both the unix and windows VFSes, so that they likely work even if SQLITE_THREADSAFE=0 is used. check-in: c6ab807b user: drh tags: trunk | |
12:19 | Make sure joins work correctly when both sides of the join are connected using indexed expressions. check-in: c2fcb032 user: drh tags: trunk | |
11:26 | Correctly handle the case of a WHERE-clause term with indexed expressions on both sides of the == sign. check-in: d9b716a6 user: drh tags: trunk | |
11:06 | Fix a JSON1 test case so that it works on builds that omit virtual tables. check-in: a4444c0f user: drh tags: trunk | |
01:40 | Another (smaller) performance optimization for the JSON parser. check-in: c43daa8c user: drh tags: trunk | |
01:06 | Performance optimizations on the JSON parser. check-in: 7dd4b07a user: drh tags: trunk | |
2015-09-23
| ||
19:17 | Take care that the number of reserved bits per page is consistent between the source and destination databases when doing the back-copy on a VACUUM. check-in: 5b61b72f user: drh tags: trunk | |
11:59 | Capture AFL-generated fuzz tests for json1.c into the test/fuzzdata4.db file. check-in: 10a214fd user: drh tags: trunk | |
01:10 | Do not allow a comma at the end of a JSON array or object. check-in: 7c7a3f3e user: drh tags: trunk | |
2015-09-22
| ||
18:51 | Add the --export-sql and --export-db options to the fuzzcheck utility program. check-in: 760af445 user: drh tags: trunk | |
17:46 | Fix a typo in the --help screen of the fuzzcheck utility. check-in: b6ae61fe user: drh tags: trunk | |
01:15 | Futher simplifications to json1.c. Also an obscure bug-fix in the initial output of json_tree() when using a path to an object contained within an array. check-in: fcb1e327 user: drh tags: trunk | |
00:21 | Fix json_set() so that it can overwrite a value that was previously overwritten during the same call. check-in: 0f160416 user: drh tags: trunk | |
2015-09-21
| ||
22:53 | Simplifications to the json1.c logic. check-in: 1646a2bd user: drh tags: trunk | |
2015-09-20
| ||
22:57 | Fix an overly-strict assert() in the btree logic. check-in: 825ce320 user: drh tags: trunk | |
2015-09-19
| ||
20:27 | Do not allow table-valued function syntax to be used on a view. check-in: 97cfe346 user: drh tags: trunk | |
19:36 | Add the --disable-lookaside option to the fuzzershell utility program. check-in: 0b043744 user: drh tags: trunk | |
18:54 | Fix a memory leak in json1.c that could occur after misuse of json_object(). check-in: 394b81b1 user: drh tags: trunk | |
18:08 | Fix compiler warnings. check-in: 5c31ee62 user: drh tags: trunk | |
16:51 | Add json1.c to the fuzzer test shells. check-in: 809d67b6 user: drh tags: trunk | |
16:45 | Adjust Makefiles to use SQLITE_CORE when statically linking json1.c into test shells. Closed-Leaf check-in: 91682ac3 user: drh tags: json-fuzz | |
14:57 | Adjust fuzzershell so that it adds the json1 extension separately for each no connection. check-in: ca2d1e90 user: drh tags: json-fuzz | |
14:32 | Include json1.c in fuzzcheck and fuzzershell. check-in: c4b68eff user: drh tags: json-fuzz | |
12:04 | Fix a documentation typo in sqlite3_bind_parameter_index(). No code changes. check-in: 650605a8 user: drh tags: trunk | |
11:57 | Fix an off-by-one error (really off-by-2 in this case) in the buffer resize logic of json1. check-in: d2a02737 user: drh tags: trunk | |
03:07 | Do not allow rowid in a UNIQUE or PRIMARY KEY constraint. (This restores the same behavior exhibited by all prior releases.) check-in: b1278301 user: drh tags: trunk | |
2015-09-18
| ||
18:09 | Fix a crash that can occur with a skip-scan on an index with expressions when SQLITE_ENABLE_EXPLAIN_COMMENTS is defined. check-in: 25f34cb9 user: drh tags: trunk | |
15:38 | Adjustments to the spellfix2.test module so that it works reliably on windows. check-in: 09a313fb user: drh tags: trunk | |
15:35 | Adjust two test cases so that they conform to the current code. check-in: 228e3d7c user: drh tags: trunk | |
15:13 | Fix sqlilimits.test module so that it knows that the SELECT in a CREATE VIEW is not checked until the view is actually used. check-in: acf5d87f user: drh tags: trunk | |
14:42 | Fix the orderby9.test case so that it works with 32-bit versions of TCL check-in: 4b6af774 user: drh tags: trunk | |
14:22 | Remove a test made obsolete by the ONEPASS DELETE optimization. check-in: c88b62c2 user: drh tags: trunk | |
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 | |
2015-09-15
| ||
19:16 | Merge enhancements from trunk. check-in: fc4d1de8 user: drh tags: begin-concurrent | |
17:31 | Merge enhancements from trunk. check-in: 66fe0683 user: drh tags: cursor-hints | |
17:20 | Merge trunk enhancements into the apple-osx branch. check-in: f12b8a0f user: drh tags: apple-osx | |
13:42 | Reformat some code to make it easier to merge with sessions. No logic changes. check-in: eade355f user: drh tags: trunk | |
2015-09-14
| ||
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 | |
10:47 | Merge the latest trunk enhancements. check-in: 22ce9218 user: drh tags: sessions | |
2015-09-12
| ||
19:27 | Fix API documentation typos. Emphasize that the sqlite3_config() routine is not threadsafe. check-in: 786333e0 user: drh 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 | |
15:32 | More test cases in test/json102.test corresponding to new examples in the json1 documentation. check-in: f599a42e user: drh 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: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 | |
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 | |
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
| ||
19:27 | Fix a possible NULL pointer deref when using SQLITE_ENABLE_MEMORY_MANAGEMENT. check-in: 89bfdbfe user: drh 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 | |
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 | |
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 | |
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: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 | |
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 | |
18:20 | A simple optimization and size reduction in sqlite3PagerAcquire(). check-in: 618d8dd4 user: drh tags: trunk | |
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: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: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 | |
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 | |
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 | |
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 | |
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 | |
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: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: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 | |