Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around d5b0def96ba6d90f.
2020-05-06
| ||
15:07 | Merge latest trunk changes into this branch. (check-in: a3727dba user: dan tags: setlk-deadlock-changes) | |
2020-05-05
| ||
20:30 | Unless upgrading an existing read transaction, have ENABLE_SETLK_TIMEOUT builds attempt to use a blocking lock when opening a write transaction on a wal mode database. (check-in: d6f819a9 user: dan tags: setlk-deadlock-changes) | |
19:54 | The only known path to a corruption detection branch was cut off by the previous commit implementing earlier index corruption. So make the branch NEVER. Maybe a fuzzer will find a new path. (check-in: 9a84d8eb user: drh tags: trunk) | |
18:42 | Earlier detection of index corruption caused by missing index entries. (check-in: f339f31f user: drh tags: trunk) | |
13:41 | Fix a compiler warning in cksumvfs.c. (check-in: 68033bca user: drh tags: trunk) | |
2020-05-04
| ||
19:52 | Fix harmless compiler warnings. (check-in: 8eee591d user: drh tags: trunk) | |
19:42 | Changes to avoid deadlock in SQLITE_ENABLE_SETLK_TIMEOUT builds. (check-in: 553423c2 user: dan tags: setlk-deadlock-changes) | |
19:04 | Minor change to the sqlite_stmt virtual table, for test coverage. (check-in: 838987b2 user: drh tags: trunk) | |
17:15 | Simplify the initialization of built-in extensions. (check-in: 729f2397 user: drh tags: trunk) | |
11:47 | Ensure that the master-journal name is in a form suitable to be passed into sqlite3_uri_parameter(). (check-in: d1ba026d user: drh tags: trunk) | |
2020-05-02
| ||
04:08 | Add the SQLITE_FCNTL_CKPT_START file-control and use it to optimize the cksumvfs extension. (check-in: efdecb13 user: drh tags: trunk) | |
03:46 | Add support for PRAGMA analyze_limit and approximate analysis. (check-in: 81254752 user: drh tags: trunk) | |
03:29 | Add a missing VdbeCoverage() macro. (Closed-Leaf check-in: 77a55c39 user: drh tags: approximate-analyze) | |
00:31 | Merge the bytecode and tables_used table-valued functions. Requires -DSQLITE_ENABLE_BYTECODE_VTAB at compile-time. (check-in: d09bcce3 user: drh tags: trunk) | |
00:01 | Corner-case changes to the bytecode virtual table for testability and correctness. (Closed-Leaf check-in: baa720e4 user: drh tags: bytecode-function) | |
2020-05-01
| ||
18:58 | Merge recent enhancements from trunk. (check-in: 96dfc71e user: drh tags: bytecode-function) | |
18:43 | Fix problems with UPDATE...FROM statements that modify rowid or primary-key values. (check-in: 623ab585 user: dan tags: update-from) | |
18:37 | Add the SQLITE_FCNTL_CKPT_START file-control. Use it to optimize the cksumvfs extension. (Closed-Leaf check-in: b40f5aa3 user: drh tags: ckpt-start-fcntl) | |
15:04 | Merge recent trunk enhancements. (check-in: 2100b2c8 user: drh tags: approximate-analyze) | |
13:45 | Clarification to the sqlite3_uri() family of interfaces. Documentation enhancement only - no changes to code. (check-in: 853703cd user: drh tags: trunk) | |
13:32 | Update documentation for sqlite3_close_v2() for clarity. No functional changes. (check-in: 80498b69 user: drh tags: trunk) | |
11:31 | Add the new SQLITE_IOERR_DATA result code and use it in cksumvfs. Also enhance cksumvfs to emit an sqlite3_log() message whenever it finds an invalid checksum. (check-in: a094e8bf user: drh tags: trunk) | |
2020-04-30
| ||
18:28 | Add OOM tests for the new code on this branch. (check-in: e4a18601 user: dan tags: update-from) | |
15:49 | Report an error if an UPDATE...FROM statement has an ORDER BY but no LIMIT clause. Add tests for multi-column primary keys. (check-in: ffcdb668 user: dan tags: update-from) | |
2020-04-29
| ||
20:11 | Fix problems with using LIMIT and FROM clauses as part of single UPDATE statement. (check-in: b717dc3c user: dan tags: update-from) | |
17:41 | Fix various bugs in new feature on this branch. (check-in: 823ba94e user: dan tags: update-from) | |
01:09 | Do not allow page_size changes on an active cksumvfs database. (check-in: 2c17cdce user: drh tags: trunk) | |
2020-04-28
| ||
23:09 | Fix incorrect error message when something goes wrong with the sqlite3_dbpage() table-valued function in the .dbinfo command of the CLI. (check-in: 0dcf0024 user: drh tags: trunk) | |
20:47 | Add the cksumvfs extension. (check-in: 237c10f9 user: drh tags: trunk) | |
14:01 | Use AtomicStore() when setting the mem0.nearlyFull boolean to avoid harmless TSAN warnings and to forestall doubts about threadsafety. (check-in: ce980af6 user: drh tags: trunk) | |
11:45 | Use an AtomicLoad() macro in sqlite3HeapNearlyFull(). (check-in: 7556bc63 user: drh tags: trunk) | |
2020-04-27
| ||
20:55 | Allow a FROM clause in UPDATE statements. (check-in: f353a1a6 user: dan tags: update-from) | |
2020-04-26
| ||
22:04 | Yet another attempt to enhance sqlite3_load_extension() so that it works with Window-style pathnames using a backslash separator character. (check-in: b73d9a7d user: drh tags: trunk) | |
14:33 | Fix an issue with check-in [bc3bf7c6681a96bc] when compiling on Windows. (check-in: 57b16d8c user: drh tags: trunk) | |
2020-04-25
| ||
21:05 | Fix the sqlite3_load_extension() interface so that it tolerates backslashes in place of forward-slashes in pathnames on Windows. (check-in: bc3bf7c6 user: drh tags: trunk) | |
15:01 | Ensure affinity is not discarded from a view column if the view appears on the rhs of a LEFT JOIN. Fix for [45f4bf4e]. (check-in: ac31edd3 user: dan tags: trunk) | |
2020-04-24
| ||
18:20 | The new sqlite3_database_file_object() interface requires that the pager never invoke xOpen with SQLITE_OPEN_MAIN_JOURNAL unless it is using a pointer to the journal name found in the Pager structure itself. Make this the case when processing a master-journal. (check-in: b4987a5c user: drh tags: trunk) | |
17:55 | New test case for ticket [1dcb4d44964846ad]. (check-in: 9e9f1e96 user: drh tags: trunk) | |
2020-04-23
| ||
20:45 | Fix an uninitialized variable in the newly enhanced ".output" command of the CLI. See forum post 5978955ac1 (check-in: 65c6c26b user: drh tags: trunk) | |
2020-04-22
| ||
13:49 | Fix an off-by-one error in the "calculated" page count output from the sqlite3_analyzer utility for databases that are more than 1GB in size. (check-in: 8789368b user: drh tags: trunk) | |
11:11 | Fix an integer overflow in fts3 causing a usan error. (check-in: e256f852 user: dan tags: trunk) | |
00:50 | Clarify the comment on the sqlite3BtreeGetRequestedReserve() routine. No changes to code. (check-in: 52a6acca user: drh tags: trunk) | |
2020-04-21
| ||
20:19 | Add the sqlite3_database_file_object() interface. (check-in: f534ebea user: drh tags: trunk) | |
19:27 | Add the sqlite3_database_file_object() interface to sqlite3ext.h. (Closed-Leaf check-in: 3cabe06b user: drh tags: sqlite3_database_file_object) | |
01:06 | Experimental API: sqlite3_database_file_object(). (check-in: ae697b15 user: drh tags: sqlite3_database_file_object) | |
2020-04-20
| ||
17:35 | Do not use O_NOFOLLOW when opening a directory just to call fsync() on that directory. (check-in: 2fc80ef1 user: drh tags: trunk) | |
16:21 | Enhance the ".filectrl" command in the CLI to support the --schema option. (check-in: 698d40db user: drh tags: trunk) | |
15:18 | The SQLITE_TESTCTRL_RESERVE operator is removed. In its place is the more general SQLITE_FCNTL_RESERVE_BYTES which is an API and which can operator on more than just the main schema. (check-in: abc1aad7 user: drh tags: trunk) | |
14:05 | Remove an obsolete comment. No changes to code. (check-in: 4135cb02 user: drh tags: trunk) | |
2020-04-18
| ||
14:12 | Add the --bom option to the ".excel", ".once", and ".output" commands of the CLI. Also fix the "--all" option on ".help" so that it works with two dashes in addition to just one. (check-in: d5b0def9 user: drh tags: trunk) | |
2020-04-17
| ||
23:46 | Fix the ".excel" command and the ".open -x" and ".open -e" command so that they work better when running from an in-memory database and on Windows and when running from a script. (check-in: 07752164 user: drh tags: trunk) | |
2020-04-16
| ||
15:56 | Merge accidentally created fork. (check-in: cb772b7a user: dan tags: trunk) | |
11:35 | Improve corruption detection in fts3 shadow tables earlier in order to prevent an assert() from failing. (check-in: a9ec8c8f user: dan tags: trunk) | |
2020-04-15
| ||
17:39 | Clarification of the byte-order determination for UTF16 inputs to routines like sqlite3_bind_text16() and sqlite3_result_text16() and others that accept UTF16 input strings. (check-in: a42fdcf5 user: drh tags: trunk) | |
2020-04-14
| ||
15:53 | Build the UINT collating sequence extension into the CLI. (check-in: 2b8c6b03 user: drh tags: trunk) | |
15:48 | Add the UINT collating sequence extension. The implementation is copied out of the "natsort" branch. (check-in: 6f46c6e3 user: drh tags: trunk) | |
15:35 | Change the name from NATSORT to UINT. Provide an OMIT compile-time option. (Leaf check-in: cc56cbdb user: drh tags: natsort) | |
15:24 | Merge trunk enhancements. (check-in: f1c284dd user: drh tags: natsort) | |
2020-04-09
| ||
19:00 | Merge recent trunk changes into begin-concurrent-pnu-wal2. (check-in: 6c11b67b user: drh tags: begin-concurrent-pnu-wal2) | |
18:51 | Merge recent trunk changes into the apple-osx branch. (Leaf check-in: d6fda470 user: drh tags: apple-osx) | |
18:46 | Merge recent trunk enhancements into the wal2 branch. (check-in: 6fb87062 user: drh tags: wal2) | |
18:44 | Merge recent trunk enhancements into the begin-concurrent-pnu branch. (check-in: cedd138c user: drh tags: begin-concurrent-pnu) | |
18:29 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 92f71a88 user: drh tags: begin-concurrent) | |
15:31 | When compiling the shell for WinRT, avoid using Win32 APIs that are unavailable. (check-in: 85d3dc8c user: mistachkin tags: trunk) | |
15:07 | Merge recent trunk enhancements into the bytecode-function branch. (check-in: 7e6576ec user: drh tags: bytecode-function) | |
15:01 | Merge trunk enhancements into the approximate-analyze branch. (check-in: 17901ea6 user: drh tags: approximate-analyze) | |
2020-04-07
| ||
15:07 | Limit LIKE/GLOB pattern length to 100 bytes (default is 50K) when running dbsql cases in the fuzzcheck utility. (check-in: 10306118 user: drh tags: trunk) | |
13:08 | Add the --spinner option to the fuzzcheck test program. (check-in: b1eae268 user: drh tags: trunk) | |
01:18 | The ALTER TABLE fix of check-in [7e5ad8e0ab7ee91a] is no longer needed due to the changes at check-in [4cf8721f5ceb1fda]. But, we keep the defense in place as an assert() for extra safety. (check-in: 230556e8 user: drh tags: trunk) | |
00:54 | Remove dead code that was added during initial development of RENAME COLUMN but never actually served a purpose. (check-in: c95c4cda user: drh tags: trunk) | |
2020-04-06
| ||
20:35 | Performance improvement in sqlite3ResolveExprNameList(). (check-in: 7e170e67 user: drh tags: trunk) | |
18:16 | Performance improvement for column name lookup. (check-in: 1e4b6a93 user: drh tags: trunk) | |
16:37 | When running ALTER TABLE, avoid adding some internally generated tokens to the token map to improve performance on schemas with nested views. (check-in: 4cf8721f user: dan tags: trunk) | |
2020-04-04
| ||
11:58 | Remove a NEVER() that could be true in sqlite3MatchEName(). (check-in: 921448f0 user: drh tags: trunk) | |
00:29 | In the push-down optimization, do not substitute columns that have previously been identified as being constant by the propagate-constants optimization. Fix for ticket [51166be0159fd2ce]. Also, avoid factoring out constant expressions on the LHS of an IN(...) operator, as the IN(...) operation may affect the affinity of these values. Fix for [fd1bda016d1]. (Leaf check-in: 43612157 user: drh tags: branch-3.31) | |
00:15 | In the push-down optimization, do not substitute columns that have previously been identified as being constant by the propagate-constants optimization. Fix for ticket [51166be0159fd2ce] (check-in: 70c44811 user: drh tags: trunk) | |
2020-04-03
| ||
20:14 | Restore an #if block inadvertently removed via check-in [9c77bfe41e]. (check-in: bf6bcfc1 user: mistachkin tags: branch-3.31) | |
19:37 | Avoid factoring out constant expressions on the LHS of an IN(...) operator, as the IN(...) operation may affect the affinity of these values. Fix for [fd1bda016d1]. (check-in: 98d56b4a user: dan tags: trunk) | |
16:11 | Add a test case to fuzzdata8.db for the recent Henry Liu bugs. (check-in: 42b02454 user: drh tags: trunk) | |
15:48 | Merge updates from trunk. (check-in: 348c4013 user: drh tags: bytecode-function) | |
13:39 | Do not suppress errors when resolving references in an ORDER BY clause belonging to a compound SELECT within a view or trigger within ALTER TABLE. Fix for ticket [a10a14e9b4ba2]. Also, in the event of a semantic error in an aggregate query, early-out the resetAccumulator() function to prevent problems due to incomplete or incorrect initialization of the AggInfo object. Fix for ticket [af4556bb5c285c08]. (check-in: b6467491 user: drh tags: branch-3.31) | |
13:29 | Fix a case when a pointer might be used after being freed in the ALTER TABLE code. Fix for [4722bdab08cb1]. (check-in: 52f800fa user: drh tags: branch-3.31) | |
13:19 | In the event of a semantic error in an aggregate query, early-out the resetAccumulator() function to prevent problems due to incomplete or incorrect initialization of the AggInfo object. Fix for ticket [af4556bb5c285c08]. (check-in: 4a302b42 user: drh tags: trunk) | |
11:52 | Do not suppress errors when resolving references in an ORDER BY clause belonging to a compound SELECT within a view or trigger within ALTER TABLE. Fix for ticket [a10a14e9b4ba2]. (check-in: 68429388 user: dan tags: trunk) | |
11:20 | Fix a case when a pointer might be used after being freed in the ALTER TABLE code. Fix for [4722bdab08cb1]. (check-in: d09f8c36 user: dan tags: trunk) | |
2020-04-02
| ||
19:58 | Fix a minor problem with EXPLAIN QUERY PLAN for triggers. (check-in: 6e11c03f user: drh tags: bytecode-function) | |
17:21 | Minor changes for better test coverage. (check-in: ae3ac297 user: drh tags: bytecode-function) | |
13:21 | Fix an obsolete comment in the parameter binding logic of the CLI. No changes to code. (check-in: c9c735e2 user: drh tags: trunk) | |
13:08 | Fix another harmless compiler warning. (check-in: 949eec25 user: drh tags: bytecode-function) | |
12:53 | Add a missing #ifdef to avoid a harmless compiler warning. (check-in: cc54de35 user: drh tags: bytecode-function) | |
12:24 | Merge enhancements from trunk. (check-in: d1731385 user: drh tags: bytecode-function) | |
2020-04-01
| ||
17:10 | Add support for the "ANALYZE WITH LIMIT=N" syntax. (Leaf check-in: 7e666b60 user: drh tags: analyze-with-limit) | |
01:15 | Simple fixes to PRAGMA analysis_limit. (check-in: c20d4fde user: drh tags: approximate-analyze) | |
2020-03-31
| ||
20:57 | Add "PRAGMA analysis_limit=N;" to limit the number of rows visited by ANALYZE when N is positive. Positive N also disables collecting stat4. (check-in: a279b151 user: drh tags: approximate-analyze) | |
18:41 | Merge recent enhancements from trunk. (check-in: c705ce26 user: drh tags: approximate-analyze) | |
2020-03-30
| ||
19:38 | Minor bug fix in NATSORT collating function. (check-in: a61be109 user: drh tags: natsort) | |
15:39 | Add the NATSORT collating sequence. No test cases yet. (check-in: 79fcaa8e user: drh tags: natsort) | |
13:35 | Use __atomic_load_n() and __atomic_store_n() for a few more things where they are available. (check-in: a49f8ec5 user: dan tags: trunk) | |
11:17 | Fix "GCC_VESRION" typo in wal.c. (check-in: fbd93787 user: dan tags: trunk) | |
2020-03-28
| ||
19:02 | Enhancements to the SQLITE_ENABLE_SETLK_TIMEOUT compile-time option to avoid rare deadlocks on recovery. (check-in: 06885e9a user: drh tags: trunk) | |