This Day In History For 2025-11-25
1 Year Ago (more context)
|
2024-11-25
| ||
| 18:47 | Ensure that file-handle winShmNode.hFile.h is used in a thread-safe manner. (check-in: 7a32b497ab user: dan tags: win32-enable-setlk) | |
| 17:07 | Correct duplicated soname linker flags, one of them mis-named. (check-in: 87dfd92d3a user: stephan tags: trunk) | |
| 16:54 | Fixes for code on this branch. Now appears to work, but is not tested well. (check-in: 0568fc6dde user: dan tags: win32-enable-setlk) | |
| 14:16 | Version 3.47.1 for the reuse-schema branch. (check-in: 83e95cf3ed user: drh tags: reuse-schema-3.47) | |
| 12:07 | Version 3.47.1 (check-in: b95d11e958 user: drh tags: release, version-3.47.1, branch-3.47) | |
2 Years Ago (more context)
|
2023-11-25
| ||
| 23:00 | Remove unused elements from the json_tree() cursor. (check-in: 914a50117d user: drh tags: jsonb-tree) | |
| 20:59 | Remove the vestigal JsonNode logic from json_tree() and json_each(). (check-in: 66c2ab9ebb user: drh tags: jsonb-tree) | |
| 19:28 | Almost working. Path is still not exactly right when Root is defined on json_tree(). (check-in: 9225824691 user: drh tags: jsonb-tree) | |
| 18:11 | Generate the fullkey and path columns of json_tree(). (check-in: ffaa468ab8 user: drh tags: jsonb-tree) | |
| 13:40 | Handle the path argument to json_tree() and json_each(). (check-in: fded888469 user: drh tags: jsonb-tree) | |
3 Years Ago (more context)
|
2022-11-25
| ||
| 18:45 | • Ticket [695a1a53de] Better choice of indexes with covering indexes on expressions status still Open with 3 other changes (artifact: d5202fa021 user: drh) | |
| 18:40 | • Ticket [695a1a53de]: 6 changes (artifact: 5ad6703c81 user: drh) | |
| 17:05 | Relax restriction (8) on the push-down optimization so that it only applies if one or more columns uses a collating sequence other than BINARY. See forum post 3824ced748baa808 and check-in [346a3b12b861ce7b]. (check-in: adbca3448e user: drh tags: trunk) | |
| 16:32 | Fix #ifdefs so that restrictions (8) and (9) of the push-down optimization are still enforced even if compiled with SQLITE_OMIT_WINDOWFUNC. This fixes a bug introduced by check-in [346a3b12b861ce7b]. (check-in: 09e1e42e0f user: drh tags: trunk) | |
| 16:12 | • Fixed ticket [9937817793]: Use indexed expressions in an aggregate query plus 6 other changes (artifact: fb3dc805a8 user: drh) | |
| 16:10 | Improve the query planner such that it is able to make use of indexed expressions within an aggregate query with GROUP BY. This implements enhancement request [99378177930f87bd]. (check-in: b9190d3da7 user: drh tags: trunk) | |
| 15:52 | Add restriction (9) to the push-down optimization: If the subquery is a compound then all arms of the compound must have the same affinity. dbsqlfuzz 3a548de406a50e896c1bf7142692d35d339d697f. (check-in: 1ad41840c5 user: drh tags: trunk) | |
| 13:26 | Remove a redundant assert() statement. (Closed-Leaf check-in: e3e1b453dc user: drh tags: agg-with-indexed-expr) | |
| 13:15 | Improve the robustness of the updateAccumulator() routine against OOM. (check-in: d2844f577b user: drh tags: agg-with-indexed-expr) | |
| 13:08 | Improved comments. Add assert()s to verify that the AggInfo structure is unchanged after registers have been assigned. (check-in: 5200b84195 user: drh tags: agg-with-indexed-expr) | |
5 Years Ago (more context)
|
2020-11-25
| ||
| 20:29 | Merge trunk changes into this branch. (check-in: f4b7c10057 user: dan tags: reuse-schema) | |
| 18:44 | Update a requirement mark in the e_expr.test script. (check-in: bb174a074b user: drh tags: trunk) | |
| 16:28 | Fix harmless compiler warnings about unused function parameters. (check-in: 25d067c270 user: drh tags: trunk) | |
| 15:29 | Fix a potential NULL pointer dereference in the geopoly_overlap() routine of the GeoPoly extension. (check-in: b5665712e6 user: drh tags: trunk) | |
| 14:50 | Fix the shell1.test test script so that it works on windows. (check-in: 9bd15b07e5 user: drh tags: trunk) | |
| 13:59 | Change the -init option to the command-line shell to honor the -bail option. Also change it to report an error if the filename mentioned cannot be opened. (check-in: a29f54bd2c user: drh tags: trunk) | |
10 Years Ago (more context)
|
2015-11-25
| ||
| 23:13 | Simplify the temporary filename generator and the time-of-day functions in the unix VFS. (check-in: 6c5621ce1b user: drh tags: trunk) | |
| 18:40 | Fix harmless compiler warnings in test_fs.c. Fix typos and clean up the text of the documentation for sqlite3_strglob() and sqlite3_strlike(). (check-in: 697b20534c user: drh tags: trunk) | |
| 18:07 | Update test_fs.c to include a virtual table that reads a file-system hierarchy. Use it to further test GLOB and LIKE support for virtual tables. (check-in: 6ef6578c03 user: dan tags: trunk) | |
| 18:03 | Make the xAccess method of the unix VFS smaller and faster. (check-in: 191aef986f user: drh tags: trunk) | |
| 15:15 | Remove unused methods from the unix VFS. (check-in: 228bd15bbb user: drh tags: trunk) | |
| 14:00 | Simplification of the error code translator in os_unix.c. Code cleanup only. The logic is unchanged. (check-in: 2a20f793fd user: drh tags: trunk) | |
| 11:56 | Fix the fts5 "prefix=" option to match the documentation (space separated list, multiple prefix= options supported). The undocumented comma-separated format (compatible with fts4) still works. (check-in: 11eb8e877e user: dan tags: trunk) | |
| 01:57 | Enhancement the virtual table interface to support LIKE, GLOB, and REGEXP operators. Also add the sqlite3_strlike() interface, which might be useful as part of the implementation of LIKE on some virtual tables. (check-in: a6bfd4692c user: drh tags: trunk) | |
15 Years Ago (more context)
|
2010-11-25
| ||
| 17:49 | Add coverage tests (and associated fixes) for new matchinfo() code. (check-in: 70495ceccc user: dan tags: fts3-experimental) | |
| 10:33 | Fix bugs in fts3 function matchinfo() when used with deferred tokens. (check-in: ddc2b7ec26 user: dan tags: fts3-experimental) | |
20 Years Ago (more context)
|
2005-11-25
| ||
| 10:55 | Ensure a low system limit on the number of open files does not cause manydb.test to fail. (CVS 2784) (check-in: dba2cc0d0e user: danielk1977 tags: trunk) | |
| 10:38 | Add the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2783) (check-in: f9f5ecbb79 user: danielk1977 tags: trunk) | |
| 10:38 | Add the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2782) (check-in: f1298bb103 user: danielk1977 tags: trunk) | |
| 09:01 | If SQLITE_DISABLE_LFS is defined, omit the bigfile tests. (CVS 2781) (check-in: f882a516da user: danielk1977 tags: trunk) | |
| 08:47 | Check the return code of full_fsync() when used to sync a directory fd. (CVS 2780) (check-in: 84aae3b0ae user: danielk1977 tags: trunk) | |
| 02:43 | Preserve 64-bit last insert rowids across triggers. (CVS 2779) (check-in: 4dd7cfaa58 user: drh tags: trunk) | |