This Day In History For 2019-09-16
1 Year Ago (more context)
|
2018-09-16
| ||
| 23:27 | First proposed fix for the ALTER TABLE problem described by ticket [b41031ea2b5372378cb3d2d] (check-in: 05a9d12925 user: drh tags: tkt-b41031ea) | |
| 20:33 | • Ticket [b41031ea2b] ALTER TABLE returns an error on certain schemas status still Open with 3 other changes (artifact: 90eeaef70d user: drh) | |
| 20:33 | • Ticket [b41031ea2b]: 6 changes (artifact: e331b118d2 user: drh) | |
| 20:03 | • New ticket [b41031ea2b]. (artifact: 65efc0ddbb user: drh) | |
| 18:23 | Remove an unreachable branch from the index-on-expression optimization. (check-in: 2df2cf4f17 user: drh tags: trunk) | |
| 16:34 | Fix a memory leak in the explain extension. (check-in: d0c92b047a user: drh tags: trunk) | |
| 16:18 | Add the new "explain" virtual table in ext/misc. Use this virtual table for additional test cases for the optimization that avoids updating indexes on expressions when none of the columns changed by the UPDATE are in the expression. (check-in: 2404304cc1 user: drh tags: trunk) | |
| 15:01 | Improved presentation on the new code that prevents unnecessary writes to expressions on indexes during an UPDATE when the expression does not reference any of the columns that are changing. (check-in: c9f045295c user: drh tags: trunk) | |
2 Years Ago (more context)
|
2017-09-16
| ||
| 20:58 | Simplify the sqlite3VdbeGet() routine. Smaller, faster, and easier to maintain. (check-in: 5dbb255a93 user: drh tags: trunk) | |
3 Years Ago (more context)
|
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: 6fc95dd7a0 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: 03573887db 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: e660402e5e user: drh tags: trunk) | |
| 18:53 | Remove the #ifdef SQLITE_DEBUG from around the testcase_glob() routine in the command-line shell. (check-in: 9885dac4b9 user: drh tags: trunk) | |
| 17:50 | Merge recent changes from trunk. (check-in: e3d9efa277 user: drh tags: apple-osx) | |
| 17:07 | • Fixed ticket [0eab1ac759]: O(N*N) behavior where it should be O(N) plus 3 other changes (artifact: 8da4f27499 user: drh) | |
| 16:47 | • Edit [01874d252ac44861|01874d252a]: Edit check-in comment. (artifact: ea1387d6a0 user: drh) | |
| 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: a92aee5520 user: dan tags: trunk) | |
| 15:43 | • Edit [a49bc0a8244feb08|a49bc0a824]: Edit check-in comment. (artifact: 87c48ab388 user: drh) | |
| 15:42 | Replace a faulty assert() with a testcase() to assure the condition is tested. Ticket [0eab1ac7591f]. (check-in: a49bc0a824 user: drh tags: trunk) | |
| 14:50 | Add WHERETRACE macros showing every entry and exit from whereLoopAddBtreeIndex(). (check-in: e7653decdc user: drh tags: trunk) | |
| 14:30 | • Ticket [0eab1ac759] O(N*N) behavior where it should be O(N) status still Open with 6 other changes (artifact: 9aab0ed930 user: drh) | |
| 13:57 | • New ticket [0eab1ac759]. (artifact: 62ca7f9b91 user: drh) | |
| 11:53 | Fix SQLITE_OMIT_AUTHORIZATION so that it compiles cleanly. (check-in: a3e3b3e1c5 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: 792afefa9c 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: 8e5c920391 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2015-09-16
| ||
| 17:46 | Add a "flush" to force incremental output to releasetest-out.txt while running the test/releasetest.tcl. script. (check-in: 0f3de2d337 user: drh tags: trunk) | |
| 12:31 | Fix typo in fts5.h. (check-in: 07721c6c24 user: dan tags: trunk) | |
5 Years Ago (more context)
|
2014-09-16
| ||
| 21:54 | Continuing cleanup of memory register memory allocation handling. (check-in: 2598aedc5d user: drh tags: micro-optimizations) | |
| 20:05 | Make sure registers are cleared properly prior to being used to store the result of an OP_Column operator. (check-in: 78fb8838d8 user: drh tags: micro-optimizations) | |
| 20:02 | Clarify the effects of the pager_ota_mode pragma. Add tests and fixes for the same. (check-in: decaccc37c user: dan tags: ota-update) | |
| 18:22 | Simplification of the OP_Column logic for the case of rows with overflow. (check-in: f73678038d user: drh tags: micro-optimizations) | |
| 14:55 | Remove an unused parameter from sqlite3VdbeIdxRowid(). This is cosmetic only as the C-compiler optimizers were already omitting this parameter on amalgamation builds. (check-in: a10a6bba49 user: drh tags: micro-optimizations) | |
| 14:37 | Reduce the number of arguments to RecordCompare functions from 4 to 3, resulting in a small performance increase. (check-in: 8239c35aed user: drh tags: micro-optimizations) | |
| 14:16 | Reorder the elements of the Mem object for a small size reduction and performance improvement. Moved into a branch because MSVC is unable to handle named structure initializer on nullMem. (check-in: 0be3019ed7 user: drh tags: micro-optimizations) | |
| 13:30 | Changes to sqlite3VdbeRecordUnpack() to make it slightly smaller and faster. (check-in: 8fb90da77c user: drh tags: trunk) | |
| 03:24 | Performance improvement to the sqlite3MemCompare() routine by factoring out sqlite3BlobCompare(). (check-in: 20ed2321b0 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2009-09-16
| ||
| 21:31 | • Ticket [e25d9ea771] recursive_triggers=1 failed to work for delete trigger status still Open with 3 other changes (artifact: 60ac754662 user: drh) | |
| 20:48 | • New ticket [e25d9ea771]. (artifact: d55a57ffea user: anonymous) | |
| 16:14 | • New ticket [f1c2a689c6] configure script ignores ``--with-tcl'' option when tclsh8.4 is installed.. (artifact: 1fd89115c5 user: anonymous) | |
| 12:10 | • Closed ticket [832b2f3e6e]: integrity_check error after backup restore plus 2 other changes (artifact: 8a05c5ead1 user: drh) | |
| 10:26 | • Ticket [084941461f] Some minor asyncvfs issues status still Open with 3 other changes (artifact: 780b0f58c7 user: anonymous) | |
| 07:40 | • Ticket [832b2f3e6e] integrity_check error after backup restore status still Open with 1 other change (artifact: 29caa96129 user: anonymous) | |
| 07:16 | • Ticket [832b2f3e6e]: 1 change (artifact: 0a237bdd05 user: anonymous) | |
| 06:55 | • Ticket [832b2f3e6e]: 3 changes (artifact: 4b3e723256 user: anonymous) | |
| 06:19 | • New ticket [832b2f3e6e]. (artifact: 3a8b087ada user: anonymous) | |