This Day In History For 2019-10-11
1 Year Ago (more context)
|
2018-10-11
| ||
| 18:45 | Fix issues with the new textkey pragma from the previous check-in. (check-in: d1008b0728 user: drh tags: apple-osx) | |
| 18:41 | Add the textkey and textrekey pragmas. (check-in: f03164d454 user: drh tags: trunk) | |
| 18:28 | Add the textkey and textrekey pragmas. (check-in: f829099d25 user: drh tags: apple-osx) | |
| 17:05 | Merge compiler warning fixes and the codec enhancement from trunk. (check-in: f9fa58e1d1 user: drh tags: apple-osx) | |
| 16:53 | Fix harmless compiler warnings in the CLI. (check-in: 1916d2912a user: drh tags: trunk) | |
| 16:38 | Always reset the pager before changing the codec. (check-in: 0bf0fd242b user: drh tags: trunk) | |
| 16:28 | Fix a merge problem in main.mk (check-in: 9a54935917 user: drh tags: apple-osx) | |
| 14:07 | Remove surplus code in geopoly.c that seems to have come from a bad merge. (check-in: c486a63c33 user: drh tags: apple-osx) | |
| 13:57 | Merge enhancements from trunk. (check-in: 9e10d88bcb user: drh tags: apple-osx) | |
| 13:51 | On the first connection to a WAL-mode database that was not cleanly shut down and contains a left-over -shm file, truncate the -shm file to 3 bytes instead of to 0 bytes. Avoiding a truncation to 0 means that system monitoring tools can better detect if a process illegitimately tries to truncate a -shm file. Such a rogue process might think it is being helpful by cleaning up old files, but there is a race condition that can cause damage to the database. (check-in: 90cf32cde0 user: drh tags: trunk) | |
| 10:37 | In the CLI, fix a file descriptor leak following OOM and a missing va_end() call. (check-in: ec36d15a9e user: drh tags: trunk) | |
| 02:39 | In the unix VFS, fix the heap shm allocator (used for unix-excl) so that it works even on systems where the page size is larger than 32KB. (check-in: 7fbb083c5c user: drh tags: trunk) | |
2 Years Ago (more context)
|
2017-10-11
| ||
| 20:27 | Add test file mmapwarm.test. With tests for the sqlite3_mmap_warm() extension. (check-in: 5c4980ef17 user: dan tags: trunk) | |
| 20:26 | Merge latest trunk changes with this branch. (check-in: 2719cf5c5b user: dan tags: schemalint) | |
| 20:10 | Change some internal details to bring this branch closer to the code on trunk. (check-in: 58e42cfd7d user: dan tags: schemalint) | |
| 18:26 | Add the checkfreelist extension to the command-line shell. (check-in: 48418f2ed5 user: drh tags: dbpage) | |
| 18:21 | Check that the leaf count on each freelist trunk page is in range as part of checkfreelist processing. (check-in: 4e89406248 user: dan tags: dbpage) | |
| 18:00 | Add new extension "checkfreelist", which uses sqlite_dbpage to check that there are no invalid entries on the database free-list. (check-in: 21930ef537 user: dan tags: dbpage) | |
| 17:51 | Convert the implementation of the ".dbstat" dot-command of the command-line shell to use the sqlite_dbpage table. (check-in: 497409e167 user: drh tags: dbpage) | |
| 17:50 | Make JSON1 defines consistent in the makefiles for MSVC. (check-in: 31eee0e4bf user: mistachkin tags: branch-3.21) | |
| 17:25 | Enable JSON by default in the Windows command-line shell sqlite3.exe. (check-in: 79c96121ba user: drh tags: branch-3.21) | |
| 17:13 | Enable sqlite_dbpage and dbstat virtual tables in the shell, by default. (check-in: 01bf856c42 user: drh tags: dbpage) | |
| 15:02 | Get writes working on the sqlite_dbpage virtual table. Add a few test cases. (check-in: a8b264d811 user: drh tags: dbpage) | |
| 13:48 | Initial implementation of the "sqlite_dbpage" virtual table. Currently it is read-only and has a place-holder xBestIndex. (check-in: c2c1d656e3 user: drh tags: dbpage) | |
| 12:20 | In the speed-check.sh test script, allow an additional test-name argument which becomes the comparison baseline, in place of "trunk". (check-in: 0245adffc6 user: drh tags: trunk) | |
| 11:12 | Create a branch for the 3.21.0 release. Development continues on trunk. (check-in: 0f160a8abb user: drh tags: branch-3.21) | |
4 Years Ago (more context)
|
2015-10-11
| ||
| 20:39 | Detect and report circularly defined views even if the views have the columns defined in the CREATE VIEW statement. (check-in: 9ab9c8c6d7 user: drh tags: trunk) | |
| 20:08 | Remove an unreachable branch in the query flattener substitution logic. (check-in: 46ee3453a3 user: drh tags: trunk) | |
| 19:46 | Improved substitution logic in the query flattener. Saves code space, and (more importantly) works correctly with table-valued functions. (check-in: 3d0bd95e97 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2014-10-11
| ||
| 23:31 | Performance optimization and very slight size reduction for OP_Column. (check-in: 869c30e45c user: drh tags: trunk) | |
| 20:00 | Attempt to further reduce memcpy() in balance_nonroot(). (check-in: fec849dcca user: dan tags: defrag-opt) | |
| 17:22 | Simplification to the insertCell() routine in btree.c, resulting in a performance boost and a very small size decrease. It turns out that the extra work involved in sometimes avoiding an memcpy() of the first four bytes of a record takes more time than just unconditionally copying those four bytes. (check-in: 66de15580d user: drh tags: trunk) | |
| 10:52 | Require the SQLITE_ENABLE_RTREE compile-time option in speedtest1.c in order to enable the R-Tree tests. (check-in: 5d29a033b0 user: drh tags: trunk) | |
| 02:12 | • Fixed ticket [ba7cbfaedc]: Wrong output order when a DESC index and GROUP BY and ORDER BY. plus 5 other changes (artifact: 7542bf3121 user: drh) | |
| 02:12 | Make sure that a GROUP BY that also implements an ORDER BY scans the table in the correct order. Fix for ticket [ba7cbfaedc7e6]. (check-in: 7a32fdfd4b user: drh tags: trunk) | |
| 01:22 | Remove an unnecessary conditional from the EXPLAIN QUERY PLAN logic. (check-in: c5dc83ebde user: drh tags: trunk) | |
10 Years Ago (more context)
|
2009-10-11
| ||
| 07:36 | • Ticket [ee4b2b48f5] Prepared statement cache status still Open with 4 other changes (artifact: b9ba3cb62a user: rogerb) | |
| 06:43 | • New ticket [ee4b2b48f5]. (artifact: 77c1854d0f user: rogerb) | |
| 06:21 | • New ticket [beb2dd69ad] do_meta_command inconsistent return values. (artifact: e428590bd7 user: rogerb) | |
| 06:04 | • New ticket [08595ca456] INTERSECT operator should have higher precedence. (artifact: da23ad28c5 user: rogerb) | |
| 05:44 | • New ticket [ed2ff2f4ef] Call progress callback while doing pragma integrity_check. (artifact: 64e43de70d user: rogerb) | |
| 05:33 | • New ticket [2cb66577f6] Diagnostic message is unintentionally printed in batch mode. (artifact: a3219b5657 user: rogerb) | |
15 Years Ago (more context)
|
2004-10-11
| ||
| 22:26 | Increment the version number. Prepare for release of version 3.0.8. (CVS 2019) (check-in: ff04d7d48b user: drh tags: trunk) | |
| 21:49 | Fix typo on the homepage. (CVS 2018) (check-in: 7f190f85e2 user: drh tags: trunk) | |
| 21:48 | Fix typo in the lockingv3.html page on the website. (CVS 2017) (check-in: a31b647727 user: drh tags: trunk) | |