This Day In History For 2020-06-02
2 Years Ago (more context)
|
2018-06-02
| ||
| 21:04 | Add support for window functions row_number(), rank(), dense_rank() and percent_rank(). (check-in: 91c1cb7a user: dan tags: exp-window-functions) | |
| 19:14 | Avoid using a misaligned pointer. (check-in: 1ecb3aa1 user: drh tags: trunk) | |
| 19:01 | Fix the usage of posix_fallocate() so that it correctly responds to EINVAL returns. (check-in: ce2c3e7a user: drh tags: trunk) | |
| 17:00 | Update a test case in malloc5.test to take into account that malloc() sometimes returns slightly more space than requested. (check-in: 3d5eae1c user: dan tags: trunk) | |
| 16:32 | Work around a sanitizer warning about a pointer being only 4-byte aligned instead of 8-byte aligned. (Closed-Leaf check-in: 1b807b51 user: drh tags: align8-fix) | |
| 14:37 | Proposed fix for the use of posix_fallocate() so that it handles EINVAL returns correctly. (Closed-Leaf check-in: ab3a5539 user: drh tags: einval-from-fallocate) | |
| 12:05 | Fix the CSV extension so that it works with single-column CSV files. (check-in: e336cf00 user: drh tags: trunk) | |
| 11:31 | Ensure that sqlite3AuthRead() is only call for TK_COLUMN and TK_TRIGGER expression nodes. This fixes a harmless assert() identified by OSSFuzz. Move the assert() into a position where it is tested even if the authorizer is disabled. (check-in: d0c3beef user: drh tags: trunk) | |
3 Years Ago (more context)
|
2017-06-02
| ||
| 23:44 | Merge all recent trunk enhancements. (check-in: 1d23294d user: drh tags: lsm-vtab) | |
| 23:32 | Add the --fsync flag to kvtest, and document the --nosync flag. (check-in: 7fdc78a6 user: drh tags: trunk) | |
| 19:31 | Work toward enhancing kvtest to measure write performance. (check-in: fc73e7d2 user: drh tags: trunk) | |
| 15:44 | Change the name of the OP_Seek opcode into OP_DeferredSeek for better clarity of function. No functional code changes. (check-in: ab33d299 user: drh tags: trunk) | |
| 13:16 | Fix a typo in the header comment of the "series.c" virtual table extension. (check-in: d637feb4 user: drh tags: trunk) | |
| 09:31 | Extend even further the logging designed to find problems in the pointer-map structure. Call abort() to dump a core as soon as such a problem is seen. (check-in: f131677d user: dan tags: begin-concurrent) | |
4 Years Ago (more context)
|
2016-06-02
| ||
| 23:13 | Add the CSV extension to the test fixture. Fix a memory leak in the CSV extension. Add test cases for the CSV extension, including one that uses a WITHOUT ROWID virtual table participating in the OR optimization. (check-in: 95f483e8 user: drh tags: without-rowid-vtab) | |
| 17:44 | Add the data= parameter to the CSV virtual table extension. (check-in: 76919104 user: drh tags: without-rowid-vtab) | |
| 16:22 | Fix corner cases in the WITHOUT ROWID virtual table logic. (check-in: a393bbb9 user: drh tags: without-rowid-vtab) | |
5 Years Ago (more context)
|
2015-06-02
| ||
| 19:38 | Change the fts5 multi-column syntax to use parenthesis instead of square brackets. (check-in: ab85a6fc user: dan tags: fts5) | |
| 19:36 | Always check for cell overflow before returning a slot from the pageFindSlot routine in btree.c. (check-in: 9f035c45 user: drh tags: trunk) | |
| 18:09 | For FROM-clause subqueries that cannot be flattened, try to push relevant WHERE clause terms of the outer query down into the subquery in order to help the subquery run faster and/or use less memory. Call this the "WHERE-clause push-down optimization". Do not confuse this with the completely different MySQL push-down optimization. (check-in: 6df18e94 user: drh tags: trunk) | |
| 18:07 | Merge latest trunk changes with this branch. (check-in: c9ffda4a user: dan tags: fts5) | |
| 17:57 | Reimplement [ec69e09a] so that each call to the xNext() method does not involve two iterations of the match expression tree (only one). (check-in: 80fe305b user: dan tags: fts5) | |
| 17:25 | Add test cases for type affinity rules. (check-in: 9678646d user: drh tags: trunk) | |
| 16:50 | • Edit [bce3f04186cd2d69|bce3f041]: Mark "Closed". (artifact: 0ff1100a user: drh) | |
| 16:19 | Rename SQLITE_AFF_NONE to SQLITE_AFF_BLOB to avoid confusion with "no affinity". (check-in: 29ad9e91 user: drh tags: trunk) | |
| 16:09 | Add the built-in affinity() SQL function. This turns out to be not as useful as originally envisioned, so abandon it on a branch. (Leaf check-in: 80889306 user: drh tags: affinity-func) | |
| 15:32 | Rename SQLITE_AFF_NONE to SQLITE_AFF_BLOB. (Closed-Leaf check-in: bce3f041 user: drh tags: blob-affinity-rename) | |
| 14:02 | Fix a faulty assert() in btree.c. Update the database fuzz test file with new test cases. (check-in: 4e621af1 user: drh tags: trunk) | |
| 09:20 | Add the "finish_test" command to the end of new test script sessionE.test. (check-in: fb391407 user: dan tags: sessions) | |
| 09:19 | Modify the sessions module to ignore all operations on tables with no primary keys as documented. (check-in: bdaf9575 user: dan tags: sessions) | |
10 Years Ago (more context)
|
2010-06-02
| ||
| 20:38 | When a lock fails due to an I/O error (not an SQLITE_BUSY) then the checkpoint should fail. (check-in: c6eb0a27 user: drh tags: trunk) | |
| 18:59 | Fix a problem with rolling back to a savepoint opened before the writer decided to wrap the log file. (check-in: 6b4aed6a user: dan tags: trunk) | |
| 17:15 | If an error occurs while writing frames to the log to commit a transaction, do not mark the pages as clean in the cache. Otherwise, the subsequent rollback does not roll them back (leaving the client to continue with a cache that makes it appear that the transaction was committed - inconsistent with the database on disk). (check-in: cb571c1b user: dan tags: trunk) | |
| 16:40 | Added implementation of vfslog_time() for Windows testing. (check-in: b3109f85 user: shaneh tags: trunk) | |
| 16:39 | Updated wal2.test for windows testing. (check-in: c3606f39 user: shaneh tags: trunk) | |
| 15:59 | Make sure the directory used by os_unix.c for shared-memory files is always the same, regardless of individual client permissions and environment variable settings. (check-in: f97bd520 user: drh tags: trunk) | |
| 15:43 | When walTryBeginRead() encounters an I/O error trying to set a lock (as opposed to SQLITE_BUSY) be sure to propagate that error back up the call stack. (check-in: aa2c2b67 user: drh tags: trunk) | |
| 14:45 | Changes to make WAL more robust against SHM locking failures and OOM errors. (check-in: ebf40413 user: drh tags: trunk) | |
| 14:43 | In the rowhash.test, make sure global variables are cleared prior to use. (check-in: 28efe0a4 user: drh tags: trunk) | |
| 12:58 | Undo one of the "const" markers from the previous check-in because the value needs to be changable, even if it is not actually ever changed in the current implementation. (check-in: c24ac356 user: drh tags: trunk) | |
| 05:53 | Add some 'const' markers to static data that is really constant. (check-in: e7073e23 user: dan tags: trunk) | |
20 Years Ago (more context)
|
2000-06-02
| ||
| 23:22 | :-) (CVS 45) (check-in: 3e88142e user: drh tags: trunk) | |
| 23:21 | :-) (CVS 44) (check-in: cd83d3cf user: drh tags: trunk) | |
| 23:04 | :-) (CVS 43) (check-in: 60f45a3b user: drh tags: trunk) | |
| 18:52 | :-) (CVS 42) (check-in: 11e32963 user: drh tags: trunk) | |
| 15:51 | :-) (CVS 41) (check-in: 90cfd617 user: drh tags: trunk) | |
| 15:05 | :-) (CVS 40) (check-in: 939adb4d user: drh tags: trunk) | |
| 14:38 | :-) (CVS 39) (check-in: 721d58f4 user: drh tags: trunk) | |
| 14:27 | :-) (CVS 38) (check-in: 46c4b792 user: drh tags: trunk) | |
| 13:27 | :-) (CVS 37) (check-in: 2b55f9b7 user: drh tags: trunk) | |
| 02:09 | :-) (CVS 1696) (check-in: 80d925b8 user: drh tags: trunk) | |
| 01:51 | :-) (CVS 36) (check-in: d3c31def user: drh tags: trunk) | |
| 01:36 | :-) (CVS 35) (check-in: a57ecd60 user: drh tags: trunk) | |
| 01:17 | :-) (CVS 34) (check-in: 52338f4a user: drh tags: trunk) | |