Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
71 check-ins for the month beginning 2020-04-01
Following month ↑|
2020-04-30
| ||
| 18:28 | Add OOM tests for the new code on this branch. (check-in: e4a18601e5 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: ffcdb66891 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: b717dc3c5f user: dan tags: update-from) | |
| 17:41 | Fix various bugs in new feature on this branch. (check-in: 823ba94e29 user: dan tags: update-from) | |
| 01:09 | Do not allow page_size changes on an active cksumvfs database. (check-in: 2c17cdce26 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: 0dcf002463 user: drh tags: trunk) | |
| 20:47 | Add the cksumvfs extension. (check-in: 237c10f941 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: ce980af65a user: drh tags: trunk) | |
| 11:45 | Use an AtomicLoad() macro in sqlite3HeapNearlyFull(). (check-in: 7556bc632e user: drh tags: trunk) | |
|
2020-04-27
| ||
| 20:55 | Allow a FROM clause in UPDATE statements. (check-in: f353a1a613 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: b73d9a7d6f user: drh tags: trunk) | |
| 14:33 | Fix an issue with check-in [bc3bf7c6681a96bc] when compiling on Windows. (check-in: 57b16d8ca3 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: bc3bf7c668 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: ac31edd3ee 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: b4987a5ced user: drh tags: trunk) | |
| 17:55 | New test case for ticket [1dcb4d44964846ad]. (check-in: 9e9f1e96c9 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: 65c6c26bb4 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: 8789368b91 user: drh tags: trunk) | |
| 11:11 | Fix an integer overflow in fts3 causing a usan error. (check-in: e256f85289 user: dan tags: trunk) | |
| 00:50 | Clarify the comment on the sqlite3BtreeGetRequestedReserve() routine. No changes to code. (check-in: 52a6acca6d user: drh tags: trunk) | |
|
2020-04-21
| ||
| 20:19 | Add the sqlite3_database_file_object() interface. (check-in: f534ebeaaf user: drh tags: trunk) | |
| 19:27 | Add the sqlite3_database_file_object() interface to sqlite3ext.h. (Closed-Leaf check-in: 3cabe06b6e user: drh tags: sqlite3_database_file_object) | |
| 01:06 | Experimental API: sqlite3_database_file_object(). (check-in: ae697b152d 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: 2fc80ef16c user: drh tags: trunk) | |
| 16:21 | Enhance the ".filectrl" command in the CLI to support the --schema option. (check-in: 698d40db58 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: abc1aad74f user: drh tags: trunk) | |
| 14:05 | Remove an obsolete comment. No changes to code. (check-in: 4135cb0244 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: d5b0def96b 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: 07752164c2 user: drh tags: trunk) | |
|
2020-04-16
| ||
| 15:56 | Merge accidentally created fork. (check-in: cb772b7a8f user: dan tags: trunk) | |
| 11:35 | Improve corruption detection in fts3 shadow tables earlier in order to prevent an assert() from failing. (check-in: a9ec8c8f80 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: a42fdcf54b user: drh tags: trunk) | |
|
2020-04-14
| ||
| 15:53 | Build the UINT collating sequence extension into the CLI. (check-in: 2b8c6b035a user: drh tags: trunk) | |
| 15:48 | Add the UINT collating sequence extension. The implementation is copied out of the "natsort" branch. (check-in: 6f46c6e3e3 user: drh tags: trunk) | |
| 15:35 | Change the name from NATSORT to UINT. Provide an OMIT compile-time option. (Leaf check-in: cc56cbdb61 user: drh tags: natsort) | |
| 15:24 | Merge trunk enhancements. (check-in: f1c284dd1e user: drh tags: natsort) | |
|
2020-04-09
| ||
| 19:00 | Merge recent trunk changes into begin-concurrent-pnu-wal2. (check-in: 6c11b67bd2 user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:51 | Merge recent trunk changes into the apple-osx branch. (Leaf check-in: d6fda470fe user: drh tags: apple-osx) | |
| 18:46 | Merge recent trunk enhancements into the wal2 branch. (check-in: 6fb870625c user: drh tags: wal2) | |
| 18:44 | Merge recent trunk enhancements into the begin-concurrent-pnu branch. (check-in: cedd138c74 user: drh tags: begin-concurrent-pnu) | |
| 18:29 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 92f71a88c4 user: drh tags: begin-concurrent) | |
| 15:31 | When compiling the shell for WinRT, avoid using Win32 APIs that are unavailable. (check-in: 85d3dc8c50 user: mistachkin tags: trunk) | |
| 15:07 | Merge recent trunk enhancements into the bytecode-function branch. (check-in: 7e6576ec00 user: drh tags: bytecode-function) | |
| 15:01 | Merge trunk enhancements into the approximate-analyze branch. (check-in: 17901ea6a1 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: 10306118e8 user: drh tags: trunk) | |
| 13:08 | Add the --spinner option to the fuzzcheck test program. (check-in: b1eae2686f 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: 230556e859 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: c95c4cda46 user: drh tags: trunk) | |
|
2020-04-06
| ||
| 20:35 | Performance improvement in sqlite3ResolveExprNameList(). (check-in: 7e170e67f2 user: drh tags: trunk) | |
| 18:16 | Performance improvement for column name lookup. (check-in: 1e4b6a9398 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: 4cf8721f5c user: dan tags: trunk) | |
|
2020-04-04
| ||
| 11:58 | Remove a NEVER() that could be true in sqlite3MatchEName(). (check-in: 921448f0e2 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: 43612157f8 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: 70c44811d1 user: drh tags: trunk) | |
|
2020-04-03
| ||
| 20:14 | Restore an #if block inadvertently removed via check-in [9c77bfe41e]. (check-in: bf6bcfc16e 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: 98d56b4a34 user: dan tags: trunk) | |
| 16:11 | Add a test case to fuzzdata8.db for the recent Henry Liu bugs. (check-in: 42b02454b1 user: drh tags: trunk) | |
| 15:48 | Merge updates from trunk. (check-in: 348c40136c 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: b64674919f 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: 52f800fa93 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: 4a302b42c7 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: 684293882c 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: d09f8c3621 user: dan tags: trunk) | |
|
2020-04-02
| ||
| 19:58 | Fix a minor problem with EXPLAIN QUERY PLAN for triggers. (check-in: 6e11c03f84 user: drh tags: bytecode-function) | |
| 17:21 | Minor changes for better test coverage. (check-in: ae3ac297d2 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: c9c735e201 user: drh tags: trunk) | |
| 13:08 | Fix another harmless compiler warning. (check-in: 949eec2530 user: drh tags: bytecode-function) | |
| 12:53 | Add a missing #ifdef to avoid a harmless compiler warning. (check-in: cc54de3543 user: drh tags: bytecode-function) | |
| 12:24 | Merge enhancements from trunk. (check-in: d1731385c0 user: drh tags: bytecode-function) | |
|
2020-04-01
| ||
| 17:10 | Add support for the "ANALYZE WITH LIMIT=N" syntax. (Leaf check-in: 7e666b6022 user: drh tags: analyze-with-limit) | |
| 01:15 | Simple fixes to PRAGMA analysis_limit. (check-in: c20d4fdee2 user: drh tags: approximate-analyze) | |