This Day In History For 2020-08-30
1 Year Ago (more context)
|
2019-08-30
| ||
| 23:56 | • Fixed ticket [40812aea1f]: Incorrect result for comparison of large number plus 6 other changes (artifact: 0dea4a6a3d user: drh) | |
| 23:56 | When the affinity of a table column is INT or REAL, make the affinity of corresponding index columns NUMERIC. This increases the precision of index lookups for large numbers so that it matches the precision of ordinary comparison operators. Ticket [40812aea1fde9594] (check-in: e0d909c740 user: drh tags: trunk) | |
| 23:15 | • Fixed ticket [5a3dba8104]: REINDEX causes "UNIQUE constraint failed" error plus 6 other changes (artifact: fedacb2dc8 user: drh) | |
| 23:15 | Make sure OP_RealAffinity has been applied to all columns of type REAL in the excluded.* pseudo-table of an UPSERT. Ticket [5a3dba8104421320] (check-in: 67381daded user: drh tags: trunk) | |
| 21:52 | Improvements to VDBE tracing. No changes to code in normal deliverables. (check-in: 54553bf16f user: drh tags: trunk) | |
| 20:28 | • New ticket [40812aea1f] Incorrect result for comparison of large number. (artifact: 8188b7b46d user: mrigger) | |
| 19:45 | Add test case to window8.test. Also fix an error in a comment in window.c. (check-in: 2925bfa597 user: dan tags: trunk) | |
| 19:41 | • New ticket [5a3dba8104] REINDEX causes "UNIQUE constraint failed" error. (artifact: a6172ac698 user: mrigger) | |
| 18:02 | Back out the change at [47cd634c98b502d4] which was incorrect. Add a test case so that we don't accidently back out that change again. (check-in: 596ac2a4ea user: drh tags: trunk) | |
| 17:28 | Add further comments to window.c. (check-in: 900464567b user: dan tags: trunk) | |
| 16:46 | New test cases for window functions with RANGE BETWEEN and DESC NULLS FIRST. (check-in: f7002f86c7 user: drh tags: trunk) | |
| 16:14 | Fix a bug in RANGE window functions that use "ORDER BY <expr> DESC NULLS FIRST" as the window-frame ORDER BY clause. (check-in: 39b4cad4a5 user: dan tags: trunk) | |
| 16:01 | • Fixed ticket [f8f472cbc7]: Partial index and BETWEEN issue plus 6 other changes (artifact: 03079b14a3 user: drh) | |
| 16:00 | The expression "(X IS FALSE) IN (FALSE)" does not imply that X is NOT NULL. Ticket [f8f472cbc77ba9c9] (check-in: dd66134817 user: drh tags: trunk) | |
| 15:43 | • New ticket [f8f472cbc7] Partial index and BETWEEN issue. (artifact: bac716244f user: mrigger) | |
| 15:11 | • Fixed ticket [fba33c8b1d]: Partial index causes row to not be fetched in BETWEEN expression plus 6 other changes (artifact: 9f4bc62d8d user: drh) | |
| 15:11 | The expression "(X IS FALSE) BETWEEN FALSE AND TRUE" does not implie that X is not NULL. Ticket [fba33c8b1df6a915] (check-in: 057fb8b180 user: drh tags: trunk) | |
| 14:33 | • New ticket [fba33c8b1d] Partial index causes row to not be fetched in BETWEEN expression. (artifact: aa64847632 user: mrigger) | |
| 13:07 | • Fixed ticket [a6408d42b9]: Partial index causes row to not be fetched plus 6 other changes (artifact: 8b2e986d26 user: drh) | |
| 13:07 | The expression "(x IS FALSE) IS FALSE" does not imply that X is not NULL. Ticket [a6408d42b9f44462] (check-in: 45ff2b1f26 user: drh tags: trunk) | |
| 11:33 | • New ticket [a6408d42b9] Partial index causes row to not be fetched. (artifact: ba5257e350 user: mrigger) | |
2 Years Ago (more context)
|
2018-08-30
| ||
| 20:28 | Try to identify the places in WAL code where thread-safety depends on the underlying architecture supporting atomic load and store of aligned 32-bit values. (check-in: 47d44be4a6 user: drh tags: trunk) | |
| 20:03 | Test the schema after renaming a table. Ensure that temp database triggers and views are updated when renaming a column. (check-in: f3c27d916d user: dan tags: alter-table-rename-table) | |
| 18:53 | Give the debugging routine print_pager_stats() external linkage in order to suppress harmless compiler and TSAN warnings. (check-in: ff4dc08298 user: drh tags: trunk) | |
| 16:26 | Fix an ALTER TABLE problem with processing temp schema views and triggers. (check-in: 72cfb1be29 user: dan tags: alter-table-rename-table) | |
| 01:52 | Improved JSON parser caching. (check-in: 58078c0d26 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2017-08-30
| ||
| 13:21 | Remove unnecessary "__declspec(dllexport)" qualifiers from generated file shell.c. (check-in: bcc20be5b2 user: dan tags: trunk) | |
| 04:44 | Small performance optimization in pcache1. (check-in: ffd437da95 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2010-08-30
| ||
| 23:04 | • Edit [4fead8e714c7e50a|4fead8e714]: Edit check-in comment. Timestamp 2010-08-30 22:15:45. (artifact: 2df6cdf1b0 user: drh) | |
| 22:15 | Provide hints to the btree layer during the creation of transient tables for when it is possible for those tables to use a hash rather than a binary tree. No use is currently made of those hints, though assert() statement verify their accuracy. (check-in: 4fead8e714 user: drh tags: trunk) | |
| 18:39 | When generating sqlite3.h, append the contents of sqlite3rtree.h. (check-in: fc4d75370b user: dan tags: trunk) | |
| 16:15 | Fix a problem in pagerfault.test uncovered by the previous change. (check-in: b6719ce328 user: dan tags: trunk) | |
| 15:43 | Add tests (and associated fixes) to restore coverage of rtree.c. (check-in: b06f4695bd user: dan tags: trunk) | |
| 15:02 | Remove the sqlite3BtreeFactory() wrapper routine. All modules now call sqlite3BtreeOpen() directly. (check-in: 0900e35348 user: drh tags: trunk) | |
| 11:34 | Add file sqlite3rtree.h. (check-in: e1d9ffce0f user: dan tags: trunk) | |
| 01:17 | Updates to comments on the VDBE opcodes. (check-in: 49c05b4e08 user: drh tags: trunk) | |
15 Years Ago (more context)
|
2005-08-30
| ||
| 22:44 | Adjust the makefile for new optimizer documentation. (CVS 2646) (check-in: 14668c85b8 user: drh tags: trunk) | |
| 22:44 | Initial work on documentation describing the optimizer. (CVS 2645) (check-in: 5cebd7ba3c user: drh tags: trunk) | |
| 20:12 | The CSV output mode does not sign-extend bytes where the high-order bit is set. Ticket #1397. (CVS 2644) (check-in: 528df777e5 user: drh tags: trunk) | |
| 19:30 | Fix printf.c so that it handles 10.0 correctly. (CVS 2643) (check-in: 0f7a53f78d user: drh tags: trunk) | |
| 00:54 | Minor code enhancements. (CVS 2642) (check-in: 4ab994a87e user: drh tags: trunk) | |
| 00:10 | Update the home page to brag about 150KiB code footprint when optional features are omitted. (CVS 2641) (check-in: 0e1ac1284c user: drh tags: trunk) | |