Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 ancestors of 1dc7993bb6957587
2019-04-01
| ||
20:57 | Performance improvement on the OP_Variable opcode. (Closed-Leaf check-in: 1dc7993b user: drh tags: value_frombind) | |
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: 27160df7 user: drh tags: value_frombind) | |
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: ab76e3a9 user: drh tags: value_frombind) | |
11:13 | Initial implementation of the sqlite3_value_frombind() interface. (check-in: 98da62df 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: 965cbcea user: drh tags: trunk) | |
2019-03-28
| ||
20:50 | Add new test cases to test/fuzzdata8.db (check-in: f908cd40 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: 1e16d3e8 user: dan tags: trunk) | |
13:53 | Show the pointer address for Window objects in the TreeView display. (check-in: 1ae70ad2 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: d6a07433 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: ec2f207d 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: 85e53ff1 user: drh tags: trunk) | |
01:00 | Improvements to the README.md file. No code changes. (check-in: bbdbaf84 user: drh tags: trunk) | |
2019-03-27
| ||
14:59 | Support building the Tcl bindings DLL using MSVC. (check-in: b2011c13 user: mistachkin tags: trunk) | |
14:58 | Fix harmless compiler warnings seen with MSVC. (check-in: 5be64ea8 user: mistachkin tags: trunk) | |
2019-03-26
| ||
16:47 | Fix a problem with window frames that use "BETWEEN <start> AND 0 PRECEDING". (check-in: 7927b6b0 user: dan tags: trunk) | |
16:21 | Fix harmless compiler warnings. (check-in: a063f7c4 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: c6da3911 user: dan tags: trunk) | |
2019-03-25
| ||
22:05 | Fix an obsolete comment in the CLI. No code changes. (check-in: fade103c user: drh tags: trunk) | |
21:56 | In the CLI, code the "sqlite_parameters" name directly rather than using a macro, for clarity of presentation for users who are reading the code for the purpose of seeing how the CLI implements parameter binding. (check-in: e775ef00 user: drh tags: trunk) | |
21:55 | Remove a test from the index build logic which is no longer needed and is in fact unreachable. (check-in: 9b20ee10 user: drh tags: trunk) | |
21:35 | Change the name of the parameter table in the CLI to "sqlite_parameters". Doing so involves adding SQLITE_DBCONFIG_WRITABLE_SCHEMA and allowing the creation of tables whose names begin with "sqlite_" and that are indexed while writable_schema is on. (check-in: 24ef3844 user: drh tags: trunk) | |
19:50 | Earlier detection of corruption while added to the freelist. (check-in: 8c80b004 user: drh tags: trunk) | |
18:44 | Fix a faulty assert() statement in balance_nonroot() - the assert() should use get2byteNotZero() instead of get2byte() for the corner case where the number cells is zero on a 65536-byte page. (check-in: bcbe7d96 user: drh tags: trunk) | |
15:09 | Improvements to the help text in the CLI. (check-in: 919fec91 user: drh tags: trunk) | |
15:06 | Fix the writefile() SQL function implemented by ext/misc/fileio.c such that any directories created have standard umask permissions, not permissions of the file that is to be written. (check-in: f11c8959 user: drh tags: trunk) | |
14:24 | For the ".archive --update" command in the CLI, only update files if their mtime or mode has changed. To force an update, use the new --insert instead. (check-in: 191a023a user: drh tags: trunk) | |
2019-03-23
| ||
00:38 | Support Tcl libraries with a suffix. (Closed-Leaf check-in: 8d015399 user: mistachkin tags: msvcTcl) | |
2019-03-22
| ||
22:34 | Further enhancements and fixes. (check-in: c9f1972e user: mistachkin tags: msvcTcl) | |
16:52 | Attempt to detect when the MSVC linker requires the /MACHINE argument. (check-in: 3e355846 user: mistachkin tags: msvcTcl) | |
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: 9aca86f9 user: dan tags: window-functions) | |
13:53 | We learn that readdir_r() is deprecated in favor of plain old readdir(), which is now suppose to be threadsafe using thread-local storage. So remove the use of readdir_r() from the test code. (SQLite itself never calls readdir() or readdir_r()). (check-in: 7a0a26ed user: drh tags: trunk) | |
11:38 | Add the --limit N option to dbfuzz2. Set the default callback limit to 250K. (check-in: b99f8512 user: drh tags: trunk) | |
01:26 | Sync up the autoconf makefile for MSVC. (check-in: ecbae90a user: mistachkin tags: msvcTcl) | |
01:25 | Support building the Tcl bindings DLL using MSVC. (check-in: 908c4c89 user: mistachkin tags: msvcTcl) | |
2019-03-21
| ||
21:18 | Add an extra test for database corruption to defragmentPage(). (check-in: 80e951fc user: dan tags: trunk) | |
13:51 | Remove assert() statements based on the counter-factual proposition that 0 is not a valid cursor number. (check-in: c7b33618 user: dan tags: window-functions) | |
2019-03-20
| ||
18:22 | In the CLI, give better error messages if something goes wrong with the ".dbinfo" command. (check-in: 3649a77b user: drh tags: trunk) | |
16:58 | Fix a potential dangling pointer deference in an ALTER TABLE run on a schema that contains constructs of the form "PRIMARY KEY(column COLLATE collation)". (check-in: b9e2393c user: dan tags: trunk) | |
12:08 | Fix harmless compiler warnings from MSVC. (check-in: f0f02d46 user: drh tags: trunk) | |
11:16 | Enhance the rtreenode() function of rtree (used for testing) so that it uses the newer sqlite3_str object for better performance and improved error reporting. Test cases added to TH3. (check-in: 90acdbfc user: drh tags: trunk) | |
05:45 | Fix various harmless compiler warnings seen with MSVC. (Closed-Leaf check-in: 1c0fe5b5 user: mistachkin tags: noWarnings) | |
2019-03-19
| ||
20:42 | Enhance the VACUUM INTO command so that it works on read-only databases. (check-in: 55be6d0a user: drh tags: trunk) | |
20:13 | Fix a compiler warning in FTS5. (check-in: d5acf3af user: drh tags: trunk) | |
19:39 | Add further tests to window8.test. (check-in: ec7e224f user: dan tags: window-functions) | |
19:19 | Fix a problem with EXCLUDE clauses on window frames with no ORDER BY. (check-in: e0255063 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: e195948a user: dan tags: window-functions) | |
16:49 | Add missing VdbeCoverage() macros to new code in window.c. (check-in: 4f9b93e6 user: dan tags: window-functions) | |
15:36 | When computing the amount of scratch memory needed during a rebalance operation, assume the worst case for the number of cells per page, rather than relying on the BtPage.nCell value, which might be incorrect for a corrupt database. (check-in: a420ebd0 user: drh tags: trunk) | |
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: c02f77b1 user: dan tags: window-functions) | |
11:35 | Tweak the tool/cg_anno.tcl script so that it can run on systems without /usr/bin/tclsh. (check-in: a026189a user: dan tags: trunk) | |
11:17 | Update this branch with latest trunk changes. (check-in: 98cc2659 user: dan tags: window-functions) | |
09:57 | Add a LICENSE.md, containing the text of the blessing. (check-in: cbb7e602 user: drh tags: trunk) | |
06:40 | Ensure that all the new window-function keywords can still be used as SQL identifiers. (check-in: a6d61dfd user: dan tags: window-functions) | |
2019-03-18
| ||
21:19 | Add further tests for new window function functionality. (check-in: 1fbddf01 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: 2879a691 user: dan tags: window-functions) | |
16:51 | Fixes for RANGE windows and NULL values. (check-in: 723c84be user: dan tags: window-functions) | |
15:49 | Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (check-in: b3fa58dd user: dan tags: trunk) | |
15:23 | Fix an fts5 problem with interleaving reads and writes in a single transaction. (check-in: 45c73deb user: dan tags: trunk) | |
10:30 | Fix a typo in a comment. No changes to code. (check-in: c2f50aa4 user: drh tags: trunk) | |
2019-03-17
| ||
23:59 | New hyperlink on the README.md file. (check-in: cc5ab967 user: drh tags: trunk) | |
23:44 | Update the README.md file at the top level to talk about how to deal with version names and how to verify the code in Git mirrors. (check-in: e8c87a0a user: drh tags: trunk) | |
2019-03-16
| ||
20:29 | Fix problems with RANGE windows and string, blob and NULL values. (check-in: cebe09e1 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: f2d5f7a2 user: dan tags: window-functions) | |
2019-03-15
| ||
20:46 | Implement the EXCLUDE clause for window frames. (check-in: 9b43c3ee user: dan tags: window-functions) | |
19:08 | Back out the change to support Fuchsia, since it turns out fuchsia does not like dot-file locks. (check-in: 1d801a3b user: drh tags: trunk) | |
18:57 | Remove a debugging printf() left in test/sessionfuzz.c. (check-in: 73c4abc9 user: dan tags: trunk) | |
16:17 | Ensure that ALTER TABLE commands open statement transactions. Fix for [596d059a]. (check-in: 0f2129f5 user: dan tags: trunk) | |
2019-03-14
| ||
20:53 | Parse EXCLUDE clauses in window frames. They do not yet work. (check-in: d03c7533 user: dan tags: window-functions) | |
16:36 | Add things to this branch that will be required to support the EXCLUDE clause. (check-in: 7d66cd20 user: dan tags: window-functions) | |
00:01 | Technical improvements to the documentation for sqlite3_bind_blob() and sqlite3_bind_text(). No changes to code. (check-in: fb60150a user: drh tags: trunk) | |
2019-03-13
| ||
23:51 | Improvements to the sqlite3_db_filename() API documentation. No code changes. (check-in: 711f5ec4 user: drh tags: trunk) | |
17:31 | Merge latest trunk changes into this branch. (check-in: 0b904517 user: dan tags: window-functions) | |
17:20 | Avoid allocating excessive registers for the PARTITION BY expressions when processing window functions. (check-in: 180be266 user: dan tags: window-functions) | |
15:29 | Remove rows from the ephemeral table used by window functions once they are no longer required. (check-in: 6ad55319 user: dan tags: window-functions) | |
13:19 | New test cases added to test/fuzzdata8.db (check-in: 049e9926 user: drh tags: trunk) | |
11:40 | When deserializing a database (sqlite3_deserialize()), do not attempt to parse the schema before the data is loaded. (check-in: 4e1b005e user: dan tags: trunk) | |
10:29 | Detect zero-length free slots on btree pages and report that as corruption. (check-in: c4f0568f user: drh tags: trunk) | |
08:28 | Minor optimization in sqlite3WindowCodeStep(). (check-in: b1322ffb user: dan tags: window-functions) | |
2019-03-12
| ||
18:28 | Allow real values to be used in PRECEDING and FOLLOWING expressions for RANGE window frames. (check-in: 25ff7091 user: dan tags: window-functions) | |
15:21 | Expand on header comment for sqlite3WindowCodeStep(). Further simplify the implementation of the same. (check-in: 5129bcc9 user: dan tags: window-functions) | |
09:49 | Fix a crash that could occur if the RHS of an IN expression is a correlated sub-query that refers to the outer query from within a window frame definition only. (check-in: 0524aaaf user: dan tags: trunk) | |
2019-03-11
| ||
19:50 | Remove "cache mode" from the window frame code generator. Handle the same cases by editing the window frame specification itself. (check-in: 08126353 user: dan tags: window-functions) | |
18:17 | Simplify the windows frame code some. Add a comment explaining some of the VM code generated by sqlite3WindowCodeStep(). (check-in: 6bd1a079 user: dan tags: window-functions) | |
11:12 | Fix problems with "RANGE ... ORDER BY <expr> DESC" window frames. (check-in: e7bced73 user: dan tags: window-functions) | |
2019-03-09
| ||
20:49 | Add support for RANGE window frames. Some cases still do not work. (check-in: ffc32b24 user: dan tags: window-functions) | |
07:38 | Merge latest trunk changes into this branch. (check-in: 53ea550c user: dan tags: window-functions) | |
2019-03-08
| ||
20:57 | Add simple tests for GROUPS window frames. (check-in: 2872702d user: dan tags: window-functions) | |
20:26 | Fix a harmless bug in the Makefile. (check-in: 62ac9cb0 user: drh tags: trunk) | |
20:02 | Finish consolidation of window frame code. Add untested support for GROUPS frames. (check-in: 954bf369 user: dan tags: window-functions) | |
14:07 | Add new test cases in test/fuzzdata8.db (check-in: 97bdc090 user: drh tags: trunk) | |
14:02 | Patch makes balance_nonroot() slightly smaller and faster and more robust against corrupt databases. (check-in: 174da3c3 user: drh tags: trunk) | |
13:27 | Fix another segfault in fts3 that could occur with corrupt records. (check-in: fcc24edd user: dan tags: trunk) | |
01:52 | Detect an attempt to drop a btree that is not within the bounds of the database file and abort early with an SQLITE_CORRUPT error, to avoid problems later on in the process. (check-in: 235a9698 user: drh tags: trunk) | |
2019-03-07
| ||
20:47 | Fix other "ROWS BETWEEN" cases on this branch. (check-in: a5f68f66 user: dan tags: window-functions) | |
19:26 | Modify new window functions function so that cursors are stepped immediately after each operation, instead of immediately before. (check-in: 093d2b25 user: dan tags: window-functions) | |
2019-03-06
| ||
21:04 | Simplify the window function code generator some more. (check-in: 45cbd3b4 user: dan tags: window-functions) | |
17:12 | Improvements to the way built-in window functions are handled. (check-in: e8eee566 user: dan tags: window-functions) | |
14:53 | Add the sqlite3_stmt_isexplain() interface. (check-in: ee642d3e user: drh tags: trunk) | |
14:08 | Add an "|| CORRUPT_DB" term to an assert() that might be false if the database is corrupt. Also add a branch to have sqlite3PagerMovepage() return SQLITE_CORRUPT in that case. (check-in: b0d5cf40 user: drh tags: trunk) | |
2019-03-05
| ||
23:49 | Fix a potential 32-bit integer overflow in the "showdb" utility program when it is trying to interpret a corrupt database file. (check-in: 3803e750 user: drh tags: trunk) | |
19:29 | Extend windowCodeStep() to handle any ROWS PRECEDING/FOLLOWING frame specification. (check-in: af0ea136 user: dan tags: window-functions) | |