This Day In History For 2023-10-23
1 Year Ago (more context)
|
2022-10-23
| ||
| 23:33 | • Edit [5dd78588203b38e5|5dd7858820]: Mark "Closed". (artifact: d603cb7d3b user: drh) | |
| 20:09 | The wide-table covering index detection must take into account aggregate queries. (check-in: 9ac73f83c5 user: drh tags: covering-index-enh) | |
2 Years Ago (more context)
|
2021-10-23
| ||
| 22:14 | Improve the authorizer filter for ATTACH on fuzzcheck. (check-in: 87d49e8087 user: drh tags: trunk) | |
| 22:11 | Provide an assert() to fire for applications that should never open or create a disk-based database file. (check-in: 5218ac788c user: drh tags: trunk) | |
| 20:32 | The pager now remembers when a VFS reports that a database file is SQLITE_OPEN_MEMORY and treats that database as an in-memory database. (check-in: 967b656238 user: drh tags: trunk) | |
| 17:46 | Fix the memdb VFS so that it does not allow mmap if it is resizable, and so that it never opens a disk file for any reason. (check-in: 5ee14715a5 user: drh tags: trunk) | |
| 11:30 | Update fuzzcheck so that it allows ATTACH statements with memdb filenames. (check-in: 31671237e5 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2019-10-23
| ||
| 21:00 | Add an experimental set of UUID processing functions as the uuid.c extension in ext/misc/uuid.c. (check-in: 1a6e009372 user: drh tags: trunk) | |
| 18:14 | Add uuid_string and uuid_blob functions (Leaf check-in: 97ba442b8d user: numist tags: uuid-funcs) | |
| 18:09 | • Fixed ticket [135c9da751]: Comparison of row values with COLLATE NOCASE yields incorrect result plus 6 other changes (artifact: 8f2a03f897 user: drh) | |
| 18:09 | When a vector comparison appears in the WHERE clause and the constraint side has a COLLATE clause on the first term of the vector, be sure to honor that COLLATE clause. Ticket [135c9da7513e5a97]. (check-in: 978b2d20cf user: drh tags: trunk) | |
| 18:01 | Create new branch named "uuid-funcs" (check-in: 815dc0437c user: numist tags: uuid-funcs) | |
| 16:46 | • New ticket [135c9da751] Comparison of row values with COLLATE NOCASE yields incorrect result. (artifact: ad3f184cda user: mrigger) | |
| 15:47 | Minor adjustments for clarity and test coverage. (check-in: 3006571687 user: drh tags: generated-columns) | |
| 03:53 | Fix incorrect arguments to testcase() macros. (check-in: 812467fbf0 user: drh tags: generated-columns) | |
| 02:32 | • Edit [c8ade949d4a2eb3b|c8ade949d4]: Move to branch obsolete. Add propagating "hidden". Mark "Closed". Edit check-in comment. (artifact: f40b2051c8 user: numist) | |
| 00:31 | Fix the foreign key logic to be compatible with generated columns. (check-in: 3de57145a1 user: drh tags: generated-columns) | |
5 Years Ago (more context)
|
2018-10-23
| ||
| 13:48 | Fix a problem with using window functions in compound (UNION, INTERSECT etc.) queries. (check-in: 059ff53a46 user: dan tags: trunk) | |
10 Years Ago (more context)
|
2013-10-23
| ||
| 23:37 | Change the sqlite3OpenTable() utility to open the PRIMARY KEY index when reading a WITHOUT ROWID table. (check-in: 247f389930 user: drh tags: omit-rowid) | |
| 22:23 | Construct secondary indices on WITHOUT ROWID tables. (check-in: 2c028ddc85 user: drh tags: omit-rowid) | |
| 17:39 | Report an error when trying to resolve column name "rowid" in a WITHOUT ROWID table. (check-in: 36bcc9cb88 user: drh tags: omit-rowid) | |
| 16:03 | Get VACUUM and the xfer optimization working with WITHOUT ROWID. (check-in: 579815fff1 user: drh tags: omit-rowid) | |
| 13:30 | Some inserts and queries working for multi-column primary keys and WITHOUT ROWID. (check-in: b21d831b2a user: drh tags: omit-rowid) | |
| 01:57 | Some simple inserts and queries working on WITHOUT ROWID tables. (check-in: 3f8016dee2 user: drh tags: omit-rowid) | |
| 00:32 | Build internal data structures appropriately for WITHOUT ROWID tables. (check-in: 35a3606071 user: drh tags: omit-rowid) | |
15 Years Ago (more context)
|
2008-10-23
| ||
| 05:45 | Fix a bug in pragma table_info. Column default values specified as negative numbers (col DEFAULT -1) were being reported as NULL by the pragma. (CVS 5839) (check-in: 0e448bc609 user: danielk1977 tags: trunk) | |
20 Years Ago (more context)
|
2003-10-23
| ||
| 15:27 | Fix progress test error 1-2 (CVS 1115) (check-in: c3a495026c user: peter tags: trunk) | |