This Day In History For 2025-06-05
1 Year Ago (more context)
2024-06-05
| ||
20:54 | Harmonize function names. (Leaf check-in: db43d7aa5d user: mistachkin tags: concatb) | |
20:52 | Add an experimental concatb() function. (check-in: 07d8420285 user: mistachkin tags: concatb) | |
20:50 | Fix harmless compilation issues seen with MSVC. (check-in: 816d474938 user: mistachkin tags: trunk) | |
20:41 | Small performance optimization in the codeEqualityTerm() routine of the code generator. (check-in: 8080c6eafd user: drh tags: trunk) | |
16:50 | Fix an fts5 problem with secure-delete mode causing integrity-check to erroneously report a corrupt index. (check-in: 0a7fa0a434 user: drh tags: branch-3.46) | |
14:47 | Fix an fts5 problem with secure-delete mode causing integrity-check to erroneously report a corrupt index. (check-in: 80bef4d60b user: dan tags: trunk) | |
11:36 | Fix a very obscure issue where the name resolver could get confused if aliases like "sqlite_schema" or "sqlite_master" were used in a query involving the sqlite_temp_schema table. (check-in: a096eb7554 user: dan tags: trunk) | |
11:30 | • Edit [38dacbd7ada9e56c|38dacbd7ad]: Move to branch mistake. Add propagating "hidden". (artifact: 5e027f85e5 user: dan) | |
11:30 | Fix a very obscure issue where the name resolver could get confused if aliases like "sqlite_schema" or "sqlite_master" were used in a query involving the sqlite_temp_schema table. (Leaf check-in: 38dacbd7ad user: dan tags: mistake) | |
2 Years Ago (more context)
2023-06-05
| ||
17:12 | Fix compiler warning in src-verify.c. (check-in: 2d58c77448 user: drh tags: trunk) | |
13:57 | Update the README.md file to talk about the verify-source makefile target. (check-in: aa8e79e16a user: drh tags: trunk) | |
11:30 | Remove extraneous console trace output from previous check-in. (check-in: c9f6e36d59 user: stephan tags: trunk) | |
11:26 | Add a JS test confirming that binding of statement parameters in a subquery works. (check-in: 5dfaf0bce8 user: stephan tags: trunk) | |
01:05 | Generalize the src-verify.c utility program and provide additional documentation in the header comment. (check-in: 7ed84046ef user: drh tags: trunk) | |
00:57 | Minor cosmetic normalizations for the MSVC makefile. (check-in: c9fda8d6db user: mistachkin tags: trunk) | |
3 Years Ago (more context)
2022-06-05
| ||
22:58 | In CLI, drop .dbinfo command when build options prevent it from working. (check-in: 2512d2f68d user: larrybr tags: dbinfo-guard) | |
22:40 | Create new branch named "dbinfo-guard" (check-in: 8d942ba72e user: larrybr tags: dbinfo-guard) | |
5 Years Ago (more context)
2020-06-05
| ||
23:21 | • New ticket [0899cf62f5] Segfault in sqlite3VdbeExec. (artifact: caa07d55de user: yongheng) | |
21:36 | Improved tracing of window function parse tree rewrites. (check-in: 7e8060cf96 user: drh tags: early-winfunc-rewrite-dev) | |
18:17 | Assign a fake name to the ephemeral subquery tables that are created when making parse-tree changes for window functions. (check-in: c4072267dc user: drh tags: early-winfunc-rewrite-dev) | |
15:56 | Do parse-tree transformations required for window functions prior to running aggregate function analysis. Fix for ticket [c8d3b9f0a750a529]. (check-in: 79eff1d038 user: drh tags: branch-3.32-early-winfunc-rewrite) | |
15:40 | New test case for fuzzdata8.db. (check-in: 2870d11720 user: drh tags: early-winfunc-rewrite-dev) | |
15:26 | • Fixed ticket [c8d3b9f0a7]: Use after free in resetAccumulator. plus 5 other changes (artifact: a22f5809c5 user: drh) | |
15:26 | Do parse-tree transformations required for window functions prior to running aggregate function analysis. Fix for ticket [c8d3b9f0a750a529]. (check-in: 0b42a2277e user: drh tags: early-winfunc-rewrite-dev) | |
14:53 | Ensure that the "push-down" optimization does not push constraints down into compound queries if any of the component queries uses window functions. (Closed-Leaf check-in: 2011e83213 user: dan tags: early-winfunc-rewrite) | |
14:25 | ALWAYS() and NEVER() macros added due to unreachable branches arising from the previous check-in. (check-in: 13ffedab9b user: drh tags: early-winfunc-rewrite) | |
14:10 | Move the parse tree rewrite for window functions earlier in the process, before sqlite3ExprAnalyzeAggregates() has run. Add new assert()s to verify that aggregate analysis always remains valid until the end of SELECT processing. (check-in: fe702aa08c user: drh tags: early-winfunc-rewrite) | |
04:01 | In the debugging treeview output, change the name of "SELECT-expr" expression nodes to be "subquery-expr", so as to not confuse them with actual SELECT nodes. (check-in: c1c8937a30 user: drh tags: trunk) | |
01:52 | • New ticket [c8d3b9f0a7] Use after free in resetAccumulator.. (artifact: cd708fa84d user: yongheng) | |
00:54 | Always use ?...? to indicate optional arguments in the output of ".help" in the CLI. Change ".mode column" so that it automatically activates ".headers on" if headers have not been previously turned on or off. (check-in: 2827c0a186 user: drh tags: trunk) | |
10 Years Ago (more context)
2015-06-05
| ||
22:33 | Split FROM-clause subquery flattening and code generation into separate loops. (check-in: be8e3fc70e user: drh tags: view-optimization) | |
20:27 | Provide one final Select tree dump prior to WHERE clause analysis when ".selecttrace 0x400" tracing bit is set with SELECTTRACE_ENABLED. Analysis and debug changes only - normal builds are unaffected. (check-in: 283bf0b64d user: drh tags: trunk) | |
19:05 | Make use of range constraints on the rowid field of an fts5 table in full-text queries. (check-in: 32cbc0ed36 user: dan tags: fts5) | |
15:59 | Add a new opcode to the VDBE that gives the b-tree a hint about the set of columns in a table or index that are actually used by the query. (Closed-Leaf check-in: f167bba446 user: drh tags: column-usage-hint) | |
15 Years Ago (more context)
2010-06-05
| ||
19:18 | Add further test cases for the logic in sqlite3WalBeginReadTransaction(). (check-in: a49713db39 user: dan tags: trunk) | |
18:34 | • Edit [c041c6a9786bc9eb|c041c6a978]: Edit check-in comment. Timestamp 2010-06-05 18:34:26. (artifact: 384ffb6ecd user: dan) | |
18:34 | Clarify the purpose of a test for a race-condition in sqlite3WalBeginReadTransaction(). (check-in: c041c6a978 user: dan tags: trunk) | |
18:12 | Remove a condition from sqlite3WalRead() that is unreachable as of the changes to clear entries out of the wal-index hash tables on transaction or savepoint rollback. (check-in: 394204735a user: dan tags: trunk) | |
14:42 | Mark a condition in wal.c as ALWAYS(). (check-in: 3fe0cc784a user: dan tags: trunk) | |
11:53 | Add extra coverage test cases for wal.c. No changes to production code. (check-in: f9d4ae0e8c user: dan tags: trunk) | |
25 Years Ago (more context)
2000-06-05
| ||
21:39 | added Agg opcodes to the vdbe (CVS 54) (check-in: e9ed5d2a36 user: drh tags: trunk) | |
18:56 | :-) (CVS 53) (check-in: 3dbfa558ef user: drh tags: trunk) | |
18:54 | :-) (CVS 52) (check-in: c02268bdf4 user: drh tags: trunk) | |
16:01 | separate Select structure (CVS 51) (check-in: ce45dea902 user: drh tags: trunk) | |
02:07 | :-) (CVS 50) (check-in: 1cf2873d55 user: drh tags: trunk) | |