This Day In History For 2019-09-23
1 Year Ago (more context)
|
2018-09-23
| ||
| 02:01 | Fix a faulty assert() in the validation logic for the LEFT JOIN strength reduction optimization. Problem found by OSSFuzz. (check-in: 2fd62fccd1 user: drh tags: trunk) | |
2 Years Ago (more context)
|
2017-09-23
| ||
| 07:46 | Experimental change so that snapshot transactions always lock the wal file - preventing writers or truncate-checkpointers from wrapping it. (Closed-Leaf check-in: d71eeaab9e user: dan tags: snapshots-lock-wal) | |
3 Years Ago (more context)
|
2016-09-23
| ||
| 21:36 | Add the EP_Leaf flag bit to the Expr.flags field to indicate Expr nodes that do not have substructure. Use that bit to avoid unnecessary recursion. (check-in: 8a6ea455cd user: drh tags: trunk) | |
| 20:59 | Use sqlite3ExprAlloc() instead of sqlite3PExpr() for leaf nodes in the expression tree, where appropriate. This is both smaller and faster. (check-in: afac0709ce user: drh tags: trunk) | |
| 18:13 | New test case for the ORDER BY LIMIT optimization. (check-in: 9a5a489d0d user: drh tags: trunk) | |
| 18:06 | Fix the ORDER BY LIMIT optimization backport so that it works when the ORDER BY uses the DESC direction. (check-in: 0c3cafb7eb user: drh tags: branch-3.8.9) | |
4 Years Ago (more context)
|
2015-09-23
| ||
| 19:17 | Take care that the number of reserved bits per page is consistent between the source and destination databases when doing the back-copy on a VACUUM. (check-in: 5b61b72f54 user: drh tags: trunk) | |
| 16:41 | • Edit [7b84641e55654f8e|7b84641e55]: Mark "Closed". (artifact: d3173abb25 user: mistachkin) | |
| 16:39 | • Edit [0ddb2532b2daaaf1|0ddb2532b2]: Mark "Closed". (artifact: 5f4481796b user: mistachkin) | |
| 16:36 | • Edit [6b85f8cd4d87d616|6b85f8cd4d]: Mark "Closed". (artifact: 2562677267 user: mistachkin) | |
| 16:35 | Merge updates from trunk. (check-in: 0a75ebd23e user: mistachkin tags: mutexInitIsInitReCheck) | |
| 16:33 | Correct superfluous whitespace difference. No functional changes. (check-in: 8d69983dc2 user: mistachkin tags: mutexInitSimpleCmpSwap) | |
| 16:24 | Simplify thread-safety of mutex initialization. (check-in: da0587c522 user: mistachkin tags: mutexInitSimpleCmpSwap) | |
| 15:54 | Merge updates from trunk. (Closed-Leaf check-in: 6b85f8cd4d user: mistachkin tags: mutexInitCmpSwap) | |
| 11:59 | Capture AFL-generated fuzz tests for json1.c into the test/fuzzdata4.db file. (check-in: 10a214fdb3 user: drh tags: trunk) | |
| 01:10 | Do not allow a comma at the end of a JSON array or object. (check-in: 7c7a3f3e9b user: drh tags: trunk) | |
5 Years Ago (more context)
|
2014-09-23
| ||
| 23:12 | Remove an unused C-preprocessor macro. No functional changes to the code. (check-in: f480582cca user: drh tags: trunk) | |
| 22:36 | Avoid calling btreeParseCellPtr() from within fillInCell() since most of what btreeParseCellPtr() computes is ignored by fillInCell(). Instead, have fillInCell() compute the values it needs inline. Performance improvement. (check-in: 4147f6671e user: drh tags: trunk) | |
| 21:25 | Simplify the CellInfo structure for a size reduction and performance improvement. (check-in: bf59df66b3 user: drh tags: trunk) | |
| 20:39 | Begin adding 'streaming' APIs to sessions module. This is a work in progress. (check-in: 3c7d3d950b user: dan tags: sessions) | |
| 18:30 | Add the "multiplex_truncate" PRAGMA to the multiplexor extension, for querying and setting the truncate flag on a database connection. (check-in: d2962a5f38 user: drh tags: trunk) | |
| 01:40 | Adjust skip-scan cost estimates slightly so that a full table scan is preferred over a skip-scan to a column with only two distinct values. (check-in: ae9a42b268 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2009-09-23
| ||
| 19:16 | • New ticket [4a03edc4c8] Index corruption following aggressive use of ON CONFLICT clause.. (artifact: 360b463978 user: drh) | |
| 18:49 | More fkey tests. (check-in: 2d544bd53d user: shane tags: trunk) | |
| 18:07 | Fix a problem with FK constraints that implicitly map to a composite primary key. (check-in: e0a48d5311 user: dan tags: trunk) | |
| 17:31 | Fix a problem in the fkey_malloc.test script. (check-in: 0ce1efa460 user: dan tags: trunk) | |
| 17:30 | Do not check immediate foreign key constraints until the end of the statement. This matches the postgres behaviour. (check-in: 1a32149cc3 user: dan tags: trunk) | |
| 15:52 | • Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 54f202b46a user: drh) | |
| 15:51 | Modify the ".dump" command on the CLI so that it always issues a PRAGMA foreign_keys=OFF at the top of the output. (check-in: 0755b9b697 user: drh tags: trunk) | |
| 15:41 | • Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 58649bce9e user: anonymous) | |
| 14:45 | Change the version number to 3.6.19. Fix a couple of incorrect testcase() macros associated with the new IS and IS NOT operators in expr.c. (check-in: e3b73394bf user: drh tags: trunk) | |
| 13:59 | Disallow using the implicit rowid column as the parent key of an FK constraint. (check-in: a5f7e71f42 user: dan tags: trunk) | |
| 13:42 | • Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: ef1b5a65fd user: drh) | |
| 13:39 | Add test cases for the IS and IS NOT operator. (check-in: 101ed58cf4 user: drh tags: trunk) | |
| 12:06 | Add extra tests for foreign key support. (check-in: 7d086afe69 user: dan tags: trunk) | |
| 11:54 | • Ticket [f51d950180] memset warning with gcc 4.3.3 status still Closed with 1 other change (artifact: 9a6159ee36 user: drh) | |
| 11:54 | • Closed ticket [f51d950180]. (artifact: 92e91053f1 user: drh) | |
| 11:22 | • Closed ticket [98f156c79b]: plus 2 other changes (artifact: 586dfe12cd user: drh) | |
| 08:43 | Add missing comments to fkey.c. Also, change the terminology used for comments and names in fkey.c from "referenced/referencing" to "parent/child". This is arguably less correct, but is easier to follow. (check-in: 540c2d18e1 user: dan tags: trunk) | |
| 08:32 | • New ticket [f51d950180] memset warning with gcc 4.3.3. (artifact: ac551f6db0 user: anonymous) | |
| 07:39 | • New ticket [98f156c79b] . (artifact: 98fde03230 user: anonymous) | |
| 04:12 | • Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 8b058ffd3e user: anonymous) | |
| 03:01 | Do not run ON UPDATE actions of a foreign key constraint unless at least one column value really does change. (check-in: 71ac8e28e5 user: drh tags: trunk) | |
| 02:29 | Generalize the IS and IS NOT operators so that their right-hand side can be an arbitrary expression and not simple the constant NULL. They work like = and <> except that NULL values compare equal to one another an unequal to everything else. (check-in: 98853f6104 user: drh tags: trunk) | |