This Day In History For 2020-07-29
1 Year Ago (more context)
|
2019-07-29
| ||
| 22:42 | • New ticket [ced41c7c] Query with DISTINCT does not fetch all distinct rows. (artifact: 538cb2f4 user: mrigger) | |
| 17:18 | Convert an assert() in R-Tree into a database corruption detection case. (check-in: 48b518eb user: drh tags: trunk) | |
| 16:53 | Fix a crash in fts3 caused by corrupt database records. (check-in: 11f7f94f user: dan tags: trunk) | |
| 15:54 | • Closed ticket [ccbe5759]: ANALYZE causes DISTINCT to malfunction in CROSS JOIN plus 5 other changes (artifact: 19310324 user: dan) | |
| 15:32 | When using an index for both DISTINCT and ORDER BY, do not confuse the number of columns required for distinctness with the number required to get the correct sort order. Fix for [6749cb3c]. (check-in: 6ac0f822 user: dan tags: trunk) | |
| 14:42 | When using an index for both DISTINCT and ORDER BY, do not confuse the number of columns required for distinctness with the number required to get the correct sort order. Fix for [6749cb3c]. (Closed-Leaf check-in: b4716931 user: dan tags: tkt-6749cb3c) | |
| 09:28 | • New ticket [ccbe5759] ANALYZE causes DISTINCT to malfunction in CROSS JOIN. (artifact: 6749cb3c user: mrigger) | |
| 06:07 | • Fixed ticket [ba2f4585]: Query with ORDER BY results in "database disk image is malformed" error plus 6 other changes (artifact: 468ed184 user: drh) | |
| 06:06 | Fix the OP_Affinity operator so that when applying REAL affinity, it only sets MEM_IntReal if the integer value will fit in 6 bytes or less. Fix for ticket [ba2f4585cf495231] (check-in: 2b221bb1 user: drh tags: trunk) | |
| 06:05 | • Closed ticket [18ab5da2]: Issue with DISTINCT and COLLATE plus 7 other changes (artifact: 739f46ad user: drh) | |
| 05:23 | Fix a minor typo in a comment. (check-in: cea8a892 user: drh tags: trunk) | |
| 02:52 | Sync up warning related compiler options in the Makefiles for MSVC. (check-in: e77d48d1 user: mistachkin tags: trunk) | |
| 02:49 | Fix harmless compiler warning seen with MSVC for x64. (check-in: 857b2ba6 user: mistachkin tags: trunk) | |
2 Years Ago (more context)
|
2018-07-29
| ||
| 18:56 | In the command-line shell, always exit if realloc() fails. (check-in: e390023c user: drh tags: trunk) | |
3 Years Ago (more context)
|
2017-07-29
| ||
| 17:47 | • Ticket [de3403bf] Column name shift due to LEFT JOIN query flattening status still Open with 6 other changes (artifact: 84cc8ca4 user: drh) | |
| 17:10 | Merge latest trunk changes with this branch. (check-in: b42c8779 user: dan tags: server-process-edition) | |
| 17:02 | New test cases for column name generation interacting with the query flattener. (Closed-Leaf check-in: 0c38dde4 user: drh tags: early-column-names) | |
| 17:01 | Update test program "tserver" to use a native pthreads mutex/condition variable to efficiently manage wal file checkpoints without the wal file growing indefinitely. (check-in: 8299bdb7 user: dan tags: server-process-edition) | |
| 16:01 | Move the generation of output column names earlier, to right after name resolution and before query transformations such as flattening. This prevents the names from getting mangled by query transformations, and obviates hacks in the query flattener that attempt to work around the name mangling. The resulting code is smaller and faster and gives more consistent output. This is an alternative fix to ticket [de3403bf5ae5f72ed]. (check-in: 09834279 user: drh tags: early-column-names) | |
| 14:56 | Use the subquery column name, not the original SQL statement text, as the added AS clause in the query flattener. (Closed-Leaf check-in: 5df7f0e6 user: drh tags: flattener-column-names) | |
| 03:33 | In the query flattener, only add AS clauses to output columns of the outer query that are copied directly from the inner query. Formerly, all columns of the outer query received an AS clause if they did not have one already. This is a proposed fix for ticket [de3403bf5ae5f72]. (check-in: 439cc5c5 user: drh tags: flattener-column-names) | |
| 03:26 | • New ticket [de3403bf] Column name shift due to LEFT JOIN query flattening. (artifact: e6b7df69 user: drh) | |
4 Years Ago (more context)
|
2016-07-29
| ||
| 20:58 | Fix some issues with vector range constraints and the column cache. Also vector range constraints and rowid columns. (check-in: 42607366 user: dan tags: rowvalue) | |
| 18:12 | Change the way "(a, b) = (SELECT *)" expressions are handled in where.c if there is an index on one of the columns only. (check-in: 4dfebff2 user: dan tags: rowvalue) | |
| 17:36 | Using the header file 'intrin.h' requires MSVC 2005 or later. (check-in: 9fae75c0 user: mistachkin tags: trunk) | |
| 16:32 | Turn memory status off by default. (check-in: ea3c7162 user: drh tags: debug) | |
| 14:31 | Enhance a debugging log message to better identify a mutex. (check-in: e60cb6d8 user: dan tags: debug) | |
| 14:23 | Use __sync_synchronous(), when available, instead of a mutex when a memory barrier is needed. (check-in: 7d4562e9 user: drh tags: debug) | |
| 14:10 | Add calls to sqlite3_log() when sqlite3_mutex_enter() takes more than 100,000 CPU cycles. (check-in: 33c7ef7a user: drh tags: debug) | |
| 04:12 | For test 'shell1-5.0', disable round-trip testing for characters in the range 0xE0 to 0xEF on Linux, due to intermittent shell portability issues. (check-in: 544c990a user: mistachkin tags: trunk) | |
| 02:04 | Fix typo in a test file interactive output string. (check-in: 4fedd790 user: mistachkin tags: trunk) | |
| 01:55 | Merge additional linkage macro changes from the branch. (check-in: 8b0eb22e user: drh tags: trunk) | |
| 01:49 | Further refinement to the calling convention macros. (check-in: 45588de3 user: drh tags: trunk) | |
| 01:47 | Merge updates from trunk. (check-in: 71ffa195 user: mistachkin tags: callbackConv) | |
| 01:46 | Update the autoconf makefile for MSVC. (check-in: 2daf2098 user: mistachkin tags: callbackConv) | |
| 01:32 | Undo some unhelpful changes to skip-scan scoring that were added by the check-in [9e2b2681] that improved scoring of index scan. (check-in: c7d51934 user: drh tags: trunk) | |
| 01:31 | Add macro necessary for building several extensions when the __stdcall calling convention is not in use. (check-in: bc8c9b55 user: mistachkin tags: callbackConv) | |
| 01:24 | • Edit [3ea567c4b07b2a7a|3ea567c4]: Move to branch callbackConv. (artifact: cc47d18d user: drh) | |
5 Years Ago (more context)
|
2015-07-29
| ||
| 22:38 | Support building VSIX packages for UAP using Visual Studio 2015 and the Windows 10 SDK. (check-in: 96559adb user: mistachkin tags: trunk) | |
| 22:37 | Update Windows 10 SDK version for RTM. (Closed-Leaf check-in: 80ab338c user: mistachkin tags: msvc2015) | |
| 21:47 | Add SQLITE_DISABLE_INTRINSIC define to disable use of intrinsic functions (e.g. for certain older compilers and/or platforms). (check-in: f0075d73 user: mistachkin tags: trunk) | |
| 20:24 | Fix the releasetest.tcl script so that it ignore cast overflow errors that recent versions of clang generate but which are unavoidable given the test input. (check-in: a0020c57 user: drh tags: trunk) | |
| 20:00 | Version 3.8.11.1 (check-in: cf538e27 user: drh tags: trunk, release, version-3.8.11.1) | |
| 15:22 | Restore an undocumented side-effect of PRAGMA cache_size: it forces the database schema to be parsed. Also increase the version number to 3.8.11.1. (check-in: e4628de3 user: drh tags: trunk) | |
| 14:58 | Update comments in fts5.h describing the xColumnCount() API function. (check-in: a623eb55 user: dan tags: trunk) | |
| 14:46 | Increase the version number to 3.8.11.1 (Closed-Leaf check-in: 326d746d user: drh tags: branch-3.8.11) | |
| 14:45 | • Edit [4489722a6b560355|4489722a]: Edit check-in comment. (artifact: 281d3440 user: drh) | |
| 14:10 | The "PRAGMA cache_size" reads the database schema, as it has done in all prior versions of SQLite. This side-effect of cache_size is undocumented, but apparently it does get used and its absence from 3.8.11 was causing problems. (check-in: 4489722a user: drh tags: branch-3.8.11) | |
| 12:14 | Only allow UNLOCKED transactions to commit if none of the pages read by the transaction have been modified since it was opened. (check-in: 0b971842 user: dan tags: begin-concurrent) | |
10 Years Ago (more context)
|
2010-07-29
| ||
| 19:02 | • Add attachment tkt-f3e5abed55.test to ticket [f3e5abed] (artifact: aee9538c user: dan) | |
| 18:59 | • New ticket [f3e5abed] Problems retrying COMMIT after SQLITE_BUSY on multi-file transaction. (artifact: fd92e3d4 user: dan) | |
| 10:13 | Unconditionally include the pTmpSpace size in the estimate of the pager memory used. (check-in: 4b97f864 user: drh tags: trunk) | |
| 10:08 | • Fixed ticket [c43940c4]: sqlite3_profile gives milliseconds (was nanoseconds in earlier releases) plus 1 other change (artifact: 057fea73 user: drh) | |
| 10:07 | Change the profile timer units back to nanoseconds and update the sqlite3_profile() documentation. Ticket [c43940c49b74c70a69] (check-in: 7783b98a user: drh tags: trunk) | |
| 04:58 | • Ticket [c43940c4] sqlite3_profile gives milliseconds (was nanoseconds in earlier releases) status still Open with 3 other changes (artifact: 5ea7d43a user: rogerb) | |
| 04:54 | • New ticket [c43940c4]. (artifact: 5ad542d1 user: rogerb) | |
| 01:55 | • Fixed ticket [ce7c133e]: Foreign key constraint fails when it should succeed. plus 1 other change (artifact: b3a12114 user: drh) | |
| 01:55 | • Ticket [ce7c133e]: 4 changes (artifact: 6fb11fef user: drh) | |
| 01:50 | Correct handling of compound foreign key constraints that include the integer primary key as one of the columns. Ticket [ce7c133ea6cc9ccdc1] (check-in: 53902f7d user: drh tags: trunk) | |
15 Years Ago (more context)
|
2005-07-29
| ||
| 19:43 | Fix problems caused by over-agressive optimization of ORDER BY in joins. Lots more testing needed. (CVS 2571) (check-in: 1a4e526d user: drh tags: trunk) | |
| 15:36 | Fix authentication so that it works with AS aliases. Ticket #1338. (CVS 2570) (check-in: cc7ae73e user: drh tags: trunk) | |
| 15:10 | Optimizer now converts OR-connected WHERE-clause terms into an IN operator so that they can be used with indices. There are known problems with the ORDER BY optimization in this and in several prior check-ins. This check-in is not recommended for production use. (CVS 2569) (check-in: d23c8bf8 user: drh tags: trunk) | |
20 Years Ago (more context)
|
2000-07-29
| ||
| 13:20 | better column names in the shell (CVS 111) (check-in: 57022a9d user: drh tags: trunk) | |
| 13:06 | better column labels in select results (CVS 110) (check-in: 3bf434d9 user: drh tags: trunk) | |