This Day In History For 2025-05-17
1 Year Ago (more context)
|
2024-05-17
| ||
| 22:51 | Improvements to a VDBE comment. No changes to anything that affects queries. (check-in: c2188da860 user: drh tags: trunk) | |
| 14:48 | • Edit [6dc6472175bccbed|6dc6472175]: Edit check-in comment. (artifact: dfb22552f6 user: dan) | |
| 14:26 | Merge branches "fix-onerow-opt", "faster-openread", "fts5-delay-tokenizer" and "enhanced-raise", each containing minor enhancements prepared for 3.46, into this branch. (Closed-Leaf check-in: 6dc6472175 user: dan tags: pending-3.46) | |
| 13:56 | Fix a problem in where.c preventing SQLite from identifying some ONEROW scans, leading to (slightly) sub-optimal byte-code. (Closed-Leaf check-in: b41e71208a user: dan tags: fix-onerow-opt) | |
2 Years Ago (more context)
|
2023-05-17
| ||
| 19:23 | Fast-path the btree transaction start for the common case where a transaction is already active. (check-in: 798c3ff20c user: drh tags: trunk) | |
| 16:13 | Simplification, performance improvement, and size reduction in the codeAllEqualityTerms() function of the code generator. (check-in: 4fbe02651e user: drh tags: trunk) | |
| 15:46 | New assert() statements to verify that Expr.iColumn is never used as an array index when its value is negative. (check-in: 6084c5fb6d user: drh tags: trunk) | |
| 15:22 | More CLI resmanage use (75% LOC) (check-in: 3428ce8247 user: larrybr tags: cli_extension) | |
| 13:21 | Improved assertions on substExpr(). (check-in: 6dbd5b3cc8 user: drh tags: trunk) | |
| 11:45 | Avoid an assert() failure that could occur in SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds when a WITH clause attached to an UPDATE or DELETE statement created a CTE of the same name as the table being modified. (check-in: 60f03e3245 user: drh tags: branch-3.42) | |
| 11:31 | Avoid an assert() failure that could occur in SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds when a WITH clause attached to an UPDATE or DELETE statement created a CTE of the same name as the table being modified. (check-in: 8edf56d169 user: dan tags: trunk) | |
| 03:57 | Further CLI resmanage use. (69% by LOC, 53% by command count) Some renames for clarity. (check-in: c010e1a7b2 user: larrybr tags: cli_extension) | |
| 00:47 | Resolve the JS-side corner case reported in forum post 7774b773937cbe0a by not caching oo1.Stmt.columnCount. (check-in: adee1440bd user: stephan tags: branch-3.42) | |
| 00:32 | Increase the version number to 3.42.1 (check-in: da0c662b31 user: drh tags: branch-3.42) | |
| 00:29 | Fix two assert() statements that failed to take into account the likely() built-in function. This does not impact production code. (check-in: 634fe4c238 user: drh tags: branch-3.42) | |
| 00:26 | Fix two assert() statements that failed to take into account the likely() built-in function. This does not impact production code. (check-in: 8504fe812c user: drh tags: trunk) | |
3 Years Ago (more context)
|
2022-05-17
| ||
| 15:33 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 495f0353db user: drh tags: reuse-schema) | |
| 15:11 | Fix harmless compiler warnings in the new unixFullPathname implementation. (check-in: f7e1ceb5b5 user: drh tags: trunk) | |
| 15:01 | Avoid treating constant expressions like "? IN ()" or "? NOT IN ()" as integers if they appear in a GROUP BY or ORDER BY clause. (check-in: d8b249e8cd user: dan tags: trunk) | |
| 14:59 | Add the sqlite3_db_name() interface. (check-in: 2ad152236c user: drh tags: trunk) | |
4 Years Ago (more context)
|
2021-05-17
| ||
| 17:14 | Fix harmless compiler warnings. (check-in: ace12a3912 user: drh tags: trunk) | |
| 16:54 | Enhance the integer-comparison optimization on the OP_Eq and similar opcodes so that it avoids a lot of useless work. (check-in: 4221f41af9 user: drh tags: trunk) | |
| 16:20 | Fix problems with refering to CTEs from within sub-selects in PARTITION BY or ORDER BY clauses of window frame definitions. Also a problem with renaming a column when the schema contains a trigger containing a correlated sub-select within a window frames PARTITION BY or ORDER BY clause. (check-in: 4c6cd54a8d user: dan tags: trunk) | |
| 13:11 | When deleting an SQL function that does not exist, return without doing anything at all rather than creating a tombstone function. In this way, function deletes that happen inside virtual-table destructors that are run when a database connection is closing do not create new tombstones in the function table after the function table has already been purged. forum post 726219164b. (check-in: 391c73132c user: drh tags: trunk) | |
| 11:19 | Performance improvement in sqlite3TableLock(). (check-in: 0d77e371c4 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2020-05-17
| ||
| 13:47 | Avoid harmless UB in memcpy() in the JSON extension. (check-in: 69e149f768 user: drh tags: trunk) | |
| 00:26 | Use the sqlite3Realloc() interface internally, rather than the public sqlite3_realloc64() equivalent, to avoid unnecessary calls to sqlite3_initialize(). (check-in: 1313557b51 user: drh tags: trunk) | |
15 Years Ago (more context)
|
2010-05-17
| ||
| 20:16 | Remove an unreachable test from wal.c. (check-in: 7162c45673 user: drh tags: trunk) | |
| 15:52 | An improvement to the SQLITE_FCNTL_SIZE_HINT change that invokes the hint less often and only when really needed. (check-in: a1d20ceb9c user: drh tags: branch-3.6.1) | |
| 15:33 | Invoke the SQLITE_FCNTL_SIZE_HINT opcode on the sqlite3_file_control() interface for database files before extending the size of the file. The VFS can use this hint to preallocate space. (check-in: 9a08371171 user: drh tags: branch-3.6.1) | |
20 Years Ago (more context)
|
2005-05-17
| ||
| 11:25 | Provide a compile-time parameter to set the default file creation permissions under Unix. Ticket #1247. (CVS 2461) (check-in: bfa55bec32 user: drh tags: trunk) | |