This Day In History For 2020-07-28
1 Year Ago (more context)
|
2019-07-28
| ||
| 22:32 | • New ticket [ba2f4585] Query with ORDER BY results in "database disk image is malformed" error. (artifact: be412e84 user: mrigger) | |
| 21:53 | • New ticket [18ab5da2] Issue with DISTINCT and COLLATE. (artifact: dd9a82ec user: mrigger) | |
2 Years Ago (more context)
|
2018-07-28
| ||
| 21:01 | Add a small cost penalty to sorting to bias the query planner in favor of plans that do not require a final sorting pass. (check-in: 85b9beb4 user: drh tags: trunk) | |
| 16:24 | Do not allow a column reference that is converted into a constant by the WHERE-clause constant propagation optimization to be moved to the init-time constant expression list, as the table reference will not work there. This fixes a problem found by OSSFuzz. (check-in: d30b2a94 user: drh tags: trunk) | |
| 14:56 | Fix an assert() statement that was made obsolete by the constant propagation enhancement. Problem discovered by OSSFuzz. (check-in: e4b4737e user: drh tags: trunk) | |
| 14:34 | Improved debugging output when the ".selecttrace" option is used in the shell. (check-in: fcb88dd6 user: drh tags: trunk) | |
| 13:37 | An early attempt at refactoring Expr (Closed-Leaf check-in: fc90a53d user: drh tags: expr-simplify-branch1) | |
| 01:30 | Add assert() statements to sqlite3ExprDelete() that prove various symmetry properties of the Expr object that might be exploited to make the Expr object smaller and faster. (check-in: 81f25d5c user: drh tags: expr-simplify) | |
3 Years Ago (more context)
|
2017-07-28
| ||
| 22:22 | Update Tcl version used by the TclKit batch tool for MSVC. (check-in: bcec155e user: mistachkin tags: trunk) | |
| 22:13 | Fix harmless compiler warning. (check-in: 3286e1a0 user: mistachkin tags: trunk) | |
| 21:02 | Reduce the number of mallocs required of writers in server mode. (check-in: 60953997 user: dan tags: server-process-edition) | |
| 20:49 | Disable the writecrash.test module on Windows. (Leaf check-in: 4c0520d4 user: drh tags: batch-atomic-write) | |
| 18:16 | More precise determination of when an in-memory journal needs to be spilled to disk. (check-in: 6a505bdd user: drh tags: batch-atomic-write) | |
| 13:18 | Add new extended error codes for the atomic write file-controls. (check-in: 94a20047 user: drh tags: batch-atomic-write) | |
| 12:20 | Fix a punctuation typo in the documentation for sqlite3_step(). No changes to code. (check-in: c965b757 user: drh tags: branch-3.20) | |
| 11:05 | Add new test file test/atomic.test. (check-in: f9213e48 user: dan tags: batch-atomic-write) | |
| 02:02 | Backport of all batch-atomic-write changes through check-in [67bad7fb9b] (check-in: def55027 user: drh tags: batch-atomic-write-3.19) | |
| 01:53 | Add the SQLITE_ENABLE_BATCH_ATOMIC_WRITE macro to ctime.c (check-in: 67bad7fb user: drh tags: batch-atomic-write) | |
| 00:45 | Release candidate 3 for 3.20.0 (check-in: d891a2a0 user: drh tags: branch-3.20) | |
4 Years Ago (more context)
|
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 | • Edit [f2f1323cc4d2ad2d|f2f1323c]: Edit check-in comment. (artifact: b63f9ef2 user: mistachkin) | |
| 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) | |
5 Years Ago (more context)
|
2015-07-28
| ||
| 19:35 | Update batch build tool library paths for MSVC 2015. (check-in: d431d4e1 user: mistachkin tags: msvc2015) | |
| 18:53 | Fix the xfer optimization for WITHOUT ROWID tables so that it correctly updates the change count returned by sqlite3_changes(). (check-in: eff43715 user: drh tags: trunk) | |
| 16:46 | Add some test cases and fix some small problems with BEGIN UNLOCKED transactions. (check-in: 6da0e962 user: dan tags: begin-concurrent) | |
10 Years Ago (more context)
|
2010-07-28
| ||
| 20:57 | • New ticket [ce7c133e] Foreign key constraint fails when it should succeed.. (artifact: 4202cdf3 user: drh) | |
| 19:17 | Get SQLITE_OMIT_VIRTUALTABLE working again after being broken by recent changes. (check-in: 33b1e862 user: drh tags: trunk) | |
| 18:51 | Fix the dbstatus.test script so that it works correctly on 64-bit machines. (check-in: a3401d9e user: drh tags: trunk) | |
| 18:35 | Merge trunk changes into experimental branch. (check-in: aa819001 user: dan tags: experimental) | |
| 17:36 | Improve the accuracy of the Pager heap usage estimate. (check-in: ae89777e user: drh tags: trunk) | |
| 17:16 | Adjust the shell test script "shell4.test" to account for changes in the ".stat on" display format from the previous checkin. (check-in: 2f2fa7dd user: drh tags: trunk) | |
| 17:01 | Record the pcache allocation size statistics even for pcache overflow allocations. Adjust the wording on one of the stat output lines in the shell. (check-in: f9adf66a user: drh tags: trunk) | |
| 16:05 | Modify CLI to optionally display "stats". (check-in: 419ce0ed user: shaneh tags: trunk) | |
| 15:52 | Lookaside memory is not used to store schemas. Change the SQLITE_DBSATUS_SCHEMA_USED documentation to reflect this fact. (check-in: 07abfd52 user: drh tags: trunk) | |
| 15:49 | Add documentation for the SQLITE_STATUS_MALLOC_COUNT parameter to sqlite3_status(). (check-in: dbfbdb60 user: drh tags: trunk) | |
| 15:10 | Fix errors in wal3.test caused by recent modifications. (check-in: 0714aecc user: dan tags: experimental) | |
| 14:26 | Support FCNTL_CHUNK_SIZE on windows too. (check-in: a038688c user: dan tags: experimental) | |
| 02:53 | • Fixed ticket [8011086c]: Query planner creates unnecessary and expensive automatic index plus 2 other changes (artifact: b5dd6bce user: drh) | |
| 02:53 | Do not allow automatic indices for the RHS of IN expressions which are not correlated subqueries. Ticket [8011086c85c6c404014c9] (check-in: 267492d3 user: drh tags: trunk) | |
| 00:33 | • New ticket [8011086c] Query planner creates unnecessary and expensive automatic index. (artifact: 333f2a70 user: drh) | |
15 Years Ago (more context)
|
2005-07-28
| ||
| 23:12 | The BETWEEN operator in a WHERE clause is now able to use indices. (CVS 2568) (check-in: cdf8c958 user: drh tags: trunk) | |
| 20:51 | Test cases and tuning of the new optimizer code. (CVS 2567) (check-in: 4b02703d user: drh tags: trunk) | |
| 16:51 | The new optimizer now passes all regression tests. (CVS 2566) (check-in: a2121284 user: drh tags: trunk) | |
20 Years Ago (more context)
|
2000-07-28
| ||
| 14:32 | added the sqlite_busy_handler() interface (CVS 1700) (check-in: 2d57b02f user: drh tags: trunk) | |
| 14:32 | added the sqlite_busy_handler() interface (CVS 109) (check-in: 4fe8e51c user: drh tags: trunk) | |