This Day In History For 2021-02-22
1 Year Ago (more context)
|
2020-02-22
| ||
| 18:27 | Do not activate the truthProb adjustment mechanism if the truth probability is less than the heuristic value, as there could be correlations unknown to stat4. Also add additional tracing output to make truthProb adjustments more visible. (check-in: c535fea147 user: drh tags: stat4-truthprob) | |
| 17:32 | Add new test file analyzeG.test, containing a test for the change on this branch. (check-in: 243ab1852a user: dan tags: stat4-truthprob) | |
| 16:58 | When stat4 information is available, try to use it to improve the truth probability of WHERE clause terms that do not participate in the index. (check-in: 1babd6ec5d user: drh tags: stat4-truthprob) | |
| 13:07 | • Fixed ticket [aa43786930]: sqlite3.c:87338: int sqlite3VdbeExec(Vdbe *): Assertion `sqlite3BtreeCursorIsValid(pCrsr)' failed. plus 6 other changes (artifact: 9fee20675e user: drh) | |
| 13:01 | In the OP_Column opcode, if the cursor is marked NullRow (due to being the right table of a LEFT JOIN that does not match) and the cursor is the table cursor for an OR-optimization with a covering index, then do not substitute the covering index cursor, since the covering index cursor does not have the NullRow flag set. Ticket [aa4378693018aa99] (check-in: f02030b340 user: drh tags: trunk) | |
| 04:18 | • New ticket [aa43786930] sqlite3.c:87338: int sqlite3VdbeExec(Vdbe *): Assertion `sqlite3BtreeCursorIsValid(pCrsr)' failed.. (artifact: ba0b33c0f8 user: yongheng) | |
2 Years Ago (more context)
|
2019-02-22
| ||
| 23:29 | Make all ephemeral tables built to hold the RHS of an IN operator be index-btrees, never table-btrees, regardless of whether or not they are used as IN_INDEX_LOOP or IN_INDEX_MEMBERSHIP. That way, the same ephmerial table can be reused for both cases. (check-in: c2d50df8fd user: drh tags: tkt-df46dfb631) | |
| 21:35 | • Fixed ticket [4feb3159c6]: Crash due to misuse of window functions. plus 5 other changes (artifact: 17c4d9a567 user: drh) | |
| 21:35 | • Open ticket [df46dfb631]: Assertion fault in self-join with a IN constraint plus 4 other changes (artifact: 0bf6d95baa user: drh) | |
| 21:33 | Check-in [fa792714ae62fa980] is not a valid fix for ticket [df46dfb631f75694], as the new test case in this check-in demonstrates. The fix here causes test cases for the [df46dfb631f75694] bug to fail again, so this check-in is on a branch. A new fix is needed for [df46dfb631f75694]. (check-in: 0d456456da user: drh tags: tkt-df46dfb631) | |
| 19:24 | Internally, remove all references to a Window object that belongs to an expression in an ORDER BY clause if that expression is converted to an alias of a result-set expression. Fix for [4feb3159c6]. (check-in: 579b66eaa0 user: dan tags: trunk) | |
| 18:44 | • New ticket [4feb3159c6] Crash due to misuse of window functions.. (artifact: a24c0ec01b user: drh) | |
| 17:44 | Merge latest trunk changes into this branch. (check-in: 001771afd0 user: dan tags: reuse-schema) | |
| 16:18 | In sqlite3NestedParse() be sure to detect all SQLITE_NOMEM and SQLITE_TOOBIG errors and to distinguish between them. (check-in: 73056b314b user: drh tags: trunk) | |
| 15:42 | Modify sqlite3_str_finish() and sqlite3VMPrintf() so that they always return NULL on any OOM or SQLITE_LIMIT_LENGTH error. (check-in: e7144ffd21 user: drh tags: trunk) | |
| 14:58 | • Edit [e6e9dd5c17405a3e|e6e9dd5c17]: Move to branch nested-parse-oom. (artifact: 9723d08c8b user: drh) | |
3 Years Ago (more context)
|
2018-02-22
| ||
| 21:06 | Add tests cases and fix some minor zonefile problems. (check-in: f4d42162fa user: dan tags: zonefile) | |
| 18:30 | For the "SQLite archive" link in the README.md file, point to the CLI .archive command documentation, not the original "sqlar" website. (check-in: 4290faf5f7 user: drh tags: trunk) | |
| 18:28 | Updates to the README.md file. Mention the ability to use SQLite-archives for download. (check-in: ab9a7ae4ee user: drh tags: trunk) | |
| 16:46 | Add an LRU cache of uncompressed frame content to the zonefile virtual table implementation. (check-in: 883e7e75d6 user: dan tags: zonefile) | |
4 Years Ago (more context)
|
2017-02-22
| ||
| 20:24 | Change the name of the analyze_as_needed pragma to "optimize". Enhance the comment (which will become documentation, assuming these changes land on trunk) to explain that the optimize pragma is likely to be enhanced in various ways in future releases and that applications should not depend upon the current behavior. (check-in: 9fced545a6 user: drh tags: auto-analyze) | |
| 19:49 | Merge integrity_check and other improvements from trunk. (check-in: fe07390508 user: drh tags: auto-analyze) | |
| 19:41 | Move a branch condition in analyze.c inside an #ifdef SQLITE_ENABLE_STAT4 block. (check-in: d6afd98de3 user: dan tags: trunk) | |
| 19:27 | Improve the performance of ANALYZE when SQLITE_ENABLE_STAT4 is defined. (check-in: 737a824440 user: dan tags: trunk) | |
| 18:54 | • Edit [5af7d72ed9ec7582|5af7d72ed9]: Mark "Closed". (artifact: d3b99bb7a7 user: drh) | |
| 18:53 | Improvements to PRAGMA integrity_check. Verify CHECK constraints. Verify NOT NULL constraints even on table that lack indexes. Verify CHECK and NOT NULL constraints with PRAGMA quick_check. (check-in: aa02bd3c95 user: drh tags: trunk) | |
| 18:04 | Cleanup and simplification of the output row count limit control of PRAGMA integrity_check. (Closed-Leaf check-in: 5af7d72ed9 user: drh tags: integrity-check-improvements) | |
| 15:11 | Fix integrity_check so that it verifies NOT NULL constraints even for tables that have no indexes. Enhance quick_check so that it verifies NOT NULL and CHECK constraints. (check-in: 5264844b06 user: drh tags: integrity-check-improvements) | |
| 14:15 | Enhance "PRAGMA integrity_check" so that it verifies CHECK constraints. (check-in: 549bae0856 user: drh tags: integrity-check-improvements) | |
5 Years Ago (more context)
|
2016-02-22
| ||
| 23:44 | Remove code not needed now that synchronous=OFF database files no longer trigger the use of a master journal. (check-in: aa9f4c622a user: drh tags: trunk) | |
| 23:14 | Avoid an unnecessary seek operation some corner-case skip-scan operations. (check-in: 2a6003a937 user: drh tags: trunk) | |
| 21:19 | Clearer presentation of the logic. No functional changes. (Closed-Leaf check-in: a3dcf6db76 user: drh tags: skip-scan-improvement) | |
| 20:52 | Avoid an unnecessary seek operation on some corner-case skip-scans. (check-in: 38e837e605 user: drh tags: skip-scan-improvement) | |
| 19:51 | Add test script shell6.test, containing tests for schemalint. (check-in: 0b73406595 user: dan tags: schemalint) | |
| 16:32 | Merge the master-journal optimization and other recent changes from trunk. (check-in: 18c3ab4784 user: drh tags: apple-osx) | |
| 16:04 | Always use the sqlite3VdbeDeleteAuxdata() routine for clearing auxdata on function parameter, rather than having a separate deleteAuxdataFromFrame() for doing the job for trigger frames. (check-in: 64386fa339 user: drh tags: trunk) | |
| 14:57 | Avoid creating a master journal unless two or more databases in the transaction can actually benefit from that master journal. (check-in: 3ed1890612 user: drh tags: trunk) | |
| 13:23 | Change magic numbers associated with synchronous settings to named constants. (check-in: 9230ba6c01 user: drh tags: trunk) | |
| 13:01 | Merge up to trunk. (check-in: f9e5fb88a5 user: drh tags: lsm-vtab) | |
| 09:45 | Add an extra test case for the change in commit [c4295725]. (check-in: a48ac4c347 user: dan tags: trunk) | |
10 Years Ago (more context)
|
2011-02-22
| ||
| 05:24 | • Ticket [b72787b1a7] Expiry mechanism causes incorrect collateral damage status still Fixed with 1 other change (artifact: 0994e86462 user: rogerb) | |
| 03:35 | • Fixed ticket [b72787b1a7]. (artifact: cce089e183 user: drh) | |
| 03:34 | When a stale schema-cookie is seen, expire only the one statement that encountered the bad cookie, not every statement on the database connection. Ticket [b72787b1a7cea1f] (check-in: 1bca0a7e19 user: drh tags: trunk) | |
15 Years Ago (more context)
|
2006-02-22
| ||
| 03:08 | New compile-time option SQLITE_SECURE_DELETE takes care to overwrite deleted data with zeros. (CVS 3107) (check-in: 614fac9068 user: drh tags: trunk) | |