This Day In History For 2021-02-09
2 Years Ago (more context)
|
2019-02-09
| ||
| 22:33 | Fix a page-cache reference leak in the btree balancer when there is a corrupt database. (check-in: 9285899120 user: drh tags: deferred-free-space) | |
| 21:06 | Defer computing the MemPage.nFree value of an in-memory btree page until it is actually needed, since for many pages it is never needed. This checkin works sufficiently to prove the concept, but still has issues with exception handling. (check-in: 1d43ee4000 user: drh tags: deferred-free-space) | |
| 19:23 | Change a few assert() statements in fts3 that might fail if the database is corrupt. (check-in: db74a56af7 user: dan tags: trunk) | |
| 17:47 | Fix virtual table support for SQLITE_OPEN_REUSABLE_SCHEMA connections. (check-in: 3ca8856a7b user: dan tags: reuse-schema) | |
3 Years Ago (more context)
|
2018-02-09
| ||
| 23:25 | Improve the performance of the built-in REPLACE() function in cases where it does many substitutions that make the string larger. OSSFuzz is reporting intermittant timeouts when running a test where it does a REPLACE() on a 930KB random blob. Perhaps this enhancement will fix that. (check-in: fab2c2b07b user: drh tags: trunk) | |
| 20:49 | Add the zorder.c extension implementing zorder() and unzorder() SQL functions. (check-in: a57a77dc0c user: drh tags: trunk) | |
| 15:42 | Make the tests in func6.test more robust against implementation changes. (check-in: b685d32310 user: dan tags: trunk) | |
| 15:04 | Fix a harmless compiler warning. (check-in: a6c3115483 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2017-02-09
| ||
| 17:12 | Cleanup the usage of the SQLITE_DISABLE_INTRINSIC compile-time option. Remove the SQLITE_RUNTIME_BYTEORDER compile-time option. Use -DSQLITE_BYTEORDER=0 instead. Fix a bug in R-Tree that occurs when compiling on a known little-endian machine without the use of intrinsic byteswapping functions. (check-in: 798fb9d70d user: drh tags: trunk) | |
5 Years Ago (more context)
|
2016-02-09
| ||
| 22:54 | Update the snapshot tarball name to use the date (ISO8601 format) instead of the SHA1 hash in its name. (check-in: 070ec66f67 user: drh tags: trunk) | |
| 22:39 | Add the new "snapshot-tarball" target to the unix makefiles, for building a tarball similar to "amalgamation-tarball" but named by the SHA1 hash of the current check-out rather than by the version number. (check-in: 4f360b2ae7 user: drh tags: trunk) | |
| 22:00 | Update the MSVC autoconf makefile with the recent changes from the primary one. (check-in: c7242aa3e9 user: mistachkin tags: trunk) | |
| 20:37 | Fix the makefiles in the autoconf-tarball so that they build the command-line shell with SQLITE_ENABLE_EXPLAIN_COMMENTS. (check-in: 1135ad014a user: drh tags: trunk) | |
| 20:31 | In the shell, use the appropriate string constant instead of a literal new-line. (check-in: 61951b153d user: mistachkin tags: trunk) | |
| 20:11 | Enhance the command-line shell to be in auto-explain mode by default. It is no longer necessary to use the ".explain" command to put the shell into a mode where the EXPLAIN output is formatted nicely. That now happens automatically. (check-in: 751915cb7e user: drh tags: trunk) | |
| 20:04 | Improved auto-detection of EXPLAIN output in the shell. (Closed-Leaf check-in: 6c6d7a6e89 user: drh tags: auto-explain) | |
| 18:39 | Add auto-explain mode to the command-line shell. Default on. Auto-explain tries to automatically detect EXPLAIN queries and format them appropriately. (check-in: 1d62aa6b31 user: drh tags: auto-explain) | |
| 18:28 | Fix MSVC makefile options that enable control-flow guard. (check-in: 51b6823f4c user: mistachkin tags: trunk) | |
| 17:12 | Fix the top-level makefiles to always include SQLITE_ENABLE_EXPLAIN_COMMENTS when building the shell. Still need to fix main.mk and the amalgamation tarball. (check-in: 992282399c user: drh tags: trunk) | |
| 16:09 | Code simplification: ALTER TABLE ADD COLUMN always upgrades the file_format to 4 if is not there already. No need to upgrade to only 2 or 3 since format 4 has now been supported for over 10 years. (check-in: e1d8ec8554 user: drh tags: trunk) | |
| 15:50 | Merge recent fixes and enhancements from trunk. (check-in: f073401792 user: drh tags: apple-osx) | |
| 15:44 | Merge enhancements and fixes from trunk. (check-in: f040a5bb62 user: drh tags: sessions) | |
| 15:10 | Merge latest trunk changes with this branch. (check-in: 1a4182eedd user: dan tags: schemalint) | |
| 14:12 | • Fixed ticket [d06a25c844]: Incorrect result from a UNION with an ORDER BY plus 6 other changes (artifact: 1ef35260c9 user: drh) | |
| 02:12 | Make sure every co-routines has its own set of temporary registers and does not share temporaries, since a co-routine might expect the content of a temporary register to be preserved across an OP_Yield. Proposed fix for ticket [d06a25c84454a]. (check-in: ca72be8618 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2011-02-09
| ||
| 19:55 | Make sure code *compiles* with each OMIT and ENABLE option. Mostly changes to test modules. (check-in: 7cc515edc9 user: shaneh tags: trunk) | |
| 18:39 | • Ticket [89b8c9ac54] False reports of corruption after writing db with two different versions (3.7 and 3.6). status still Open with 3 other changes (artifact: 58f6afac74 user: drh) | |
| 18:20 | • Ticket [89b8c9ac54]: 2 changes (artifact: a149ec4f13 user: dan) | |
| 18:19 | Do not report corruption if the the db size header field is greater than the file size on disk unless the two change-counter header fields are identical. Fix for ticket [89b8c9ac54]. (check-in: 00c4596f0b user: dan tags: trunk) | |
| 18:08 | • New ticket [89b8c9ac54] False reports of corruption after writing db with two different versions (3.7 and 3.6).. (artifact: c3bfe79ff1 user: dan) | |
| 15:25 | Update Makefile.in for fts3_aux changes. (check-in: 38b7cb33c5 user: shaneh tags: trunk) | |
| 03:04 | Use macros to define the relative costs of search and seek operations when computing costs in the query planner. Current constants seems wrong and need to be fixed, but doing so will alter test results. Need more experimentation to determine accurate relative costs. (check-in: 5f2ec44b22 user: drh tags: trunk) | |
| 03:03 | Simplifications to the sqlite3_wal_checkpoint_v2() logic. (check-in: 652b8835c5 user: drh tags: trunk) | |
15 Years Ago (more context)
|
2006-02-09
| ||
| 23:05 | Ignore errors when when calling fsync() on a directory. Ticket #1657. (CVS 3068) (check-in: d54d3b82c4 user: drh tags: trunk) | |
| 22:24 | Allow '@' to introduce host parameter names for compatibility with MS SQL Server. Ticket #1671. (CVS 3067) (check-in: 0738ef818d user: drh tags: trunk) | |
| 22:13 | SUM never gives an error. An integer result is returned for exact results and a floating point result is returned for approximate results. Tickets #1664, #1669, and #1670. (CVS 3066) (check-in: 9e04f8fdf1 user: drh tags: trunk) | |
| 18:35 | Deprecate the sqlite3_aggregate_count() API. Make sure all aggregate counters are 64 bits. Remove unused StdDev structure from func.c. Ticket #1669. (CVS 3065) (check-in: 44bd7ba432 user: drh tags: trunk) | |
| 17:47 | Integer overflow in SUM causes an exception. Ticket #1669. (CVS 3064) (check-in: c72b946198 user: drh tags: trunk) | |
| 16:52 | Back out check-in (3058) - it breaks too much application code. (CVS 3063) (check-in: 731f1e3245 user: drh tags: trunk) | |
| 13:43 | Add the sqlite3_table_column_meta() API. (CVS 3062) (check-in: 1ac72f68c0 user: danielk1977 tags: trunk) | |
| 13:38 | Avoid overflowing the 48-bit mantissa of a floating point number when summing large integers in the SUM() function. Ticket #1664. (CVS 3061) (check-in: a9169e879d user: drh tags: trunk) | |
| 02:56 | Correctly handle COLLATE clauses in tables being modified by an ALTER TABLE ADD COLUMN command. Ticket #1665. (CVS 3060) (check-in: baef2f66be user: drh tags: trunk) | |
| 02:41 | Use 64-bit integers in sqlite3_analyzer. Ticket #1666. (CVS 3059) (check-in: 8b3068aca7 user: drh tags: trunk) | |