This Day In History For 2023-11-05
1 Year Ago (more context)
|
2022-11-05
| ||
| 19:26 | Update test file dbpagefault.test to account for the restriction on using SQLITE_VTAB_DIRECTONLY virtual tables from within triggers. (check-in: 2b68fc8aa3 user: dan tags: trunk) | |
| 17:52 | Fix harmless compiler warnings. (check-in: fe44e7ef53 user: drh tags: reuse-schema) | |
| 15:31 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 224eaf2622 user: drh tags: reuse-schema) | |
2 Years Ago (more context)
|
2021-11-05
| ||
| 23:32 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: ca09148e13 user: drh tags: reuse-schema) | |
| 22:35 | Add the rbu_exclusive_checkpoint query parameter to RBU. (check-in: c2d33ea9d8 user: drh tags: trunk) | |
| 22:23 | New test cases for rbu_exclusive_checkpoint query parameter. (Closed-Leaf check-in: 00285ff10c user: drh tags: rbu_exclusive_checkpoint) | |
| 19:52 | Update an assert() statement to conform to the changes of the previous check-in. (check-in: b5c668cac8 user: drh tags: trunk) | |
| 19:36 | Add the SQLITE_OPEN_EXRESCODE flag for sqlite3_open_v2(). (check-in: ff9373f42d user: drh tags: trunk) | |
| 19:05 | • Edit [7cb77296a22a87e7|7cb77296a2]: Move to branch rbu_exclusive_checkpoint. (artifact: 099881a99f user: dan) | |
| 19:04 | If the target database URI passed to sqlite3rbu_open() is contains the option "rbu_exclusive_checkpoint=1", hold an exclusive lock for the duration of any incremental checkpoint operation. (check-in: 7cb77296a2 user: dan tags: rbu_exclusive_checkpoint) | |
| 14:13 | Update sqllimits1.test to account for recent changes to SQL function strftime(). (check-in: 7bba415f91 user: dan tags: trunk) | |
| 12:34 | Use the FTS_CORRUPT_VTAB macro rather than a direct call to sqlite3Fts3Corrupt() in [2fad2a89527757b3] so that the build works in all cases. (check-in: 029c59cdf9 user: drh tags: trunk) | |
| 12:10 | • Edit [f474ac370accc5c7|f474ac370a]: Edit check-in comment. (artifact: 274fba792d user: drh) | |
| 11:52 | Remove an incorrect NEVER() reported at forum post 5bbabfb7ce. Also use this opportunity to improve the isSimpleCount() function with better formatting, an expanded header comment, and some extra assert() and textcase() macros. (check-in: 2927185be8 user: drh tags: trunk) | |
| 11:26 | Fix vacuum3.test so that it works with SQLITE_OMIT_ALTERTABLE builds. (check-in: 07cca2fa89 user: dan tags: trunk) | |
| 11:18 | Update a test case in sqllimits1.test to account for the updated implementation of SQL function strftime() (check-in: f474ac370a user: dan tags: trunk) | |
| 10:43 | Fix a couple of problems with test scripts and SQLITE_OMIT_ALTERTABLE builds. (check-in: 3ab5414d33 user: dan tags: trunk) | |
3 Years Ago (more context)
|
2020-11-05
| ||
| 19:13 | Suppress errors associated with TEMP triggers that reference objects in non-TEMP databases. This is a continuation of the fix for ticket #3810 shown in check-in [ba1afc040171810d] from 2009-08-06, based on a bug report in forum post 157dc791df (check-in: 991ca9b26b user: drh tags: trunk) | |
| 14:50 | Remove unused variable from speedtest1.c (check-in: c0a18565e6 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2019-11-05
| ||
| 22:31 | • New ticket [2399f59861] REPLACE on table with generated NOT NULL column results in segfault. (artifact: c677a2c3da user: mrigger) | |
| 13:04 | • Closed ticket [1cda8f4b54]: UNLIKELY in query causes row to not be fetched plus 6 other changes (artifact: 248d7d1e3f user: drh) | |
5 Years Ago (more context)
|
2018-11-05
| ||
| 23:01 | Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. (check-in: 31942b3dd3 user: drh tags: read-only-shadow) | |
| 20:37 | Version 3.25.3 (check-in: 89e099fbe5 user: drh tags: release, version-3.25.3, branch-3.25) | |
| 20:37 | Add preliminary version of "changesetfuzz" program. For fuzzing changeset data without creating corrupt changesets. (check-in: 81ac8745fa user: dan tags: changesetfuzz) | |
| 19:37 | Add the SQLITE_DBCONFIG_DEFENSIVE flag. (check-in: 11d98414ea user: drh tags: trunk) | |
| 16:38 | Eponymous virtual tables appear to exist in all schemas. This is an alternative and improved fix to the eponymous virtual table in trigger problem that was previously addressed by checkin [1fa74930ab56171e]. (check-in: b8d35c4a7c user: drh tags: trunk) | |
| 13:53 | Merge recent trunk enhancements. (check-in: 62acf7a09e user: drh tags: apple-osx) | |
| 13:48 | Disable the IS NOT NULL optimization when the IS NOT NULL operator is part of the ON clause of a LEFT JOIN. Fix for ticket [65eb38f6e46de8c75e188a17ec]. (check-in: 8d09ce5d73 user: drh tags: branch-3.25) | |
| 13:43 | Add extra defenses against strategically corrupt databases to fts3/4. (check-in: 940f2adc85 user: drh tags: branch-3.25) | |
| 13:42 | • Fixed ticket [1a84668dcf]: Assertion fault due to malformed PRIMARY KEY plus 5 other changes (artifact: 4912034c3a user: drh) | |
| 13:37 | Increase the version number to 3.25.3. (check-in: 1250ab8f22 user: drh tags: branch-3.25) | |
| 13:35 | Fix a assert() in the query planner that can arise when doing row-value operations on a PRIMARY KEY that contains duplicate columns. Ticket [1a84668dcfdebaf12415d]. (check-in: 1309c84ad3 user: drh tags: branch-3.25) | |
| 08:09 | • Fixed ticket [65eb38f6e4]: Incorrect answer on LEFT JOIN when STAT4 is enabled plus 6 other changes (artifact: 88c47ba1e7 user: drh) | |
| 07:53 | Disable the IS NOT NULL optimization when the IS NOT NULL operator is part of the ON clause of a LEFT JOIN. Fix for ticket [65eb38f6e46de8c75e188a17ec]. (check-in: af39661e60 user: drh tags: trunk) | |
| 07:34 | • New ticket [65eb38f6e4] Incorrect answer on LEFT JOIN when STAT4 is enabled. (artifact: cf10feffbe user: drh) | |
10 Years Ago (more context)
|
2013-11-05
| ||
| 22:39 | Make sure the query planner knows that the PRIMARY KEY index of a WITHOUT ROWID table is always a covering index. (check-in: 03e7019e14 user: drh tags: omit-rowid) | |
| 19:41 | Fix conflict handling for the case when the rowid uses REPLACE but other unique constraints use FAIL or IGNORE. (check-in: 573cc27427 user: drh tags: omit-rowid) | |
| 17:30 | Fix a bug in secondary index initialization when the secondary index is a superset of the PRIMARY KEY for a WITHOUT ROWID table. (check-in: 52a3d88519 user: drh tags: omit-rowid) | |
| 16:56 | Remove an "explain" command from test script without_rowid1.test that was accidentally committed. (check-in: 4b41d989e8 user: dan tags: omit-rowid) | |
| 16:39 | Unless the destination table is completely empty, disable the xfer optimization for WITHOUT ROWID tables. (check-in: 3877c9f505 user: dan tags: omit-rowid) | |
| 15:02 | Updates to the backcompat.test test script so that it works with really old (3.6.*) versions. (check-in: ace7e7b642 user: dan tags: omit-rowid) | |
| 14:19 | Add tests for updates of without-rowid tables that use non-BINARY collation sequences for the primary key columns. And a minor bugfix to the same. (check-in: 99b1fa4b16 user: dan tags: omit-rowid) | |
| 13:33 | Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. (check-in: 54b2219297 user: drh tags: omit-rowid) | |
| 01:59 | Add the conflict2.test script. Fix issues discovered by this script. (check-in: 294ed33756 user: drh tags: omit-rowid) | |
15 Years Ago (more context)
|
2008-11-05
| ||
| 17:41 | Fix memory allocation problems when string length exceeds limits. (CVS 5865) (check-in: b568e32520 user: drh tags: trunk) | |
| 16:37 | The COMMIT command now works even if there are pending queries, as long as the pending queries are reading and not writing the database. (CVS 5864) (check-in: 51f04aaff2 user: drh tags: trunk) | |