This Day In History For 2020-07-10
1 Year Ago (more context)
2019-07-10
| ||
20:16 | Minor performance improvement in sqlite3ExprDeleteNN(). (check-in: bcc8b38a user: dan tags: filter-clause) | |
18:45 | Merge the version 3.29.0 release enhancements into the reuse-schema branch. (check-in: 9819ead0 user: drh tags: reuse-schema) | |
18:40 | Merge the 3.29.0 updates into the begin-concurrent-pnu-wal2 branch. (check-in: 627b428f user: drh tags: begin-concurrent-pnu-wal2) | |
18:30 | Merge the 3.29.0 release into the wal2 branch. (check-in: 8baa4022 user: drh tags: wal2) | |
18:21 | Merge the 3.29.0 changes into the begin-concurrent-pnu branch. (check-in: c89949cc user: drh tags: begin-concurrent-pnu) | |
18:11 | Merge the 3.29.0 release into the begin-concurrent branch. (check-in: 983733ae user: drh tags: begin-concurrent) | |
17:58 | Merge the 3.29.0 release into the apple-osx branch. (check-in: 87aa1d70 user: drh tags: apple-osx) | |
17:32 | Version 3.29.0 (check-in: fc82b73e user: drh tags: trunk, release, version-3.29.0) | |
2 Years Ago (more context)
2018-07-10
| ||
23:31 | Remove incorrect ALWAYS() macros from the window function logic. (check-in: 94ac51cc user: drh tags: trunk) | |
22:24 | Add VdbeModuleComment()s on the three main code generators for window functions. (check-in: f7c239e9 user: drh tags: trunk) | |
20:50 | Minor comment changes. Add ALWAYS() macros on some unreachable branches in the xStep() methods of built-in window functions. (check-in: f2057542 user: drh tags: trunk) | |
19:48 | Identify Select objects within a single statement using small sequential integers rather than "0x%p". This is more readable and yields the same result on successive runs. (check-in: a7cdc5bc user: drh tags: trunk) | |
18:50 | Modify tests in window3.test to be tolerant of rounding errors when comparing floating point values. (check-in: 7c26c443 user: dan tags: trunk) | |
17:26 | Fix a problem with using scalar sub-selects in window function queries. (check-in: 687fe532 user: dan tags: trunk) | |
17:10 | Further improvements to bytecode branch testing. Fix cases where the macros said a branch could not be taken when in fact it could be. Alter some window function branch coverage macros to indicate that comparison operands cannot be NULL. (check-in: 76e42b70 user: drh tags: trunk) | |
16:04 | Enhancements and improved documentation to the byte-code branch coverage testing logic. Provide new macros that allow the code to specify that some branch instructions can never take the NULL path and that the OP_Jump opcode is only interested in equal/not-equal. The SQLITE_TESTCTRL_VDBE_COVERAGE file control callback now works slightly differently (it provides the callback with a bitmask of the branch action, rather than an integer). (check-in: cd2da7e1 user: drh tags: trunk) | |
15:55 | Experimental planner change to avoid a skip-scan if a regular index scan on the same index columns can be done instead. (Leaf check-in: 350f29ea user: dan tags: exp-begin-concurrent-pnu) | |
15:48 | Merge begin-concurrent changes into this branch. (check-in: af17432e user: dan tags: begin-concurrent-pnu) | |
15:45 | Merge latest trunk changes into this branch. (check-in: e9a3e864 user: dan tags: begin-concurrent) | |
07:39 | Fix a harmless warning about comment formatting in the previous check-in. Simplify the ORDER BY dereferencing logic so that it avoids unreachable branches. (check-in: 0f6ec605 user: drh tags: trunk) | |
07:25 | Assert that if two functions compare equal in every other way, then they must both have OVER clauses, or neither has an OVER clause. Use this fact to simplify expression comparison. (check-in: 52559ad5 user: drh tags: trunk) | |
06:47 | Enhance the sqlite3ExprCompare() routine so that it knows to compare the OVER clause of window functions. (check-in: 0a7649af user: drh tags: trunk) | |
06:32 | Enhance the TreeView mechanism so that it shows the window function data structures as part of the abstract syntax tree. (check-in: a2c0e1be user: drh tags: trunk) | |
05:11 | New VDBE comments and coverage macros. (check-in: a9a30726 user: drh tags: trunk) | |
3 Years Ago (more context)
2017-07-10
| ||
21:32 | Fix harmless compiler warnings in lsmtest. (check-in: bd8a1fb9 user: mistachkin tags: trunk) | |
20:39 | Fix errors in comments in the STMT virtual table. No code changes. (check-in: 9a8f045d user: drh tags: trunk) | |
20:33 | Minor cleanup and refactoring of the Win32 VFS for lsm1. (check-in: bf7eda67 user: mistachkin tags: trunk) | |
19:54 | Another spelling error in the README.md file. (check-in: 05129374 user: drh tags: trunk) | |
19:08 | Spelling error in README.md (check-in: 12bc47c5 user: drh tags: trunk) | |
19:07 | Yet another typo in README.md (check-in: 75c9327b user: drh tags: trunk) | |
19:05 | Fix another README.md typo. (check-in: 20b1f0ef user: drh tags: trunk) | |
19:03 | Fix an obsolete statement about Lemon in the README.md file. (check-in: 4f6ce7a3 user: drh tags: trunk) | |
18:57 | Cleanup header usage in lsmtest for files that require _O_BINARY. (check-in: f3a6a64e user: mistachkin tags: trunk) | |
18:52 | Updates to the repository README.md file. (check-in: 7bfd3ab7 user: drh tags: trunk) | |
18:33 | In LSM, avoid calling the VFS xTestLock method to test for a lock that conflicts with one held by the same process. The results of such a call are considered undefined (since they are different under win32 and posix). (check-in: a82a9bea user: dan tags: trunk) | |
18:04 | Add the "--newlines" option to the ".dump" command in the shell to disable the newline escaping mechanism. (check-in: bde431b1 user: drh tags: trunk) | |
17:00 | When multiple constraints need to be evaluated for a row, do any constraints that involve correlated subqueries last. Hence, the priority is index-covered constraints first, correlated subquery constraints last, and all others in the middle. This is a follow-on and improvement to the push-down optimization of check-in [d7bb79ed]. (check-in: c4cb9048 user: drh tags: trunk) | |
16:38 | Additional debugging Noop-comment in the constraint generator when wheretrace is enabled. (Closed-Leaf check-in: 0ca7474f user: drh tags: defer-where-subqueries) | |
15:26 | Small performance optimization in sqlite3WhereExprUsage(). (check-in: 38edc677 user: drh tags: defer-where-subqueries) | |
15:17 | Fix another problem on this branch. (check-in: a4fc9811 user: dan tags: defer-where-subqueries) | |
14:39 | Fix a problem causing non-covered WHERE terms to be evaluated before covered WHERE terms. (check-in: 7d3cb39f user: dan tags: defer-where-subqueries) | |
14:33 | When testing non-indexed WHERE constraints, test those that involve correlated sub-queries last of all. This increases the chances of not having to run the sub-query at all. (check-in: 1f9c1f35 user: dan tags: defer-where-subqueries) | |
13:24 | For sqlite3TreeView() debugging output, show the Expr.flags field on scalar subqueries. (check-in: dc857a96 user: drh tags: trunk) | |
12:07 | Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case. (check-in: f27b6370 user: drh tags: trunk) | |
11:17 | Remove the error message text from disused error codes such as SQLITE_EMPTY and SQLITE_FORMAT. (check-in: 871752f2 user: drh tags: trunk) | |
4 Years Ago (more context)
2016-07-10
| ||
19:35 | Merge comment typo fixes from trunk. (check-in: 728c5aa4 user: mistachkin tags: rowvalue) | |
19:35 | Fix typos in comments. No changes to code. (check-in: 77c692a6 user: mistachkin tags: trunk) | |
5 Years Ago (more context)
2015-07-10
| ||
17:55 | Fix inconsistencies in formatting of fts5 docs. (check-in: 5fb4c771 user: dan tags: trunk) | |