/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 descendants of [f2d5f7a24c]

2019-04-01
19:42
Improvements to the sqlite3ExprImpliesNonNullRow() theorem prover. check-in: 3fde627616 user: drh tags: trunk
18:43
Add a test case to cover a missed VDBE branch generated by window.c. check-in: b36813d646 user: dan tags: trunk
17:24
If the library is built with SQLITE_VDBE_COVERAGE defined, have the Tcl tests generate a vdbe coverage report in file testdir/vdbe_coverage.txt. check-in: f0ed714637 user: dan tags: trunk
16:23
Frame range comparisons can never be NULL because the values will have been checked for NULL prior to the test. check-in: fa37cf9a6a user: drh tags: trunk
15:55
Mark rowid-comparison opcodes as never-null for VDBE coverage tracking purposes. check-in: a69bb4f257 user: drh tags: trunk
14:30
Improved VDBE branch coverage in the run-time frame-spec error detection logic of window functions. check-in: f56d305a7b user: drh tags: trunk
14:01
Improved comments on the VDBE branch coverage testing logic. Fix the VDBE branch coverage measurement on the OP_MustBeInt opcode. check-in: 8681750e85 user: drh tags: trunk
13:06
Fix a defect in the VDBE branch coverage testing logic. check-in: 1fcf3307d3 user: drh tags: trunk
03:07
Fix harmless compiler warnings seen with MSVC. check-in: 6cf8b18ec2 user: mistachkin tags: trunk
2019-03-31
21:09
Early detection of too many columns in an index avoid a possible 16-bit signed integer overflow. check-in: 8af0caeb6d user: drh tags: trunk
18:17
Add some missing VdbeCoverage() macros. check-in: d03b611302 user: drh tags: trunk
2019-03-30
20:43
Improvements to VdbeCoverage macros. check-in: 10ee9e337e user: drh tags: trunk
20:37
Fix issues with the previous check-in and add more VDBE branch coverage testing macros. Closed-Leaf check-in: b5f72f10f2 user: drh tags: oops
20:10
Enhanced VdbeCoverage() macros in the new windows function code. Later: This check-in causes an assertion fault. check-in: f24066f8dd user: drh tags: oops
19:17
Add a call to sqlite3FaultSim(410) inside of btreeRestoreCursorPosition() to simplify testing of error scenarios. check-in: bb643bac53 user: drh tags: trunk
18:39
The defragmentPage() routine detects corruption in the first-free-slot fields at offset 1 in the header and throws an error, rather than asserting. check-in: fb125bd338 user: drh tags: trunk
17:30
Add the blobio.c extension module implementing readblob() and writeblob(). Experimental. check-in: e3fde56da4 user: drh tags: trunk
17:07
Add an extra IO-error test to windowfault.test. check-in: 5b8c44cd39 user: dan tags: trunk
2019-03-29
17:26
Change the fts3_tokenizer() function to always return the pointer as a BLOB as long as the first argument is a bound parameter, regardless of the SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER setting. check-in: 27160df7b3 user: drh tags: value_frombind
15:21
Remove the unused P5 flag from the OP_Rewind opcode. check-in: c2edbf3b8c user: drh tags: trunk
13:17
Fix a fairly obscure problem causing the planner to sometimes choose sub-optimal plans for a query with a single virtual table in the FROM clause, and at least one IN(...) constraint in the WHERE clause. check-in: f5752517f5 user: dan tags: trunk
11:48
Fix typos in the comments of the sessions extension, one of which affects the generated documentation. No code changes. check-in: 040d5d515b user: drh tags: trunk
11:39
The two-argument version of fts3_tokenizer() works regardless of the value of SQLITE_DBCONFIG_ENABLE_FT3_TOKENIZER as long as the second argument is a bind parameter. check-in: ab76e3a90e user: drh tags: value_frombind
11:13
Initial implementation of the sqlite3_value_frombind() interface. check-in: 98da62dfda user: drh tags: value_frombind
01:15
Recover a some of the performance lost by window function alias fix two check-ins back. check-in: 965cbcea11 user: drh tags: trunk
2019-03-28
20:50
Add new test cases to test/fuzzdata8.db check-in: f908cd40b2 user: drh tags: trunk
16:15
Prevent aliases of window functions expressions from being used as arguments to aggregate or other window functions. check-in: 1e16d3e8fc user: dan tags: trunk
13:53
Show the pointer address for Window objects in the TreeView display. check-in: 1ae70ad2ff user: drh tags: trunk
13:35
More improvements to TreeView output for Window objects: (1) Show when the frame-spec is implied rather than explicit. (2) Move the FILTER clause out from within the OVER clause, making it a sibling of the OVER clause, to match syntax. check-in: d6a0743342 user: drh tags: trunk
13:03
Improved TreeView display of Window objects. Change the Window.eType field to Window.eFrmType to avoid confusion with other "eType" values. check-in: ec2f207ded user: drh tags: trunk
04:03
If the string formatter in sqlite3NestedParse() fails due to an over-length string, make sure this error is recorded by the parser so that it knows to fail. check-in: 85e53ff133 user: drh tags: trunk
01:00
Improvements to the README.md file. No code changes. check-in: bbdbaf84a5 user: drh tags: trunk
2019-03-27
14:59
Support building the Tcl bindings DLL using MSVC. check-in: b2011c1317 user: mistachkin tags: trunk
14:58
Fix harmless compiler warnings seen with MSVC. check-in: 5be64ea8e3 user: mistachkin tags: trunk
2019-03-26
16:47
Fix a problem with window frames that use "BETWEEN <start> AND 0 PRECEDING". check-in: 7927b6b023 user: dan tags: trunk
16:21
Fix harmless compiler warnings. check-in: a063f7c426 user: drh tags: trunk
13:08
Add support for new window functions related features - GROUPS frames, RANGE frames with logical start and end points, the EXCLUDE clause and window chaining. check-in: c6da39115d user: dan tags: trunk
2019-03-22
13:56
Fix a problem with a window function in a correlated sub-query where at least one reference to the outer SELECT appears in a FROM clause sub-select. Closed-Leaf check-in: 9aca86f983 user: dan tags: window-functions
2019-03-21
13:51
Remove assert() statements based on the counter-factual proposition that 0 is not a valid cursor number. check-in: c7b336181a user: dan tags: window-functions
2019-03-19
19:39
Add further tests to window8.test. check-in: ec7e224f50 user: dan tags: window-functions
19:19
Fix a problem with EXCLUDE clauses on window frames with no ORDER BY. check-in: e025506379 user: dan tags: window-functions
17:45
Add tests to ensure that the window functions implementation is not generating code for unnecessary sorts. check-in: e195948a68 user: dan tags: window-functions
16:49
Add missing VdbeCoverage() macros to new code in window.c. check-in: 4f9b93e6cf user: dan tags: window-functions
11:56
Revert the OP_MustBeInt opcode implementation on this branch so that it again matches trunk. The extra functionality is no longer required. check-in: c02f77b1b4 user: dan tags: window-functions
11:17
Update this branch with latest trunk changes. check-in: 98cc265987 user: dan tags: window-functions
06:40
Ensure that all the new window-function keywords can still be used as SQL identifiers. check-in: a6d61dfd47 user: dan tags: window-functions
2019-03-18
21:19
Add further tests for new window function functionality. check-in: 1fbddf01b1 user: dan tags: window-functions
18:55
Always evaluate window functions using the alternative path usually only used by EXCLUDE frames if the SQLITE_QueryFlattener test flag is set. check-in: 2879a691ac user: dan tags: window-functions
16:51
Fixes for RANGE windows and NULL values. check-in: 723c84be3e user: dan tags: window-functions
2019-03-16
20:29
Fix problems with RANGE windows and string, blob and NULL values. check-in: cebe09e11c user: dan tags: window-functions
10:15
In order to identify the first row of each partition, check if the rowid in the ephemeral table is 1 instead of using a dedicated flag register. check-in: f2d5f7a24c user: dan tags: window-functions