/ Timeline
Login

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

50 check-ins occurring around e3fde56da46e9592.

2019-04-02
17:45
Use a separate bit on db->dbOptFlags to disable the xInverse optimization on window functions, rather than reusing the query-flattener disable bit. check-in: bc0fb1c324 user: drh tags: trunk
17:45
Including the phrase EXCLUDE NO OTHERS in the frame-spec of a window function (which is the default setting for EXCLUDE) silently disables the xInverse optimization. This is a feature, but we will keep it undocumented for now in case we later decide it is a bad idea. check-in: 10aedce3dd user: drh tags: trunk
13:10
Put the list of keywords in mkkeywordhash.c into alphabetical order. check-in: ac98b23b34 user: drh tags: trunk
01:00
Merge fixes from trunk. check-in: 20372906cb user: drh tags: apple-osx
00:56
Make sure the MEM_FromBind bit inthe Mem.flags field is not included in the MEM_TypeMask. This critical changes was omitted from the previous two check-ins by mistake, and so those check-ins are not fully functional. check-in: f7ba2daf91 user: drh tags: trunk
00:48
Add new APIs to the extension loading mechanism. check-in: 6f122faf8a user: drh tags: trunk
00:34
Merge enhancements from trunk. check-in: 0b35aebbb3 user: drh tags: apple-osx
00:28
Add the sqlite3_value_frombind() interface. Use that interface to improve fts3_tokenizer(). check-in: b3f2c3205a user: drh tags: trunk
2019-04-01
20:57
Performance improvement on the OP_Variable opcode. Closed-Leaf check-in: 1dc7993bb6 user: drh tags: value_frombind
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
19:14
Remove a "puts" statement accidentally left in a test script. check-in: 9f591ac078 user: dan tags: reuse-schema
18:40
Add a few extra tests for SQLITE_STATUS_SCHEMA_USED with shared-schema databases. check-in: e399fede7b user: dan tags: reuse-schema
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
14:04
Use the mutex-free PRNG in this branch, since anybody using this branch is probably interested in high concurrency. check-in: e88fc6d0cd user: drh tags: begin-concurrent
13:28
Bring this branch into closer alignment with begin-concurrent. check-in: 6433d36617 user: drh tags: begin-concurrent-pnu
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