Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
914 check-ins using file doc/lemon.html version e2118945
|
2022-09-27
| ||
| 17:00 | Fix a potential division by zero error in this version of RBU that might occur if an external client checkpoints a wal file created by a suspended RBU process. (Leaf check-in: 73edd93a user: dan tags: branch-3.14) | |
|
2016-10-17
| ||
| 23:44 | Fix SQLITE_DBCONFIG_REQUIRE_TXN so that it allows BEGIN IMMEDAITE and BEGIN EXCLUSIVE to run outside of a transaction. (Leaf check-in: 29997f79 user: drh tags: require-write-txn) | |
| 19:00 | Escape non-ASCII character from an ICU extension comment. Cherrypick of [5ec02ecf3d20ce7e]. (Leaf check-in: a3a96c4d user: mistachkin tags: mutexDbg) | |
| 18:59 | Enhancments to Win32 mutex debugging. (check-in: 2fb9a5dd user: mistachkin tags: mutexDbg) | |
|
2016-10-08
| ||
| 11:55 | Add missing "static" to internal function whereRangeVectorLen(). (check-in: cbed3d75 user: dan tags: trunk) | |
| 09:21 | Updates to the tool/warnings.sh script to make it easier to use on OpenBSD. (check-in: dbe2997f user: dan tags: trunk) | |
|
2016-10-05
| ||
| 20:14 | Fix some compiler warnings in fts5. (check-in: b066637b user: dan tags: trunk) | |
| 20:10 | Fix harmless compiler warnings. (check-in: 2dde3375 user: drh tags: trunk) | |
| 15:04 | Add a test case for the fix in [a596b7c6cc]. (check-in: b2ef39b1 user: dan tags: trunk) | |
| 15:02 | Do not set MEM_Blob unless the appropriate fields of the Mem object have been correctly initialized. (check-in: a596b7c6 user: drh tags: trunk) | |
| 01:33 | Fix the backup_malloc.test script so that it works on Windows. (check-in: d080012d user: drh tags: trunk) | |
|
2016-10-04
| ||
| 12:20 | Fix a problem with the lempar.c parser template. (check-in: 3a9d802f user: drh tags: trunk) | |
| 00:47 | Do not bother to initialize unused fields in the BtreePayload object. (check-in: b10d0f93 user: drh tags: trunk) | |
|
2016-10-03
| ||
| 18:13 | Allow deterministic functions in the WHERE clause of a partial index. (check-in: c6e9b942 user: drh tags: trunk) | |
| 16:33 | Size and performance optimizations on the sqlite3ExprAssignVarNumber() routine. (check-in: 109852e5 user: drh tags: trunk) | |
| 15:28 | Avoid unnecessary strlen() calls in sqlite3ExprAssignVarNumber() by passing in the token length from the parser. (check-in: d15ae2e5 user: drh tags: trunk) | |
| 14:44 | Avoid unnecessary memset() calls in the query optimizer. (check-in: 5bb7cde0 user: drh tags: trunk) | |
| 12:56 | Fix an obsolete comment on a variable definition in expr.c. No code changes. (check-in: 012ff6dd user: drh tags: trunk) | |
| 02:59 | Make sure the sqlite_sequence table is updated when an optional xfer optimization is used. Fix for ticket [7b3328086a5c1]. (check-in: 81e4d4f8 user: drh tags: trunk) | |
| 01:21 | Allocate Parse objects off of the stack where appropriate for a substantial performance increase and a size reduction. (check-in: ea8affa9 user: drh tags: trunk) | |
|
2016-10-01
| ||
| 23:55 | Add SQLITE_USE_ALLOCA to the --lean configuration in speed-check.sh. (check-in: fe07609e user: drh tags: trunk) | |
| 21:43 | Rearrange fields in the Parse object to reduce the amount of initialization required. (check-in: 361940b4 user: drh tags: trunk) | |
| 20:43 | Reduce the width of a memset() to avoid double-initializing some variables. (check-in: 34edbfd1 user: drh tags: trunk) | |
| 19:32 | Remove an unnecessary memset() call. (check-in: a76bff74 user: drh tags: trunk) | |
| 19:21 | Use sqlite3DbMallocRawNN() where appropriate, instead of sqlite3DbMallocRaw(). (check-in: 54a449a4 user: drh tags: trunk) | |
| 16:53 | Make sure deleting an unused prepared statement does not reference uninitialized fields in the structure. (check-in: 7983eef0 user: drh tags: trunk) | |
| 11:39 | Avoid accessing Vdbe.pc if it is uninitialized. Check Vdbe.magic first. (check-in: 6ac6e446 user: drh tags: trunk) | |
| 00:37 | Avoid unnecessary zeroing of fields in the Vdbe object when it is allocated. (check-in: 1e21bbe8 user: drh tags: trunk) | |
|
2016-09-30
| ||
| 22:24 | Avoid initializing the column-cache section of the Parse object, since entries in the cache will be initialized as they are used, and avoiding the initial memset() saves many CPU cycles. (check-in: 63cf7eaf user: drh tags: trunk) | |
| 21:20 | Fix an always-true conditional left over from the previous commit. (check-in: ab12fce3 user: drh tags: trunk) | |
| 20:22 | Fix the Parse.aColCache column cache so that all of the valid entries are in the first Parse.nColCache slots. (check-in: 60285020 user: drh tags: trunk) | |
| 19:14 | Another simplification to the Parse object. (check-in: c1419727 user: drh tags: trunk) | |
| 18:35 | Remove unnecessary fields from the Parse object. (check-in: 814e41da user: drh tags: trunk) | |
| 17:46 | Avoid unnecessary Mem initializations when generating a new sqlite3_stmt object. (check-in: 47ae1cda user: drh tags: trunk) | |
|
2016-09-29
| ||
| 20:28 | Small size and performance optimization to sqlite3VdbeChangeP5(). (check-in: 3c93c8f5 user: drh tags: trunk) | |
| 19:50 | Remove the peep-hole optimization of removing OP_Close opcodes that come before OP_Halt, as the extra work of removing those opcodes uses more cycles than just running them. (check-in: 984a96d7 user: drh tags: trunk) | |
| 19:27 | Size and performance optimization to sqlite3ValueFromExpr() (check-in: 945f82bc user: drh tags: trunk) | |
| 15:53 | Clarification and typo-fixes in comments. No changes to code. (check-in: e2cd79aa user: drh tags: trunk) | |
|
2016-09-28
| ||
| 20:42 | Use Knuth multiplicative hashing for the symbol table. (check-in: cc29ddd6 user: drh tags: trunk) | |
| 16:15 | Merge recent enhancements from trunk. (check-in: 06014163 user: drh tags: apple-osx) | |
| 16:05 | Two more typo fixes in comments. (check-in: 40c0fb0a user: drh tags: trunk) | |
| 16:04 | Fix typos in comments. No code changes. (check-in: 5bbd071d user: drh tags: trunk) | |
|
2016-09-27
| ||
| 00:09 | Update requirements marks due to improvements in the wording of documentation. No changes to code. (check-in: bf903b2e user: drh tags: trunk) | |
| 00:03 | Fix FTS3 test cases due to the flattener change of the previous check-in. (check-in: 0c8b9b21 user: drh tags: trunk) | |
|
2016-09-26
| ||
| 14:39 | When flattening a query of the form "SELECT * FROM (SELECT * FROM tbl WHERE x=?) WHERE y=?", ensure that the final WHERE clause is "x=? AND y=?" instead of "y=? AND x=?". Although it is still not guaranteed, this makes the order in which WHERE clause terms are processed comport more closely to users expectations. (check-in: cf7f9e6d user: dan tags: trunk) | |
| 12:38 | Inline the relevent parts of sqlite3ExprAlloc() into spanExpr(), for a performance improvement. (check-in: fe89225e user: drh tags: trunk) | |
|
2016-09-24
| ||
| 17:42 | Omit the LikeOp object from the parser. Change more sqlite3PExpr() calls into sqlite3ExprAlloc() calls. (check-in: 795454a3 user: drh tags: trunk) | |
| 01:41 | Add -DSQLITE_MAX_EXPR_DEPTH=0 to the --lean option on speed-check.sh. (check-in: a8cb1390 user: drh tags: trunk) | |
|
2016-09-23
| ||
| 21:36 | Add the EP_Leaf flag bit to the Expr.flags field to indicate Expr nodes that do not have substructure. Use that bit to avoid unnecessary recursion. (check-in: 8a6ea455 user: drh tags: trunk) | |
| 20:59 | Use sqlite3ExprAlloc() instead of sqlite3PExpr() for leaf nodes in the expression tree, where appropriate. This is both smaller and faster. (check-in: afac0709 user: drh tags: trunk) | |
| 18:13 | New test case for the ORDER BY LIMIT optimization. (check-in: 9a5a489d user: drh tags: trunk) | |
|
2016-09-22
| ||
| 21:37 | Fix a potential null-pointer dereference and crash in the case where one thread is calling sqlite3_column_text() and another thread is calling sqlite3_step() on the same prepared statement at the same instant. (check-in: ee1382a3 user: drh tags: trunk) | |
| 18:53 | Remove the internal sqlite3CodeOnce() interface, replacing it with a direct call to sqlite3VdbeAddOp0(v,OP_Once). Slightly smaller and faster. (check-in: c3774c6a user: drh tags: trunk) | |
| 18:46 | Makefile changes to support building winsqlite3.dll using STDCALL rather than CDECL. (check-in: 5e892d60 user: mistachkin tags: trunk) | |
|
2016-09-21
| ||
| 23:58 | Fix speedtest1.c so that it works with SQLITE_OMIT_DEPRECATED. Add the --lean and --cachesize options to speed-check.sh. (check-in: 7785b3a2 user: drh tags: trunk) | |
| 19:43 | Fix a problem with the fts5 auxiliary function API causing a crash when a query contained a phrase of zero terms. (check-in: 0741812d user: dan tags: trunk) | |
| 19:00 | Do not run vacuummem.test if ENABLE_MEMORY_MANAGEMENT is defined. (check-in: 4a613d85 user: dan tags: trunk) | |
| 18:18 | Fix obsolete requirements marks. Add new tests for VACUUM of attached databases. (check-in: 2b44f9aa user: drh tags: trunk) | |
| 17:53 | Avoid running vacuum5.test in auto-vacuum mode. (check-in: be184bef user: dan tags: trunk) | |
| 17:47 | Do not run test "delete_db.test" with either the journaltest or inmemoryjournal permutations. Ensure that the multiplexor tests in delete_db.test are performed in non-autovacuum mode. (check-in: 46b7d19e user: dan tags: trunk) | |
| 14:41 | Update the fts5vocab table to handle "ORDER BY term" efficiently. (check-in: d4928fb5 user: dan tags: trunk) | |
|
2016-09-20
| ||
| 22:04 | Improved implementation of 64-bit signed integer multiply that correctly detects overflow (and promotes to floating-point) in some corner cases. Fix for ticket [1ec41379c9c1e400] (check-in: db3ebd7c user: drh tags: trunk) | |
| 17:49 | Fix harmless compiler warning. (check-in: 72429063 user: mistachkin tags: trunk) | |
| 17:38 | Fix typo in comment. (check-in: bd3ecbb5 user: mistachkin tags: trunk) | |
| 01:46 | Further performance enhancements in zeroblob() handling. (check-in: 21b0e3b7 user: drh tags: trunk) | |
| 01:19 | Avoid unnecessary calls to ExpandBlob() for smaller and faster code. (check-in: 5e196fd1 user: drh tags: trunk) | |
|
2016-09-19
| ||
| 23:39 | Very small optimization in the bytecode engine. (check-in: 46002511 user: drh tags: trunk) | |
| 11:00 | Fix a segfault introduced by the row-value enhancement that comes up on a skip-scan where the first term of the index is unconstrained and the second term is of the form "columm IN (SELECT...)". (check-in: 2401ea5a user: drh tags: trunk) | |
| 10:24 | Improved performance in sqlite3ExprCodeTarget(). (check-in: 75146165 user: drh tags: trunk) | |
| 02:19 | Small performance optimization in the expression walker. (check-in: c6e6afb9 user: drh tags: trunk) | |
|
2016-09-18
| ||
| 16:08 | Revise the implementation of OP_Once so that it is smaller, faster, and uses less memory. This also fixes an obscure bug introduced 3 days ago by check-in [5990a1bdb4a073]. (check-in: 6bf5ba10 user: drh tags: trunk) | |
|
2016-09-17
| ||
| 22:46 | Minor enhancement to the TclKit batch tool: it should download the TclKit EXE alone when the TCLKIT_NOENV environment variable is set. (check-in: baceb988 user: mistachkin tags: trunk) | |
| 19:34 | Small performance optimization in the freeSpace() routine of btree.c. (check-in: 63962e2a user: drh tags: trunk) | |
| 17:39 | Improved description of the ElseNotEq opcode in comments. No changes to code. (check-in: e011435e user: drh tags: trunk) | |
|
2016-09-16
| ||
| 20:39 | Fix typo in the name of a Win32 string conversion routine. Replace several uses of raw_printf() with utf8_printf() in the shell. (check-in: 6fc95dd7 user: mistachkin tags: trunk) | |
| 19:42 | If no KEY is specified on ATTACH, copy the main schema key if the key size is non-zero. In other words, allow for -1 as a valid key size in support of the --textkey to SEE. (check-in: 03573887 user: drh tags: trunk) | |
| 19:11 | Fix problems with the fileRead() function in the command-line shell. Fix a harmless memory leak in the command-line shell, to make validation testing easier. (check-in: e660402e user: drh tags: trunk) | |
| 18:53 | Remove the #ifdef SQLITE_DEBUG from around the testcase_glob() routine in the command-line shell. (check-in: 9885dac4 user: drh tags: trunk) | |
| 17:50 | Merge recent changes from trunk. (check-in: e3d9efa2 user: drh tags: apple-osx) | |
| 16:30 | Fix a problem causing incorrect code to be generated for IN constraints like "a IN (1, 2, 3)" where column "a" is a rowid column with an extra UNIQUE index created on it. Ticket [0eab1ac759]. (check-in: a92aee55 user: dan tags: trunk) | |
| 15:42 | Replace a faulty assert() with a testcase() to assure the condition is tested. Ticket [0eab1ac7591f]. (check-in: a49bc0a8 user: drh tags: trunk) | |
| 14:50 | Add WHERETRACE macros showing every entry and exit from whereLoopAddBtreeIndex(). (check-in: e7653dec user: drh tags: trunk) | |
| 11:53 | Fix SQLITE_OMIT_AUTHORIZATION so that it compiles cleanly. (check-in: a3e3b3e1 user: drh tags: trunk) | |
| 02:52 | In the shell, make ".testcase" and ".check" available in all configurations, not just SQLITE_DEBUG. All testcases to be named. Show the result of each testcase on stdout. (check-in: 792afefa user: drh tags: trunk) | |
| 00:26 | In the command-line shell, add the --new option to the ".open" command. Also, report the current database filename as part of the ".show" command. (check-in: 8e5c9203 user: drh tags: trunk) | |
|
2016-09-15
| ||
| 21:35 | Add the ".testcase" and ".check" dot-commands in the shell, when compiled using SQLITE_DEBUG. (check-in: 62289f27 user: drh tags: trunk) | |
| 19:15 | Omit the sqlite3Apis constant object when compiling with SQLITE_OMIT_LOAD_EXTENSION, since it is not used. (check-in: 7b104613 user: drh tags: trunk) | |
| 14:54 | Remove no-op code (adding an assert() to prove that the code was no-op) in the text affinity logic of the bytecode engine comparison operators. (check-in: b9f5bdbf user: drh tags: trunk) | |
| 05:47 | Fix a typo in a comment in sqlite.h.in. No changes to code. (check-in: 12df7152 user: dan tags: trunk) | |
| 00:32 | Slight size reduction and performance increase in sqlite3VdbeHalt(). (check-in: 5990a1bd user: drh tags: trunk) | |
| 00:04 | Optimization to vdbeRecordCompareInt() makes it slightly smaller and faster. (check-in: 5a2a7712 user: drh tags: trunk) | |
|
2016-09-14
| ||
| 18:56 | Update comments used to generate API documentation to include the new "[dateof:3.X.Y]" notation for dates of release where appropriate. No changes to code. (check-in: 55f7f8ee user: drh tags: trunk) | |
|
2016-09-12
| ||
| 18:50 | Version 3.14.2 (check-in: 29dbef4b user: drh tags: release, branch-3.14, version-3.14.2) | |
| 14:23 | Fix a bug in sqldiff causing it to confuse blobs zero bytes in size with NULL values. (check-in: 264e9c75 user: dan tags: trunk) | |
| 13:32 | Add missing "finish_test" command to vacuum5.test. (check-in: 02f40c3b user: dan tags: trunk) | |
| 09:28 | Have releasetest.tcl delete all test files except for "testfixture", "testfixture.exe", "sqlite3", "sqlite3.exe", "test.log" and "test-out.txt" after each test run is finished. Passing the "--keep" option restores the old behaviour. (check-in: e0e042dc user: dan tags: trunk) | |
|
2016-09-10
| ||
| 19:51 | Changes to give a warning-free build with SQLITE_OMIT_INCRBLOB and SQLITE_OMIT_SHARED_CACHE. (check-in: 711c5917 user: drh tags: trunk) | |
| 14:43 | Add test code to delete an SQLite database and its auxiliary files. (check-in: 8a9d1281 user: dan tags: trunk) | |
|
2016-09-09
| ||
| 20:26 | Make the new file test_delete.c portable to MSVC on Windows. (Closed-Leaf check-in: 0e3ace39 user: mistachkin tags: test_delete) | |
| 20:23 | Remove an unnecessary call to sqlite3VdbeMemExpandBlob() when casting to text. (check-in: 19e2e595 user: drh tags: trunk) | |
| 20:00 | Add new file test_delete.c, containing test code for deleting an sqlite database. (check-in: fb0b95e9 user: dan tags: test_delete) | |
| 19:33 | Performance improvements to the comparison operators in the bytecode engine. (check-in: 37803b19 user: drh tags: trunk) | |
| 15:12 | Fix a out-of-order variable declaration for some compile-time configurations. (check-in: 6ac932c9 user: drh tags: trunk) | |
| 13:23 | In releasetest.tcl, the --srcdir option is automatic, so no need to mention it in the --help output. (check-in: 2bdd838e user: drh tags: trunk) | |
| 13:17 | Fix an obsolete comment in the releasetest.tcl source code. (check-in: afaaa276 user: drh tags: trunk) | |
| 12:29 | In releasetest.tcl: Improved testing for uncommitted changes. If uncommitted changes are seen, exit immediately unless the --force option is used. (check-in: 9a14e6c4 user: drh tags: trunk) | |
|
2016-09-08
| ||
| 23:18 | Remove an extra space before function names in the amalgamation. Cherrypick of [20f3c7436f6a8a7bab39]. (check-in: a04a21ad user: mistachkin tags: branch-3.14) | |
| 23:16 | Remove an extra space before function names in the amalgamation. (Closed-Leaf check-in: 20f3c743 user: mistachkin tags: callbackConv) | |
| 23:12 | Issue a warning and prompt the user to continue if the releasetest.tcl script is run in a checkout with uncommitted changes. (check-in: 30e917ff user: drh tags: trunk) | |
|
2016-09-07
| ||
| 20:12 | Fix the sqlite3_trace_v2() interface so that it goes disabled if either the callback or mask arguments are zero, in accordance with the documentation. Cherrypick of [37e6c54b1afc6348]. (check-in: e9acf616 user: mistachkin tags: branch-3.14) | |
| 19:54 | Add support for row-value comparisons, including IN operators, and row-value updates in the UPDATE statement. (check-in: ddb5f055 user: drh tags: trunk) | |
| 19:47 | Fix the extra comments (added with -DSQLITE_ENABLE_EXPLAIN_COMMENTS) so that the sense of <, <=, >, and >= tests is correct and so that the SQLITE_STOREP2 version is shown correctly. Cherrypick of [4d43c4698eef4e3d]. (check-in: c844f3da user: mistachkin tags: branch-3.14) | |
| 19:37 | Fix a problem handling expressions like "(a, b) IN (SELECT ... ORDER BY 1, 2)" when there is an index on "a" but not "b". (Closed-Leaf check-in: 7f2c5c9e user: dan tags: rowvalue) | |
| 19:31 | Merge selected test fixes from trunk. (check-in: 71866b36 user: mistachkin tags: branch-3.14) | |
| 19:23 | Sync up the MSVC makefiles. (check-in: b3777e1f user: mistachkin tags: branch-3.14) | |
| 18:20 | Merge recent enhancements from trunk. (check-in: 00759af0 user: drh tags: apple-osx) | |
| 18:11 | Add the ext/misc/memvfs.c extension that implements a VFS for read-only database files contained in memory. (check-in: 12b7782a user: drh tags: trunk) | |
| 13:30 | Simplify the affinity handling logic in codeAllEqualityTerms(). Logically the same, just a little easier to read and understand. (check-in: bbab9621 user: drh tags: rowvalue) | |
| 13:20 | Fix the ".read" command in the command-line shell so that it understands that the input is not interactive. (check-in: 7c2c0d1d user: drh tags: branch-3.14) | |
| 13:12 | Merge fixes from trunk. (check-in: 193f036c user: drh tags: rowvalue) | |
| 12:47 | Version number to 3.14.2. (check-in: 925ef2f9 user: drh tags: branch-3.14) | |
| 12:41 | Makefile changes to support building winsqlite3.dll using STDCALL rather than CDECL. (check-in: af951e03 user: drh tags: branch-3.14) | |
| 12:20 | Correct affinity computations for a SELECT on the RHS of an IN operator. Fix for ticket [199df4168c]. (check-in: 2d1983ff user: drh tags: branch-3.14) | |
| 12:08 | The ORDER BY LIMIT optimization is not valid unless the inner-most IN operator loop is actually used by the query plan. Fix for ticket [0c4df46116e90f92]. (check-in: b4f8be1f user: drh tags: branch-3.14) | |
| 11:27 | Fix a problem in internal function sqlite3OpenTableAndIndices causing an operand of an unrelated VM instruction to be overwritten. Fix for [ef360601]. (check-in: e5c30f22 user: drh tags: branch-3.14) | |
| 10:10 | Fix the ".read" command in the command-line shell so that it understands that the input is not interactive. (check-in: d8451fe8 user: drh tags: trunk) | |
| 01:51 | The ORDER BY LIMIT optimization is not valid unless the inner-most IN operator loop is actually used by the query plan. Fix for ticket [0c4df46116e90f92]. (check-in: 820644b8 user: drh tags: trunk) | |
|
2016-09-06
| ||
| 19:08 | Remove obsolete vector-IN test cases. Fix a bad testcase() macro. (check-in: ab3f8f19 user: drh tags: rowvalue) | |
| 18:51 | Fix corer cases of vector IN operators where the RHS is a compound SELECT that includes an ORDER BY clause. (check-in: 8329ac6f user: drh tags: rowvalue) | |
| 17:21 | Remove an unnecessary branch from expr.c. (check-in: 7cc9746c user: dan tags: rowvalue) | |
| 17:13 | Avoid unnecessary memory allocations for aiMap in codeEqualityTerm(). (check-in: 70319c3d user: drh tags: rowvalue) | |
| 16:53 | Avoid a NULL pointer deref in codeAllEqualityConstraints() following an OOM. (check-in: c6e528c1 user: drh tags: rowvalue) | |
| 16:33 | Simplify the fix in commit [7d9bd22c]. (check-in: bd5a3420 user: dan tags: rowvalue) | |
| 15:25 | Fix the header comment on codeEqualityTerm(). (check-in: b7e710e4 user: drh tags: rowvalue) | |
| 14:58 | Fix a problem handling (a, b) IN (SELECT ...) expressions when there is an index on just one of "a" or "b". (check-in: 231c72d9 user: dan tags: rowvalue) | |
| 14:37 | Enhance the sqlite3GetTempRange() and sqlite3ReleaseTempRange() internal routines so that they use sqlite3GetTempReg() and sqlite3ReleaseTempReg() when nReg==1. (check-in: 4071da2f user: drh tags: rowvalue) | |
| 12:04 | Fix a typo in a comment in expr.c. (check-in: 288e934f user: dan tags: rowvalue) | |
|
2016-09-05
| ||
| 22:50 | Simplified logic to extract a column from a row value. (check-in: e8f105c3 user: drh tags: rowvalue) | |
| 20:46 | Sync up the MSVC makefiles. (check-in: f66d0d8c user: mistachkin tags: callbackConv) | |
| 20:40 | Merge updates from trunk. (check-in: ea635bf9 user: mistachkin tags: callbackConv) | |
| 19:57 | Fix an assert() so that it does C-compiler does not combine an assert() conditional with a production code conditional and thereby confuse the mutation testing script. (check-in: 2fa5288a user: drh tags: rowvalue) | |
| 15:02 | Simplifications to the SQLITE_KEEPNULL flag on VDBE comparison operators. (check-in: 96269f01 user: drh tags: rowvalue) | |
| 12:12 | Do vector comparison size checking early - at name resolution time - to forestall future problems. (check-in: ae127bcc user: drh tags: rowvalue) | |
| 12:02 | Catch vector size mismatch problems during name resolution to avoid later problems. (Closed-Leaf check-in: 56562a03 user: drh tags: early-vector-size-check) | |
| 09:44 | Fix a crash that could occur under certain circumstances if the vectors on either side of a comparison operator were of a different size. (check-in: 42670935 user: dan tags: rowvalue) | |
|
2016-09-03
| ||
| 19:52 | Fix a problem causing the affinity of sub-select row-value elements to be ignored in some contextes. (check-in: 7d9bd22c user: dan tags: rowvalue) | |
| 16:24 | Merge the fuzzershell enhancement from trunk. (check-in: ed206048 user: drh tags: rowvalue) | |
| 16:23 | Build the generate_series(START,END,STEP) table-valued function into fuzzershell, to make it easier to construct compact test cases that contain actual data. (check-in: 672c21bc user: drh tags: trunk) | |
| 15:31 | Consider the affinity of "b" when using an "a IN (SELECT b ...)" expression with an index on "a". Fix for [199df416]. (check-in: f5e49855 user: dan tags: rowvalue) | |
| 01:46 | Performance optimizations. (check-in: f1d06c49 user: drh tags: rowvalue) | |
|
2016-09-02
| ||
| 23:56 | Merge recent changes from trunk. (check-in: c7271fbd user: drh tags: rowvalue) | |
| 21:34 | Add a test case for the OOM handled by the previous commit. (check-in: 9bdf7ca1 user: dan tags: trunk) | |
| 21:17 | Correctly detect an OOM occurring in the setDestPgsz() subroutine of backup. (check-in: d9d8a048 user: drh tags: trunk) | |
| 17:27 | The previous commit could miss an SQLITE_NOMEM error. This commit catches it. (Closed-Leaf check-in: 3a9f4750 user: dan tags: mistake) | |
| 17:18 | Within a backup operation, ensure that a read-transaction is opened on the source database before its page size is read. This ensures the page-size used to write to the backup database is the same as its actual page-size, which is important for ZipVFS databases. (check-in: 7908fc60 user: dan tags: trunk) | |
|
2016-09-01
| ||
| 14:03 | Have "sqldiff --rbu" ignore rows with NULL values in primary key fields. RBU can't handle such rows and the documentation already says sqldiff ignores them. Because the code now uses "=" instead of "IS" to filter on primary key columns, diffs on virtual tables are faster now too. (check-in: f4ba894a user: dan tags: trunk) | |
| 09:35 | If SQLITE_ENABLE_ZIPVFS is defined, journal_mode=off is configured and a savepoint or statement rollback is attempted, move the pager into the error state to prevent the transaction from being committed. This makes it safe to use journal_mode=off with zipvfs under some conditions. (check-in: 38d31e18 user: dan tags: trunk) | |
|
2016-08-29
| ||
| 14:18 | Use some of the example code from the sessions documenatation in the sessions test cases. (check-in: 6602974d user: dan tags: trunk) | |
|
2016-08-27
| ||
| 20:21 | Fix typos in comments. No changes to running code. (check-in: a07269f2 user: drh tags: trunk) | |
| 18:35 | Fix some comments in sqlite3session.h. No changes to code. (check-in: 78cd64e2 user: dan tags: trunk) | |
| 18:34 | Fixes to fts5 snippet() function. (check-in: d464a7b1 user: dan tags: trunk) | |
| 14:13 | Merge updates from trunk. (check-in: 082fd5f8 user: drh tags: rowvalue) | |
| 14:05 | Fix the extra comments (added with -DSQLITE_ENABLE_EXPLAIN_COMMENTS) so that the sense of <, <=, >, and >= tests is correct and so that the SQLITE_STOREP2 version is shown correctly. These changes are already in the rowvalue branch but are added here since they are technically unrelated to rowvalue. (check-in: 4d43c469 user: drh tags: trunk) | |
| 01:41 | Fix the "Synopsis" on the OP_Lt, OP_Le, OP_Gt, and OP_Ge opcodes, which has been backwards for time out of mind. (check-in: f51248dc user: drh tags: rowvalue) | |
|
2016-08-26
| ||
| 22:09 | Fix a minor problem in sqlite3FindInIndex() related to rowids being used as part of the index. (check-in: 829f802b user: drh tags: rowvalue) | |
| 21:15 | Fix the sqlite3FindInIndex() to ensure that it always uses a prefix of the index and uses no repeated columns. Enhanced comments. (check-in: b9fc89e4 user: drh tags: rowvalue) | |
| 19:54 | Add an EXPLAIN QUERY PLAN line for when a index is used to implement an IN operator. (check-in: 171aa833 user: drh tags: rowvalue) | |
| 19:47 | Add test cases to rowvalue2.test. (check-in: 078bb69e user: dan tags: rowvalue) | |
| 19:31 | Enhance sqlite3FindInIndex() so that it is able to make use of the primary keys at the end of an index. (check-in: 4b589fbf user: drh tags: rowvalue) | |
| 18:17 | Fix a post-OOM crash in updateRangeAffinityStr(). Add several ALWAYS() macros on unreachable branches. (check-in: 87d40195 user: drh tags: rowvalue) | |
| 17:54 | Fix a problem with affinity changes and vector range comparisons. (check-in: b34413ac user: dan tags: rowvalue) | |
| 13:19 | Allow ROWID values in indexed vector comparisons. (check-in: b0cc6be4 user: drh tags: rowvalue) | |
| 12:00 | Fix a problem in internal function sqlite3OpenTableAndIndices causing an operand of an unrelated VM instruction to be overwritten. Fix for [ef360601]. (check-in: 70901479 user: dan tags: trunk) | |
| 04:32 | Rename a test procedure in 'speed3.test' to avoid a name collision. (check-in: 84de17bc user: mistachkin tags: trunk) | |
| 03:42 | Comment improvements. Put ALWAYS and NEVER macros on three unreachable branches. (check-in: 39761700 user: drh tags: rowvalue) | |
| 02:10 | Adapt the special case of '$' in item names for test 'vtabH-3.1' as well. (check-in: e4aeaa2b user: mistachkin tags: trunk) | |
| 01:47 | Make the test 'vtabH-3.1' work when there are less than 5 top-level items. (check-in: 328f79bb user: mistachkin tags: trunk) | |
| 01:17 | Support running the fstree tests in 'vtabH.test' on Windows when not using the system drive. (check-in: 3680f95f user: mistachkin tags: trunk) | |
| 01:02 | Remove an unreachable branch from sqlite3ExprAffinity() (check-in: 9d96f614 user: drh tags: rowvalue) | |
|
2016-08-25
| ||
| 23:24 | Fix typos in 'vtabF.test' file. No changes to code. (check-in: a8546fee user: mistachkin tags: trunk) | |
| 22:31 | Merge recent changes from trunk. (check-in: 5789aab8 user: drh tags: rowvalue) | |
| 22:06 | Fix the sqlite3_trace_v2() interface so that it goes disabled if either the callback or mask arguments are zero, in accordance with the documentation. (check-in: 37e6c54b user: drh tags: trunk) | |
| 21:14 | Refactor the sqlite3ExprCodeIN() routine for improved maintainability. (check-in: b56705ae user: drh tags: rowvalue) | |
| 17:47 | Another fix in the IN-operator algorithm description. (check-in: f474aeac user: drh tags: rowvalue) | |
| 17:40 | Further refinement of the in-operator.md documentation. (check-in: df064837 user: drh tags: rowvalue) | |
| 15:46 | Improvements to IN operator code generator comments. Avoid unnecessary Copy operations on the LHS of the IN operator. (check-in: b6344298 user: drh tags: rowvalue) | |
| 14:23 | Corrections to the IN-operator notes. (check-in: 25033ee9 user: drh tags: rowvalue) | |
| 14:00 | Add notes on the implementation of the IN operator. (check-in: d256b2ca user: drh tags: rowvalue) | |
|
2016-08-24
| ||
| 21:54 | Simplified VDBE code for the vector NOT IN null-scanning loop. (check-in: 7ae504e6 user: drh tags: rowvalue) | |
| 21:24 | Improved extended comments of comparison operators when the SQLITE_STOREP2 flags is set on P5. No changes to non-debug code. (check-in: bbc1b016 user: drh tags: rowvalue) | |
| 19:58 | Modularize all use of the calling convention macros based on the USE_STDCALL nmake macro. (check-in: e4a56197 user: mistachkin tags: callbackConv) | |
| 19:14 | Add the sqlite3changebatch_db() API. (check-in: bee44ebc user: dan tags: changebatch) | |
| 18:51 | In sqlite3FindInIndex(), improve internal comments and avoid an unreachable branch. (check-in: 55945fc1 user: drh tags: rowvalue) | |
| 18:50 | Fix a bug in the fts5 snippet function causing it to return text containing zero phrase instances. (Closed-Leaf check-in: b174ed2b user: dan tags: fts5-snippet-bias) | |
| 18:49 | Merge updates from trunk. (check-in: 428fc38d user: mistachkin tags: callbackConv) | |
| 18:21 | Sync up the MSVC autoconf makefile. (check-in: 77f7c31a user: mistachkin tags: trunk) | |
| 17:49 | Fix more unreachable branches. (check-in: 6099c180 user: drh tags: rowvalue) | |
| 15:37 | Add a NEVER() on an unreachable branch in comparisonAffinity(). (check-in: 505a2f20 user: drh tags: rowvalue) | |
| 12:22 | Fix a buffer overrun in the code for handling IN(...) operators when the LHS of the operator contains indexed columns or expressions. (check-in: f41a0391 user: dan tags: rowvalue) | |
| 00:51 | The previous OOM fix was bad. Back it out and replace it with a better one. (check-in: 1e3bc369 user: drh tags: rowvalue) | |
| 00:25 | Avoid a potential null-pointer dereference following an OOM. (check-in: 25f6ed8d user: drh tags: rowvalue) | |
|
2016-08-23
| ||
| 19:02 | Simplify the row value misuse error message. (check-in: 838c50a5 user: drh tags: rowvalue) | |
| 19:02 | Add further tests for changebatch. And a fix to prevent a changeset from conflicting with itself. (check-in: 506d6ff4 user: dan tags: changebatch) | |
| 18:30 | Fix a problem with rowvalue UPDATE when the rowvalue is not the left-most and the RHS is a multi-column subquery. (check-in: e149e6b9 user: drh tags: rowvalue) | |
| 18:09 | Fix harmless compiler warnings in changebatch. (check-in: a721a738 user: drh tags: changebatch) | |
| 17:30 | Fix an uninitialized variable in CASE expression code generation. (check-in: c8ffae05 user: drh tags: rowvalue) | |
| 17:02 | Add a new method to sessions - sqlite3sessions_fullchangeset() - to return a changeset that always contains values for all old.* fields. Update changebatch to use these values to more reliably detect multi-column UNIQUE constraint violations. (check-in: efa761b2 user: dan tags: changebatch) | |
| 14:42 | Fix the SQLITE_USER_AUTHENTICATION login check so that the SQLITE_AUTH_USER error code correctly propagates and is not overwritten by SQLITE_ERROR. (check-in: c640489d user: drh tags: trunk) | |
|
2016-08-22
| ||
| 21:01 | Add a couple of extra tests to changebatch1.test. (check-in: 207d970b user: dan tags: changebatch) | |
| 20:49 | Add an experimental module to detect conflicts between sessions changesets. (check-in: 0c9fd6b7 user: dan tags: changebatch) | |
| 20:10 | Add support for the SQLITE_DBCONFIG_MAINDBNAME configuration option. (check-in: 78395193 user: drh tags: trunk) | |
| 14:30 | Fix the vector BETWEEN operator so that it only evaluates the left-most vector expression once. Add support for vector comparisons in the CASE operator. (check-in: 07e69f43 user: drh tags: rowvalue) | |
| 00:48 | Reinstate the mechanism in BETWEEN that avoids evaluating the first expression more than once, but fix the affinity extractor so that it works with this mechanism. The de-duplication of the first expression still does not work for vector expressions, though. (check-in: 2f39987f user: drh tags: rowvalue) | |
|
2016-08-20
| ||
| 22:49 | The docs promise the in "x BETWEEN y AND z" the x expression is only evaluated once. That is no longer true, and so some tests are failing. This needs to be fixed before merging to trunk. (check-in: e50d264f user: drh tags: rowvalue) | |
| 21:11 | Further comment enhancements. No changes to code. (check-in: d4562a9e user: drh tags: rowvalue) | |
| 21:02 | Clarification of code comments in expr.c. Clean up the implementations of sqlite3ExprIsVector() and sqlite3ExprVectorSize() slightly. (check-in: 4fb66d65 user: drh tags: rowvalue) | |
| 18:06 | Fixes for problems following OOM errors. (check-in: 9041ee4a user: drh tags: rowvalue) | |
| 17:23 | Fix other minor problems with the fts5 snippet() function. (check-in: b56b2a85 user: dan tags: fts5-snippet-bias) | |
| 17:00 | Do not duplicate the Expr.pLeft subtree of a TK_SELECT_COLUMN node. (check-in: 8384c77e user: drh tags: rowvalue) | |
| 15:01 | Fix a segfault that could occur if a query that used a vector comparison contained certain types of syntax errors. (check-in: 203f07c5 user: dan tags: rowvalue) | |
| 12:00 | Improvements to the vector comparison splitter in exprAnalyze(). (check-in: a3ffd283 user: drh tags: rowvalue) | |
| 01:06 | Improvements to comments. No code changes. (check-in: 4165d20f user: drh tags: rowvalue) | |
| 00:51 | Add support for vector assignments in the SET clause of an UPDATE statement. (check-in: f320d47d user: drh tags: rowvalue) | |
| 00:07 | Change the way TK_SELECT_COLUMN is handled so that the subquery is only generated once even if part of the vector comparison is used for indexing and the other part is now. This change also is a pathway to vector assignment in UPDATE statements. (check-in: d8feea7d user: drh tags: rowvalue) | |
|
2016-08-19
| ||
| 19:58 | Replace the magic number (-2) with its symbol XN_EXPR in the exprMightBeIndexed() routine. No logic changes. (check-in: d4a5af69 user: drh tags: rowvalue) | |
| 19:12 | Improved comments on sqlite3CodeSubquery(). No changes to code. (check-in: acea4ee1 user: drh tags: rowvalue) | |
| 18:40 | Show the WhereTerm.iField value on debugging output, when it is non-zero. (check-in: 931c9535 user: drh tags: rowvalue) | |
| 18:37 | Register any built-in fts5 module before loading automatic extensions. This allows automatic extensions to register fts5 tokenizers and auxiliary functions. (check-in: b10e31dc user: dan tags: fts5-snippet-bias) | |
| 18:28 | Fix an obsolete comment on codeEqualityTerm(). No changes to code. (check-in: d07be5af user: drh tags: rowvalue) | |
| 15:41 | Merge recent enhancements from trunk. (check-in: b1787236 user: drh tags: rowvalue) | |
| 15:17 | Merge the VACUUM attached database enhancement from trunk. (Closed-Leaf check-in: 12d5e38d user: drh tags: dbconfig_maindbname) | |
| 15:15 | Enhance the VACUUM command so that it can operate on an attached database. (check-in: 083f9e62 user: drh tags: trunk) | |
| 15:12 | Disable row counting on queries run while doing a VACUUM. (Closed-Leaf check-in: ad35ef11 user: drh tags: vacuum-attached-db) | |
| 14:25 | Have the fts5 snippet() function avoid favouring snippets that begin with sentences that do not contain search terms. Add an extra bias in favour of the first sentence in the document. (check-in: d8180af2 user: dan tags: fts5-snippet-bias) | |
| 14:20 | Add the capability to VACUUM an attached database by specifying the schema name as an argument to the VACUUM command. Since version 2.0, VACUUM has accepted an argument which was silently ignored. Now it has meaning. (check-in: 29d63059 user: drh tags: vacuum-attached-db) | |
|
2016-08-18
| ||
| 22:44 | Add the SQLITE_DBCONFIG_MAINDBNAME interface. (check-in: d6e3d579 user: drh tags: dbconfig_maindbname) | |
| 22:19 | Change the name of Db.zName to Db.zDbSName for improved long-term code maintainability. (check-in: cb9865e1 user: drh tags: trunk) | |
| 20:56 | Fix a zName to zDbSName conversion missed in the previous check-in. (Closed-Leaf check-in: d7cf423c user: drh tags: zDbSName) | |
| 19:04 | Fix a SQL NULL handling bug in the vector IN operator code generation. (check-in: 936146b1 user: drh tags: rowvalue) | |
| 18:09 | Display SELECT_COLUMN expressions in the .wheretrace debugging output. (check-in: 3b27a5da user: drh tags: rowvalue) | |
| 17:55 | Display VECTOR expressions in .wheretrace and .selecttrace debugging output. (check-in: 157347e2 user: drh tags: rowvalue) | |
| 15:36 | Since the TK_VECTOR token is not actually used by the parser, make it an extra token code added by the tool/addopcodes.tcl script during parser build. (check-in: b40b202c user: drh tags: rowvalue) | |
| 15:21 | Merge recent enhancements from trunk. (check-in: 4768a106 user: drh tags: rowvalue) | |
| 15:15 | Simplify the vector comparison code generator logic, and the resulting VDBE code. (check-in: e2ad0b5d user: drh tags: rowvalue) | |
| 14:47 | Adjust some tests to account for recent changes to the fts5 snippet function. (check-in: 184ecbe9 user: dan tags: fts5-snippet-bias) | |
| 14:33 | Rename the Db.zName field to Db.zDbSName to make it more descriptive and to distinguish it from all of the other "zName" variables scattered throughout the code. (check-in: 92a22f01 user: drh tags: zDbSName) | |
|
2016-08-17
| ||
| 19:05 | Bias the fts5 snippet() function to return snippets that look like they start at the start of sentences. (check-in: 60de1594 user: dan tags: fts5-snippet-bias) | |
| 11:14 | Fix a problem in the fts5 snippet() auxiliary function. (check-in: a861713c user: dan tags: trunk) | |
|
2016-08-16
| ||
| 16:46 | Fix a bug in destructor processing of Lemon. That has no impact on the SQLite grammar. The bug was introduced by prior work to optimize the Lemon-generated parser used by SQLite. (check-in: f9035b8e user: drh tags: trunk) | |
|
2016-08-13
| ||
| 14:30 | Questionable changes to support interruptible checkpoint in ZipVFS. (Leaf check-in: c7a9f26d user: dan tags: interruptible-checkpoint) | |
| 14:17 | Remove an unnecessary stack variable from sqlite3VdbeExec(). (Closed-Leaf check-in: c54bd9c8 user: drh tags: vector-compare) | |
| 13:03 | Improvements to commits. No code changes. (check-in: 18f5a3be user: drh tags: vector-compare) | |
| 12:37 | Fix to the vector less-than operator. All legacy tests passing now. (check-in: ec70a67e user: drh tags: vector-compare) | |
| 10:34 | Fix an fts5 problem with corrupt database handling found by address-sanitizer. (check-in: e22252e1 user: dan tags: trunk) | |
| 10:02 | Attempt to simplify the logic and generated code for vector comparisons. Basic comparison operators are working, but there are many indexing test failures still to be worked through. (check-in: dfc028cf user: drh tags: vector-compare) | |
| 06:38 | Fix a buffer overread in fts5. (check-in: fcfbee6c user: dan tags: trunk) | |
|
2016-08-12
| ||
| 16:21 | Have wal file checkpoints exit early if the sqlite3_interrupt() API function is called. (check-in: 8a5f41c7 user: dan tags: interruptible-checkpoint) | |
| 11:25 | Add VdbeCoverage() macros on newly added VDBE branch operations. (check-in: 381aa731 user: drh tags: rowvalue) | |
| 11:01 | Fix a post-OOM memory leak. (check-in: 14009b32 user: drh tags: rowvalue) | |
|
2016-08-11
| ||
| 19:12 | Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. (check-in: d9f8918c user: drh tags: begin-concurrent) | |
| 18:53 | Version 3.14.1 (check-in: a12d8059 user: drh tags: release, branch-3.14, version-3.14.1) | |
| 18:05 | Add the "modeof=<filename>" URI parameter to os_unix.c - used to specify a file to copy permissions from when a new database is created. Also allow passing NULL as the second parameter to sqlite3rbu_vacuum(). (check-in: ed406d31 user: dan tags: trunk) | |
| 13:51 | Fix a 1 byte buffer overwrite in the "sqldiff --rbu" command. (check-in: 1adb22f5 user: drh tags: branch-3.14) | |
| 13:08 | Increase the version number to 3.14.1. (check-in: 34aed3a3 user: drh tags: branch-3.14) | |
| 13:03 | Enhance sqlite3PcacheTruncate() to run faster in the common case where the cutoff is just a few pages less than the page number highwater mark. (check-in: 03dceaea user: drh tags: branch-3.14) | |
| 12:31 | Merge recent changes from trunk. (check-in: 959677b9 user: drh tags: rowvalue) | |
| 12:01 | Fix some problems with handling "no such collation sequence" errors. (check-in: 8278be06 user: dan tags: rowvalue) | |
| 09:55 | Fix a 1 byte buffer overwrite in the "sqldiff --rbu" command. (check-in: ab83d707 user: dan tags: trunk) | |
| 01:24 | Fix a harmless compiler warning in FTS5. (check-in: 2ea0c8b4 user: drh tags: trunk) | |
|
2016-08-10
| ||
| 20:02 | Optimization to sqlite3WhereExprUsage(). (check-in: 95493058 user: drh tags: trunk) | |
| 19:43 | List of MATCH operator names in isMatchOfColumn() should be constant. (check-in: 7319d676 user: drh tags: trunk) | |
| 18:56 | Performance enhancement in the expression walker. (check-in: ebccbd96 user: drh tags: trunk) | |
| 15:02 | Tweaks to pcache1TruncateUnsafe() to make it slightly smaller and faster and easier to test. (check-in: 059f4e2e user: drh tags: trunk) | |
| 14:40 | Rearrange the code inside sqlite3RunParser() routine so that sqlite3Parser() is only called from a single place. This allows sqlite3Parser() to be in-lined, which results in a 0.25% overall performance gain. (check-in: 25d1d02b user: drh tags: trunk) | |
| 13:34 | Increment the version number to 3.15. (check-in: 8c2701e7 user: drh tags: trunk) | |
| 13:30 | Improved comments on the lempar.c parser template. Adjust the YY_SHIFT_USE_DFLT constant in the Lemon-generated parser tables so as to guarantee that it is always out of range of the yy_lookahead[] table. (check-in: 83622f3f user: drh tags: trunk) | |
| 11:50 | Fix pcache1TruncateUnsafe() run faster for the case where iLimit is very close to iMaxKey. (check-in: b07a26df user: drh tags: trunk) | |
| 01:43 | Performance optimization in the yy_find_shift_action() routine of the Lemon-generated parser. (check-in: ba6663be user: drh tags: trunk) | |
|
2016-08-09
| ||
| 21:08 | Prototype for the remember(V,PTR) extension function. (Closed-Leaf check-in: f0942c36 user: drh tags: rememberFunc) | |
| 21:01 | Fix harmless compiler warning. (check-in: 9a5a4f6e user: drh tags: trunk) | |
| 19:48 | Minor update to the way fts5 column filters are parsed. (check-in: 14864f2b user: dan tags: trunk) | |
| 19:26 | Have fts5 interpret column lists that begin with a "-" character as "match any column except" lists. (check-in: e5175456 user: dan tags: trunk) | |
| 05:48 | Add rowvalue5.test, which should have been part of the previous commit on this branch. (check-in: ea03e219 user: dan tags: rowvalue) | |
|
2016-08-08
| ||
| 20:15 | Fix some cases involving row values and virtual tables. (check-in: 156a41f3 user: dan tags: rowvalue) | |
| 18:42 | Fix the EXPLAIN QUERY PLAN output for row value range constaints that use an index. (check-in: bb606511 user: dan tags: rowvalue) | |
| 16:52 | Merge trunk changes with this branch. (check-in: 0e927a7e user: dan tags: rowvalue) | |
| 14:21 | Merge all changes from the 3.14 release. (check-in: c3cd543f user: drh tags: apple-osx) | |
| 13:40 | Version 3.14 (check-in: d5e98057 user: drh tags: trunk, release, version-3.14.0) | |
|
2016-08-07
| ||
| 18:52 | Fix documentation typos. No changes to code. (check-in: ebc396a1 user: drh tags: trunk) | |
|
2016-08-05
| ||
| 20:54 | Have the TEA package build without SQLITE_OMIT_DEPRECATED. As it uses recently deprecated interfaces sqlite3_profile() and sqlite3_trace(). (check-in: 95578898 user: dan tags: trunk) | |
| 16:16 | Undo commit [f250166bb]. It is required to handle IO and other errors that occur within a VACUUM of a Zipvfs database. (check-in: ae72513a user: dan tags: trunk) | |
| 15:34 | Remove an incorrect ALWAYS() statement and add a test case to show when the condition is sometimes false. (check-in: 0f57effa user: drh tags: trunk) | |
| 14:35 | Fix a very obscure problem following OOM in sqlite3_declare_vtab(). (check-in: 68eac748 user: drh tags: trunk) | |
|
2016-08-04
| ||
| 13:39 | Merge all recent enhancements from trunk. (check-in: dacfff51 user: drh tags: apple-osx) | |
| 13:23 | Revert the SQLITE_APICALL changes for now. That changes needs further research before it is released. Deferred until 3.15. (check-in: 9adda385 user: drh tags: trunk) | |
| 12:35 | Add the experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. When enabled, the "unknown function" error is suppressed for EXPLAIN and a no-op function named "unknown()" is substituted. This facilitiates using the command-line shell to analyze queries from applications that contain many application-defined functions that are not normally available to the shell. (check-in: b7f30a9f user: drh tags: trunk) | |
| 12:33 | Add the experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. When enabled, the "unknown function" error is suppressed for EXPLAIN and a no-op function named "unknown()" is substituted. This facilitiates using the command-line shell to analyze queries from applications that contain many application-defined functions that are not normally available to the shell. (check-in: e22ca3cd user: drh tags: apple-osx) | |
| 09:13 | Merge the ORDER BY LIMIT fix, and other enhancements, from trunk. (check-in: bf5a9542 user: drh tags: apple-osx) | |
| 09:09 | Make sure the ORDER BY LIMIT optimization is not applied if the inner-most loop can only have a single iteration and is hence not really a loop. (check-in: 13e3bd3d user: drh tags: trunk) | |
| 01:47 | Add an experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. This changes has been merged into main branches via cherry-pick. (Closed-Leaf check-in: 4ada023c user: drh tags: unknown-function) | |
|
2016-08-03
| ||
| 18:00 | Fix a problem with estimating the number of rows visited by a query that uses a multi-column IN(SELECT...) constraint. (check-in: 3c2f908f user: dan tags: rowvalue) | |
| 16:39 | Fix another problem involving vector range constraints and mixed ASC/DESC indexes. (check-in: 1559f4c4 user: dan tags: rowvalue) | |
| 16:14 | Fix stat4-based cost estimates for vector range constraints. (check-in: 18af74ab user: dan tags: rowvalue) | |
| 14:51 | Fix a typo in a comment in btree.c. No changes to code. (check-in: 722c1281 user: drh tags: trunk) | |
| 13:40 | Fix the --help output on fuzzcheck so that it fix in an 80-character window. (check-in: b91444b5 user: drh tags: trunk) | |
|
2016-08-02
| ||
| 20:45 | Add new test file rowvaluefault.test. (check-in: e496b2d6 user: dan tags: rowvalue) | |
| 20:42 | Fix a unused variable that comes up with -DSQLITE_OMIT_DATETIME_FUNCS. (check-in: e2f9919e user: drh tags: trunk) | |
| 19:29 | The 'replace.tcl' tool should use Unix line-endings. (check-in: 50de9631 user: mistachkin tags: trunk) | |
| 18:50 | Add tests and fixes for vector operations that use sub-queries with different combinations of LIMIT, OFFSET and ORDER BY clauses. (check-in: 092b1c5f user: dan tags: rowvalue) | |
| 17:45 | Fix SQLITE_OMIT_SUBQUERY builds. (check-in: 339f85f4 user: dan tags: rowvalue) | |
| 17:07 | Fix a problem with vector range constraints and mixed ASC/DESC indexes. (check-in: e2ad30c8 user: dan tags: rowvalue) | |
| 16:24 | Merge latest trunk changes into this branch. (check-in: d468101b user: dan tags: rowvalue) | |
| 16:18 | Add missing comments and make some code on this branch clearer. (check-in: 6937677c user: dan tags: rowvalue) | |
| 13:26 | Updates to requirements marks. No changes to code. (check-in: b23c10ac user: drh tags: trunk) | |
| 11:29 | Fix a problem introduced by [77948b5eceab92a7] causing duplicate calls to be made to the xSavepoint() method of virtual tables under some circumstances. (check-in: e64a4173 user: dan tags: trunk) | |
| 08:45 | Fix harmless compiler warnings in sqlite3_status(). (check-in: 7c38a79c user: drh tags: trunk) | |
|
2016-08-01
| ||
| 21:17 | Update the wordcount.c test program and add a new script "time-wordcount.sh" for additional performance testing. (check-in: d8ef9f58 user: drh tags: trunk) | |
| 20:14 | Fix a problem with vector range constraints involving the rowid column. And other issues. (check-in: 3ef75d45 user: dan tags: rowvalue) | |
| 17:06 | Fix other harmless compiler warnings. (check-in: 90d2c490 user: drh tags: trunk) | |
| 16:57 | Remove a duplicate typedef from loadext.c (remaining copy is in sqlite3ext.h). (check-in: fd184e5a user: dan tags: trunk) | |
| 16:50 | Add an extra compiler switch to loadext.test to ensure that it picks up the correct version of sqlite3.h when building a test extension. (check-in: e57fa6af user: dan tags: trunk) | |
| 16:37 | Fix a problem with IN(...) constraints where the LHS is a sub-select that is an aggregate query. (check-in: 1f4dba87 user: dan tags: rowvalue) | |
| 15:00 | Update releasetest.tcl to automatically do one round of tests with USE_STDCALL=1 when running on Windows with MSVC. (check-in: a6a112de user: drh tags: trunk) | |
| 14:35 | Avoid making unnecessary changes to the signatures of the sqlite3_auto_extension() and sqlite3_cancel_auto_extension() interfaces. (check-in: b6ea2f21 user: drh tags: trunk) | |
|
2016-07-30
| ||
| 21:02 | Fix problems with vector == comparisons and NULL values. (check-in: 059d0d05 user: dan tags: rowvalue) | |
| 18:54 | Fix harmless compiler warning seen with MSVC. (check-in: 390a38a1 user: mistachkin tags: trunk) | |
| 17:59 | Merge latest trunk with this branch. (check-in: 63ae02d0 user: dan tags: rowvalue) | |
| 16:39 | Remove the EP_Vector expression flag. (check-in: e9d9c6d4 user: dan tags: rowvalue) | |
|
2016-07-29
| ||
| 20:58 | Fix some issues with vector range constraints and the column cache. Also vector range constraints and rowid columns. (check-in: 42607366 user: dan tags: rowvalue) | |
| 18:12 | Change the way "(a, b) = (SELECT *)" expressions are handled in where.c if there is an index on one of the columns only. (check-in: 4dfebff2 user: dan tags: rowvalue) | |
| 17:36 | Using the header file 'intrin.h' requires MSVC 2005 or later. (check-in: 9fae75c0 user: mistachkin tags: trunk) | |
| 04:12 | For test 'shell1-5.0', disable round-trip testing for characters in the range 0xE0 to 0xEF on Linux, due to intermittent shell portability issues. (check-in: 544c990a user: mistachkin tags: trunk) | |
| 02:04 | Fix typo in a test file interactive output string. (check-in: 4fedd790 user: mistachkin tags: trunk) | |
| 01:55 | Merge additional linkage macro changes from the branch. (check-in: 8b0eb22e user: drh tags: trunk) | |
| 01:49 | Further refinement to the calling convention macros. (check-in: 45588de3 user: drh tags: trunk) | |
| 01:47 | Merge updates from trunk. (check-in: 71ffa195 user: mistachkin tags: callbackConv) | |
| 01:46 | Update the autoconf makefile for MSVC. (check-in: 2daf2098 user: mistachkin tags: callbackConv) | |
| 01:32 | Undo some unhelpful changes to skip-scan scoring that were added by the check-in [9e2b2681] that improved scoring of index scan. (check-in: c7d51934 user: drh tags: trunk) | |
| 01:31 | Add macro necessary for building several extensions when the __stdcall calling convention is not in use. (check-in: bc8c9b55 user: mistachkin tags: callbackConv) | |
|
2016-07-28
| ||
| 23:58 | Missed a couple Tcl command deletion callbacks. (check-in: fc5c1876 user: mistachkin tags: callbackConv) | |
| 23:54 | Use the SQLITE_TCLAPI macro in several extensions that were missed in the previous check-in. (check-in: df254365 user: mistachkin tags: callbackConv) | |
| 22:53 | More compiler warning fixes for GCC related to the auto-extension mechanism. (check-in: b8218129 user: mistachkin tags: callbackConv) | |
| 22:46 | The return type used by the auto-extension entry points is 'int', not 'void'. (check-in: bf9c86c7 user: mistachkin tags: callbackConv) | |
| 22:38 | Make sure all the auto-extension mechanism function signatures match up precisely. (check-in: 87ba69b5 user: mistachkin tags: callbackConv) | |
| 22:23 | Make the extension auto-loading mechanism work with the __stdcall calling convention. Also, fix a couple Tcl command calling conventions missed in the previous check-in. (check-in: 3ea567c4 user: mistachkin tags: callbackConv) | |
| 19:47 | Fix further issues with multi-column IN(...) operators. Also some error handling cases surrounding row values. (check-in: cc3f6542 user: dan tags: rowvalue) | |
| 19:28 | The 'sqlite3ext.h' content should be processed before being included in the amalgamation. (check-in: cbe1de47 user: mistachkin tags: trunk) | |
| 18:55 | Decorate all interfaces with calling convention macros. (check-in: fd784887 user: drh tags: trunk) | |
| 18:49 | All SQLite API functions and callbacks in the 'sqlite3ext.h' header file must be decorated with the calling convention. (Closed-Leaf check-in: 97fc6e43 user: mistachkin tags: callbackConv) | |
| 18:42 | Merge recent trunk fixes. (check-in: 97657445 user: drh tags: apple-osx) | |
| 18:38 | Disable the authorizer callback when reparsing the schema. This avoids undesirable authorization failures following an ALTER TABLE. (check-in: 805d01cd user: drh tags: trunk) | |
| 18:18 | Fixup reserved function pointers in the Tcl stubs table and several macros containing Tcl function pointers. (check-in: 959cd013 user: mistachkin tags: callbackConv) | |
| 18:06 | Adjustments to get 'testfixture.exe' compiling with Tcl 8.6 when __stdcall is enabled. (check-in: 90e89ec9 user: mistachkin tags: callbackConv) | |
| 17:24 | Improvements to the way the COMPILER compile-time option is set when compiling with Clang. (check-in: 81f9cf86 user: drh tags: trunk) | |
| 17:11 | Make sure the SQLITE_TCLAPI macro is always defined and use it for all callback functions that must interface with the Tcl C API. (check-in: f2f1323c user: mistachkin tags: callbackConv) | |
| 16:09 | More work on getting the 'testfixture.exe' target to work correctly. (check-in: 36b72fd6 user: mistachkin tags: callbackConv) | |
| 15:38 | Modify the mksqlite3h.tcl tool to handle the syscall typedef specially. (check-in: 478a84ef user: mistachkin tags: callbackConv) | |
| 15:09 | Change mksqlite3h.tcl to automatically insert the SQLITE_CALLBACK calling convention macros. (check-in: 11ab9c9a user: drh tags: callbackConv) | |
| 14:37 | Allow the 'testfixture.exe' target to be compiled with the __stdcall calling convention. (check-in: e8be3dfe user: mistachkin tags: callbackConv) | |
| 13:59 | Merge latest trunk changes into this branch. (check-in: 9685880f user: dan tags: rowvalue) | |
| 12:52 | New test case to insure legacy CREATE TABLE syntax is supported. (check-in: 6feff15c user: drh tags: trunk) | |
| 04:14 | Work in progress on setting a calling convention for all callback functions. (check-in: 02b8040e user: mistachkin tags: callbackConv) | |
|
2016-07-27
| ||
| 19:33 | Fix some problems with multi-column IN(SELECT...) processing. (check-in: 719a3b20 user: dan tags: rowvalue) | |
| 19:30 | Enhance the query planner cost estimation for index scans to take into account WHERE clause terms that can be computed using only the index and that do not require looking up rows in the original table. This fixes an obscure performance regression that arose when the ORDER BY LIMIT optimization was added by check-in [bf46179d44843]. (check-in: 9e2b2681 user: drh tags: trunk) | |
| 19:20 | Add test cases and fix a comment. (Closed-Leaf check-in: 50f8ea37 user: drh tags: improved-index-scan) | |
| 18:27 | When estimating the cost of an index scan, factor in the cost savings of being able to use the index to evaluate some WHERE clause terms without having to do a table lookup. (check-in: a59b5622 user: drh tags: improved-index-scan) | |
| 16:03 | Initialize a variable in where.c to avoid a valgrind warning. (check-in: 4d59df02 user: dan tags: trunk) | |
|
2016-07-26
| ||
| 18:15 | Merge latest trunk changes into this branch. (check-in: d4f3d52c user: dan tags: rowvalue) | |
| 18:06 | Fix where.c handling of "IN (SELECT ...)" expressions when the SELECT returns more than one result column. Also error handling for other row value constructor cases. (check-in: 061b8006 user: dan tags: rowvalue) | |
| 15:17 | Merge fixes to sqlite3_scrub_backup() from trunk. (check-in: 91e811f5 user: drh tags: apple-osx) | |
| 10:46 | Ensure that the sqlite3_scrub_backup() extension creates a backup database at least as large as indicated by the database header, even if the last page of the input database is a free-list leaf. (check-in: 483994a5 user: dan tags: trunk) | |
| 04:54 | Merge the cache_spill VACUUM fix from trunk. (check-in: cc6bfdf8 user: drh tags: apple-osx) | |
| 04:49 | Copy the cache_spill setting from the main database over to the vacuum_db transient database when running a VACUUM. (check-in: c0e7d98e user: drh tags: trunk) | |
| 04:31 | Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. (check-in: b819bace user: drh tags: trunk) | |
| 04:23 | Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. (check-in: 0e9f534f user: drh tags: apple-osx) | |
|
2016-07-25
| ||
| 22:46 | Merge the VACCUM cache_size adjustment from trunk. (check-in: cdb7efd0 user: drh tags: apple-osx) | |
| 22:40 | In the VACUUM command, set the cache_size of the transient vacuum_db database to be the same as the database being vacuumed. (check-in: b78d9954 user: drh tags: trunk) | |
| 21:11 | Fix a test case in FTS5 to make it compatible with Tcl 8.5. (check-in: a495f8e7 user: drh tags: trunk) | |
| 18:50 | Add the experimental SQLITE_VACUUM_CACHE_SIZE macro. (check-in: 68ecd8e0 user: drh tags: apple-osx) | |
| 17:31 | Merge 3.14 alpha changes from trunk. (check-in: e98cefb1 user: drh tags: apple-osx) | |
| 16:10 | Minor test infrastructure changes to better support SEE testing. (check-in: 8dcb9d50 user: drh tags: trunk) | |
| 14:40 | Add a new %ifdef to parse.y so that the build works with SQLITE_OMIT_SUBQUERY. (check-in: 38a48cfb user: drh tags: trunk) | |
| 14:20 | Changes to test scripts to get them all running on OpenBSD. (check-in: 9e7bedee user: drh tags: trunk) | |
| 12:10 | Disable the DBSTATUS_CACHE_USED_SHARED tests on mac when memsys3/5 is disabled due to differences in the allocation sizes for the Darwin memory allocator. (check-in: d6f6c87c user: drh tags: trunk) | |
| 12:01 | Update the vacuummem.test script so that it works on mac as well as on linux. (check-in: ea7fb98b user: drh tags: trunk) | |
| 11:57 | If both MEMSYS3 and MEMSYS5 are enabled, than automatically disable MEMSYS3. (check-in: ccc22e14 user: drh tags: trunk) | |
| 11:39 | Another attempt at getting --enable-memsysN working. (check-in: 5f40e6ad user: drh tags: trunk) | |
| 11:32 | Fix the --enable-memsysN options in configure so that they actually work. (check-in: 67955255 user: drh tags: trunk) | |
| 11:27 | Add --enable-memsys3 and --enable-memsys5 options to the configure script. (check-in: 67e1dc98 user: drh tags: trunk) | |
| 02:42 | Evidence marks and code reformatting for SQLITE_TRACE_STMT operation. (check-in: e1e02238 user: drh tags: trunk) | |
| 02:31 | Change SQLITE_TRACE_STMT to return unexpanded SQL text in the X argument. Add documentation on how and when to use sqlite3_expanded_sql(P) to compute the expanded text for legacy sqlite3_trace() compatibility. (check-in: 163e1522 user: drh tags: trunk) | |
| 00:05 | Fix code so that the deprecated sqlite3_trace() and sqlite3_profile() interfaces are not called when SQLITE_OMIT_DEPRECATED is used. (check-in: 1c5baae3 user: drh tags: trunk) | |
|
2016-07-23
| ||
| 20:27 | Use sqlite3_trace_v2() instead of sqlite3_trace() in the shell. (check-in: c8e0539b user: drh tags: trunk) | |
| 20:24 | Allow vector IN(SELECT ...) expressions to use an index if either all the indexed columns are declared NOT NULL or if there is no difference between the expression evaluating to 0 and NULL (as in a WHERE clause). (check-in: e2fd6f49 user: dan tags: rowvalue) | |
| 19:34 | Add the json_quote() function to the JSON1 extension. (check-in: 269892ab user: drh tags: trunk) | |
| 19:18 | Small tweak to the btree balancer for improved tree balance. (check-in: 8817dedb user: drh tags: trunk) | |
| 14:50 | Fix recently added tests so that they work in all configurations. (check-in: d0bcaf0c user: drh tags: trunk) | |
| 05:22 | Add the sqlite3_expanded_sql() and sqlite3_trace_v2() interfaces. (check-in: 99a6c518 user: drh tags: trunk) | |
| 04:58 | Improvements to sqlite3_trace_v2() documentation. Fix the sqlite3VdbeExpandSql() routine to respond better to OOM conditions. (Closed-Leaf check-in: 0400f642 user: drh tags: sqlite3_trace_v2) | |
| 02:07 | Add requirements marks to the sqlite3_trace_v2() interface documentation. (check-in: ebd388e9 user: drh tags: sqlite3_trace_v2) | |
| 00:43 | Fix sqlite3VdbeExpandSql() so that it handles OOMs by always returning NULL. (check-in: 5a027fe4 user: drh tags: sqlite3_trace_v2) | |
|
2016-07-22
| ||
| 21:35 | Revise a warning fix from the previous check-in to improve clarity. Also, fix an incorrect test prefix (typo). (check-in: f50a3fd6 user: mistachkin tags: trunk) | |
| 21:26 | Fix harmless compiler warnings seen with MSVC. (check-in: 8bb6e6fc user: mistachkin tags: trunk) | |
| 20:45 | Be sure to hold the database connection mutex while calling sqlite3VdbeExpand() from within sqlite3_expanded_sql(). (check-in: 527b5ba6 user: drh tags: sqlite3_trace_v2) | |
| 20:20 | Add requirements marks to the sqlite3_expanded_sql() documentation. (check-in: 409535e6 user: drh tags: sqlite3_trace_v2) | |
| 17:58 | Merge latest trunk changes with this branch. (check-in: 60fed5cd user: dan tags: rowvalue) | |
| 10:09 | Fix a problem with upper case module names in the "sqldiff --vtab" command. (check-in: 87e25fc4 user: dan tags: trunk) | |
|
2016-07-21
| ||
| 18:02 | Add extra test cases to verify the fix in [64ca1a835]. (check-in: bf98a2de user: dan tags: trunk) | |
| 16:43 | Add new test file vacuummem.test. To test that any temporary memory used by VACUUM is freed as soon as the VACUUM has finished (not, for example, when sqlite3_close() is finally called). (check-in: 1b1ad0b2 user: dan tags: trunk) | |
|
2016-07-15
| ||
| 19:17 | Add the largely untested SQLITE_FTS5_NO_WITHOUT_ROWID compile time option to fts5. For building a dynamically loadable extension that does not use WITHOUT ROWID. (check-in: d0a1cf1c user: dan tags: trunk) | |
| 10:01 | The sqlite3_expanded_sql() function compiles, but always returns NULL, when the SQLITE_OMIT_TRACE compile-time option is used. (check-in: 53c25ebe user: drh tags: sqlite3_trace_v2) | |
| 02:55 | Merge fixes from trunk. Fix the tclsqlite.test script. (check-in: d2b1fa55 user: drh tags: sqlite3_trace_v2) | |
| 02:50 | Disable the CSV extension when virtual tables are disabled. (check-in: ec718089 user: drh tags: trunk) | |
| 01:49 | Modify the Tcl test command 'sqlite3_bind_blob' to make use of the Tcl_GetByteArrayFromObj() API. (check-in: e03c8189 user: mistachkin tags: sqlite3_trace_v2) | |
| 00:39 | Fix typo in sqlite3_trace_v2(). (check-in: 97ccf15f user: mistachkin tags: sqlite3_trace_v2) | |
| 00:23 | Corrections and enhancements for the new tests. (check-in: 20e74c63 user: mistachkin tags: sqlite3_trace_v2) | |
| 00:09 | Modify one test result to be case-insensitive. (check-in: 5ccbeeea user: mistachkin tags: sqlite3_trace_v2) | |
| 00:07 | Add tests, including some for the sqlite3_expanded_sql() API. (check-in: 8b8c0b74 user: mistachkin tags: sqlite3_trace_v2) | |
|
2016-07-14
| ||
| 23:17 | More work on the Tcl interface and tests for the sqlite3_trace_v2() API. (check-in: f3c4aa97 user: mistachkin tags: sqlite3_trace_v2) | |
| 21:26 | Initial work on the Tcl API interface to the new sqlite3_trace_v2() function. (check-in: 7b59fa40 user: mistachkin tags: sqlite3_trace_v2) | |
| 19:48 | Minor tweak the the b-tree balancer. (Closed-Leaf check-in: d2a0af7a user: drh tags: btree-tuning) | |
| 19:13 | Fix ALTER TABLE so that it does not promote the schema version past 3, as that will cause DESC indexes to go corrupt. Ticket [f68bf68513a1c]. (check-in: a7db6e45 user: drh tags: trunk) | |
| 09:22 | Fix copy/paste typo in the new sqlite3_expanded_sql() function. (check-in: e7d18c70 user: mistachkin tags: sqlite3_trace_v2) | |
| 01:13 | Fix a parameter misordering on sqlite3_trace_v2() in the loadable extension interface. (check-in: 989de2d5 user: drh tags: sqlite3_trace_v2) | |
| 01:09 | Add the sqlite3_expanded_sql() interface. Refinements to the sqlite3_trace_v2() interface to make it more useful. (check-in: 99ee7ee5 user: drh tags: sqlite3_trace_v2) | |
|
2016-07-13
| ||
| 23:18 | Legacy tests now passing. (check-in: f33526a3 user: drh tags: sqlite3_trace_v2) | |
| 22:55 | First cut at implementing the new sqlite3_trace_v2() interface. (check-in: cb0062fe user: drh tags: sqlite3_trace_v2) | |
| 21:30 | Interface design for a new sqlite3_trace_v2() method that supersedes sqlite3_trace() and sqlite3_profile(). (check-in: 0c569f75 user: drh tags: sqlite3_trace_v2) | |
| 19:48 | Modifications towards better vector IN(...) support on this branch. Not activated yet. (check-in: 34e35c71 user: dan tags: rowvalue) | |
| 13:05 | Fix harmless compiler warnings in shell.c for NetBSD. (check-in: 824b39e5 user: drh tags: trunk) | |
| 00:55 | Fix header comments and remove an unnecessary version restriction from the carray() table-valued function implementation. (check-in: 021d0fb8 user: drh tags: trunk) | |
|
2016-07-12
| ||
| 19:54 | Fix the error counter reset in Lemon generated parsers. This has no effect on SQLite. (check-in: 3ef93950 user: drh tags: trunk) | |
|
2016-07-10
| ||
| 19:35 | Merge comment typo fixes from trunk. (check-in: 728c5aa4 user: mistachkin tags: rowvalue) | |
| 19:35 | Fix typos in comments. No changes to code. (check-in: 77c692a6 user: mistachkin tags: trunk) | |
|
2016-07-09
| ||
| 20:23 | Add some support for using row value constructors in certain parts of SQL expressions. There are many bugs on this branch. (check-in: b2204215 user: dan tags: rowvalue) | |
| 17:47 | Add the "#/value-list/" style of results for approximate value matching in the do_test command of the test infrastructure. Use this new result style to make the SQLITE_DBSTATUS_CACHE_SIZE_SHARED tests cross-platform. (check-in: c869bf34 user: drh tags: trunk) | |
| 17:15 | Fix a compiler warning in test code - in the int64array_addr TCL command. (check-in: 29fb988f user: drh tags: trunk) | |
| 16:38 | Fix compiler warnings on windows. (check-in: 8b22f777 user: drh tags: trunk) | |
| 16:14 | Fix various internal #defines to conform to new C-language naming restrictions, specifically that private-use macros names must not begin with "_". (check-in: 5471aca0 user: drh tags: trunk) | |
| 00:06 | Add support for the win32-none VFS. (check-in: b5f32a89 user: drh tags: trunk) | |
|
2016-07-08
| ||
| 21:14 | Initial work on a Win32 VFS with NOP locking. (Closed-Leaf check-in: 549abe3f user: mistachkin tags: win32nolock) | |
| 19:54 | Another attempt to fix error handling in Lemon. This change is a no-op for SQLite's usage. (check-in: e1d8ef31 user: drh tags: trunk) | |
| 02:14 | In the sqldiff program, make sure the first argument to the db_prepare() utility function is always a valid format string. (check-in: 8bb8d886 user: drh tags: trunk) | |
|
2016-07-06
| ||
| 18:42 | Add the SQLITE_DBSTATUS_CACHE_USED_SHARED sqlite3_db_status() parameter. This option is similar to DBSTATUS_CACHE_USED, except that it divides memory used by shared caches evenly between all connections. (check-in: 06cf2680 user: dan tags: trunk) | |
| 18:12 | Change the name of the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED to SQLITE_DBSTATUS_CACHE_USED_SHARED. (Closed-Leaf check-in: d58401ab user: dan tags: dbstatus-prop-cache-used) | |
| 10:17 | Fix a test script problem causing a test to fail if the ICU extension is enabled. (check-in: 0c228f5d user: dan tags: trunk) | |
| 10:12 | Add the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED sqlite3_db_status() parameter. (check-in: 118321c8 user: dan tags: dbstatus-prop-cache-used) | |
| 09:19 | Fix a memory leak in recently added test code. (check-in: 724e4cdc user: dan tags: trunk) | |
| 08:32 | Fix a typo in test program bc_test1.c. (check-in: 2c61b7ab user: dan tags: begin-concurrent) | |
|
2016-07-05
| ||
| 16:11 | More fixes to Lemon so that it automatically resets its error counter at the end of a parse. (check-in: 2683b375 user: drh tags: trunk) | |
| 12:47 | Attempt to reset the error count in the Lemon-generated parser after a parse failure. (check-in: 91889fa3 user: drh tags: trunk) | |
|
2016-07-04
| ||
| 11:47 | Add the sqlite3rbu_state() API. Used to determine the current state (creating OAL, ready to move OAL, incremental-checkpoint, finished or error) of an RBU operation. (check-in: 0357875f user: dan tags: trunk) | |
| 11:34 | Add the carray() virtual table as a loadable extension. (check-in: d8bc6feb user: drh tags: trunk) | |
|
2016-07-03
| ||
| 02:35 | Change the name of the intarray() extension to carray() and give it an optional third parameter that specifies the datatype as one of 'int32', 'int64', 'double', or 'char*'. 'int32' is the default. (Closed-Leaf check-in: a204ba99 user: drh tags: prototype-int-array) | |
|
2016-07-02
| ||
| 20:57 | Fix an off-by-one comparison in the intarray() virtual table. Get the intarray() virtual table tests working using the legacy makefile. (check-in: 7c3d441f user: drh tags: prototype-int-array) | |
| 20:51 | Merge the alternative table-valued function RHS of IN operator implementation from trunk. (check-in: 507fdbfb user: drh tags: prototype-int-array) | |
| 12:33 | Fix a problem in table-valued functions on the RHS of an IN operator that occurs following an OOM error. (check-in: bead151e user: drh tags: trunk) | |
| 12:08 | Add support for table-valued functions on the RHS of an IN operator. (check-in: ac6000f0 user: drh tags: trunk) | |
|
2016-07-01
| ||
| 20:12 | Fix the transitive constraint logic error that can result in a null pointer dereference. Fix for ticket [e8d439c77685eca6]. (check-in: 228a7879 user: drh tags: trunk) | |
| 19:48 | Add test cases to the transitive constraint fix. (Closed-Leaf check-in: c952af89 user: drh tags: planner-fix) | |
| 12:39 | Add the sqlite3rbu_state() API. Used to determine the current state (creating OAL, ready to move OAL, incremental-checkpoint, finished or error) of an RBU operation. (Closed-Leaf check-in: 92e7df0f user: dan tags: rbu-state-api) | |
|
2016-06-29
| ||
| 06:19 | Add the ability to have a table-valued function on the RHS of an IN operator. (check-in: ba1b441b user: drh tags: prototype-int-array) | |
| 05:08 | Another test case for the intarray($PTR,$N) virtual table. (check-in: 06e1fab7 user: drh tags: prototype-int-array) | |
| 05:00 | Add a prototype intarray($PTR,$N) table valued function. (check-in: 233b3338 user: drh tags: prototype-int-array) | |
|
2016-06-28
| ||
| 22:27 | Proposed fix for a problem in the query planner. (check-in: a33d2356 user: drh tags: planner-fix) | |
|
2016-06-26
| ||
| 04:06 | Prevent the WhereLoop.rSetup cost estimate from going negative on complex queries. (check-in: f8105085 user: drh tags: trunk) | |
|
2016-06-25
| ||
| 11:43 | Fix the handling of OP_Eq opcodes that compare a register against itself and that require an affinity change. (check-in: 507014e4 user: drh tags: trunk) | |
|
2016-06-24
| ||
| 06:23 | Fix the ctime.test script so that it works with clang. (check-in: 77e4f7a3 user: drh tags: trunk) | |
| 02:50 | Fix the Makefile.in to avoid unnecessary recompiles of sqlite3.c. (check-in: 67c39e16 user: drh tags: trunk) | |
| 02:21 | Provide for a separate default page size for TEMP and transient database files and initialize that separate default page size to 1024 instead of 4096. (Leaf check-in: a2778ae4 user: drh tags: temp-page-size) | |
|
2016-06-23
| ||
| 16:48 | Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. (check-in: b8671e94 user: dan tags: trunk) | |
| 12:35 | Fix the build for -DSQLITE_OMIT_VIRTUALTABLE (check-in: 91113142 user: drh tags: trunk) | |
|
2016-06-21
| ||
| 10:34 | Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. (Closed-Leaf check-in: 5d0a9d4c user: dan tags: sqldiff-vtab-support) | |
|
2016-06-20
| ||
| 17:25 | For a table on the rhs of a LEFT JOIN operator, do not include terms like "IS NULL" from the WHERE clause in the cursor-hint. These may be false for rows that the cursor would otherwise visit, but true for a row of all NULL values generated by the LEFT JOIN. (check-in: 913e5956 user: dan tags: trunk) | |
| 17:22 | Allow LIKE operators that appear in a WHERE clause to be included in the cursor-hint for a cursor on the rhs of a LEFT JOIN. (Closed-Leaf check-in: 7455d932 user: dan tags: cursor-hints) | |
|
2016-06-17
| ||
| 19:27 | Include WHERE terms in the cursor-hint passed to a cursor opened for the rhs of a LEFT JOIN iff we can be sure that those terms will not evaluate to true if the LEFT JOIN generates a row of NULLs. (check-in: 998095ab user: dan tags: cursor-hints) | |
| 14:59 | Fix a duplicate test name in cursorhint2.test. (check-in: fcd12b69 user: dan tags: cursor-hints) | |
| 14:47 | Fix a typo in the cursorhint2.test script. (check-in: c1a5a57c user: dan tags: cursor-hints) | |
| 14:33 | If a table is on the rhs of a LEFT JOIN, include only terms from the joins ON(...) clause in the cursor-hint passed via OP_CursorHint. (check-in: 2a2346b0 user: dan tags: cursor-hints) | |
| 13:01 | Add the json_quote() function to the JSON1 extension. (Closed-Leaf check-in: 2c3714ae user: drh tags: json_quote) | |
|
2016-06-16
| ||
| 17:14 | Add a missing OP_ColumnsUsed opcode to code for expressions like "? IN (SELECT ...)" in cases where expression can use an index that may contain NULL values. (check-in: 0b1579ca user: dan tags: trunk) | |
| 11:16 | Fix a typo in a comment on the SrcList object. (check-in: 48b555c4 user: drh tags: trunk) | |
|
2016-06-15
| ||
| 10:21 | Merge changes from trunk. (check-in: 0f707d15 user: drh tags: apple-osx) | |
|
2016-06-13
| ||
| 19:58 | Fix RBU so that it builds with -DSQLITE_ENABLE_8_3_NAMES. Fix "PRAGMA compile_options" for SQLITE_ENABLE_8_3_NAMES such that it reports the numeric setting: "1" or "2". (check-in: 0230ca17 user: drh tags: trunk) | |
| 15:59 | Fix the declaration of the table implemented by DBSTAT so that it uses correct datatypes. (check-in: a1e1cdc5 user: drh tags: trunk) | |
| 12:51 | Fix an incorrect assert() in the btree logic. (check-in: fcf6114b user: drh tags: trunk) | |
| 12:34 | Fix the "onecolumn" and "exists" methods of the TCL interface so that they work in combination with the "profile" callback. (check-in: d362ba15 user: drh tags: trunk) | |
|
2016-06-10
| ||
| 22:49 | Enhance "PRAGMA table_info" to that it provides information about eponymous virtual tables. (check-in: 53a1e5d5 user: drh tags: trunk) | |
|
2016-06-08
| ||
| 18:07 | Prefer to use partial indexes for full table scans when that is possible. (check-in: fe187432 user: drh tags: trunk) | |
| 14:04 | Add the "dbhash.exe" utility program that computes a SHA1 hash over the invariant content of an SQLite database file. Free space in the file, the page size, auto_vacuum status, text encoding, and so forth do not change the hash. Only the content matters. (check-in: f48a4ad3 user: drh tags: trunk) | |
| 13:59 | Fix an undersized buffer in the SHA1 implementation. (Closed-Leaf check-in: fb276815 user: drh tags: dbhash) | |
| 13:49 | Fix the dbhash utility so that it ignores the root page number when hashing the sqlite_master table. Add new command-line options. Add the ability to hash multiple databases with a single command. (check-in: 44f157e0 user: drh tags: dbhash) | |
| 01:03 | An initial attempt at a "dbhash" command-line utility. (check-in: 2247649c user: drh tags: dbhash) | |
|
2016-06-07
| ||
| 20:25 | Fix the walcrash4.test test module so that it works on windows. (check-in: 2091a4c9 user: drh tags: trunk) | |
|
2016-06-06
| ||
| 20:36 | In winFullPathname, translate '/X:' to 'X:' before doing anything else. (check-in: e404ad70 user: mistachkin tags: trunk) | |
| 20:27 | Translate filenames of the form "/c:/*" into just "c:/*" on WinRT and Cygwin. (SQLite has long done this for Win32/WinNT.) (check-in: f8470ffc user: drh tags: trunk) | |
| 18:17 | Fix lempar.c so that the shift-reduce optimization works for error processing. This is a Lemon issue only and has no impact on SQLite. (check-in: 3665a2f5 user: drh tags: trunk) | |
| 13:24 | Initialize the yyerrcnt variable in the lemon parser template. This has no effect on SQLite itself. (check-in: 45531654 user: drh tags: trunk) | |
| 01:54 | Small performance boost and size decrease in sqlite3BtreeMovetoUnpacked(). (check-in: e106a77d user: drh tags: trunk) | |
| 01:48 | Small performance improvement in the LIKE function. (check-in: 5fb0c354 user: drh tags: trunk) | |
| 01:14 | Btree interface refactoring: (1) The sqlite3BtreeKeySize() interface is renamed to sqlite3BtreeIntegerKey() and modified to work only for table btrees with a rowid. (2) The sqlite3BtreeDataSize() interface is renamed to sqlite3BtreePayloadSize() and modified to work with any btree. (3) The sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() routines are combined into a single sqlite3BtreePayloadFetch() routine. The result of these changes is a smaller binary and fewer CPU cycles needed to run queries. (check-in: 2d831074 user: drh tags: trunk) | |
|
2016-06-04
| ||
| 21:05 | Improved comment on cursorOwnsBtShared(). No changes to code. (Closed-Leaf check-in: 5e269c2d user: drh tags: btree-refactor) | |
| 20:58 | Fix a C99-ism and a compiler warning for MSVC. (check-in: aa53a36e user: drh tags: btree-refactor) | |
| 20:37 | Change the sqlite3BtreeKeySize() interface into sqlite3BtreeIntegerKey() and make it only work for table btrees. Change sqlite3BtreeDataSize() into sqlite3BtreePayloadSize() and make it work for all btrees. Combine sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() into a single sqlite3BtreePayloadFetch() routine. These changes seem to make the b-tree interface more rational and they reduce both binary size and CPU usage. (check-in: bef35e18 user: drh tags: btree-refactor) | |
| 17:12 | Allocate KeyInfo objects from lookaside if possible. (check-in: b411107a user: drh tags: trunk) | |
| 16:33 | Fix up speedtest1.c so that it will compile and run on SQLite versions prior to 3.6.18 (circa 2009-09-11). (check-in: 9583c0fb user: drh tags: trunk) | |
| 13:57 | Remove an unreachable branch in the UNIQUE constraint parsing. (check-in: 313e990c user: drh tags: trunk) | |
|
2016-06-03
| ||
| 18:59 | The OR optimization is usable on virtual tables with LIKE, REGEXP and/or GLOB terms in the WHERE clause. (check-in: fa3a89fc user: drh tags: trunk) | |
| 18:44 | Add support for virtual tables using a WITHOUT ROWID schema. This merge also includes enhancements to the CSV extension, which is used for testing of the new WITHOUT ROWID virtual table mechanism. (check-in: aa7e9d0c user: drh tags: trunk) | |
| 18:21 | Fix a memory leak when a WITHOUT ROWID eponymous virtual table is used. (Closed-Leaf check-in: 31b83a7d user: drh tags: without-rowid-vtab) | |
| 17:27 | Disallow access to the rowid column on WITHOUT ROWID virtual tables. (check-in: d31c2597 user: drh tags: without-rowid-vtab) | |
| 13:35 | Enhance the sqlite3_load_extension() interface to permit extensions to return SQLITE_OK_LOAD_PERMANENTLY which will prevents unloading when the database connection closes. (check-in: 5908aa4d user: drh tags: trunk) | |
| 01:01 | Performance optimizations on the CSV virtual table. Disallow WITHOUT ROWID virtual tables that have an xUpdate method, for now. (check-in: 3134b326 user: drh tags: without-rowid-vtab) | |
|
2016-06-02
| ||
| 23:13 | Add the CSV extension to the test fixture. Fix a memory leak in the CSV extension. Add test cases for the CSV extension, including one that uses a WITHOUT ROWID virtual table participating in the OR optimization. (check-in: 95f483e8 user: drh tags: without-rowid-vtab) | |
| 17:44 | Add the data= parameter to the CSV virtual table extension. (check-in: 76919104 user: drh tags: without-rowid-vtab) | |
| 16:22 | Fix corner cases in the WITHOUT ROWID virtual table logic. (check-in: a393bbb9 user: drh tags: without-rowid-vtab) | |
|
2016-06-01
| ||
| 10:37 | Fix an issue preventing RBU vacuum from working with virtual tables. (check-in: 3bd85fa5 user: dan tags: trunk) | |
| 05:02 | Fix compilation issues with the VFS stat extension. (check-in: f6e95652 user: mistachkin tags: trunk) | |
|
2016-05-31
| ||
| 21:18 | An experimental branch with code that allows virtual tables to be declared as WITHOUT ROWID tables. This might be useful for virtual tables that model external data sources that do not have a convenient way of computing a unique rowid. The current check-in almost works, but there are still serious issues. (check-in: 49638f18 user: drh tags: without-rowid-vtab) | |
| 18:44 | Add the columns=N parameter to the CSV extension. (check-in: 28ebeadd user: drh tags: trunk) | |
| 18:08 | Add the testflags parameter to the csv extension. (check-in: b93fb2fe user: drh tags: trunk) | |
| 16:22 | Add the "csv" virtual table for reading CSV files, as an extension in the ext/misc/ subfolder. (check-in: 00d3570c user: drh tags: trunk) | |
|
2016-05-30
| ||
| 08:28 | Fix an FTS5 problem (segfault or incorrect query results) with "... MATCH 'x OR y' ORDER BY rank" queries when either token 'x' or 'y' is completely absent from the dataset. (check-in: 64ca1a83 user: dan tags: trunk) | |
| 05:45 | Minor tweaks to the bc_test1 test program. (check-in: d0d0bab4 user: dan tags: begin-concurrent) | |
|
2016-05-28
| ||
| 18:53 | Experimental change to allow virtual tables to take advantage of LIKE, REGEXP and GLOB terms that are part of OR expressions within WHERE clauses. (Closed-Leaf check-in: 242507b4 user: dan tags: vtab-experimental) | |
| 17:45 | Remove an unnecessary malloc from the vfsstat extension. (check-in: 24f258c2 user: drh tags: trunk) | |
| 17:23 | Enhance the sqlite3_load_extension() interface to permit extensions to return SQLITE_OK_LOAD_PERMANENTLY which will prevent the extensions from unloading when the database connection closes. (Closed-Leaf check-in: d3f99a5e user: drh tags: load-permanently) | |
| 15:22 | Enhance "PRAGMA compile_options" so that it shows the version of the compiler used to generate the executable, for common compilers. (check-in: 6a0f2009 user: drh tags: trunk) | |
| 15:09 | Update the amalgamation-tarball configure script so that it can use header file "readline/readline.h" with library file "libedit". (check-in: cbf72b04 user: dan tags: trunk) | |
| 15:03 | Enhance the sqlite3_load_extension() API so that the first parameter (the "db" parameter) can be NULL. An extension that is not associated with any database connection remains loaded for the life of the process. (Closed-Leaf check-in: 3a461043 user: drh tags: persistent-extensions) | |
| 14:53 | Add the vfsstat.c loadable extension - a VFS shim that measures the amount of I/O, and an eponymous virtual table that is used to extract and view the measurements. (check-in: 0987487d user: drh tags: trunk) | |
| 00:13 | Clang can define _MSC_VER in some circumstances; therefore, check for Clang first. (Closed-Leaf check-in: 3f710bc3 user: mistachkin tags: ctimeCompiler) | |
|
2016-05-27
| ||
| 21:13 | Check for Clang before GCC. (check-in: 7c2cd4b0 user: mistachkin tags: ctimeCompiler) | |
| 20:30 | Remove surplus quotation marks from the COMPILER= compile_options setting for Clang. (check-in: 5c966f20 user: mistachkin tags: ctimeCompiler) | |
| 19:34 | Remove surplus quotation marks from the COMPILER= compile_options setting for GCC. (check-in: 664c132d user: drh tags: ctimeCompiler) | |
| 18:09 | Add basic compiler information to the results of 'PRAGMA compile_options'. (check-in: d734e2df user: mistachkin tags: ctimeCompiler) | |
| 12:30 | Improvements to WHERE-clause debug tracing. Show TK_MATCH expressions and show more details on WhereTerm traces. (check-in: 71087c12 user: drh tags: trunk) | |
| 04:10 | Fix Lemon so that it actually works with -DYYSTACKDEPTH=0. (check-in: a9be4c2d user: drh tags: trunk) | |
| 01:07 | Fix the Lemon-generated parser so that it compiles with -DYYSTACKDEPTH=0. It does compile now, but there are subtle issues still. (check-in: 28d439f8 user: drh tags: trunk) | |
|
2016-05-26
| ||
| 20:56 | Add a new OP_SeekRowid opcode, that combines the functions of OP_MustBeInt and OP_NotExists. This makes the code slightly smaller and faster. (check-in: ffe80a1b user: drh tags: trunk) | |
| 20:52 | Add further instrumentation to the bc_test1.c test app. (check-in: 5528de4a user: dan tags: begin-concurrent) | |
|
2016-05-25
| ||
| 18:53 | Add the libvers.c tool in the tool/ subdirectory. (check-in: 2a41f098 user: drh tags: trunk) | |
|
2016-05-24
| ||
| 18:55 | Enhance Lemon and the parser template so that it can once again build parsers that have no unreachable branches. (check-in: 41fd46e2 user: drh tags: trunk) | |
| 18:50 | Minor change to the walcrash4.test module so that it works when SQLITE_DEFAULT_WAL_SYNCHRONOUS is set to something other than 2. (check-in: 61e239bc user: drh tags: trunk) | |
| 16:20 | Fix an obscure problem with transactions written in "PRAGMA synchronous=full" mode on systems that do not support POWERSAFE_OVERWRITE causing an xSync() call to be omitted if the last frame written by a transaction is aligned to a sector boundary. This means that if a power failure or OS crash occurs very soon after such a transaction is committed, it may be lost following system recovery. (check-in: 37de3eab user: dan tags: trunk) | |
| 00:40 | Improvements to the initialization of the push-down automoton for the Lemon-generated parser. Smaller and faster. (check-in: 3b28b68e user: drh tags: trunk) | |
|
2016-05-23
| ||
| 21:56 | Use a pointer to the top of the stack rather than an index into the stack in the Lemon-generated parser template, for about 6.6% parser performance gain. (check-in: 3c2a7705 user: drh tags: trunk) | |
| 19:02 | Avoid a minor error message when running RTREE without an sqlite_stat1 table. (check-in: 276e92f5 user: drh tags: trunk) | |
| 18:27 | Fix the rtreeG.test test case. (Closed-Leaf check-in: 9589e937 user: drh tags: tree-stat1-fix) | |
| 18:12 | Fix RTREE so that it does not run queries against the sqlite_stat1 if that table does not exist. (check-in: 48526a2f user: drh tags: tree-stat1-fix) | |
| 18:06 | Remove an extra "finish_test" from the end of rtreeC.test. (check-in: bfbb6dd8 user: drh tags: tree-stat1-fix) | |
| 16:16 | Improve the error messages generated by the rtree module when a constraint fails. (check-in: 3ad2531e user: dan tags: trunk) | |
| 16:15 | Lemon enhancement: avoid unnecessary reduce actions that convert one non-terminal into another but have no side effects. (check-in: a86e782a user: drh tags: trunk) | |
| 14:24 | Fix comment typos and improve clarity of presention in Lemon. The output should be identical. (check-in: b91a5b82 user: drh tags: trunk) | |
| 02:57 | Merge changes from trunk. (check-in: 815cc2bb user: drh tags: apple-osx) | |
| 00:10 | Update the configure script with additional hints on the location of tclConfig.sh, hints needed by the latest versions of Xcode. (check-in: 90411a28 user: drh tags: trunk) | |
|
2016-05-21
| ||
| 23:25 | More tweaks to improve the performance of the insert logic, slightly. (check-in: dec13075 user: drh tags: trunk) | |
| 20:03 | Simplify the sqlite3BtreeInsert() interface by gathering the five arguments describing the content to be inserted into the new BtreePayload structure, and thus reducing the number of parameters from eight to four. (check-in: 55f348cd user: drh tags: trunk) | |
| 19:10 | Remove some unused legacy code from the btree insert logic. (check-in: 2ce11667 user: drh tags: trunk) | |
| 18:50 | Use pthreads mutexes and conditions to synchronize threads in bc_test1. (check-in: f33aa76f user: dan tags: begin-concurrent) | |
| 12:29 | Yet another minor size reduction and performance increase in the b-tree insert logic. (check-in: 1dbaf7a1 user: drh tags: trunk) | |
| 11:23 | Small size reduction and performance increase in the sqlite3BtreeInsert() logic. (check-in: 656aa1ec user: drh tags: trunk) | |
| 00:45 | Add the shell-script used for routine performance testing. (check-in: 8e366f18 user: drh tags: trunk) | |
|
2016-05-20
| ||
| 23:51 | Add a simple TCL script for summing cachegrind information for each VDBE opcode. (check-in: 96cf821b user: drh tags: trunk) | |
| 21:40 | Another optimization on the OP_Column opcode. (check-in: 1765672c user: drh tags: trunk) | |
| 20:58 | Fix typo in comment. (check-in: 9db8f214 user: mistachkin tags: trunk) | |
| 19:51 | Slight performance improvement in the OP_Column opcode. (check-in: 5c157474 user: drh tags: trunk) | |
| 18:09 | Remove the sqlite3PagerClearCache() routine, which does not accomplish anything useful. (check-in: f250166b user: drh tags: trunk) | |
| 15:53 | Performance optimization and size reduction on the freeP4() routine. (check-in: 4dc56e86 user: drh tags: trunk) | |
| 15:24 | Increase the version number to 3.14.0 since we are already making significant code changes. (check-in: 1a0d0576 user: drh tags: trunk) | |
| 15:15 | Use sqlite3VdbeAddOp0() to code OP_Expire, to save a few bytes. (check-in: 3d55d24d user: drh tags: trunk) | |
| 14:54 | Optimizations to link list merge sort code in vdbesort.c, pcache.c, and rowset.c. Resulting binaries are 10 bytes smaller and use 0.03% fewer CPU cycles. (check-in: 9033afbb user: drh tags: trunk) | |
| 14:11 | For queries with both ORDER BY and LIMIT, if the rows of the inner loop are emitted in ORDER BY order and the LIMIT has been reached, then optimize by exiting the inner loop and continuing with the next cycle of the first outer loop. (check-in: 559733b0 user: drh tags: trunk) | |
| 13:44 | Set the NULLEQ flag on the sequence counter comparison in the ORDER BY LIMIT optimization, to avoid coverage complaints about not testing the NULL case. (Closed-Leaf check-in: ed1b30dc user: drh tags: orderby-limit) | |
| 12:22 | Autoconf configure.ac adjustment to try to get it to look for both editline and readline automatically. (check-in: 645bd696 user: drh tags: trunk) | |
| 00:21 | A few simple test cases for the ORDER BY LIMIT optimization. (check-in: 08849eab user: drh tags: orderby-limit) | |
|
2016-05-19
| ||
| 22:40 | Appears to work now. Needs test cases, more comments, and code optimization. (check-in: 990fe50c user: drh tags: orderby-limit) | |
| 22:13 | In a query with both ORDER BY and LIMIT, if the inner loop satisfies the ORDER BY then try to cut short each invocation of the inner loop once the LIMIT has been satisfied. This check-in is a partial implementation only. (check-in: 852d1eda user: drh tags: orderby-limit) | |
| 19:31 | Fixup comments on wctrlFlags value definitions. (check-in: 58b516e8 user: drh tags: trunk) | |
| 18:56 | Clean up the WHERE_* macros used for the wctrlFlags parameter on the sqlite3WhereBegin() interface, freeing up some bits to be used for other things. (check-in: d0130584 user: drh tags: trunk) | |
| 17:51 | Optimization marks in vdbe.c. No logic changes. (check-in: cf273741 user: drh tags: trunk) | |
| 16:58 | Performance improvement in the OP_Column opcode. (check-in: 4737cadc user: drh tags: trunk) | |
| 16:21 | Add test cases to test some fts3/4 edge case behaviour surrounding the '*' character. (check-in: 1f577e1f user: dan tags: trunk) | |
| 11:12 | Small size reduction and performance improvement in the OP_Column opcode. (check-in: 0d773061 user: drh tags: trunk) | |
|
2016-05-18
| ||
| 21:03 | Add the "scrub" utility program that simultaneously backs-up a live database and erases all deleted content. (check-in: c981ab2a user: drh tags: trunk) | |
| 21:01 | Omit the unnecessary WHERE_REOPEN_IDX flag in the WHERE interface. (check-in: 915416d1 user: drh tags: trunk) | |
| 20:53 | Merge the 3.13.0 release changes. (check-in: e2e9b985 user: drh tags: apple-osx) | |
| 10:57 | Version 3.13.0 (check-in: fc49f556 user: drh tags: trunk, release, version-3.13.0) | |
|
2016-05-17
| ||
| 21:17 | Enhance the scrub utility program so that it does a FULL checkpoint prior to starting the backup, to ensure that the database file content matches what needs to be backed up without having to look at the WAL file. (Closed-Leaf check-in: ab1c5ce5 user: drh tags: scrub-backup) | |
| 17:11 | Merge the latest changes from trunk. (check-in: 5021dfe1 user: drh tags: scrub-backup) | |
|
2016-05-16
| ||
| 14:35 | Do not run snapshot_fault.test as part of the inmemory_journal permutation. (check-in: 995c084b user: dan tags: trunk) | |
| 13:37 | Merge recent fixes from trunk. (check-in: 0d9b82af user: drh tags: apple-osx) | |
| 11:55 | Disable shell.exe test cases for UTF8 filenames as they do not work on MinGW. (check-in: 386bcbba user: drh tags: trunk) | |
|
2016-05-13
| ||
| 17:22 | Improvements to a comment in the pcache.c file. No changes to code. (check-in: b369980f user: drh tags: trunk) | |
| 15:22 | Remove the unused PGHDR_NEED_READ flag. Add invariant checking (during SQLITE_DEBUG builds only) for the PgHdr object. (check-in: 771c5411 user: drh tags: trunk) | |
| 12:12 | Clarification of the pagerFlushOnCommit() logic. (check-in: 3401d9dc user: drh tags: trunk) | |
| 11:50 | Fix pager_end_transaction() to ensure that a ROLLBACK does not clobber unwritten pages in a TEMP file pcache. (check-in: 9495d338 user: drh tags: trunk) | |
| 04:24 | Additional debugging and tracing logic for pcache.c, turned off by default using an "#if 0". (check-in: 32a62e3b user: drh tags: trunk) | |
|
2016-05-12
| ||
| 19:17 | Disable ALWAYS and NEVER when compiled with SQLITE_MUTATION_TEST. (check-in: 24d9fbc1 user: drh tags: trunk) | |
| 19:05 | Simplification of the sqlite3FaultSim() call inside of sqlite3PagerCommitPhaseOne(). (check-in: 1b0f4cc3 user: drh tags: trunk) | |
| 18:38 | Add an assert in pager.c to confirm that pPager->tempFile is always true for in-memory databases. (check-in: 3fd71092 user: drh tags: trunk) | |
| 17:06 | Add extra OPTIMIZATION-IF-FALSE comments where required to pcache.c. (check-in: 9d55b8f5 user: dan tags: trunk) | |
| 12:08 | For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". (check-in: 06c1e27c user: drh tags: trunk) | |
| 12:01 | Remove an unnecessary call to sqlite3PcacheMakeClean() inside of the ROLLBACK logic. (check-in: 0dc50d99 user: drh tags: trunk) | |
| 09:48 | Add a missing OPTIMIZATION-IF-FALSE comment to pcache.c. (check-in: bc202e5b user: dan tags: trunk) | |
|
2016-05-11
| ||
| 23:54 | For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". (Closed-Leaf check-in: ad601c79 user: drh tags: pager-dev) | |
| 20:03 | Remove a redundant condition from pcache.c. Add an OPTIMIZATION-IF-TRUE comment to another condition that requires it. (check-in: 3bfd2621 user: dan tags: trunk) | |
| 18:20 | Remove a redundant condition from pcache.c. Add an OPTIMIZATION-IF-TRUE comment to another condition that requires it. (Closed-Leaf check-in: 4533ed35 user: dan tags: mistake) | |
| 15:41 | Remove some a small amount of redundant code related to PCache.pSynced from pcache.c. (check-in: 9cc8cad7 user: dan tags: trunk) | |
| 12:47 | Do not reset the page cache when a rollback journal truncate fails, as doing so can cause loss of information for an in-memory TEMP file. (check-in: 345ce1c9 user: drh tags: trunk) | |
| 11:04 | Always truncate, rather than persist, the rollback journal of a TEMP database. (check-in: 42fb6f1e user: drh tags: trunk) | |
| 10:57 | Add pcache tracing macros. Off by default. Requires changing an "#if 0" and recompiling to enable. (check-in: d9313d19 user: drh tags: trunk) | |
|
2016-05-10
| ||
| 20:16 | Add another test case to temptable3.test. (check-in: 22364024 user: dan tags: trunk) | |
| 20:03 | Fix a problem in sqlite3PagerMovepage() when working on a temp table for which pages have been spilled. (check-in: 20cf8811 user: drh tags: trunk) | |
|
2016-05-09
| ||
| 23:11 | Fixes to requirements marks. No changes to code. (check-in: 79ecd0ef user: drh tags: trunk) | |
| 22:35 | Enhancements to test/sort5.test so that it works with SEE. (check-in: 8a39c8ee user: drh tags: trunk) | |
| 22:32 | Remove some forgotten debugging lines from test/sort5.test. (check-in: f5875489 user: drh tags: trunk) | |
| 19:58 | Omit the unnecessary WHERE_REOPEN_IDX flag in the WHERE interface. (Closed-Leaf check-in: da94a6e0 user: drh tags: dev) | |
| 19:03 | Update a comment in fts5.h. No changes to code. (check-in: 14e53d0e user: dan tags: trunk) | |
| 18:05 | Fix the FTS5 xQueryPhrase() API function so that it recognizes column filters. (check-in: 48505cde user: dan tags: trunk) | |
|
2016-05-07
| ||
| 18:02 | Add options to bc_test1.c to make it more flexible. (check-in: ec6ef5f2 user: dan tags: begin-concurrent) | |
| 12:15 | Make the sqlite3DeleteTable() routine smaller and faster. (check-in: d75140b8 user: drh tags: trunk) | |
| 12:15 | Fix typo in the intpkey-17.2 test. (check-in: a45fda65 user: drh tags: trunk) | |
|
2016-05-06
| ||
| 21:04 | Add test/bc_test1.c, for testing the degree of concurrency provided by this branch under various conditions. (check-in: 128c7eae user: dan tags: begin-concurrent) | |
| 20:23 | Simplification to the logic used to decide between OP_Seek and OP_NotExists. Use OP_NotExists for both DELETE and UPDATE. (check-in: 3a695263 user: drh tags: trunk) | |
| 18:47 | Corrections to comments on the whereScanInit() interface. (check-in: ab7ab415 user: drh tags: trunk) | |
| 16:49 | For DELETE operations, make sure that seeks on the main table are not deferred, since if they are and none of the indexes reference columns of the table, the seek might never occur until the OP_Delete opcode, which is too late. Fix for ticket [16c9801ceba49]. (check-in: 93a2bace user: drh tags: trunk) | |
| 16:30 | Fix an error in main.mk causing testfixture to use individual fts5 source code files instead of fts5.c. (check-in: 933a1c81 user: dan tags: trunk) | |
| 16:06 | In the WHERE generator, when building code for a DELETE operation, make sure that seeks to the main table are not deferred. This is a better fix for the [16c9801ceba49] bug than the previous. (Closed-Leaf check-in: 150dd09e user: drh tags: ticket-16c9801ce) | |
| 15:16 | Fix a bug in sqlite_analyzer causing it report (slightly) incorrect values for the number of entries in indexes or WITHOUT ROWID tables. (check-in: dc37750d user: dan tags: trunk) | |
| 11:31 | Do not scan indexes that have the integer primary key as their left-most column. This fixes the crash of ticket [16c9801ceba] but it seems like the wrong fix. More investigation needed. (check-in: 50312273 user: drh tags: ticket-16c9801ce) | |
|
2016-05-05
| ||
| 23:59 | Additional error reporting. Open the source database read/write so that it can delete the WAL file when done. (check-in: d2efd3c1 user: drh tags: scrub-backup) | |
| 23:39 | Working when run against sqlite.fossil. (check-in: b0bd9dd6 user: drh tags: scrub-backup) | |
| 23:09 | Finished implementation compiles, but untested. (check-in: aeb88bdf user: drh tags: scrub-backup) | |
| 17:15 | Initial check-in of the "scrub.exe" utility program prototype. Not yet fully functional. In particular, no scrubbing is done. (check-in: bdf2ec77 user: drh tags: scrub-backup) | |
| 11:53 | Renumber internal constants in the printf() implemention for a small performance improvement. (check-in: 69d11447 user: drh tags: trunk) | |
|
2016-05-04
| ||
| 21:06 | Disable the session extension API if SQLITE_ENABLE_SESSION is not defined. (check-in: 71af9ac1 user: drh tags: trunk) | |
| 19:04 | Fix typo in comment. No changes to code. (check-in: 6c43ba1c user: mistachkin tags: trunk) | |
| 14:45 | Only disable the one-pass DELETE optimization if the WHERE clause contains a correlated subquery. Uncorrelated subqueries are allowed. This is a refinement of check-in [3f221f592a9a1] that is the fix for ticket [dc6ebeda9396087]. (check-in: aae38969 user: drh tags: trunk) | |
| 14:20 | Portability enhancements to the configure script on the amalgamation tarball. (check-in: 7184c4b8 user: drh tags: trunk) | |
| 11:28 | Disable the PagerDontWrite() optimization for temp tables. It can cause database corruption if a page passed to PagerDontWrite() is dirty at the start of a transaction that is subsequently rolled back. (check-in: 6341ab2f user: dan tags: trunk) | |
|
2016-05-03
| ||
| 19:40 | Minor style tweaks in the MSVC makefile. (check-in: 1b43358f user: mistachkin tags: trunk) | |
| 19:36 | Add the experimental SQLITE_FCNTL_WIN32_GET_HANDLE file control. (Leaf check-in: b6ddabe1 user: mistachkin tags: win32GetHandle) | |
| 14:57 | The session extension is disabled by default. To enable it using --enable-session on ./configure on unix and add SESSION=1 to the nmake on Windows. Or add -DSQLITE_ENABLE_SESSION and -DSQLITE_ENABLE_PREUPDATE_HOOK to build manually. (check-in: bcaa650e user: drh tags: trunk) | |
| 13:14 | Turn the session extension off by default. Enable using --enable-session on configure scripts, or using the SESSION=1 argument to nmake on Windows. (Closed-Leaf check-in: e462cde2 user: drh tags: session-make) | |
| 02:43 | Fix the build when SQLITE_ENABLE_DATA_PROTECTION is defined. (check-in: 8f05e140 user: drh tags: apple-osx) | |
| 00:04 | Avoid left-shifts of signed integers. (check-in: 0715ce16 user: drh tags: trunk) | |
|
2016-05-02
| ||
| 19:05 | Remove some randomness from test script temptable2.test. (check-in: 5830cf72 user: dan tags: trunk) | |
| 16:59 | Fix a test case in temptable2.test so that it works on systems that lack a coherient cache (ex: OpenBSD) and thus do not support the "PRAGMA mmap_size" command. (check-in: 088cf838 user: drh tags: trunk) | |
| 15:00 | Merge enhancements and bug fixes from trunk. (check-in: f52765ee user: drh tags: apple-osx) | |
| 13:57 | Fix harmless LLVM compiler warnings in the srcck1.c utility program used during the build process. (check-in: e4af9675 user: drh tags: trunk) | |
| 12:18 | Disable the multi-row one-pass DELETE optimization when the WHERE clause contains a subquery. Fix for ticket [dc6ebeda9396087]. (check-in: 3f221f59 user: drh tags: trunk) | |
| 10:25 | Improvements to the way the LIKE optimization is implemented, resulting in slightly smaller and faster code that is easier to test. (check-in: 54c63b32 user: drh tags: trunk) | |
|
2016-04-30
| ||
| 19:23 | Change the way tester.tcl handes $argv so that in "permutations.test <permutation> <filename>" <filename> may be the name of any file in the test/ directory. (check-in: 820c57bb user: dan tags: trunk) | |
| 18:10 | Remove an unnecessary branch from the OP_String8 opcode. (check-in: 459a0b45 user: drh tags: trunk) | |
| 17:19 | More bug fixes to Lemon identified by Kelvin Sherlock. None of these have any impact on SQLite. (check-in: 762bdc55 user: drh tags: trunk) | |
| 02:59 | Simplifications to the OP_Halt opcode implementation. (check-in: daf4630f user: drh tags: trunk) | |
|
2016-04-29
| ||
| 20:30 | Fix the temporary directory search algorithm for unix so that it fails gracefully even if all candidate directories are inaccessible. This fixes a bug that was introduced by check-in [9b8fec60d8e]. (check-in: 614bb709 user: drh tags: trunk) | |
| 17:07 | Fix the nolock VFS so that it supports shared memory. (check-in: ce11f8e8 user: drh tags: apple-osx) | |
| 16:01 | Merge the latest enhancements from trunk. (check-in: 91e5c07e user: drh tags: begin-concurrent) | |
| 15:52 | Merge enhancements from trunk, and in particular the TEMP file deferred I/O enhancements. (check-in: 81b76901 user: drh tags: apple-osx) | |
| 15:39 | Postpone I/O associated with TEMP files for as long as possible, with the hope that the I/O can ultimately be avoided completely. (check-in: 9d0a5ae0 user: drh tags: trunk) | |
| 14:12 | Fix test script temptable2.test so that it works with the "inmemory_journal" and "journaltest" permutations. (Closed-Leaf check-in: b7bec7f2 user: dan tags: tempfiles-25) | |
| 11:35 | Merge latest trunk changes, including test case fixes, with this branch. (check-in: 99794aca user: dan tags: tempfiles-25) | |
| 11:33 | Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script. Fix a mostly harmless buffer overread in the sessions module. (check-in: 4cbd5024 user: dan tags: trunk) | |
| 11:28 | Lemon bug fix: Do not merge action routines unless their destructors are also identical. Problem and suggested fix reported on the mailing list by Kelvin Sherlock. (check-in: 4792d6db user: drh tags: trunk) | |
| 10:13 | Fix an almost entirely harmless buffer overread in the sessions module. (Closed-Leaf check-in: 89b0ee33 user: dan tags: permutations-fix) | |
| 02:55 | Some optimization comments added to vdbe.c. No functional changes to code. (check-in: e7c22e3b user: drh tags: trunk) | |
|
2016-04-28
| ||
| 22:29 | Further simplifications and improved commentting on the rowset.c module, including several optimization comments. (check-in: 9f15a520 user: drh tags: trunk) | |
| 20:11 | Comment changes only: Add several optimization marks in rowset.c. Add a header comment that explains what the various special comments mean. (check-in: 8cdbe89a user: drh tags: trunk) | |
| 19:23 | Fix typo in comment. No changes to code. (check-in: 9f6f17b5 user: mistachkin tags: trunk) | |
| 18:53 | Rearrange some code in the RowSet logic for clarity of presentation, while adding an /*OPTIMIZATION-IF-TRUE*/ comment. It should operate identically. (check-in: 5748e643 user: drh tags: trunk) | |
| 14:59 | Merge latest changes from trunk with this branch. (check-in: 45467ee4 user: dan tags: permutations-fix) | |
| 14:54 | Avoid running sessionfault.test and sessionfault2.test as part of the "inmemory_journal" permutation. (check-in: 5973d3bf user: dan tags: permutations-fix) | |
| 14:15 | Use comments to mark several branches as optimizations. No changes to code. (check-in: 33e62747 user: drh tags: trunk) | |
| 09:53 | Ensure that quota.test deletes the directory named "test.db" that it creates. (check-in: 045edd4b user: dan tags: permutations-fix) | |
| 03:52 | Remove an unnecessary conditional from the sqlite3DecOrHexToI64() routine. (check-in: fcf85bfe user: drh tags: trunk) | |
| 00:32 | Change the sqlite3Atoi64() routine so that it returns failure if not all of the input characters are consumed, even if it consumed all characters up to the first 0x00. This has no impact on external APIs as far as I can tell. (check-in: 46d4ffff user: drh tags: trunk) | |
|
2016-04-27
| ||
| 18:54 | Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script. (check-in: 2662d8fe user: dan tags: permutations-fix) | |
| 15:24 | More simplification of the sqlite3AtoF() routine. Add special comments to indicate branches that are for optimization purposes only and that give the correct answer even if always or never taken. (check-in: 0065fe97 user: drh tags: trunk) | |
| 11:24 | Fix a couple of test script problems on this branch. Both related to the fact that temp database page sizes can no longer be changed by VACUUM or the backup API after the temp db is populated. (check-in: 6bb5aa2b user: dan tags: tempfiles-25) | |
| 02:35 | Remove still more unnecessary branches from sqlite3AtoF(). (check-in: 3adfe9f3 user: drh tags: trunk) | |
|
2016-04-26
| ||
| 23:14 | Further simplifications to sqlite3AtoF() to remove unneeded branches. (check-in: dd69e53c user: drh tags: trunk) | |
| 21:02 | Remove an unnecessary line from the sqlite3AtoF() routine. (check-in: a9d00749 user: drh tags: trunk) | |
| 18:58 | The pcache and the built-in VFSes should not use mutexes when SQLITE_CONFIG_SINGLETHREAD is set. (check-in: 12418b10 user: drh tags: trunk) | |
| 17:10 | Fix an issue in temptable2.test preventing it from working with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: e790aac0 user: dan tags: tempfiles-25) | |
| 16:03 | Merge the checksymbols fix from trunk into this branch. (check-in: 04911cee user: dan tags: tempfiles-25) | |
| 13:13 | Fix the "checksymbols" target in Makefile.in to be able to deal with the sqlite3changegroup family of interfaces. (check-in: d819bfbd user: drh tags: trunk) | |
|
2016-04-25
| ||
| 22:39 | Add an sqlite3FaultSim() all to make it easier to simulate IO errors in a VACUUM commit. (check-in: 8bfde416 user: drh tags: tempfiles-25) | |
| 19:28 | Remove an obsolete comment from the pager. No code changes. (check-in: 36f97ca8 user: drh tags: tempfiles-25) | |
| 19:25 | Update the RBU vacuum code so that databases that use custom collation sequences can be vacuumed. (check-in: 7dd48c10 user: dan tags: trunk) | |
| 19:20 | Fix some unreachable branches in the pager. (check-in: 3ae44770 user: drh tags: tempfiles-25) | |
| 15:03 | Merge bug fix from trunk. (check-in: a905d5e0 user: drh tags: tempfiles-25) | |
| 02:20 | When checking for the WHERE-clause push-down optimization, verify that all terms of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket [f7f8c97e97597]. (check-in: ec215f94 user: drh tags: trunk) | |
| 01:43 | Fix a typo in the Makefile. (check-in: d0a579b3 user: mistachkin tags: trunk) | |
|
2016-04-23
| ||
| 21:16 | Merge the temporary directory search algorithm fix from trunk. (check-in: 9b8fec60 user: drh tags: tempfiles-25) | |
| 20:59 | Fix the fix to the temporary directory search algorithm so that it continues to return "." as a fallback if that directory has the correct permissions. (check-in: b38fe522 user: drh tags: trunk) | |
| 19:55 | Merge the latest trunk changes. (check-in: 84da122d user: drh tags: tempfiles-25) | |
| 17:24 | Fix a problem with mixing temp-files and mmap-mode. (check-in: c80c5c62 user: dan tags: tempfiles-25) | |
| 14:55 | Fix some problems to do with temp-file databases and recovering from IO and SQLITE_FULL errors. (check-in: 3d61da4a user: dan tags: tempfiles-25) | |
|
2016-04-21
| ||
| 23:37 | Change the temporary directory search algorithm on unix so that directories with only -wx permission are allowed. And do not allow "." to be returned if it lacks -wx permission. (check-in: 67985761 user: drh tags: trunk) | |
| 18:13 | Add the sqlite3rbu_vacuum() API, to create an RBU handle that can be used to rebuild a database in the same way as the VACUUM command. (check-in: bd4a6f83 user: dan tags: trunk) | |
| 16:44 | If a call to sqlite3rbu_close() on an rbu handle opened by sqlite3rbu_vacuum() returns other than SQLITE_OK, delete the contents of the rbu_state table. This ensures that if an RBU vacuum operation either completes successfully or encounters an error, the next call to sqlite3rbu_vacuum() with the same parameters starts a new RBU vacuum operation. (Closed-Leaf check-in: 6e4ac704 user: dan tags: rbu-vacuum) | |
| 15:44 | Merge the latest changes from trunk. (Closed-Leaf check-in: 8183fa68 user: drh tags: skip-ahead-distinct) | |
| 15:35 | Merge all recent enhancements from trunk. (check-in: a15c49ae user: drh tags: apple-osx) | |
| 15:26 | Fix a problem in rbu vacuum on tables with a large sqlite_master table. (check-in: 23eac52e user: dan tags: rbu-vacuum) | |
| 15:24 | Add a function prototype in order to fix a compiler warning. (check-in: 49aec971 user: drh tags: tempfiles-25) | |
| 15:03 | Merge updates from trunk. (check-in: cc28106e user: drh tags: tempfiles-25) | |
| 02:27 | Add the SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION method for enabling sqlite3_load_extension() while leaving the load_extension() SQL function disabled. (check-in: c4f165c4 user: drh tags: trunk) | |
| 01:58 | Test cases for SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION. (Closed-Leaf check-in: debafa5e user: drh tags: load-ext-security) | |
| 01:30 | Revert sqlite3_enable_load_extension() to its original long-standing behavior. Add SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION which will enable only the C-API and leave the SQL function disabled. (check-in: b2ae5bfa user: drh tags: load-ext-security) | |
|
2016-04-20
| ||
| 20:08 | Add a documentation comment for sqlite3rbu_vacuum() to sqlite3rbu.h. (check-in: da5c753d user: dan tags: rbu-vacuum) | |
| 19:30 | When an error occurs while transitioning out of WAL mode, make sure the locking state is not left at EXCLUSIVE. (check-in: 3340f086 user: drh tags: trunk) | |
| 18:31 | Fix a locking race condition in Windows 10 that can occur when two or more processes attempt to recover the same hot journal at the same time. (check-in: 38a4e9d9 user: drh tags: trunk) | |
| 17:47 | Add fault injection tests for rbu vacuum. Fix some problems revealed by the same. (check-in: f042fdd1 user: dan tags: rbu-vacuum) | |
| 12:16 | Merge all recent enhancements from trunk. (check-in: 1f709fbf user: drh tags: begin-concurrent) | |
| 00:30 | API Change: Modify sqlite3_enable_load_extension() so that it only enables/disables the load_extension() SQL function, and leaves the C-APIs enabled at all times. In this way, applications can enable extension loading for the C interface without having to expose that capability to the SQL. (check-in: edb454e4 user: drh tags: load-ext-security) | |
|
2016-04-19
| ||
| 19:27 | Updates to ensure the values of PRAGMA settings like "page_size", "auto_vacuum", "user_version" and "application_id" are not lost when a database is RBU vacuumed. (check-in: 74ffea76 user: dan tags: rbu-vacuum) | |
| 17:11 | When an RBU vacuum is started on a db identified using a URI filename, pass the same URI parameters when creating the new version of the db. This ensures that RBU vacuum works with password protected databases. (check-in: ca021ba8 user: dan tags: rbu-vacuum) | |
| 16:20 | Detect attempts to use rbu vacuum on a wal mode database (not allowed). And attempts to write to a database in the middle of an rbu vacuum (which prevents the vacuum from resuming). (check-in: 00b2f4b0 user: dan tags: rbu-vacuum) | |
|
2016-04-18
| ||
| 21:00 | Another fix to rbu vacuum for a zipvfs case. (check-in: 29407d70 user: dan tags: rbu-vacuum) | |
| 18:18 | Fix some zipvfs related problems in RBU vacuum. (check-in: d76f4aaa user: dan tags: rbu-vacuum) | |
| 17:30 | Version 3.12.2 (Leaf check-in: 92dc59fd user: drh tags: release, branch-3.12.0, version-3.12.2) | |
| 16:18 | Correctly interpret negative "PRAGMA cache_size" values when determining the cache-size used for sorting large amounts of data (i.e. the functionality in vdbesort.c). (check-in: 39dd67af user: drh tags: branch-3.12.0) | |
| 16:12 | Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (check-in: a2cf4968 user: drh tags: branch-3.12.0) | |
| 16:06 | Fix the sqlite3BtreeDelete() routine so that it preserves the correct key even when the row being deleted is not on a leaf page. Fix for ticket [a306e56ff68b8fa56] (check-in: 368e86c7 user: drh tags: branch-3.12.0) | |
| 15:59 | Increase the version number to 3.12.2. (check-in: 9c37e9ce user: drh tags: branch-3.12.0) | |
| 15:54 | Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (check-in: ab9d279f user: drh tags: branch-3.12.0) | |
| 15:46 | Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (check-in: eba27d4d user: drh tags: trunk) | |
| 13:36 | Merge recent trunk changes. (check-in: d9768de5 user: drh tags: tempfiles-25) | |
| 13:30 | sqlite3PCachePerecentDirty() should return 0 if the pcache is empty. (check-in: 85f3d80e user: drh tags: tempfiles-25) | |
| 13:09 | The last parameter to pread64() and pwrite64() should be off64_t, not off_t. (check-in: 3a7d7298 user: drh tags: trunk) | |
| 09:17 | Add the -vacuum switch to the "rbu" demonstration program. (check-in: 9a0078a5 user: dan tags: rbu-vacuum) | |
|
2016-04-16
| ||
| 19:02 | Changes so that rbu vacuum works with zipvfs databases. (check-in: bae7f875 user: dan tags: rbu-vacuum) | |
| 17:53 | Avoid creating any extra files ("<target>-vacuum") when running an RBU vacuum. Ensure that the OAL file created is "<target>-oal", not "<target>-vacuum-oal". (check-in: dc19aacc user: dan tags: rbu-vacuum) | |
| 15:03 | Fix a couple of assert() statements that were failing with OOM error tests. (check-in: 8eb3d7d8 user: dan tags: rbu-vacuum) | |
|
2016-04-15
| ||
| 22:03 | Add the SQLITE_SkipAhead optimization setting (check-in: 87703b76 user: drh tags: skip-ahead-distinct) | |
| 20:46 | Add the experimental sqlite3rbu_vacuum() API function. For opening an RBU handle that rebuilds a database from scratch. (check-in: 0216b48f user: dan tags: rbu-vacuum) | |
| 16:27 | Skip-ahead is now just an optimization. If it gets confused, it falls back to an incremental scan with redundancy elimination. (check-in: 6fac0b92 user: drh tags: skip-ahead-distinct) | |
| 16:17 | Skip-ahead does not always work. So we still have to check for redundancy. (check-in: db5a2364 user: drh tags: skip-ahead-distinct) | |
| 15:54 | Fixes to the skip-ahead distinct logic. More issues remain. (check-in: 45a70b2b user: drh tags: skip-ahead-distinct) | |
| 15:06 | Merge enhancements from trunk, especially the ".eqp full" enhancement to the command-line shell. (check-in: 491f0dbd user: drh tags: skip-ahead-distinct) | |
| 15:03 | CLI enhancement: Add the ".eqp full" option, that shows both the EXPLAIN QUERY PLAN and the EXPLAIN output for each command run. Also disable any ".wheretrace" and ".selecttrace" when showing EQP output. (check-in: 3e217d62 user: drh tags: trunk) | |
| 14:13 | Several new test cases that cause failures. (check-in: 0379f2cf user: drh tags: skip-ahead-distinct) | |
| 13:24 | Fixed crash bugs. Still sometimes gets the wrong answers. (check-in: 2afcb2c7 user: drh tags: skip-ahead-distinct) | |
| 01:55 | Progress toward getting DISTINCT to use a seek to advance to the next distinct row, when driven by an appropriate index. (check-in: 9e14aa14 user: drh tags: skip-ahead-distinct) | |
|
2016-04-14
| ||
| 19:29 | Work toward improving analysis and code generation for DISTINCT and aggregate queries. (Leaf check-in: 129083bd user: drh tags: better-distinct-agg) | |
| 17:29 | In the ICU extension toupper() and tolower() SQL functions, avoid calling u_strToUpper() or u_strToLower() a second time if the buffer passed to the first invocation turns out to be large enough. (check-in: d23e5813 user: dan tags: trunk) | |
| 16:40 | Add the SF_HasAgg constant (currently unused). Also enhance the comments on many other constant definitions to detail constraints on their values. (check-in: 7b7a69d0 user: drh tags: trunk) | |
| 15:44 | Correctly interpret negative "PRAGMA cache_size" values when determining the cache-size used for sorting large amounts of data (i.e. the functionality in vdbesort.c). (check-in: 79147dca user: dan tags: trunk) | |
| 15:38 | Add some missing testcase() macros to the pushDownWhereTerms() routine. (check-in: 67d7f79c user: drh tags: trunk) | |
| 13:35 | Rename WhereInfo.pResultSet to pDistinctSet to more accurately reflect what it represents. (check-in: 53179614 user: drh tags: trunk) | |
| 13:16 | Since the return value of sqlite3OsClose() is always ignored, we might as well make it "void" instead of "int", and thereby save 50 bytes in the compiled binary. (check-in: 7ee570e7 user: drh tags: trunk) | |
| 13:06 | Additional ".selecttrace" debugging output when the query is transformed from a DISTINCT into a GROUP BY. (check-in: 5a469145 user: drh tags: trunk) | |
|
2016-04-13
| ||
| 21:00 | Fix compiler warnings by removing surplus local variables in the schema pretty-printer logic of the command-line shell. (check-in: 55a62483 user: drh tags: trunk) | |
| 19:20 | Merge enhancements from trunk via tempfiles-lazy-open. (check-in: ae16310c user: drh tags: tempfiles-25) | |
| 16:52 | On commit, flush dirty temp-file pages only if the file is already open and 25% or more of the cache is dirty. (check-in: f6babf29 user: dan tags: tempfiles-25) | |
| 16:02 | Merge enhancements from trunk. (Closed-Leaf check-in: e2edd34e user: drh tags: tempfiles-lazy-open) | |
| 15:52 | Fixes for harmless compiler warnings. (check-in: 68142dc5 user: drh tags: trunk) | |
| 15:33 | Add the --indent option to the .schema and .fullschema commands in the shell, to enable simple but effective pretty-printing. (check-in: 83cfe82c user: drh tags: trunk) | |
|
2016-04-12
| ||
| 20:26 | A couple more compiler warning fixes. (Closed-Leaf check-in: 929fa4c3 user: mistachkin tags: warnings) | |
| 20:15 | Even more compiler warning fixes. (check-in: 7faec9ea user: mistachkin tags: warnings) | |
| 20:05 | More harmless compiler warning fixes. (check-in: ab69527c user: mistachkin tags: warnings) | |
| 19:30 | Compilation fix for a C99-ism in the 'fts3view' tool. (check-in: bedb88a4 user: mistachkin tags: trunk) | |
| 19:20 | Fix harmless compiler warnings in the 'session' module. (check-in: a18a6ce2 user: mistachkin tags: trunk) | |
| 19:09 | Once a temporary database file has been opened, flush all dirty pages to disk when comitting a transaction. (check-in: bbac71aa user: dan tags: tempfiles-lazy-open) | |
| 17:13 | Fix speedtest1 so that it automatically unlinks its test database prior to startup. (check-in: b65b69f6 user: drh tags: trunk) | |
| 16:59 | Add the --temp option to the speedtest1.c performance test program. (check-in: 8053a6e2 user: drh tags: trunk) | |
| 16:23 | Improved localtime() support for WindowsCE (check-in: 662c32af user: drh tags: trunk) | |
| 16:11 | Add and adjust comments. (Closed-Leaf check-in: 541c6da2 user: mistachkin tags: winCeLocalTime) | |
| 16:10 | Merge enhancements from trunk. (check-in: 9682c043 user: drh tags: tempfiles-lazy-open) | |
| 16:04 | Add the sqlite3_snapshot_cmp() interface (available only with SQLITE_ENABLE_SNAPSHOT). (check-in: 7e728965 user: drh tags: trunk) | |
| 15:14 | Update the documentation for sqlite3_snapshot_cmp() to make the circumstances under which the comparison is valid clearer. Add tests for the same. (Closed-Leaf check-in: 8fc83474 user: dan tags: snapshot-cmp) | |
| 11:58 | Update the header comment on the memjournal.c file. No code changes. (check-in: 07f10dea user: drh tags: trunk) | |
| 00:26 | Performance optimization the Vdbe allocator. (check-in: e2c4995b user: drh tags: trunk) | |
| 00:16 | Avoid unnecessary calls to object destructors for a small performance gain. (check-in: aec94b6e user: drh tags: trunk) | |
| 00:00 | Performance improvements in sqlite3WhereExprUsage(). (check-in: fdf75239 user: drh tags: trunk) | |
|
2016-04-11
| ||
| 22:45 | Further refinements. (check-in: b35bb928 user: mistachkin tags: winCeLocalTime) | |
| 22:24 | Merge updates from trunk. (check-in: b8094166 user: mistachkin tags: winCeLocalTime) | |
| 22:23 | Fix typo in the MSVC makefile. (check-in: 3189a7f1 user: mistachkin tags: trunk) | |
| 22:10 | Fix some compilation issues. (check-in: 016481b3 user: mistachkin tags: winCeLocalTime) | |
| 19:59 | Add the sqlite3_snapshot_cmp() API. (check-in: c698a21a user: dan tags: snapshot-cmp) | |
| 19:24 | Fix a typo in temptable2.test. (check-in: 04b1890f user: dan tags: tempfiles-lazy-open) | |
| 19:23 | Add tests for wal mode to temptable2.test. (check-in: c6d0d441 user: dan tags: tempfiles-lazy-open) | |
| 19:01 | Performance optimization to sqlite3Dequote() and its callers. (check-in: 9efe2265 user: drh tags: trunk) | |
| 18:50 | Merge latest trunk changes with this branch. (check-in: ffc62af1 user: dan tags: tempfiles-lazy-open) | |
| 18:49 | Add extra tests to temptable2.test. (check-in: 7dd9d4c1 user: dan tags: tempfiles-lazy-open) | |
| 18:25 | Performance optimization for the sqlite3ExprListDelete() routine. (check-in: 2764aeaa user: drh tags: trunk) | |
| 18:15 | Performance optimizations in the column cache of the code generator, and especially the sqlite3ExprCacheRemove() routine. (check-in: e35b345c user: drh tags: trunk) | |
| 18:07 | Fixes for OOM and IO error handling with temp file databases. (check-in: 4eb06e84 user: dan tags: tempfiles-lazy-open) | |
| 16:43 | Simplification and performance improvements in sqlite3ExprDup() and its subroutines. More work is possible in this area. (check-in: 476cc283 user: drh tags: trunk) | |
| 16:35 | Rename the OP_MX_JUMP macro to SQLITE_MX_JUMP_OPCODE to avoid confusing the opcode name generator. (check-in: e554a4c3 user: drh tags: trunk) | |
| 14:49 | Performance improvement in sqlite3ExprDelete(). (check-in: 60ad80e3 user: drh tags: trunk) | |
| 13:36 | Remove the VdbeOp.opflags field and its associated initialization overhead. Update mkopcodeh.tcl to reorder opcode numbers to help the resolveP2Values() routine run faster. (check-in: 099478fa user: drh tags: trunk) | |
| 09:39 | Update this branch with the latest changes from the trunk. (check-in: 982b753d user: dan tags: tempfiles-lazy-open) | |
| 01:43 | Back off of the parser optimization in the previous check-in, slightly, to preserve some backwards compatibility regarding some undocumented behavior in the '#AAA' style query parameter. (check-in: ef1966c2 user: drh tags: trunk) | |
| 01:26 | Small size reduction and performance improvement in the parser. (check-in: 16df7128 user: drh tags: trunk) | |
| 01:06 | Factor out the common operation of setting the Expr.x.pSelect field of an Expr object into a subroutine. (check-in: 6a5cceee user: drh tags: trunk) | |
|
2016-04-09
| ||
| 18:04 | Fix a problem in the code generator for joins on virtual tables where the outer loop of the join uses the IN operator. (check-in: 6c56b3a0 user: drh tags: trunk) | |
| 17:04 | Fix the sqlite3BtreeDelete() routine so that it preserves the correct key even when the row being deleted is not on a leaf page. Fix for ticket [a306e56ff68b8fa56] (check-in: ca2ef8a8 user: drh tags: trunk) | |
| 14:36 | Limit the number of digits shown in the "prereq" mask for ".wheretrace" debugging output. (check-in: 3686ed74 user: drh tags: trunk) | |
|
2016-04-08
| ||
| 21:35 | Attempt to treat the arguments to a table-valued function as if they occur in the ON clause of a LEFT JOIN rather than in the WHERE clause. But this causes undesirable behavior with generate_series, as demonstrated by test cases. This is an incremental check-in pending further work. (Leaf check-in: 00ac73a0 user: drh tags: tabfunc-in-left-join) | |
| 19:44 | Update documentation for sqlite3_snapshot_open(). No code changes. (check-in: 1dfa5234 user: drh tags: trunk) | |
| 15:09 | Version 3.12.1 (check-in: fe7d3b75 user: drh tags: release, branch-3.12.0, version-3.12.1) | |
|
2016-04-07
| ||
| 23:18 | Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. (check-in: 84d2a09e user: drh tags: branch-3.12.0) | |
| 21:29 | Update the version number to 3.12.1. This is the first release candidate. (check-in: 300f1b61 user: drh tags: branch-3.12.0) | |
| 21:29 | Carry table column types through into VIEW definitions, where possible. (check-in: 3360ab09 user: drh tags: branch-3.12.0) | |
| 21:22 | Prevent the in-memory journal read cursor from entering an inconsistent state when it reads the last few bytes out of the journal file. Fix for ticket [7f7f8026eda38]. (check-in: c232b99e user: drh tags: branch-3.12.0) | |
| 21:14 | Add test cases for ticket [7f7f8026eda387d544]. (check-in: 87aa9357 user: drh tags: trunk) | |
| 18:42 | Prevent the in-memory journal read cursor from entering an inconsistent state when it reads the last few bytes out of the journal file. Fix for ticket [7f7f8026eda38]. (check-in: c4b9c611 user: drh tags: trunk) | |
| 14:16 | Avoid decrementing a pointer off the front end of the buffer in OP_MakeRecord. (check-in: 153135bf user: drh tags: trunk) | |
| 14:05 | Instead of just commenting out the unneeded code in the previous check-in, remove it completely. (check-in: 8415d484 user: drh tags: trunk) | |
| 14:01 | Remove an unnecessary test for a NULL pointer in freeP4(). (check-in: e84e88e3 user: drh tags: trunk) | |
| 13:45 | Update comments on the unix file locking protocol. No changes to code. (check-in: 716b20de user: drh tags: trunk) | |
|
2016-04-06
| ||
| 18:20 | For a pager backed by a temp file, store the main journal in memory until it is at least sqlite3_config.nStmtSpill bytes in size. Prevent the backup API from being used to change the page-size of a temp file. (check-in: 84c55701 user: dan tags: tempfiles-lazy-open) | |
| 17:32 | Add a couple options to the MSVC makefile. (check-in: ea4de04d user: mistachkin tags: branch-3.12.0) | |
| 16:27 | Fix a problem in test script lock.test. Fix minor issues in pager.c. (check-in: 84de8813 user: dan tags: tempfiles-lazy-open) | |
| 15:39 | Add tests to this branch. Fix a problem with temporary databases in auto-vacuum mode. (check-in: afe9bd9b user: dan tags: tempfiles-lazy-open) | |
|
2016-04-05
| ||
| 23:39 | Remove an unnecessary branch in the sqlite3LogEstToInt() routine. (check-in: da81d7af user: drh tags: trunk) | |
| 21:07 | Defer opening the file used for the temp database (where CREATE TEMP TABLE tables are stored) until the database is too large to reside entirely within the cache. There are likely still problems on this branch. (check-in: be5a549e user: dan tags: tempfiles-lazy-open) | |
| 20:59 | Carry table column types through into VIEW definitions, where possible. (check-in: fb555c3c user: drh tags: trunk) | |
| 19:46 | Remove superfluous directories from the Makefile clean targets. (check-in: 0bf9926c user: mistachkin tags: trunk) | |
| 17:59 | Merge updates from trunk. (check-in: 00990020 user: mistachkin tags: winCeLocalTime) | |
| 17:50 | Add the SQLITE_DBCONFIG_REQUIRE_TXN argument for sqlite3_dbconfig() which when set requires an explicit transaction before updating the database. (check-in: b7570ac1 user: drh tags: require-write-txn) | |
| 15:59 | Incorrect version of build.c checked in at [87e5f5a6c60e3] (because I neglected to press the "Save" button on the text editor). There is no change to the logic, just improved presentation. (check-in: cf569f9f user: drh tags: trunk) | |
| 14:02 | Make sure "0" intended as a NULL pointer is cast to a pointer when used in a varargs functions parameter. (check-in: ed128e8b user: drh tags: trunk) | |
| 14:01 | Remove an unnecessary conditional from the index builder. (check-in: 87e5f5a6 user: drh tags: trunk) | |
| 13:35 | Use SQLITE_WITHIN() for pointer range comparisons in some testing code. (check-in: 7cacf4e9 user: drh tags: trunk) | |
| 13:19 | Do not allow pointer arithmetic to move a pointer across a memory allocation boundary. (check-in: 85b97931 user: drh tags: trunk) | |
| 00:44 | Avoid unnecessary memset() operations in sqlite3PagerGet(). (Leaf check-in: 0c97b802 user: drh tags: pager-get-noinit) | |
|
2016-04-04
| ||
| 18:04 | Fix documentation typos. Comment changes only. No changes to code. (check-in: d5fc2f7f user: drh tags: trunk) | |
| 17:59 | Improve error messages from the 'shell1-5.0' test. (check-in: cefd36ff user: mistachkin tags: trunk) | |
| 17:34 | Improved handling of UTF8 by the command-line shell. (check-in: 4534ebf1 user: drh tags: trunk) | |
| 17:23 | Add the ".auth ON|OFF" command to the command-line shell. (check-in: 65c7bcc4 user: drh tags: trunk) | |
| 16:40 | Test that the view name is passed to the authorization callback when a SELECT statement is run on a view. (check-in: 8627a4cd user: dan tags: trunk) | |
| 15:47 | Add and enhance the new tests. (Closed-Leaf check-in: f4cbd18d user: mistachkin tags: altShellFix) | |
| 14:57 | Enhance sqlite3session_apply() and sqlite3session_apply_strm() so that conflicts are retried before the xConflict() callback is invoked, as long as the "apply" operation is making forward progress. (check-in: 42a21966 user: drh tags: trunk) | |
| 13:46 | Minor performance optimization in the comparison opcodes of the VDBE. (check-in: e375fe52 user: drh tags: trunk) | |
| 12:38 | Fix harmless compiler warnings. (check-in: 0213d6af user: drh tags: trunk) | |
| 02:33 | Refinements to the previous check-in. (check-in: b36dfdff user: mistachkin tags: altShellFix) | |
| 02:16 | Experimental changes to the command line shell to make it work better with Unicode on Windows. (check-in: 74183a5f user: mistachkin tags: altShellFix) | |
| 02:05 | More refactoring and cleanup work on the Win32 string conversion and utility routines. (check-in: 02ccb444 user: mistachkin tags: altShellFix) | |
|
2016-04-03
| ||
| 22:44 | Revise and enhance the Win32 string conversion routines. (check-in: 345860c9 user: mistachkin tags: altShellFix) | |
| 20:50 | Replace the new fprintf() calls. (check-in: f76c3a0c user: mistachkin tags: altShellFix) | |
| 20:45 | Merge updates from trunk. (check-in: 566b551e user: mistachkin tags: altShellFix) | |
|
2016-04-01
| ||
| 17:54 | Preupdate hook documentation fixes. No changes to code. (check-in: 59814f35 user: drh tags: trunk) | |
| 12:35 | When reading an sqlite_stat1 table with missing entries for some indexes, set the default for the missing indexes after all other indexes are set so that the default values are more in line with indexes that are actually in the stat1 table. (check-in: a62340dc user: drh tags: trunk) | |
|
2016-03-31
| ||
| 22:53 | Update the clean target in the MSVC makefile. (check-in: 69f4d832 user: mistachkin tags: trunk) | |
| 20:40 | Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. (check-in: c648539b user: drh tags: trunk) | |
| 15:08 | Add another OOM test to this branch. (Closed-Leaf check-in: 49763fc3 user: dan tags: session-retry) | |
| 10:50 | Add further tests for the code on this branch. Fix a problem in OOM handling. (check-in: 195f3340 user: dan tags: session-retry) | |
| 02:44 | Enhanced comments describing the sessions file format. No changes to code. (check-in: 84dc41e2 user: drh tags: session-retry) | |
| 00:45 | Fix the return code in sessionRetryConstraints(). (check-in: ea917c14 user: drh tags: session-retry) | |
|
2016-03-30
| ||
| 21:19 | Have the sqlite3session_apply() function and its streaming equivalent retry any operations that failed with SQLITE_CONSTRAINT after all other operations on the same table have been attempted. New code is largely untested. (check-in: 1085911a user: dan tags: session-retry) | |
| 16:23 | Updates for the MSVC makefiles. (check-in: 7cf0cab7 user: mistachkin tags: trunk) | |
| 16:22 | Fix typo in comment. No changes to code. (check-in: 64d75cbe user: mistachkin tags: trunk) | |
| 15:30 | Simplifications and clarification to update callback handling in the OP_Delete and OP_Insert opcodes. (check-in: 47887ef8 user: drh tags: trunk) | |
| 14:26 | Increase the version number to 3.13.0 on account of the new session extension. (check-in: e9bcd5ac user: drh tags: trunk) | |
| 14:17 | Remove a redundant test for disabling RESTRICT with defer_foreign_keys=ON. (check-in: 9cdf813c user: drh tags: trunk) | |
| 13:43 | Incorporate the sessions extension and the SQLITE_ENABLE_PREUPDATE_HOOK compile-time option. (check-in: 4af7a90f user: drh tags: trunk) | |
| 12:56 | Avoid compiler warnings and excess opcodes when SQLITE_ENABLE_PREUPDATE_HOOK is not used. Fix the EXPLAIN output for P4_TABLE opcodes. (Closed-Leaf check-in: 5ab46d76 user: drh tags: sessions) | |
| 12:20 | Improvements to the performance testing program "speedtest1.c" and the shell script that invokes it. (check-in: e4bee561 user: drh tags: trunk) | |
|
2016-03-29
| ||
| 21:19 | Fix some code and test coverage issues in fts5_index.c. (Leaf check-in: 7635c680 user: dan tags: fts5) | |
| 10:36 | Merge 3.12.0 changes. (check-in: d7381eff user: drh tags: begin-concurrent) | |
| 10:30 | Merge 3.12.0 changes. (check-in: eef55744 user: drh tags: apple-osx) | |
| 10:19 | Merge changes for 3.12.0. (check-in: ed22eb65 user: drh tags: sessions) | |
| 10:14 | Version 3.12.0 (check-in: e9bb4cf4 user: drh tags: trunk, release, version-3.12.0) | |
|
2016-03-28
| ||
| 20:13 | Add further tests for savepoint rollback. Fix various code issues and add missing comments in fts5_index.c. (check-in: a805c6f7 user: dan tags: fts5) | |
| 15:06 | Integrate the vcreate-stmt branch into this one. (check-in: 06039d90 user: dan tags: fts5) | |
| 14:57 | Open a statement transaction for "CREATE VIRTUAL TABLE" statements in order to ensure that if the xCreate() call fails, changes made to the sqlite_master and possibly other tables are rolled back. (Closed-Leaf check-in: d0a3853b user: dan tags: vcreate-stmt) | |
| 11:01 | Fix the multiplexor so that it does not assume that the xGetLastError method is non-NULL in the child VFS. (check-in: f6a88ccc user: drh tags: trunk) | |
|
2016-03-26
| ||
| 20:11 | Fix a problem with OOM handling when setting an fts5 configuration option. (check-in: 53b80a6d user: dan tags: fts5) | |
| 15:36 | More changes to the shellN.test scripts to get them working on all variations of Windows. (check-in: 8213c2f5 user: drh tags: trunk) | |
| 14:41 | Remove the catchcmd_collapse_space procedure in tester.tcl - no longer needed. (check-in: 3bd499d3 user: drh tags: trunk) | |
| 13:26 | Update shell1.test tests to deal with backslash escaping in TCL on Windows-style pathnames. (check-in: 219a251e user: drh tags: trunk) | |
|
2016-03-25
| ||
| 20:10 | Do not run the shell3.test module under mingw because of mingw's dodgy command-line parsing. (check-in: a7c080a9 user: drh tags: trunk) | |
| 17:19 | In the Win32 VFS, avoid trying to use rand_s() on Windows CE. (check-in: 183350fa user: mistachkin tags: trunk) | |
| 17:09 | Add the catchcmd_collapse_space command and use it to help make shell testing more robust against TCL space escapes. (check-in: 93caabb6 user: drh tags: trunk) | |
| 12:10 | Fix two instances of undefined behavior in the C code - both harmless for all current compilers. (check-in: 99fd194c user: drh tags: trunk) | |
|
2016-03-24
| ||
| 20:55 | Make test cases in shell1.test robust against TCL deciding to quote strings using lots of backslashes. (check-in: 817e93f4 user: drh tags: trunk) | |
| 20:36 | Prevent negative values of SQLITE_DEFAULT_CACHE_SIZE from making SQLITE_WIN32_HEAP_INIT_SIZE negative. (check-in: e0737f52 user: mistachkin tags: trunk) | |
| 15:32 | Larger margins for one memsubsys1 range check when running with a non-zero reserved-bytes value. (check-in: 6db1d1fb user: drh tags: trunk) | |
| 15:09 | Fix some test scripts so that they work with various permutations. (check-in: f4d234b5 user: dan tags: trunk) | |
| 14:34 | Merge the beta changes into sessions. (check-in: beb5ea14 user: drh tags: sessions) | |
|
2016-03-23
| ||
| 17:54 | Avoid calling realloc() with a zero size in fuzzcheck.c. (check-in: a1fd1469 user: drh tags: trunk) | |
| 16:32 | Fix "ifcapable" tests in capi3.test and capi3c.test so that the tests work with more build configurations. (check-in: 3fa88f68 user: dan tags: trunk) | |
| 15:53 | Remove an unused local variable from FTS5. (check-in: 0ed693c2 user: drh tags: trunk) | |
| 15:04 | Explicitly limit the size of fts5 tokens to 32768 bytes. (check-in: 70fc69ee user: dan tags: trunk) | |
| 13:46 | Update a requirement mark. No changes to code. (check-in: 41298464 user: drh tags: trunk) | |
|
2016-03-22
| ||
| 20:05 | The sqlite3_column_decltype() routine should return NULL, not an empty string, if the column has no declared type. (check-in: 605eba4a user: drh tags: trunk) | |
| 15:26 | Fix harmless compiler warning for MSVC. (check-in: 142cd359 user: mistachkin tags: trunk) | |
| 15:25 | Fix a harmless compiler warning. (check-in: 5ace870d user: drh tags: trunk) | |
| 15:01 | Fix some errors in fts5 test scripts. (check-in: e1ab2d37 user: dan tags: trunk) | |
| 14:37 | Create the "uptr" typedef (the same as uintptr_t when available) and use it to cast pointers before comparison. (check-in: 2484cc0c user: drh tags: trunk) | |
| 14:10 | Avoid the possibility of integer overflow on a pointer comparison test for corruption in the database file. (check-in: ff1b1ac3 user: drh tags: trunk) | |
|
2016-03-21
| ||
| 22:28 | Fix harmless compiler warnings. (check-in: 25d776e4 user: drh tags: trunk) | |
| 16:25 | Add tests to ensure that fts5 is now deterministic. (check-in: 3d076094 user: dan tags: trunk) | |
| 16:19 | Skip recently added test cases in nolock.test when running in the inmemory_journal permutation. (check-in: a1dcf7af user: drh tags: trunk) | |
| 16:06 | Remove an unreachable branch from the unlink verification logic in the UNIX VFS. (check-in: 4dc30cce user: drh tags: trunk) | |
| 15:54 | Merge all recent changes from trunk. (check-in: 8ee7d346 user: drh tags: begin-concurrent) | |
| 15:32 | Merge 3.12.0 beta changes from trunk. (check-in: 3296a0ce user: drh tags: sessions) | |
| 15:30 | Have fts5 cache the structure of its index in main memory. Use "PRAGMA data_version" to figure out when this cache should be invalidated. (check-in: 902f2217 user: dan tags: trunk) | |
| 14:52 | Merge the sqlite3_system_errno() change from trunk. (check-in: 063f1b37 user: drh tags: apple-osx) | |
| 14:46 | Add the sqlite3_system_errno() interface. (check-in: 4bd12b57 user: drh tags: trunk) | |
| 12:28 | Make sure system errors that occur durign sqlite3_step() are captured for use by sqlite3_system_errno(). (Closed-Leaf check-in: b4a1114f user: drh tags: sqlite_system_errno) | |
| 11:57 | Improved comments. No logical changes to code. (check-in: a6b6c6c4 user: drh tags: sqlite_system_errno) | |
| 11:38 | Do a better job of capturing all system errno values regardless of when they occur. (check-in: 7d49998d user: drh tags: sqlite_system_errno) | |
| 10:49 | Merge updates from trunk. (check-in: 86ab8643 user: drh tags: sqlite_system_errno) | |
| 09:56 | Change the way fts5 internally allocates segment ids in order to eliminated non-determinism from the module. (check-in: d6e2637d user: dan tags: trunk) | |
| 00:38 | Change the Vdbe.aMem array so that it is zero-based instead of one-based. (check-in: c39081e8 user: drh tags: trunk) | |
| 00:30 | Remove an unreachable branch. Improvements to comments. (Closed-Leaf check-in: c5677ecd user: drh tags: zero-base-aMem) | |
|
2016-03-19
| ||
| 23:32 | Change the Vdbe.aMem array so that it is zero-based instead of one-based. (check-in: e07b0c47 user: drh tags: zero-base-aMem) | |
| 18:11 | Fix exclusive.test so that it works with -DSQLITE_TEMP_STORE=3. (check-in: d7852c63 user: dan tags: trunk) | |
| 18:00 | Updates to the Lemon documentation. (check-in: f0953414 user: drh tags: trunk) | |