This Day In History For 2020-08-23
1 Year Ago (more context)
|
2019-08-23
| ||
| 23:05 | Fix the built-in edit() SQL function in the CLI so that it works with zero-length blobs. (check-in: e3249012 user: drh tags: trunk) | |
| 21:11 | • Edit [bad4d7a0d93f4d8f|bad4d7a0]: Mark "Closed". (artifact: ca328fec user: drh) | |
| 21:11 | Attempt to parse the NULLS LAST clause more efficiently. A few cycles were saved, but at the expense of more code. And there is a bug was introduced somewhere. Not worth continuing down this line. (Closed-Leaf check-in: 12d2cf88 user: drh tags: dead-end) | |
| 20:33 | Move some things in parse.y so that TK_COLUMN and TK_AGG_COLUMN are assigned the same values as they are on trunk for a very small speedup. (check-in: d26fdfa3 user: dan tags: nulls-last) | |
| 17:09 | Revise the VDBE comments for NULL-scan so that they also work make sense when reading a NULLS FIRST plan. (check-in: bfe79378 user: drh tags: nulls-last) | |
| 17:00 | Additional simplifications of the WHERE loop code generator logic for NULLS LAST. (check-in: 1383680d user: drh tags: nulls-last) | |
| 16:12 | Simplification of the WHERE loop code generator for NULLS LAST saves a few CPU cycles and about a hundred bytes of code space. (check-in: e3ed2f49 user: drh tags: nulls-last) | |
| 13:32 | Invert the meaning of the regBignull flag so that it is 1 when doing the normal scan and 1 when scanning nulls. This enables the re-do jump at the bottom of the loop to be coded with a single OP_IfNotZero opcode, rather than a sequence of OP_If, OP_Integer, OP_Goto. (check-in: bf875e1a user: drh tags: nulls-last) | |
| 13:08 | Extra VDBE comments in the NULLS LAST logic provide landmarks to help understand the EXPLAIN output. (check-in: 649b08ea user: drh tags: nulls-last) | |
2 Years Ago (more context)
|
2018-08-23
| ||
| 20:09 | Add the "atrc" test program to the Makefiles. Fix a typo in the instructions in the header comment of the atrc program. (check-in: 2130a407 user: drh tags: alter-table-rename-column) | |
| 19:32 | Fix harmless compiler warnings in the ALTER TABLE logic. Rephrase an error message to use active voice. (check-in: a7dae59a user: drh tags: alter-table-rename-column) | |
| 18:56 | Automatically detect when compiling for AArch64 on windows and set SQLITE_BYTEORDER to little-endian to avoid compile-time testing. (check-in: ef6729be user: drh tags: trunk) | |
| 18:50 | The Expr.iColumn field must also be initialized in tokenExpr(). (check-in: 772985f1 user: drh tags: alter-table-rename-column) | |
| 18:22 | Make sure the Expr.iTable field is initialized by tokenExpr(). (check-in: 02a05a3b user: drh tags: alter-table-rename-column) | |
| 14:54 | Merge enhancements from trunk. (check-in: c446c884 user: drh tags: rtree-geopoly) | |
3 Years Ago (more context)
|
2017-08-23
| ||
| 23:09 | Performance optimization to pageFindSlot() in the b-tree layer. (check-in: 59560d07 user: drh tags: trunk) | |
| 20:36 | Size and performance optimization to dropCell() and freeSpace(). (check-in: bc1ec123 user: drh tags: trunk) | |
| 14:45 | Smaller and faster implementation of the fillInCell() routine. (check-in: 77074990 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2016-08-23
| ||
| 19:02 | Simplify the row value misuse error message. (check-in: 838c50a5 user: drh tags: rowvalue) | |
| 19:02 | Add further tests for changebatch. And a fix to prevent a changeset from conflicting with itself. (check-in: 506d6ff4 user: dan tags: changebatch) | |
| 18:30 | Fix a problem with rowvalue UPDATE when the rowvalue is not the left-most and the RHS is a multi-column subquery. (check-in: e149e6b9 user: drh tags: rowvalue) | |
| 18:09 | Fix harmless compiler warnings in changebatch. (check-in: a721a738 user: drh tags: changebatch) | |
| 17:30 | Fix an uninitialized variable in CASE expression code generation. (check-in: c8ffae05 user: drh tags: rowvalue) | |
| 17:02 | Add a new method to sessions - sqlite3sessions_fullchangeset() - to return a changeset that always contains values for all old.* fields. Update changebatch to use these values to more reliably detect multi-column UNIQUE constraint violations. (check-in: efa761b2 user: dan tags: changebatch) | |
| 14:42 | Fix the SQLITE_USER_AUTHENTICATION login check so that the SQLITE_AUTH_USER error code correctly propagates and is not overwritten by SQLITE_ERROR. (check-in: c640489d user: drh tags: trunk) | |
5 Years Ago (more context)
|
2015-08-23
| ||
| 20:48 | Fix a comment typo on sqlite3ExprAlloc(). No code changes. (check-in: 518d6220 user: drh tags: trunk) | |
| 20:44 | Fix minor glitches in the json1.c extension, mostly having to do with OOM behavior. (check-in: cc520414 user: drh tags: trunk) | |
| 02:42 | Fixes to json_each() and json_tree(). Improved json_parse() debugging output. (check-in: fc1b24f3 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2010-08-23
| ||
| 18:19 | Fixes for the SQLITE_CHECK_PAGES debugging feature. (check-in: 21a1e596 user: dan tags: trunk) | |
| 18:08 | • Edit [1070918e3b68c0ba|1070918e]: Edit check-in comment. Timestamp 2010-08-23 15:26:50. (artifact: eadd204f user: drh) | |
| 17:09 | Update the version number in preparation for the 3.7.2 release. (check-in: 77889510 user: drh tags: trunk) | |
| 17:08 | • Fixed ticket [5e10420e]: Free-list corruption in incremental-vacuum mode plus 5 other changes (artifact: cfdf952b user: drh) | |
| 15:41 | Fix for ticket [5e10420e8d]. (check-in: 255f1eef user: dan tags: trunk) | |
| 15:35 | • New ticket [5e10420e] Free-list corruption in incremental-vacuum mode. (artifact: 9ae88290 user: drh) | |
| 15:26 | Update the "showdb" debug utility to handle 64K pages and with extra options to decode the freelist structure. (check-in: 1070918e user: drh tags: trunk) | |
| 01:25 | • Edit [3613b0695a5e9909|3613b069]: Change background color to "#d0c0ff". Edit check-in comment. Timestamp 2010-08-23 01:25:03. Add tag "release". (artifact: cbf72e29 user: drh) | |
| 01:25 | Version 3.7.1 (check-in: 3613b069 user: drh tags: trunk, release) | |
15 Years Ago (more context)
|
2005-08-23
| ||
| 11:31 | Allow floating point literals to being or end with a decimal point. Ticket #1371. (CVS 2616) (check-in: a715e700 user: drh tags: trunk) | |
| 11:17 | Handle empty blob constants correctly. Ticket #1373. (CVS 2615) (check-in: 5cada745 user: drh tags: trunk) | |
| 11:03 | Fix another documentation typo. (CVS 2614) (check-in: 55f4b14e user: drh tags: trunk) | |
| 11:00 | Fix typos in syntax documentation. Ticket #1374 and a report on the mailing list. (CVS 2613) (check-in: 990d1f3a user: drh tags: trunk) | |