This Day In History For 2019-09-17
1 Year Ago (more context)
|
2018-09-17
| ||
| 20:47 | Further optimizations to the UPDATE logic to avoid making changes to partial indexes if none of the columns mentioned in the WHERE clause are modified by the UPDATE. (check-in: d1365a5bf0 user: drh tags: trunk) | |
| 15:30 | • Fixed ticket [510cde2777]: Endless loop on a query with window functions, ORDER BY, and LIMIT plus 5 other changes (artifact: c0db9c3972 user: drh) | |
| 15:29 | • Fixed ticket [b41031ea2b]: ALTER TABLE returns an error on certain schemas plus 3 other changes (artifact: fea593b6ba user: drh) | |
| 15:25 | Disable the ORDER BY LIMIT optimization in queries using window functions. This fixes a problem that was introduced by check-in [206720129ed2fa8875a286] which attempted to fix ticket [9936b2fa443fec03ff25f9]. This changes is a fix for the follow-in tocket [510cde277783b5fb5de628]. (check-in: 36c75fd5b7 user: drh tags: branch-3.25) | |
| 15:19 | Disable the ORDER BY LIMIT optimization in queries using window functions. This fixes a problem that was introduced by check-in [206720129ed2fa8875a286] which attempted to fix ticket [9936b2fa443fec03ff25f9]. This changes is a fix for the follow-in tocket [510cde277783b5fb5de628]. (check-in: c6c9585f29 user: drh tags: trunk) | |
| 14:28 | • New ticket [510cde2777] Endless loop on a query with window functions, ORDER BY, and LIMIT. (artifact: 614870a83e user: drh) | |
| 14:18 | Fix a false-positive in the post-ALTER-TABLE schema verification logic that prevents ALTER TABLE from working if the table being altered has a trigger that references any column of a virtual table. Ticket [b41031ea2b537237]. (check-in: 5ce568c0e7 user: drh tags: branch-3.25) | |
| 14:13 | Fix a false-positive in the post-ALTER-TABLE schema verification logic that prevents ALTER TABLE from working if the table being altered has a trigger that references any column of a virtual table. Ticket [b41031ea2b537237]. (check-in: 84105ea4af user: drh tags: trunk) | |
| 13:55 | Restore an assert() that was present on trunk. (Closed-Leaf check-in: a7b572ca78 user: drh tags: tkt-b41031ea) | |
| 13:38 | Minor modification to the fix on this branch to avoid adding extra conditional compilation macros. (check-in: 4d8be404da user: dan tags: tkt-b41031ea) | |
| 12:49 | Fix missing space in 'configure.ac' reported on the mailing list. (check-in: 96b00a3cd2 user: mistachkin tags: trunk) | |
| 11:36 | Increase the version number to 3.25.1. (check-in: f3c8cfdb35 user: drh tags: branch-3.25) | |
| 08:27 | Add extra test for the fix on this branch. Also fix a pointer-compare-after-free problem that occurs in similar cases. (check-in: 1856ea63b3 user: dan tags: tkt-b41031ea) | |
| 00:15 | Add assert()s to the new code in the previous check-in. (check-in: b12f23a5c4 user: drh tags: tkt-b41031ea) | |
2 Years Ago (more context)
|
2017-09-17
| ||
| 19:45 | Do not make the assumption (as check-in [4da49a95c0f07] incorrectly did) that the ExprList returned by sqlite3ExprListDup() would never be passed into sqlite3ExprListAppend(). Include a new test case that shows this sometimes does happen. (check-in: 29227d00a9 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2016-09-17
| ||
| 22:46 | Minor enhancement to the TclKit batch tool: it should download the TclKit EXE alone when the TCLKIT_NOENV environment variable is set. (check-in: baceb988c6 user: mistachkin tags: trunk) | |
| 19:34 | Small performance optimization in the freeSpace() routine of btree.c. (check-in: 63962e2a92 user: drh tags: trunk) | |
| 17:39 | Improved description of the ElseNotEq opcode in comments. No changes to code. (check-in: e011435e2f user: drh tags: trunk) | |
4 Years Ago (more context)
|
2015-09-17
| ||
| 17:21 | Avoid passing (signed char) values directly to isspace(), isalnum() or isdigit() in json1.c. Cast the value to (unsigned char) first. (check-in: 6713e35b8a user: dan tags: trunk) | |
| 09:48 | Fix a crash in FTS5 caused by specifying NULL as the rhs of a MATCH operator. (check-in: e8ed62f82e user: dan tags: trunk) | |
5 Years Ago (more context)
|
2014-09-17
| ||
| 23:37 | Performance improvement and slight size reduction to the comparison operators in the VDBE. (check-in: 14052a7d08 user: drh tags: micro-optimizations) | |
| 19:05 | Fix an unintialized variable problem in sqlite3ota.c. (check-in: 0126860751 user: dan tags: ota-update) | |
| 16:41 | In the Mem object, stop requiring that Mem.xDel be NULL when the MEM_Dyn bit is clear. Also reduce the amount of initialization of Mem objects. All for a small size reduction and performance increase. (check-in: fdddb477c8 user: drh tags: micro-optimizations) | |
| 15:20 | Add tests and fixes for "PRAGMA ota_mode". (check-in: 39df35c4ac user: dan tags: ota-update) | |
| 14:52 | Improved interface to the Mem object handling. Small size reduction and performance increase. (check-in: 4e43784432 user: drh tags: micro-optimizations) | |
10 Years Ago (more context)
|
2009-09-17
| ||
| 21:22 | • Ticket [f76cabebfd] xBestIndex/xFilter slight interface improvement status still Closed with 1 other change (artifact: c7a39ecfa3 user: anonymous) | |
| 21:01 | • Ticket [eaa105fe74] (...) WHERE col IN (val1) not reflected in xBestIndex status still Open with 1 other change (artifact: 2074da8bd3 user: anonymous) | |
| 18:55 | • New ticket [af3450b763] Recursive virtual tables. (artifact: 8b2bd18ca7 user: anonymous) | |
| 12:50 | • New ticket [15e11a2c87] IfEmpty(a,b) : a function like IfNull(a,b) but for empty strings. (artifact: 79ae2f13e7 user: anonymous) | |
| 12:41 | • New ticket [b803a45d50] Feature Request: MATCHES(VAL1%, VAL2, %VALn%, ...). (artifact: dcae36aa53 user: anonymous) | |
| 11:09 | • Ticket [1ff6d29030] Compile fails with SQLITE_OMIT_TRIGGER status still Open with 3 other changes (artifact: c18f740830 user: anonymous) | |
| 11:09 | • New ticket [1ff6d29030]. (artifact: bbe12f430c user: anonymous) | |
| 00:47 | • Fixed ticket [e25d9ea771]: Cascading delete trigger fails. plus 4 other changes (artifact: df2f80f30b user: drh) | |
| 00:41 | When coding a trigger, assume that the "oldmask" requires all columns until we know otherwise. That pessimistic assumption assures that all necessary parameters are available on a cascading delete trigger. Ticket [e25d9ea771f] (check-in: 03e464be51 user: drh tags: trunk) | |
15 Years Ago (more context)
|
2004-09-17
| ||
| 21:35 | Always include -lpthread on link lines even if it is not needed. (CVS 1968) (check-in: 46a96890f7 user: drh tags: trunk) | |
| 21:07 | Make use of $(libdir) in the Makefile.in. Ticket #904. (CVS 1967) (check-in: 10b5e51733 user: drh tags: trunk) | |
| 20:47 | Create directories using "mkdir -p". Ticket #903. (CVS 1966) (check-in: 02de1cf95e user: drh tags: trunk) | |
| 20:46 | Close stray statements prior to finishing trace.test, to avoid a file descriptor leak. (CVS 1965) (check-in: 8bb0221da8 user: drh tags: trunk) | |
| 20:25 | The page_size pragma preserves the reserved area at the end of each page. (CVS 1964) (check-in: c34f3209e5 user: drh tags: trunk) | |
| 20:02 | Get VACUUM working on databases that have reserved bytes at the end of each page. (CVS 1963) (check-in: 90bb3af6cd user: drh tags: trunk) | |
| 19:39 | Fix a bug in the test3.c module that was causing failures in btree5.test. (CVS 1962) (check-in: cd200cf833 user: drh tags: trunk) | |
| 17:23 | The INSERT code generator does a better job of detecting if the table being written into is used in the SELECT on the right-hand side. ticket #901. (CVS 1961) (check-in: 709bb22d6d user: drh tags: trunk) | |