Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/window1.test
2025-04-10
| ||
10:18 | [2a6970e27f] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 63185) | |
2024-05-23
| ||
23:26 | [79dc3b9a22] part of check-in [cec6bb3fc9] Fix the window-function group_concat() so that it returns an empty string if it has one or more empty string inputs. This fixes a bug introduced by [c6da39115d3e2b0f] on 2019-03-26 (version 3.28.0) and reported by forum post bf8f43aa522c2299. (check-in: [cec6bb3fc9] user: drh branch: trunk, size: 63197) | |
2023-12-15
| ||
21:39 | [8f8585432c] part of check-in [122cd0bada] Fix a spurious "misuse of aggregate function" error that could occur when an aggregate function was used within the FROM clause of a sub-select of the select that owns the aggregate. (check-in: [122cd0bada] user: drh branch: branch-3.43, size: 62595) | |
2023-11-07
| ||
19:02 | [e38b3dbe7c] part of check-in [fce776ccce] Do not allow aggregate or window functions in UPDATE statements. (check-in: [fce776ccce] user: dan branch: no-aggregates-in-update, size: 62563) | |
2023-11-02
| ||
21:02 | [5e8abe56a7] part of check-in [4470f657d2] Fix a spurious "misuse of aggregate function" error that could occur when an aggregate function was used within the FROM clause of a sub-select of the select that owns the aggregate. e.g. "SELECT (SELECT x FROM (SELECT sum(t1.a) AS x)) FROM t1". Forum post c9970a37ed. (check-in: [4470f657d2] user: dan branch: trunk, size: 62585) | |
2023-10-20
| ||
20:19 | [ccfeaf116a] part of check-in [b91c19bf26] Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: [b91c19bf26] user: drh branch: string_agg, size: 62612) | |
2023-05-23
| ||
15:16 | [1e7e13d362] part of check-in [48e65f18b2] When converting an aggregate expression to AGG_COLUMN, be sure to remove the EP_Unlikely flag if it is present. Forum post fbfe330a2009d036. (check-in: [48e65f18b2] user: drh branch: trunk, size: 62622) | |
2023-04-13
| ||
15:11 | [cc3cf7ea8c] part of check-in [fc12743763] Remove an ALWAYS() that can sometimes be false. And fix a code-generator issue associated with very unusual use of window functions. (check-in: [fc12743763] user: drh branch: branch-3.41, size: 62218) | |
14:53 | [5ba48e9d33] part of check-in [ebc844fbfb] Add extra test cases to window1.test. (check-in: [ebc844fbfb] user: dan branch: trunk, size: 62303) | |
14:50 | [57a2107dd1] part of check-in [1ba22631a7] Fix a code-generator issue associated with very unusual use of window functions. Both the expr.c or the window.c changes will each independently fix the problem. They are both included in this patch for defense in depth. Forum post 0d48347967. (check-in: [1ba22631a7] user: drh branch: trunk, size: 61812) | |
2023-04-11
| ||
15:06 | [c607e30741] part of check-in [c8fb143d64] Remove an ALWAYS() that can sometimes be false. Add a test case that makes the test false. Forum post 6c5678e3da. (check-in: [c8fb143d64] user: drh branch: trunk, size: 61290) | |
2023-03-28
| ||
16:02 | [67aaef6e01] part of check-in [c34fd9fe1b] Fix a weird corner case in aggregate function processing that results from the recent addition of support for index expressions on aggregate queries. Forum post bad532820c. (check-in: [c34fd9fe1b] user: drh branch: trunk, size: 60884) | |
11:18 | [71e51e4d5e] part of check-in [c8bedef0d6] Fix multiple problems with RETURNING on a DML statement against a view, all inspired by forum post dc3b92cfa0. (1) Do not allow a RETURNING clause to trick the code generator into thinking that the view being updated has an INSTEAD OF trigger. (2) Generate all result columns for a view in a DML statement. (3) The automatic covering index for a view should cover all result columns of the view. (check-in: [c8bedef0d6] user: drh branch: trunk, size: 59841) | |
2023-03-03
| ||
16:25 | [5ad2f3e2ae] part of check-in [cc4bb05b36] When it is known when preparing a statement that X cannot be NULL or is always NULL, transform the expression (X IS NULL) to integer value 1 or 0 instead of 'true' or 'false'. This is because under some circumstances, "Y IS TRUE" or "Y IS FALSE" may not be equivalent to "Y IS 1" of "Y IS 0". This problem was introduced by [de9c86c9e4cdb34f] and was reported by forum post 2cd11c2d37. (check-in: [cc4bb05b36] user: dan branch: trunk, size: 58660) | |
2022-09-01
| ||
10:41 | [0410dd5c7d] part of check-in [e3754cc188] In the query planner, add a heuristic that will reduce the cost of a full table scan for a materialized view or subquery if the full scan is the outer-most loop. This is shown to speed up some queries. (check-in: [e3754cc188] user: drh branch: branch-3.28, size: 30990) | |
10:29 | [08bac93423] part of check-in [609fbb94b8] In the query planner, add a heuristic that will reduce the estimated cost of a full table scan for a materialized view or subquery if the full scan is the outer-most loop. This is shown to speed up some queries. (check-in: [609fbb94b8] user: drh branch: trunk, size: 58258) | |
2022-06-21
| ||
13:41 | [ae87c4ea4e] part of check-in [9322a7c21f] Allow a HAVING clause on any aggregate query, even if there is no GROUP BY clause. This brings SQLite into closer agreement with PostgreSQL and fixes the concern raised by forum post 1a7fea4651. (check-in: [9322a7c21f] user: drh branch: trunk, size: 58242) | |
12:54 |
[a0eeb74273]
part of check-in [1f57584102]
| |
2021-11-07
| ||
23:33 | [18aadea36d] part of check-in [0f9fc6b607] Ensure that the window function rewrite does not leave the parse tree in an invalid state that might cause problems downstream before the error is recognized and unwinds the stack. Also take steps such that an invalid parse tree does not cause problems even if it goes unrecognized. Forum post 398e9d5aa9. (check-in: [0f9fc6b607] user: drh branch: trunk, size: 58041) | |
2021-10-01
| ||
20:39 | [778ac2a5a0] part of check-in [2f7c946c5f] Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: [2f7c946c5f] user: dan branch: trunk, size: 57730) | |
2021-07-13
| ||
15:30 | [2a692388f8] part of check-in [d2e6722037] Remove two incorrect assert() statements from the logic used to derive column names and types from subqueries. This allows the SQL associated with CVE-2020-13871 (ticket [c8d3b9f0a750a529]) to be tested. (check-in: [d2e6722037] user: dan branch: branch-3.28a, size: 30974) | |
2021-06-23
| ||
11:12 | [9242d80831] part of check-in [710f75b98b] Fix a problem handling ORDER BY terms of the form "ORDER BY likely(<integer>)" within window frames. (check-in: [710f75b98b] user: dan branch: trunk, size: 57691) | |
2021-05-24
| ||
00:17 | [49eadb28b0] part of check-in [0be6b6c9f7] Additional defenses (above and beyond [b986600520696b0c]) to prevent an invalid subquery from causing problems downstream. If an error is found while analyzing a subquery expression, change the expression to TK_ERROR so inhibit further processing on that expression. dbsqlfuzz cf624b8c0484c66e0f552bf6475e3e3f2c22b24e. (check-in: [0be6b6c9f7] user: drh branch: trunk, size: 57315) | |
2021-05-22
| ||
11:23 | [b7ed3bc818] part of check-in [b986600520] Do not invoke sqlite3ExprAffinity() after a syntax error that might have left the tree in an inconsistent state. See also [e8a1515b44380cc5] and forum post 7e484e225c. (check-in: [b986600520] user: drh branch: trunk, size: 57024) | |
2021-05-19
| ||
14:49 | [7cb66f49d3] part of check-in [3daab94977] Allow aggregate sub-selects within ORDER BY and PARTITION BY clauses of window frame definitions. (check-in: [3daab94977] user: dan branch: trunk, size: 56745) | |
2021-05-17
| ||
16:20 | [138f328242] part of check-in [4c6cd54a8d] Fix problems with refering to CTEs from within sub-selects in PARTITION BY or ORDER BY clauses of window frame definitions. Also a problem with renaming a column when the schema contains a trigger containing a correlated sub-select within a window frames PARTITION BY or ORDER BY clause. (check-in: [4c6cd54a8d] user: dan branch: trunk, size: 55836) | |
2021-05-07
| ||
15:46 | [5950af3f6f] part of check-in [0d11d777c8] Detect misuse of aggregate functions in the ORDER BY clause of a query even if the query also contains window functions. (check-in: [0d11d777c8] user: drh branch: trunk, size: 55613) | |
2021-04-17
| ||
20:13 | [54e160bdeb] part of check-in [4ec9ef4bcd] Remove a couple of NEVER() macros from the code for walking window lists. (check-in: [4ec9ef4bcd] user: dan branch: trunk, size: 55213) | |
13:46 | [515512f47c] part of check-in [1a341378ab] Ensure that variables are not used in the WINDOW clause of a query inside of a trigger. dbsqlfuzz d9cf66100064952b66951845dfab41de1c124611 (check-in: [1a341378ab] user: drh branch: trunk, size: 54644) | |
2021-04-12
| ||
16:59 | [d85fd6d82f] part of check-in [5ba15ebb34] Fix a segfault that could occur if the ORDER BY clause of a compound SELECT contains a sub-select that uses one or more window functions. (check-in: [5ba15ebb34] user: dan branch: trunk, size: 54221) | |
2021-04-05
| ||
19:05 | [1d3527fe4e] part of check-in [7a19fed4f2] Do not allow floating point rounding errors to cause a window function xInverse() function to be invoked before the corresponding xStep() call. (check-in: [7a19fed4f2] user: dan branch: trunk, size: 53787) | |
2020-07-13
| ||
15:20 | [e52b81fff0] part of check-in [e6c2192ef8] Fix a problem causing queries containing window functions to ignore collation sequences under some circumstances. (check-in: [e6c2192ef8] user: dan branch: trunk, size: 52300) | |
2020-06-11
| ||
15:47 | [9d7f4990e5] part of check-in [50b4a1c7f4] Avoid rewriting compound SELECT statements that use a different collation sequence for ORDER BY and record processing a second time if they contain window functions. Fix for [b706351c]. (check-in: [50b4a1c7f4] user: dan branch: mistake, size: 50908) | |
2020-06-10
| ||
10:58 | [486f0e0131] part of check-in [094dcfe779] Ensure that the "push-down" optimization does not push constraints down into compound queries if any of the component queries uses window functions. (check-in: [094dcfe779] user: dan branch: trunk, size: 50326) | |
2020-06-07
| ||
20:18 | [49f81c25c0] part of check-in [3c840b4df3] AggInfo objects might be referenced even after the sqlite3Select() function that created them has exited. So AggInfo cannot be a stack variable. And it must not be freed until the Parse object is destroyed. (check-in: [3c840b4df3] user: drh branch: persist-agginfo, size: 49792) | |
17:33 | [30ec5cc344] part of check-in [7682d8a768] Alternative fix to ticket [c8d3b9f0a750a529]: Prior to deleting or modifying an Expr not that is referenced by an AggInfo, modify the AggInfo to get its own copy of the original Expr. (check-in: [7682d8a768] user: drh branch: persist-agginfo, size: 48785) | |
00:43 | [6df6331862] part of check-in [a6c2147cc6] Extra steps to ensure that queries that involve both window functions and aggregate functions are processed correctly by sqlite3WindowRewrite(). Fix for ticket [e5504e987e419fb0]. (check-in: [a6c2147cc6] user: drh branch: early-winfunc-rewrite-dev, size: 48440) | |
2020-06-06
| ||
19:35 | [aacc5150f3] part of check-in [8583c3483c] When determining if the subquery inserted by the window-function rewriter is an aggregate query, aggregate functions that are in parameters to another window function do not count. Fix for ticket [1f6f353b684fc708] (check-in: [8583c3483c] user: drh branch: early-winfunc-rewrite-dev, size: 48142) | |
18:34 | [e71abf4c87] part of check-in [03b32be44d] In the query flattener, defer deleting content until after associated Parse object is destroyed, in case some of the deleted expressions have been collected for use by sAggInfo. (check-in: [03b32be44d] user: drh branch: early-winfunc-rewrite-dev, size: 47872) | |
14:44 | [bd7894d134] part of check-in [2cddb24e91] When rewriting the parse-tree for window functions, ensure that the inserted subqueries have an accurate SF_Aggregate bit set. This change also coincidentally fixes ticket [0899cf62f597d7e7], even thought that was not the issue we were working on at the time. (check-in: [2cddb24e91] user: drh branch: early-winfunc-rewrite-dev, size: 47604) | |
14:29 | [2063fc0819] part of check-in [c96914ea02] Fix an assert() failure that could occur if an ORDER BY expression attached to a compound query contains a subquery that (a) is itself a compound query, (b) uses window functions and (c) has an ORDER BY clause that includes another sub-query. (check-in: [c96914ea02] user: dan branch: early-winfunc-rewrite-dev, size: 47152) | |
2020-06-05
| ||
15:26 | [e5960fcb65] part of check-in [0b42a2277e] Do parse-tree transformations required for window functions prior to running aggregate function analysis. Fix for ticket [c8d3b9f0a750a529]. (check-in: [0b42a2277e] user: drh branch: early-winfunc-rewrite-dev, size: 46427) | |
14:53 | [7383659a95] part of check-in [2011e83213] Ensure that the "push-down" optimization does not push constraints down into compound queries if any of the component queries uses window functions. (check-in: [2011e83213] user: dan branch: early-winfunc-rewrite, size: 46137) | |
2020-05-24
| ||
03:38 | [502a3e72fc] part of check-in [ad7bb70af9] When rewriting a query for window functions, if the rewrite changes the depth of TK_AGG_FUNCTION nodes, be sure to adjust the Expr.op2 field appropriately. Fix for ticket [7a5279a25c57adf1] (check-in: [ad7bb70af9] user: drh branch: trunk, size: 45567) | |
2020-05-11
| ||
10:55 | [a3504d44a3] part of check-in [155e6649ef] Fix a problem handling constant integer expressions with collation sequences in PARTITION BY clauses. (check-in: [155e6649ef] user: dan branch: trunk, size: 45214) | |
2020-04-09
| ||
18:51 | [b0739f481c] part of check-in [d6fda470fe] Merge recent trunk changes into the apple-osx branch. (check-in: [d6fda470fe] user: drh branch: apple-osx, size: 43860) | |
2020-04-03
| ||
13:39 | [4aa2a388e5] part of check-in [b64674919f] Do not suppress errors when resolving references in an ORDER BY clause belonging to a compound SELECT within a view or trigger within ALTER TABLE. Fix for ticket [a10a14e9b4ba2]. Also, in the event of a semantic error in an aggregate query, early-out the resetAccumulator() function to prevent problems due to incomplete or incorrect initialization of the AggInfo object. Fix for ticket [af4556bb5c285c08]. (check-in: [b64674919f] user: drh branch: branch-3.31, size: 41914) | |
13:19 | [ec792f92e6] part of check-in [4a302b42c7] In the event of a semantic error in an aggregate query, early-out the resetAccumulator() function to prevent problems due to incomplete or incorrect initialization of the AggInfo object. Fix for ticket [af4556bb5c285c08]. (check-in: [4a302b42c7] user: drh branch: trunk, size: 43861) | |
2020-02-29
| ||
17:19 | [879a1928c9] part of check-in [1e174ed0d2] Fix a problem with window functions occuring within sub-selects that are part of an OR term in a WHERE clause of the outer SELECT. (check-in: [1e174ed0d2] user: dan branch: trunk, size: 43591) | |
2020-01-15
| ||
12:49 | [ab9c9b3b98] part of check-in [dadedf41c7] Merge all recent enhancements and fixes from trunk into the apple-osx branch. (check-in: [dadedf41c7] user: drh branch: apple-osx, size: 41641) | |
2020-01-09
| ||
20:11 | [cec56b9a0a] part of check-in [83dc55679a] Fix an assert() in window.c that could fail with some obscure SELECT statements that use window functions. Ticket [678ecf429f8d1a5f] (check-in: [83dc55679a] user: dan branch: trunk, size: 41642) | |
2020-01-03
| ||
13:55 | [b61afc46ba] part of check-in [4889cbf898] Ensure that when a Select object is reset a new, empty, SrcList is allocated. (check-in: [4889cbf898] user: dan branch: trunk, size: 41125) | |
2020-01-01
| ||
20:17 | [30f38038f2] part of check-in [ce14173252] Ensure that when code for a scalar SELECT featuring window functions is generated more than once by the planner, separate ephemeral tables are opened for each instance. (check-in: [ce14173252] user: dan branch: trunk, size: 40648) | |
2019-12-28
| ||
18:25 | [cd6e2dafaa] part of check-in [eeb76f621d] Do not attempt to flatten compound sub-queries in a FROM clause into the parent if any component of the sub-query uses a window function. (check-in: [eeb76f621d] user: dan branch: trunk, size: 40160) | |
2019-12-27
| ||
20:06 | [caf402a972] part of check-in [597896ed0a] Remove a NEVER() that is no longer true. Fix for [36ffedcb9]. (check-in: [597896ed0a] user: dan branch: trunk, size: 39783) | |
19:46 | [9b17982e6f] part of check-in [e3b5fc05c0] Fix a problem involving window function aliases being referenced from sub-selects. (check-in: [e3b5fc05c0] user: dan branch: trunk, size: 39121) | |
18:15 | [2a017e7638] part of check-in [4e6fbb1a51] Add a missing "ifcapable rtree {...}" line to the window1.test test module. (check-in: [4e6fbb1a51] user: drh branch: trunk, size: 37736) | |
16:25 | [9f5883b8f9] part of check-in [99609786f4] Fix a problem with window functions in aggregate queries that do not have GROUP BY clauses. (check-in: [99609786f4] user: dan branch: trunk, size: 37702) | |
15:31 | [f091ea2dad] part of check-in [45c64d39d5] Do not mistake constant integers in a PARTITION BY expression for references to ORDER BY style references to values returned by the SELECT statement. (check-in: [45c64d39d5] user: dan branch: trunk, size: 36738) | |
08:57 | [7619f715b5] part of check-in [1ffc045d2b] When determining if an aggregate within a sub-query should be processed as part of the sub-query or an outer query, consider any FILTER clause in the same way as the arguments to the aggregate. (check-in: [1ffc045d2b] user: dan branch: trunk, size: 35891) | |
2019-12-25
| ||
23:54 | [7968f1baa1] part of check-in [fa58aad48a] When the sqlite3WindowRewrite() routine detects and error, have it convert the SELECT statement into just "SELECT null" so that it does not leave the parse tree in a goofy state that can cause problems with subsequent code before the stack has a chance to unwind and report the error. Ticket [d87336c81c7d0873] (check-in: [fa58aad48a] user: drh branch: trunk, size: 35831) | |
2019-12-23
| ||
15:17 | [790c9f12bc] part of check-in [2f17974912] Fix a case in which SQLite could fail to identify "x BETWEEN ? AND ?" being true as implying that x is not null. Ticket [dfd66334]. (check-in: [2f17974912] user: dan branch: trunk, size: 35537) | |
14:20 | [31b56e5330] part of check-in [0b1dbd60f5] For expressions like (x, y) IN (SELECT ...) where the SELECT uses window-functions, require that all columns on the LHS be indexed before an index can be used. Fix for [d9ed4ebe]. (check-in: [0b1dbd60f5] user: dan branch: trunk, size: 35436) | |
2019-12-20
| ||
15:35 | [29efd3d6c1] part of check-in [3cc2b5709e] When computing dependencies on WHERE-clause terms, be sure to take into account the FILTER clause of aggregate functions. Problem reported by Manuel Rigger. (check-in: [3cc2b5709e] user: drh branch: trunk, size: 35216) | |
2019-12-18
| ||
09:17 | [6db2c38a08] part of check-in [519864da8b] Add a test case for fix in check-in [1ca0bd982ab1183b] (check-in: [519864da8b] user: drh branch: trunk, size: 34693) | |
2019-12-07
| ||
13:42 | [b3567fde13] part of check-in [26d991f214] Correctly deal with multi-row VALUES clauses that contain window functions. (check-in: [26d991f214] user: drh branch: trunk, size: 34223) | |
2019-12-04
| ||
01:42 | [a73b1d41e0] part of check-in [92893b7980] Fix a double-free that could occur when a component of a compound SELECT with an ORDER BY clause uses named window definitions. (check-in: [92893b7980] user: dan branch: trunk, size: 33932) | |
2019-11-23
| ||
15:10 | [027053b78d] part of check-in [57070c68bb] Avoid evaluating PARTITION BY or ORDER BY expressions multiple times for window function queries that use multiple window functions with the same window-definition. (check-in: [57070c68bb] user: dan branch: trunk, size: 33193) | |
2019-11-22
| ||
10:14 | [60ba11fb64] part of check-in [bcdd66c169] Fix a crash that could occur if a sub-select that uses both DISTINCT and window functions also used an ORDER BY that is the same as its select list. (check-in: [bcdd66c169] user: dan branch: trunk, size: 32892) | |
2019-11-16
| ||
11:33 | [e88f674b5d] part of check-in [0adb273f7e] Fix a potential NULL pointer dereference on a RENAME TABLE that references a VIEW with a logic error in a window function in the ORDER BY clause. (check-in: [0adb273f7e] user: drh branch: trunk, size: 32600) | |
2019-10-10
| ||
15:17 | [453bb9dcb1] part of check-in [ccba7202b6] Be sure to rewrite column references inside FILTER clauses and window frame definitions when flattening queries. Fix for [1079ad19]. (check-in: [ccba7202b6] user: dan branch: trunk, size: 32287) | |
2019-07-19
| ||
01:25 | [9f42ddb050] part of check-in [ce6bf395e2] Fix a new problem in the BETWEEN operator when applied to a window function. The problem was introduced yesterday by check-in [7ef7b23cbb1b9ace]. This cherry-pick also needed to remove an assert from sqliteExprDelete(). (check-in: [ce6bf395e2] user: drh branch: branch-3.29, size: 31180) | |
01:11 | [376a7c9c5b] part of check-in [47e23064ba] Fix a new problem in the BETWEEN operator when applied to a window function. The problem was introduced yesterday by check-in [7ef7b23cbb1b9ace]. (check-in: [47e23064ba] user: drh branch: trunk, size: 31303) | |
2019-07-13
| ||
17:54 | [82202e1396] part of check-in [8c80e81d01] Fix a typo in test file window1.test. (check-in: [8c80e81d01] user: dan branch: trunk, size: 30585) | |
17:45 | [18ec9bbd5b] part of check-in [871796bb19] Fix error handling for the case where a window function is passed the wrong number of arguments. (check-in: [871796bb19] user: dan branch: trunk, size: 30583) | |
2019-04-03
| ||
16:27 | [8d453bfaa3] part of check-in [39225cc775] Fix a couple of problems with "RANGE BETWEEN <expr> PRECEDING AND <expr> PRECEDING" frames. (check-in: [39225cc775] user: dan branch: trunk, size: 30462) | |
2019-04-01
| ||
18:43 | [71bb9bfb70] part of check-in [b36813d646] Add a test case to cover a missed VDBE branch generated by window.c. (check-in: [b36813d646] user: dan branch: trunk, size: 28357) | |
2019-03-22
| ||
13:56 | [7484bf9a2e] part of check-in [9aca86f983] 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. (check-in: [9aca86f983] user: dan branch: window-functions, size: 27970) | |
2019-03-21
| ||
13:51 | [c4ff89d6b2] part of check-in [c7b336181a] Remove assert() statements based on the counter-factual proposition that 0 is not a valid cursor number. (check-in: [c7b336181a] user: dan branch: window-functions, size: 27191) | |
2019-03-19
| ||
17:45 | [c7c274d5af] part of check-in [e195948a68] Add tests to ensure that the window functions implementation is not generating code for unnecessary sorts. (check-in: [e195948a68] user: dan branch: window-functions, size: 27077) | |
11:56 | [320d881253] part of check-in [c02f77b1b4] 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 branch: window-functions, size: 25632) | |
06:40 | [1e0118726f] part of check-in [a6d61dfd47] Ensure that all the new window-function keywords can still be used as SQL identifiers. (check-in: [a6d61dfd47] user: dan branch: window-functions, size: 24793) | |
2019-03-16
| ||
20:29 | [6c7bbed965] part of check-in [cebe09e11c] Fix problems with RANGE windows and string, blob and NULL values. (check-in: [cebe09e11c] user: dan branch: window-functions, size: 24358) | |
2019-03-13
| ||
17:31 | [d690a34fc6] part of check-in [0b904517bd] Merge latest trunk changes into this branch. (check-in: [0b904517bd] user: dan branch: window-functions, size: 22011) | |
2019-03-12
| ||
09:49 | [53db04133c] part of check-in [0524aaaf45] 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: [0524aaaf45] user: dan branch: trunk, size: 18997) | |
2019-03-04
| ||
21:08 | [5d9b3cfc4b] part of check-in [9b4d561f68] Merge trunk changes into this branch. (check-in: [9b4d561f68] user: dan branch: window-functions, size: 21300) | |
2019-02-22
| ||
19:24 | [d141eba02e] part of check-in [579b66eaa0] Internally, remove all references to a Window object that belongs to an expression in an ORDER BY clause if that expression is converted to an alias of a result-set expression. Fix for [4feb3159c6]. (check-in: [579b66eaa0] user: dan branch: trunk, size: 18286) | |
2019-02-16
| ||
17:27 | [4d98700cf2] part of check-in [c155125fd5] Add support for chaining of WINDOW definitions. (check-in: [c155125fd5] user: dan branch: window-functions, size: 20829) | |
2019-01-26
| ||
16:34 | [8910b6d158] part of check-in [d536be698d] Roll back the transaction if a write statement fails with OE_Abort but there is no open statement transaction. (check-in: [d536be698d] user: dan branch: rollback-abort, size: 18782) | |
2019-01-23
| ||
16:59 | [2798c8249e] part of check-in [0387cb3add] Fix problems with sub-selects in WINDOW definitions. Also rename-column operations when the column being renamed appears in a WINDOW definition that is part of a VIEW or TRIGGER. (check-in: [0387cb3add] user: dan branch: trunk, size: 17815) | |
2019-01-01
| ||
18:00 | [9003bb7596] part of check-in [5c188361a9] Ensure that when a new cursor is opened by OP_OpenDup, any existing cursor with the same id opened by a previous OP_OpenDup is closed first. (check-in: [5c188361a9] user: dan branch: trunk, size: 17311) | |
2018-12-31
| ||
16:36 | [148552f633] part of check-in [4678cb1044] Fix the OP_OpenEphemeral opcode in the bytecode engine so that if it is called a second or subsequent time, it merely clears the existing table rather than creating a new one. Proposed fix for ticket [d0866b26f83e9c55e30de0821f5d]. (check-in: [4678cb1044] user: drh branch: trunk, size: 17199) | |
2018-12-22
| ||
15:46 | [a96a80bd6c] part of check-in [ad70f03ced] Remove unnecessary whitespace from testcase result strings. (check-in: [ad70f03ced] user: drh branch: trunk, size: 16107) | |
2018-12-06
| ||
19:56 | [1003e19beb] part of check-in [a9a3b53264] New test case that still hits an assertion fault, just to prove that the previous checkin merely made the problem more obscure and did not completely fix it. (check-in: [a9a3b53264] user: drh branch: ticket-f09fcd17810f, size: 16108) | |
19:15 | [d55c41a0b7] part of check-in [f1b18d44ff] Simplify the query flattener so that it does not duplicate the WHERE clause of subquery that is being incorporated into the outer query - copies it directly. This is more efficient. And it also fixes the specific test case show for ticket [f09fcd17810f65f71789525] but it does not resolve the more general problem that sqlite3ExprDup() does not correctly duplicate expressions that contain subqueries with window functions. (check-in: [f1b18d44ff] user: drh branch: ticket-f09fcd17810f, size: 15619) | |
2018-10-23
| ||
13:48 | [02e481ac48] part of check-in [059ff53a46] Fix a problem with using window functions in compound (UNION, INTERSECT etc.) queries. (check-in: [059ff53a46] user: dan branch: trunk, size: 15324) | |
2018-09-17
| ||
15:19 | [474bef1a6a] part of check-in [c6c9585f29] Disable the ORDER BY LIMIT optimization in queries using window functions. This fixes a problem that was introduced by check-in [206720129ed2fa8875a286] which attempted to fix ticket [9936b2fa443fec03ff25f9]. This changes is a fix for the follow-in tocket [510cde277783b5fb5de628]. (check-in: [c6c9585f29] user: drh branch: trunk, size: 14338) | |
2018-06-25
| ||
11:42 | [7cb260079c] part of check-in [e954145a3a] Fix another problem that could cause a crash when a window function was used in a view. (check-in: [e954145a3a] user: dan branch: exp-window-functions, size: 13582) | |
2018-06-23
| ||
19:29 | [0e0867fd8d] part of check-in [3e23cfc813] Fix problems with using window-functions in correlated sub-queries. (check-in: [3e23cfc813] user: dan branch: exp-window-functions, size: 12931) | |
16:26 | [a28ea12169] part of check-in [c1abd2dda4] Fix a problem with using LIMIT in window-function queries. (check-in: [c1abd2dda4] user: dan branch: exp-window-functions, size: 11400) | |
07:59 | [ebb246c830] part of check-in [11d733396f] Fix a problem with using a window-function SELECT as a FROM clause sub-query in some circumstances. (check-in: [11d733396f] user: dan branch: exp-window-functions, size: 10548) | |
2018-06-22
| ||
20:51 | [6ec7d8927a] part of check-in [5f04b01646] Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. (check-in: [5f04b01646] user: dan branch: exp-window-functions, size: 9683) | |
2018-06-19
| ||
18:11 | [c4c138b120] part of check-in [f4b1b6f85b] 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: [f4b1b6f85b] user: dan branch: exp-window-functions, size: 9634) | |
17:13 | [8908f00013] part of check-in [801074ce63] Fix a problem with using min() or max() as a window function. (check-in: [801074ce63] user: dan branch: exp-window-functions, size: 9166) | |
2018-06-18
| ||
20:34 | [f6624f9790] part of check-in [943bccd2a6] Fix problems with using window functions in CREATE VIEW statements. (check-in: [943bccd2a6] user: dan branch: exp-window-functions, size: 8135) | |
16:55 | [af17e84722] part of check-in [da03fb4318] Add new API function sqlite3_create_window_function(), for creating new aggregate window functions. (check-in: [da03fb4318] user: dan branch: exp-window-functions, size: 7186) | |
2018-06-15
| ||
20:46 | [3398c54113] part of check-in [ac251f7260] Add extra OOM test. (check-in: [ac251f7260] user: dan branch: exp-window-functions, size: 6988) | |
16:10 | [fb076d9229] part of check-in [3839fb18f9] Fix a bug in the lead() and lag() window functions causing them to fail when used in queries featuring multiple window functions. (check-in: [3839fb18f9] user: dan branch: exp-window-functions, size: 6903) | |
2018-06-14
| ||
19:06 | [68607fd4cf] part of check-in [43eb1e75a4] 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: [43eb1e75a4] user: dan branch: exp-window-functions, size: 6678) | |
2018-06-11
| ||
18:16 | [94c626fe8d] part of check-in [b6d9c7eda8] Fix handling of window frames containing negative number of rows. e.g. "ROWS x PRECEDING AND y PRECEDING" where (x<y). (check-in: [b6d9c7eda8] user: dan branch: exp-window-functions, size: 6563) | |
2018-06-09
| ||
17:43 | [6c648f3fa7] part of check-in [ceaf798ea0] Add support for FILTER clause on aggregate window functions. (check-in: [ceaf798ea0] user: dan branch: exp-window-functions, size: 5431) | |
2018-06-08
| ||
16:11 | [4561399c91] part of check-in [236cb75bd1] Do not flatten sub-queries that contain window functions. (check-in: [236cb75bd1] user: dan branch: exp-window-functions, size: 5252) | |
2018-06-04
| ||
18:55 | [905fe0842e] part of check-in [3f093f608c] Add implementation of window function ntile(). (check-in: [3f093f608c] user: dan branch: exp-window-functions, size: 4739) | |
2018-05-19
| ||
14:15 | [5705337783] part of check-in [19c2e4b2f1] Fix minor problems on this branch. (check-in: [19c2e4b2f1] user: dan branch: exp-window-functions, size: 4273) | |
2018-05-17
| ||
19:24 | [5278e1578b] part of check-in [c9f0f14094] 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: [c9f0f14094] user: dan branch: exp-window-functions, size: 4016) | |
14:26 | [c088fff1b9] part of check-in [35af0b750e] Handle multiple window-functions in a single query. (check-in: [35af0b750e] user: dan branch: exp-window-functions, size: 3520) | |
2018-05-16
| ||
20:58 | Added: [d1766b0cba] part of check-in [3781e52085] Start of experimental implementation of SQL window functions. Does not yet work. (check-in: [3781e52085] user: dan branch: exp-window-functions, size: 3000) | |