This Day In History For 2025-06-09
1 Year Ago (more context)
|
2024-06-09
| ||
| 18:02 | Disable the omit-noop-join optimization when there are 64 or more terms in the ORDER BY clause. (Leaf check-in: d2d37e6d2b user: drh tags: branch-3.45) | |
| 17:58 | Disable the omit-noop-join optimization when there are 64 or more terms in the ORDER BY clause. (check-in: a7fe90c158 user: drh tags: branch-3.46) | |
| 17:34 | Disable the omit-noop-join optimization when there are 64 or more terms in the ORDER BY clause. (check-in: 40de393979 user: drh tags: trunk) | |
2 Years Ago (more context)
|
2023-06-09
| ||
| 19:24 | Naming consistency: Always use the singular "STRICT AGGREGATE", not the plural. (check-in: 275d056e46 user: drh tags: newbie-safe-aggregates) | |
| 18:58 | Improved sqlite3_error_offset() values for bare column errors on '*' and 'table.*' expressions in SELECT statements. (check-in: 446ad162f7 user: drh tags: newbie-safe-aggregates) | |
| 18:30 | The -DSQLITE_STRICT_AGGREGATES compile-time option enables SQLITE_DBCONFIG_STRICT_AGGREGATE by default. (check-in: cd1f6b27d9 user: drh tags: newbie-safe-aggregates) | |
| 15:54 | Simplify a memcpy() in defragmentPage(). It now might copy more content than is strictly necessary, but runs faster and uses less code space. Possible reasons for the improved performance: (1) the copy is now always 8-byte aligned, (2) fewer intermediate results are required which means less register pressure which helps the compiler to optimize the subroutine. (check-in: 6e5607ae4d user: drh tags: trunk) | |
| 13:08 | Experimental change to add a per-connection option that raises an error if a bare column appears in an aggregate query. (check-in: f587891134 user: drh tags: newbie-safe-aggregates) | |
| 06:04 | More .parameter improvements, a WIP for ".parameter set <cast_op> ..." (check-in: 2b51dcdad8 user: larrybr tags: cli_extension) | |
| 01:11 | Sync w/trunk. Fix spelling nits. Add ".parameter edit ..." improvements. (check-in: d73f065b93 user: larrybr tags: cli_extension) | |
3 Years Ago (more context)
|
2022-06-09
| ||
| 20:26 | Do not allow the subtype of a value to cross a subquery boundary. This fixes the problem identified by forum post 3d9caa45cbe38c78. (check-in: bbaf1f2eb1 user: drh tags: trunk) | |
| 17:17 | Prevent subtype values from slipping across a subquery boundry when the subquery is implemented as a co-routine. (Closed-Leaf check-in: 9e51a6c0fb user: drh tags: subtype-subquery) | |
| 16:19 | The subtype of a value should not propagate across a subquery boundary. Proposed fix for the problem reported by forum post 3d9caa45cbe38c78. Additional works is needed as not all cases are covered. (check-in: 08af1fe27e user: drh tags: subtype-subquery) | |
4 Years Ago (more context)
|
2021-06-09
| ||
| 14:45 | • Edit [56ff58c0b8905aa1|56ff58c0b8]: Edit check-in comment. (artifact: f24a22f00d user: drh) | |
| 14:45 | Set the database connection error code for an oversize argument to sqlite3_bind_blob64() or sqlite3_bind_text64(). Forum post a636276f0d451667 and 33821c8db543c. (check-in: 56ff58c0b8 user: drh tags: trunk) | |
| 13:39 | Add defensive code to better handle corrupt records in fts5. (check-in: a99c29b5ef user: dan tags: trunk) | |
5 Years Ago (more context)
|
2020-06-09
| ||
| 23:50 | • Fixed ticket [7c6d876f84]: Use after free in resetAccumulator. plus 5 other changes (artifact: 0f214f19d9 user: drh) | |
| 23:50 | Ensure that aggregate functions that (a) are part of SELECT statements with no FROM clause and (b) have one or more scalar sub-selects as arguments are assigned to the correct aggregate context. Fix for ticket [7c6d876f84e6e7e2] (check-in: c29a9e484e user: drh tags: trunk) | |
| 22:11 | Mark an always-true conditional with ALWAYS(). (Closed-Leaf check-in: 35a2368417 user: drh tags: agg-context-fix) | |
| 17:45 | Ensure that aggregate functions that (a) are part of SELECT statements with no FROM clause and (b) have one or more scalar sub-selects as arguments are assigned to the correct aggregate context. (check-in: 16a41fa8c4 user: dan tags: agg-context-fix) | |
| 14:56 | Crazy experimental change to refcount the AggInfo objects. (Leaf check-in: 9a4cc1dbf2 user: drh tags: refcount-agginfo) | |
| 13:53 | Modify a test file to avoid causing Tcl to allocate too much memory. (check-in: 232431f32e user: dan tags: trunk) | |
| 13:38 | Give the expression pointer fields of AggInfo distinctive names in order to simplify tracking of all their uses. (check-in: a53bdd311c user: drh tags: trunk) | |
| 13:17 | Persist AggInfo expressions before deleting them when omitting the LIMIT clause in a subquery. One possible fix for ticket [7c6d876f84e6e7e2]. (Leaf check-in: 04867cba97 user: drh tags: tkt-7c6d876f84e6e7e2) | |
| 11:59 | Improved tree-view debugging output for aggregate functions. (check-in: b5711b4eea user: drh tags: trunk) | |
10 Years Ago (more context)
|
2015-06-09
| ||
| 20:58 | Add the "columnsize=" option to fts5, similar to fts4's "matchinfo=fts3". (check-in: aa12f9d9b7 user: dan tags: fts5) | |
| 15:58 | Add the --output=$file and --verbose=(0|1|file) options to tester.tcl. (check-in: f7b2c70362 user: dan tags: trunk) | |
| 10:58 | Remove some repeated lines of source code. Probably introduced by careless cut'n'pasting. (Closed-Leaf check-in: a34cd71c8a user: dan tags: vtab-left-join) | |
15 Years Ago (more context)
|
2010-06-09
| ||
| 19:01 | Fix test script problems causing errors in the "inmemory_journal" permutations. (check-in: ea05b7f929 user: dan tags: trunk) | |
| 18:46 | • Edit [0797b10c0cc08ae3|0797b10c0c]: Edit check-in comment. Timestamp 2010-06-09 16:58:50. (artifact: e55f0d3890 user: drh) | |
| 16:58 | When restarting (wrapping) a log file, set all unused aReadMark[] slots to READMARK_NOT_USED instead of 0. Setting them to 0 does not cause a problem, but may cause SQLite to obtain and release a few more file locks than would otherwise be necessary. (check-in: 0797b10c0c user: dan tags: trunk) | |
| 16:16 | • Fixed ticket [f973c7ac31]: Incorrect affinity for indexed range constraint plus 2 other changes (artifact: 9b2cbacd90 user: drh) | |
| 15:47 | Fix for ticket [f973c7ac31]. (check-in: 6eb058dda8 user: dan tags: trunk) | |
| 15:20 | • New ticket [f973c7ac31] Incorrect affinity for indexed range constraint. (artifact: def6ef2209 user: drh) | |
| 14:45 | Shift the meaning of aReadMark[] back so that +1 offset from mxFrame is removed. Add the new READMARK_NOT_USED value (0xffffffff) instead of zero to signal an aReadMark[] that is not in use. (check-in: c576827d55 user: drh tags: trunk) | |
| 12:30 | • Edit [7c102c7b5f90717f|7c102c7b5f]: Change branch background color to "#ffc0d0". Move to branch mistake. Mark "Closed". Timestamp 2010-06-09 11:02:13. (artifact: 9e3e9ca2ee user: drh) | |
| 11:30 | • Edit [7c102c7b5f90717f|7c102c7b5f]: Timestamp 2010-06-09 11:02:13. Cancel tag "trunk". (artifact: 4d073dc296 user: dan) | |
| 11:29 | • Edit [7c102c7b5f90717f|7c102c7b5f]: Timestamp 2010-06-09 11:02:13. Add tag "mistake". (artifact: 4ca4f62e7b user: dan) | |
| 11:28 | Simpler fix for the race condition also fixed by [7c102c7b5f] (check-in: 3c2de82003 user: dan tags: trunk) | |
| 11:02 | Fix for race condition in WAL locking code. (Closed-Leaf check-in: 7c102c7b5f user: dan tags: mistake) | |
25 Years Ago (more context)
|
2000-06-09
| ||
| 14:14 | :-) (CVS 91) (check-in: d573b431ed user: drh tags: trunk) | |
| 03:52 | :-) (CVS 90) (check-in: aba926bb33 user: drh tags: trunk) | |
| 03:51 | :-) (CVS 89) (check-in: 8de283ded1 user: drh tags: trunk) | |
| 03:47 | :-) (CVS 88) (check-in: 3252269e90 user: drh tags: trunk) | |
| 01:58 | :-) (CVS 87) (check-in: 3661b5ff93 user: drh tags: trunk) | |