Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants and 100 ancestors of [236cb75b]
|
2018-07-10
| ||
| 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 | |
|
2018-07-09
| ||
| 22:49 | Fixes for various harmless compiler warnings. check-in: 5023b1b8 user: drh tags: trunk | |
| 20:58 | Add a comment to restriction (6) of the push-down optimization. No changes to code. check-in: 0c8a2f25 user: drh tags: trunk | |
| 20:41 | Add an ALWAYS() around a branch in sqlite3BtreeSkipNext() that we believe must always be true. check-in: 12be361a user: drh tags: trunk | |
| 18:55 | Avoid leaving view-definitions with an incomplete set of column names/types in the in-memory schema if an OOM strikes while allocating the same. check-in: 1ddbb537 user: dan tags: trunk | |
| 18:11 | Add a couple of OOM tests. check-in: 50de2a0d user: dan tags: trunk | |
| 17:33 | Remove redundant branches in window function processing. check-in: 8fdaf3f3 user: drh tags: trunk | |
| 16:24 | Simplification to the grammar rules for window functions. Fix a memory leak that can follow an OOM while parsing a comma-separated list of window definitions. check-in: a568f9c9 user: drh tags: trunk | |
| 13:31 | Throw an error if the second argument passed to nth_value() is not a positive integer. check-in: 1a06e57a user: dan tags: trunk | |
| 06:51 | Fix a bad assert() in window.c. check-in: fe8aaf0c user: dan tags: trunk | |
| 02:37 | Simplification to the logic that detects misuse of the application-defined function creation interfaces. check-in: 8f21d778 user: drh tags: trunk | |
| 02:02 | During WITHOUT ROWID table creation, if the sqlite3CreateTable() call fails due to an authorizer denying the INSERT into the sqlite_master table, then detect this fact and abort the CREATE TABLE early, to avoid an assertion fault. check-in: 164b1641 user: drh tags: trunk | |
|
2018-07-08
| ||
| 01:02 | Identify specific FuncDef objects for window functions using the pointer to the function name (FuncDef.zName) rather than the pointer to the xStep method. This allows xStep method pointer to be replaced with a single noopStepFunc() procedure, and thus save having lots of different no-op step functions. check-in: 410e13b0 user: drh tags: trunk | |
|
2018-07-07
| ||
| 20:55 | Simplifications to the implementation of the sum() SQL function. check-in: a8b13002 user: drh tags: trunk | |
| 20:26 | Fix another problem with reusing LSM cursors for range scans. check-in: ae3fc765 user: dan tags: trunk | |
| 20:23 | Fix the JSON extension so that it can be compiled separately from the amalgamation. check-in: 4b8cfe7b user: drh tags: trunk | |
| 20:13 | Fix an LSM problem caused by using the same cursor for equality and range scans. check-in: f05bead3 user: dan tags: trunk | |
| 19:47 | Add ALWAYS() macros on results of sqlite3_aggregate_context() calls in xInverse() implements, since they can never fail. check-in: fdef2a92 user: drh tags: trunk | |
| 19:36 | Add an assert() to help verify that OP_AggInverse is never called on an accumulator that has not previously been processed by OP_AggStep. check-in: 42138891 user: drh tags: trunk | |
| 17:38 | Add missing VdbeCoverage() macro to window.c. check-in: 63f4d306 user: dan tags: trunk | |
| 17:30 | Fix a problem with the handling of NULL values in the min() window function. check-in: b76f35b0 user: dan tags: trunk | |
|
2018-07-06
| ||
| 17:19 | Try to improve the error messages for misformed frame specifications in window definitions. check-in: 927b95a0 user: drh tags: trunk | |
| 14:31 | Also disallow non-constant expressions in "<expr> PRECEDING" or "<expr> FOLLOWING" clauses. check-in: a6dffecc user: dan tags: trunk | |
| 14:15 | Ensure an error is returned if the user specifies an unsupported frame type. check-in: 0f3f8fcd user: dan tags: trunk | |
| 13:48 | Prevent "UNBOUNDED FOLLOWING" from being used as the starting boundary of a window-frame. And "UNBOUNDED PRECEDING" from being used as the ending boundary. check-in: e51fdf66 user: dan tags: trunk | |
| 13:25 | Remove some bad assert() statements from the implementations of window functions percent_rank() and cume_dist(). check-in: 443f0c28 user: dan tags: trunk | |
| 07:42 | Return an error if DISTINCT is used with a window-function (e.g. "count(DISTINCT <expr>) OVER (...)"). check-in: d59bcc8e user: dan tags: trunk | |
|
2018-07-05
| ||
| 21:22 | Use separate opcodes, OP_AggValue and OP_AggInverse, for the new callbacks associated with Window Functions, for improved readability of EXPLAIN output. check-in: fa653805 user: drh tags: trunk | |
| 20:33 | Update the recipe for resetting a database using SQLITE_DBCONFIG_RESET_DATABASE. check-in: c43dd23f user: dan tags: trunk | |
| 20:05 | Get the json_group_array() and json_group_object() SQL functions working as window functions. check-in: 916cdc83 user: drh tags: trunk | |
| 18:34 | Return an error if a "RANGE" window-frame uses "<expr> PRECEDING" or "<expr> FOLLOWING". check-in: 786c87ba user: dan tags: trunk | |
| 18:19 | Fix a problem in the xInverse method of window-function group_concat(1). check-in: 73391283 user: dan tags: trunk | |
| 17:35 | Fix the .dump command in the command-line shell so that it does not show extraneous SELECT statements when ".echo on" is enabled. check-in: 11763cac user: drh tags: trunk | |
| 17:16 | In wal mode, if a "BEGIN EXCLUSIVE" command (or any other command that upgrades from no transaction directly to a write transaction) hits an SQLITE_BUSY_SNAPSHOT error, change the error code to SQLITE_BUSY to indicate to the caller that the condition may be transient. check-in: e6108047 user: dan tags: trunk | |
| 17:03 | Fix a typo inside an assert() statement introduced by the previous commit. Closed-Leaf check-in: e3357728 user: dan tags: exp-busy-snapshot-fix | |
| 15:46 | In wal mode, if a "BEGIN EXCLUSIVE" command (or any other command that upgrades from no transaction directly to a write transaction) hits an SQLITE_BUSY_SNAPSHOT error, change the error code to SQLITE_BUSY to indicate to the caller that the condition may be transient. check-in: 221ff63e user: dan tags: exp-busy-snapshot-fix | |
|
2018-07-04
| ||
| 14:28 | 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: 32924446 user: dan tags: exp-avoid-expensive-skipscan | |
|
2018-07-03
| ||
| 20:17 | Test that a race condition can cause a "BEGIN EXCLUSIVE" to return SQLITE_BUSY_SNAPSHOT in wal mode. check-in: 5a12db75 user: dan tags: trunk | |
|
2018-07-02
| ||
| 17:45 | Fix a problem in the xInverse callback for the built-in sum() window function. check-in: b6563647 user: dan tags: trunk | |
| 17:14 | Fix a segfault caused by having identical window functions in the select-list and ORDER BY clause of a SELECT statement. check-in: 693b4350 user: dan tags: trunk | |
| 15:03 | Fix a crash caused by a LIKE pattern that consists of a single escape character. Problem found by OSSFuzz. check-in: bb9bfc3a user: dan tags: trunk | |
| 12:07 | Fix a segfault caused by invoking a regular aggregate as a window-function. And some problems with count(*) when used as a window-function. check-in: 4f3c8a82 user: dan tags: trunk | |
|
2018-07-01
| ||
| 16:05 | Quick patch to the Lemon parser template to avoid an array overread reported by OSSFuzz. A proper fix involves enhancements to the table generators in Lemon to make the overread impossible. That fix will take longer to implement. The current check-in is a stop-gap. check-in: 3f6730be user: drh tags: trunk | |
|
2018-06-30
| ||
| 20:26 | Avoid a warning in fts5.c due to not using generated routine sqlite3Fts5ParserFallback(). check-in: 65ff5144 user: dan tags: trunk | |
| 20:15 | Merge implementation of SQL window functions from the exp-window-functions into trunk. check-in: 17198a12 user: dan tags: trunk | |
| 20:00 | Fix a minor problem in the code for determining whether or not an SQL statement is SQLITE_TOOBIG. Closed-Leaf check-in: 763e6c9e user: dan tags: exp-window-functions | |
| 19:12 | Merge all changes from the weak-fallback branch except those related to the weak-fallback feature itself. check-in: aad718fb user: dan tags: exp-window-functions | |
| 18:54 | Have the tokenizer handle fallback for tokens "OVER" and "FILTER" in the same way as it does for "WINDOW". Leaf check-in: 12d819e1 user: dan tags: weak-fallback | |
|
2018-06-29
| ||
| 20:43 | Further performance related tweaks for sqlite3RunParser(). check-in: 5eb47765 user: dan tags: weak-fallback | |
| 20:21 | Further tweaks to sqlite3RunParser(). check-in: eef61ffa user: dan tags: weak-fallback | |
| 19:54 | Improve on the previous checkin. Still a bit slow. check-in: c1fb41aa user: dan tags: weak-fallback | |
| 17:44 | Instead of using a lemon %fallback directive, have the tokenizer try to figure out whether an instance of "WINDOW" should be TK_WINDOW or TK_ID. check-in: 022079cb user: dan tags: weak-fallback | |
|
2018-06-28
| ||
| 20:05 | Modifications to parse.y to better support backwards compatibility for the "window" keyword. check-in: 7c4b879b user: dan tags: weak-fallback | |
| 03:38 | Introduce the concept of "weak fallback" in the parser. A weak fallback only occurs if a syntax error would result otherwise. check-in: c41d7079 user: drh tags: weak-fallback | |
|
2018-06-27
| ||
| 20:24 | Add missing VdbeCoverage() and VdbeCoverageNeverTaken() macros to window.c. check-in: 4383cb68 user: dan tags: exp-window-functions | |
| 19:48 | Avoid redundant ORDER BY operations when rewriting SELECT statements that contain window functions. check-in: 336de43a user: dan tags: exp-window-functions | |
|
2018-06-26
| ||
| 20:19 | Merge latest trunk changes. check-in: d9f814b4 user: dan tags: exp-window-functions | |
|
2018-06-25
| ||
| 20:34 | Add documentation comment for sqlite3_create_window_function(). And further tests. check-in: 3f2705b9 user: dan tags: exp-window-functions | |
| 11:42 | Fix another problem that could cause a crash when a window function was used in a view. check-in: e954145a user: dan tags: exp-window-functions | |
|
2018-06-23
| ||
| 19:29 | Fix problems with using window-functions in correlated sub-queries. check-in: 3e23cfc8 user: dan tags: exp-window-functions | |
| 16:26 | Fix a problem with using LIMIT in window-function queries. check-in: c1abd2dd user: dan tags: exp-window-functions | |
| 07:59 | Fix a problem with using a window-function SELECT as a FROM clause sub-query in some circumstances. check-in: 11d73339 user: dan tags: exp-window-functions | |
|
2018-06-22
| ||
| 20:51 | Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. check-in: 5f04b016 user: dan tags: exp-window-functions | |
| 17:57 | Merge latest trunk changes. check-in: ebe65b23 user: dan tags: exp-window-functions | |
|
2018-06-21
| ||
| 19:20 | Fix a problem with handling single row partitions in the percent_rank() window function. check-in: b84fbf16 user: dan tags: exp-window-functions | |
|
2018-06-20
| ||
| 09:23 | Add tests to improve coverage of code in window.c. Fix a problem with "SELECT row_number() OVER ()". check-in: f41b6b73 user: dan tags: exp-window-functions | |
|
2018-06-19
| ||
| 19:15 | Merge latest trunk changes with this branch. check-in: 6ad0e64b user: dan tags: exp-window-functions | |
| 18:11 | Fix a problem caused by a sub-query containing a window function in the FROM clause of a query that itself uses a window function. check-in: f4b1b6f8 user: dan tags: exp-window-functions | |
| 17:13 | Fix a problem with using min() or max() as a window function. check-in: 801074ce user: dan tags: exp-window-functions | |
|
2018-06-18
| ||
| 20:34 | Fix problems with using window functions in CREATE VIEW statements. check-in: 943bccd2 user: dan tags: exp-window-functions | |
| 17:36 | Ensure that all four callbacks are provided when registering a window function (otherwise SQLITE_MISUSE is returned). check-in: 5720dcd8 user: dan tags: exp-window-functions | |
| 16:55 | Add new API function sqlite3_create_window_function(), for creating new aggregate window functions. check-in: da03fb43 user: dan tags: exp-window-functions | |
|
2018-06-15
| ||
| 20:46 | Add extra OOM test. check-in: ac251f72 user: dan tags: exp-window-functions | |
| 19:01 | Fix another problem in lead()/lag(). And some errors that could occur following OOM faults. check-in: fadd4dc1 user: dan tags: exp-window-functions | |
| 16:10 | Fix a bug in the lead() and lag() window functions causing them to fail when used in queries featuring multiple window functions. check-in: 3839fb18 user: dan tags: exp-window-functions | |
|
2018-06-14
| ||
| 20:52 | Fix a problem with handling of statements containing two or more different windows. check-in: 567e09ef user: dan tags: exp-window-functions | |
| 19:06 | Fix problem with window functions min() and max() when used with a PARTITION clause and a frame starting point other than "UNBOUNDED PRECEDING". check-in: 43eb1e75 user: dan tags: exp-window-functions | |
| 14:30 | Merge latest trunk changes into this branch. check-in: 5cf5f180 user: dan tags: exp-window-functions | |
| 14:27 | Improve comments and code legibility in new file window.c. check-in: bb915854 user: dan tags: exp-window-functions | |
|
2018-06-13
| ||
| 20:29 | Fix problems with "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frames. check-in: c34f31db user: dan tags: exp-window-functions | |
|
2018-06-12
| ||
| 20:53 | Fix another issue to do with window-functions in aggregate queries. check-in: 6413e38a user: dan tags: exp-window-functions | |
| 18:40 | Fix some problems with using window-functions in aggregate queries. check-in: fe7081e0 user: dan tags: exp-window-functions | |
|
2018-06-11
| ||
| 20:50 | Clarify the relationship between a Window object and its associated Expr. check-in: 0cd55e98 user: dan tags: exp-window-functions | |
| 18:16 | Fix handling of window frames containing negative number of rows. e.g. "ROWS x PRECEDING AND y PRECEDING" where (x<y). check-in: b6d9c7ed user: dan tags: exp-window-functions | |
| 11:19 | Fix a typon in main.mk. check-in: e74f86f2 user: dan tags: exp-window-functions | |
|
2018-06-10
| ||
| 07:42 | Update Makefile.msc to include window.c in the build. check-in: 16db7384 user: dan tags: exp-window-functions | |
|
2018-06-09
| ||
| 18:09 | Merge recent trunk changes with this branch. check-in: c71f2359 user: dan tags: exp-window-functions | |
| 17:58 | Update the amalgamation build script to include window.c. check-in: 21d2f4a6 user: dan tags: exp-window-functions | |
| 17:43 | Add support for FILTER clause on aggregate window functions. check-in: ceaf798e user: dan tags: exp-window-functions | |
|
2018-06-08
| ||
| 20:58 | Add support for the WINDOW clause. check-in: 19c983b5 user: dan tags: exp-window-functions | |
| 16:11 | Do not flatten sub-queries that contain window functions. check-in: 236cb75b user: dan tags: exp-window-functions | |
| 11:45 | Fixes to allow group_concat() to be used as a window function. check-in: 89bbc9ba user: dan tags: exp-window-functions | |
|
2018-06-07
| ||
| 20:35 | Merge latest trunk changes with this branch. check-in: 25102203 user: dan tags: exp-window-functions | |
| 20:08 | Add window functions lag() and lead(). check-in: ef342070 user: dan tags: exp-window-functions | |
| 18:13 | The IN-early-out optimization: When doing a look-up on a multi-column index and an IN operator is used on a column other than the left-most column, then if no rows match against the first IN value, check to make sure there exist rows that match the columns to the right before continuing with the next IN value. check-in: 09fffbdf user: drh tags: trunk | |
| 18:01 | Fix the assert()s in the byte-code engine that prove that cursors are unidirectional. Closed-Leaf check-in: 4b0b4e14 user: drh tags: multikey-opt-idea | |
| 17:45 | Add support for window function first_value(). check-in: 060b2640 user: dan tags: exp-window-functions | |
| 17:32 | Remove the NextIfOpen and PrevIfOpen opcodes which are no longer needed when the IN-early-out optimization is working. check-in: 439c8162 user: drh tags: multikey-opt-idea | |
| 16:07 | Test cases. check-in: 085e8637 user: drh tags: multikey-opt-idea | |
| 15:54 | Fix problems with the nth_value() function. check-in: 63002b9a user: dan tags: exp-window-functions | |
| 15:28 | Merge the ".stat/.eqp" CLI fix from trunk. check-in: a91cad33 user: drh tags: multikey-opt-idea | |
| 15:23 | Avoid using a prepared statement for ".stats on" after it has been closed by the ".eqp full" logic. Fix for ticket [7be932dfa60a8a6b3b26bcf76]. check-in: bb87c054 user: drh tags: trunk | |
| 14:59 | Add the WHERE_IN_EARLYOUT flag and use it to clarify the logic of this optimization. check-in: 522f1eac user: drh tags: multikey-opt-idea | |
| 14:32 | Merge recent trunk enhancements. check-in: e9d7bf4f user: drh tags: multikey-opt-idea | |
|
2018-06-06
| ||
| 23:31 | Change a comma into a logically equivalent but semantically clearer semicolon. check-in: 71f97f0f user: drh tags: trunk | |
| 20:55 | More space and performance enhancements to sqlite3VdbeRecordCompare(). check-in: 83a60ff0 user: drh tags: trunk | |
| 20:51 | Add implementation of nth_value() window function. check-in: eb1fb420 user: dan tags: exp-window-functions | |
| 20:29 | Small performance optimization in sqlite3VdbeRecordCompareWithSkip() for the common case where the comparison is equal. check-in: 1e616e25 user: drh tags: trunk | |
| 19:48 | Rearrange the order of some checks in the integrity_check pragma for a very slight performance gain. check-in: 4b853f02 user: drh tags: trunk | |
| 18:50 | Fix the sqlite3BeginTrans() calls within the snapshot extension. check-in: 1fef7ad2 user: drh tags: trunk | |
| 17:45 | Another minor optimization to OP_Transaction. check-in: d80077ae user: drh tags: trunk | |
| 16:28 | Change sqlite3BtreeBeginTrans() to return the BTREE_SCHEMA_COOKIE, for a small speed improvement when starting new transactions. check-in: a10662aa user: drh tags: trunk | |
| 01:18 | Fix the ".archive" command in the CLI (and the corresponding -A command-line option) so that it silently ignores filenames that contain "../" in their names. This prevents the "Zip Slip" attack. check-in: 27291f2d user: drh tags: trunk | |
|
2018-06-05
| ||
| 23:51 | Update the version number to 3.25.0 for the next development cycle. check-in: 7598236c user: drh tags: trunk | |
| 23:21 | Avoid unnecessary loads of columns in an aggregate query that are not within an aggregate function and that are not part of the GROUP BY clause. check-in: e15e1006 user: drh tags: trunk | |
| 20:45 | Add the OP_IfNoHope and OP_SeekHit opcodes used to reduce the number of unnecessary sqlite3BtreeMovetoUnpacked() calls when checking for an early exit on IN-operator loops. Futher optimizations are likely possible here. check-in: 6bf251af user: drh tags: multikey-opt-idea | |
| 20:04 | Calculate non-aggregate expressions in the SELECT list of an aggregate query that does not use min() or max() once per group, instead of once per row visited. Closed-Leaf check-in: dce2dfbe user: dan tags: exp-agg-opt | |
| 16:16 | Add implementation of last_value() window function. check-in: 2493ce1a user: dan tags: exp-window-functions | |
| 15:16 | Use an OP_NotFound opcode to cancel futile IN operators early. The current implementation is suboptimal because it always runs teh OP_NotFound. This still needs to be enhanced to only do the OP_NotFound if no results have been seen on the current loop. check-in: 87a9fc50 user: drh tags: multikey-opt-idea | |
| 13:54 | Merge trunk changes. check-in: 047295c5 user: drh tags: multikey-opt-idea | |
| 13:43 | Update and correct the documentation on the OP_OpenRead, OP_OpenWrite, and OP_ReopenIdx opcodes. No code changes other than the addition of an assert(). check-in: 8a0b730d user: drh tags: trunk | |
|
2018-06-04
| ||
| 19:24 | Version 3.24.0 check-in: c7ee0833 user: drh tags: trunk, release, version-3.24.0 | |
| 18:55 | Add implementation of window function ntile(). check-in: 3f093f60 user: dan tags: exp-window-functions | |
| 13:27 | Merge recent changes from trunk. check-in: f8df2a8e user: drh tags: multikey-opt-idea | |
| 08:28 | Merge latest trunk changes into this branch. check-in: 83d6416a user: dan tags: exp-window-functions | |
| 08:22 | Add support for window function cume_dist(). Improve tests for percent_rank(). check-in: 76543f7d user: dan tags: exp-window-functions | |
|
2018-06-02
| ||
| 21:04 | Add support for window functions row_number(), rank(), dense_rank() and percent_rank(). check-in: 91c1cb7a user: dan tags: exp-window-functions | |
| 19:14 | Avoid using a misaligned pointer. check-in: 1ecb3aa1 user: drh tags: trunk | |
| 19:01 | Fix the usage of posix_fallocate() so that it correctly responds to EINVAL returns. check-in: ce2c3e7a user: drh tags: trunk | |
| 17:00 | Update a test case in malloc5.test to take into account that malloc() sometimes returns slightly more space than requested. check-in: 3d5eae1c user: dan tags: trunk | |
| 16:32 | Work around a sanitizer warning about a pointer being only 4-byte aligned instead of 8-byte aligned. Closed-Leaf check-in: 1b807b51 user: drh tags: align8-fix | |
| 14:37 | Proposed fix for the use of posix_fallocate() so that it handles EINVAL returns correctly. Closed-Leaf check-in: ab3a5539 user: drh tags: einval-from-fallocate | |
| 12:05 | Fix the CSV extension so that it works with single-column CSV files. check-in: e336cf00 user: drh tags: trunk | |
| 11:31 | Ensure that sqlite3AuthRead() is only call for TK_COLUMN and TK_TRIGGER expression nodes. This fixes a harmless assert() identified by OSSFuzz. Move the assert() into a position where it is tested even if the authorizer is disabled. check-in: d0c3beef user: drh tags: trunk | |
|
2018-06-01
| ||
| 21:00 | Allow an entire partition to be cached in a temp table for all types of window frames. This is required by nth_value() and others. check-in: b5b18f66 user: dan tags: exp-window-functions | |
| 13:30 | Fix a bug in the SQLITE_ENABLE_SORTER_REFERENCES code causing an out-of-bounds array reference. check-in: 8cadaf58 user: dan tags: trunk | |
|
2018-05-31
| ||
| 19:14 | More documentation typo fixes. No code changes. check-in: 66c24513 user: drh tags: trunk | |
| 19:00 | Fix a harmless typo in a comment used to generate documentation. check-in: 5a2a88cb user: drh tags: trunk | |
|
2018-05-30
| ||
| 20:44 | Allow min() and max() to be used as window functions. check-in: c16125a8 user: dan tags: exp-window-functions | |
| 14:17 | Add the Makefile.fallback makefile to the amalgamation tarball. check-in: ce3d0456 user: drh tags: trunk | |
| 07:36 | Do not use the codec on the resetdb.test script. check-in: fe55cea0 user: drh tags: trunk | |
| 07:24 | Fix a typo in an error message in the CLI. check-in: 80883980 user: drh tags: trunk | |
| 01:14 | Fix the parser so that it builds with -DSQLITE_OMIT_CTE. check-in: 86ee267e user: drh tags: trunk | |
| 00:59 | Fix a harmless compiler warning. check-in: 8d02c7a6 user: drh tags: trunk | |
| 00:54 | Demonstration code on a possible technique for optimizing the use of IN operator on columns to the right of multicolumn indexes. If the OP_Noop generated where were really a new opcode that checked to see if there existed any entries in the index with a matching prefix, it might prevent unnecessary iterations of the IN operator. check-in: 92f0fe15 user: drh tags: multikey-opt-idea | |
|
2018-05-29
| ||
| 19:12 | Increase the number of database handles opened by test script oserror.test to provoke an "out of file-descriptors" error to 20000 (from 2000). check-in: 3b00f734 user: dan tags: trunk | |
| 16:37 | Fix autoinc.test and resetdb.test so that they work with all permutations. check-in: 89f56d6b user: dan tags: trunk | |
| 15:18 | Add a comment to justify a goto statement. No code changes. check-in: f141d806 user: drh tags: trunk | |
| 14:29 | More minor changes to test scripts. check-in: ce9b756f user: dan tags: trunk | |
| 14:06 | Fix some test script issues caused by recent EXPLAIN QUERY PLAN enhancements. check-in: f808e228 user: dan tags: trunk | |
| 13:25 | Do not run test file "resetdb.test" as part of permutation "inmemory_journal". check-in: 4921e5ba user: dan tags: trunk | |
|
2018-05-28
| ||
| 18:30 | Further window frame tests and fixes. check-in: e74c6e91 user: dan tags: exp-window-functions | |
| 18:29 | Do not require a statement journal in cases where REPLACE conflict handling is used to insert a single row, so long as the REPLACE operation cannot fire any triggers or foreign key actions. check-in: 469a62ca user: dan tags: trunk | |
| 18:25 | When compiling with SQLITE_DEBUG, add run-time checks to ensure that no statement aborts unless either there have been no writes or else there is a statement journal. check-in: ce99c772 user: drh tags: trunk | |
| 17:43 | Fix the build so that it works with -DSQLITE_TEST_REALLOC_STRESS Closed-Leaf check-in: 90ba2b2e user: drh tags: stmt-journal-testing | |
| 17:31 | When compiling with SQLITE_DEBUG, add run-time checks to ensure that no statement aborts unless either there have been no writes or else there is a statement journal. check-in: 5a4542db user: drh tags: stmt-journal-testing | |
|
2018-05-26
| ||
| 21:17 | More fixes for different window frame types. check-in: 2c85668a user: dan tags: exp-window-functions | |
| 16:00 | Store application-defined function names as lower-case to avoid the need for case conversions before calling xFindFunction on virtual tables. Avoid using lookaside to store the destructors for application defined functions, as lookaside should be reserved for transient allocations. check-in: 777189ce user: drh tags: trunk | |
| 13:55 | Add a single sentence of documentation about the virtual table scan flags. No changes to code. check-in: 27b4fa5d user: drh tags: trunk | |
|
2018-05-25
| ||
| 20:30 | Fix "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frame processing. check-in: b4e9c686 user: dan tags: exp-window-functions | |
| 09:36 | Merge latest trunk changes into this branch. check-in: 62325198 user: dan tags: exp-window-functions | |
| 09:29 | Fixes for "ROWS BETWEEN <expr> FOLLOWING AND <expr> FOLLOWING" and "ROWS BETWEEN <expr> FOLLOWING AND UNBOUNDED FOLLOWING" check-in: 5ac44872 user: dan tags: exp-window-functions | |
|
2018-05-24
| ||
| 23:51 | When doing a one-pass UPDATE or DELETE on virtual tables, close the cursor prior to running VUpdate. This allows one-pass to work on virtual tables that do not allow concurrent reads and writes. Enhance rtree to take advantage of this new capability. check-in: b816023c user: drh tags: trunk | |
| 22:42 | New test case for reading and writing the same rtree concurrently. check-in: 3ba08e53 user: drh tags: trunk | |
| 22:31 | Do not allow RTree writes when a read cursor is active on the same virtual table, as the writes might rebalance and disrupt the read cursors. Return the new SQLITE_LOCKED_VTAB error code if this happens. check-in: d4ce6661 user: drh tags: trunk | |
| 21:10 | Allow "<expr> PRECEDING" to be used to specify the end of a window frame. check-in: 7b709a98 user: dan tags: exp-window-functions | |
| 17:49 | Support other frame types that use "<expr> PRECEDING" or "<expr> FOLLOWING" as start or end conditions. check-in: ec7b648c user: dan tags: exp-window-functions | |
| 17:38 | In the OOM testing logic, add the sqlite3FirstFault() routine as a place to set a breakpoint the first time any simulated OOM fault occurs for a single test case. check-in: b4d80bd2 user: drh tags: trunk | |
| 17:25 | Fix a typo in a comment used to generate VDBE opcode documentation. No code changes. check-in: 36cdfbf2 user: drh tags: trunk | |
| 16:18 | Addition cases for rtree preformance testing in speedtest1.c. Add the --nodiff option to the speed-check.sh script. check-in: 95f2d62c user: drh tags: trunk | |
| 13:59 | Updates to the sqlite3_vtab_nochange() documentation. No changes to code. check-in: 5bd99abc user: drh tags: trunk | |
|
2018-05-23
| ||
| 20:55 | Add support for "ROWS BETWEEN <expr> PRECEDING AND <expr> FOLLOWING" window frames. check-in: 3a203660 user: dan tags: exp-window-functions | |
| 17:53 | Remove a branch that is no longer used due to the fix to the sqlite_sequence schema problem, ticket [d8dc2b3a58cd5dc2918a1d4acbba4676a23ada4c] check-in: 06674269 user: drh tags: trunk | |
| 16:50 | Verify that the sqlite_sequence table exists and is in approximately the correct format prior to using it to process an autoincrement table. Fix for ticket [d8dc2b3a58cd5dc2918a1d4a]. check-in: e199e859 user: drh tags: trunk | |
|
2018-05-22
| ||
| 20:36 | Merge latest trunk changes into this branch. check-in: cdb68d2c user: dan tags: exp-window-functions | |
| 20:35 | Add comments to window.c describing how other window frames will be implemented. check-in: 16168146 user: dan tags: exp-window-functions | |
|
2018-05-21
| ||
| 19:45 | Begin adding support for more esoteric window frames. check-in: bc4b81d6 user: dan tags: exp-window-functions | |
|
2018-05-19
| ||
| 14:15 | Fix minor problems on this branch. check-in: 19c2e4b2 user: dan tags: exp-window-functions | |
|
2018-05-18
| ||
| 17:58 | Add support for auxiliary columns to the rtree extension. check-in: c6071ac9 user: drh tags: trunk | |
| 17:17 | Merge enhancements from trunk, especially the CLI fixes. Closed-Leaf check-in: a350040a user: drh tags: aux-data-in-rtree | |
| 17:11 | In the CLI, detect and report errors on sqlite3_close(). Clear global variables prior to exit to so that valgrind can better detect resource leaks. check-in: e3b2e0a0 user: drh tags: trunk | |
| 16:53 | Avoid unnecessary sqlite3_finalize() operations. check-in: 16f71032 user: drh tags: aux-data-in-rtree | |
| 16:46 | Fix a prepare-statement leak. check-in: 95fd296f user: drh tags: aux-data-in-rtree | |
| 15:21 | Improved error messages. Limit the number of auxiliary columns to 100. check-in: 059d20ab user: drh tags: aux-data-in-rtree | |
| 14:24 | Improvements to integer/float comparisons on architectures that lack a "long double" type. check-in: 5139ea62 user: drh tags: trunk | |
| 14:19 | Remove incorrect NEVER() macro added by the previous check-in. Closed-Leaf check-in: 3d662511 user: drh tags: int-float-compare | |
| 13:39 | Improvements to the sqlite3IntFloatCompare() routine for systems that lack the long double type. check-in: ea6a03a8 user: drh tags: int-float-compare | |
|
2018-05-17
| ||
| 20:04 | In the CLI with the -A command, if the file does not previously exist and its name looks like a ZIP archive name, then create it as a ZIP archive. check-in: 33dc8fad user: drh tags: trunk | |
| 19:24 | Evaluate multiple window functions in a single pass if they use the same window definition. Add xValue callbacks for other built-in aggregate functions. check-in: c9f0f140 user: dan tags: exp-window-functions | |
| 14:26 | Handle multiple window-functions in a single query. check-in: 35af0b75 user: dan tags: exp-window-functions | |
| 14:09 | Improved error and help messages for the ".archive" command and "-A" option to the CLI. If a memory leak in --list processing. check-in: 02541ac6 user: drh tags: trunk | |