Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/window1.test
|
2019-12-07
| ||
| 13:42 | Correctly deal with multi-row VALUES clauses that contain window functions. file: [b3567fde] check-in: [26d991f2] user: drh branch: trunk, size: 34223 | |
|
2019-12-04
| ||
| 01:42 | Fix a double-free that could occur when a component of a compound SELECT with an ORDER BY clause uses named window definitions. file: [a73b1d41] check-in: [92893b79] user: dan branch: trunk, size: 33932 | |
|
2019-11-23
| ||
| 15:10 | Avoid evaluating PARTITION BY or ORDER BY expressions multiple times for window function queries that use multiple window functions with the same window-definition. file: [027053b7] check-in: [57070c68] user: dan branch: trunk, size: 33193 | |
|
2019-11-22
| ||
| 10:14 | 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. file: [60ba11fb] check-in: [bcdd66c1] user: dan branch: trunk, size: 32892 | |
|
2019-11-16
| ||
| 11:33 | 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. file: [e88f674b] check-in: [0adb273f] user: drh branch: trunk, size: 32600 | |
|
2019-10-10
| ||
| 15:17 | Be sure to rewrite column references inside FILTER clauses and window frame definitions when flattening queries. Fix for [1079ad19]. file: [453bb9dc] check-in: [ccba7202] user: dan branch: trunk, size: 32287 | |
|
2019-07-19
| ||
| 01:25 | 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(). file: [9f42ddb0] check-in: [ce6bf395] user: drh branch: branch-3.29, size: 31180 | |
| 01:11 | Fix a new problem in the BETWEEN operator when applied to a window function. The problem was introduced yesterday by check-in [7ef7b23cbb1b9ace]. file: [376a7c9c] check-in: [47e23064] user: drh branch: trunk, size: 31303 | |
|
2019-07-13
| ||
| 17:54 | Fix a typo in test file window1.test. file: [82202e13] check-in: [8c80e81d] user: dan branch: trunk, size: 30585 | |
| 17:45 | Fix error handling for the case where a window function is passed the wrong number of arguments. file: [18ec9bbd] check-in: [871796bb] user: dan branch: trunk, size: 30583 | |
|
2019-04-03
| ||
| 16:27 | Fix a couple of problems with "RANGE BETWEEN <expr> PRECEDING AND <expr> PRECEDING" frames. file: [8d453bfa] check-in: [39225cc7] user: dan branch: trunk, size: 30462 | |
|
2019-04-01
| ||
| 18:43 | Add a test case to cover a missed VDBE branch generated by window.c. file: [71bb9bfb] check-in: [b36813d6] user: dan branch: trunk, size: 28357 | |
|
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. file: [7484bf9a] check-in: [9aca86f9] user: dan branch: window-functions, size: 27970 | |
|
2019-03-21
| ||
| 13:51 | Remove assert() statements based on the counter-factual proposition that 0 is not a valid cursor number. file: [c4ff89d6] check-in: [c7b33618] user: dan branch: window-functions, size: 27191 | |
|
2019-03-19
| ||
| 17:45 | Add tests to ensure that the window functions implementation is not generating code for unnecessary sorts. file: [c7c274d5] check-in: [e195948a] user: dan branch: window-functions, size: 27077 | |
| 11:56 | Revert the OP_MustBeInt opcode implementation on this branch so that it again matches trunk. The extra functionality is no longer required. file: [320d8812] check-in: [c02f77b1] user: dan branch: window-functions, size: 25632 | |
| 06:40 | Ensure that all the new window-function keywords can still be used as SQL identifiers. file: [1e011872] check-in: [a6d61dfd] user: dan branch: window-functions, size: 24793 | |
|
2019-03-16
| ||
| 20:29 | Fix problems with RANGE windows and string, blob and NULL values. file: [6c7bbed9] check-in: [cebe09e1] user: dan branch: window-functions, size: 24358 | |
|
2019-03-13
| ||
| 17:31 | Merge latest trunk changes into this branch. file: [d690a34f] check-in: [0b904517] user: dan branch: window-functions, size: 22011 | |
|
2019-03-12
| ||
| 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. file: [53db0413] check-in: [0524aaaf] user: dan branch: trunk, size: 18997 | |
|
2019-03-04
| ||
| 21:08 | Merge trunk changes into this branch. file: [5d9b3cfc] check-in: [9b4d561f] user: dan branch: window-functions, size: 21300 | |
|
2019-02-22
| ||
| 19:24 | 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]. file: [d141eba0] check-in: [579b66ea] user: dan branch: trunk, size: 18286 | |
|
2019-02-16
| ||
| 17:27 | Add support for chaining of WINDOW definitions. file: [4d98700c] check-in: [c155125f] user: dan branch: window-functions, size: 20829 | |
|
2019-01-26
| ||
| 16:34 | Roll back the transaction if a write statement fails with OE_Abort but there is no open statement transaction. file: [8910b6d1] check-in: [d536be69] user: dan branch: rollback-abort, size: 18782 | |
|
2019-01-23
| ||
| 16:59 | 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. file: [2798c824] check-in: [0387cb3a] user: dan branch: trunk, size: 17815 | |
|
2019-01-01
| ||
| 18:00 | 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. file: [9003bb75] check-in: [5c188361] user: dan branch: trunk, size: 17311 | |
|
2018-12-31
| ||
| 16:36 | 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]. file: [148552f6] check-in: [4678cb10] user: drh branch: trunk, size: 17199 | |
|
2018-12-22
| ||
| 15:46 | Remove unnecessary whitespace from testcase result strings. file: [a96a80bd] check-in: [ad70f03c] user: drh branch: trunk, size: 16107 | |
|
2018-12-06
| ||
| 19:56 | 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. file: [1003e19b] check-in: [a9a3b532] user: drh branch: ticket-f09fcd17810f, size: 16108 | |
| 19:15 | 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. file: [d55c41a0] check-in: [f1b18d44] user: drh branch: ticket-f09fcd17810f, size: 15619 | |
|
2018-10-23
| ||
| 13:48 | Fix a problem with using window functions in compound (UNION, INTERSECT etc.) queries. file: [02e481ac] check-in: [059ff53a] user: dan branch: trunk, size: 15324 | |
|
2018-09-17
| ||
| 15:19 | 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]. file: [474bef1a] check-in: [c6c9585f] user: drh branch: trunk, size: 14338 | |
|
2018-06-25
| ||
| 11:42 | Fix another problem that could cause a crash when a window function was used in a view. file: [7cb26007] check-in: [e954145a] user: dan branch: exp-window-functions, size: 13582 | |
|
2018-06-23
| ||
| 19:29 | Fix problems with using window-functions in correlated sub-queries. file: [0e0867fd] check-in: [3e23cfc8] user: dan branch: exp-window-functions, size: 12931 | |
| 16:26 | Fix a problem with using LIMIT in window-function queries. file: [a28ea121] check-in: [c1abd2dd] user: dan branch: exp-window-functions, size: 11400 | |
| 07:59 | Fix a problem with using a window-function SELECT as a FROM clause sub-query in some circumstances. file: [ebb246c8] check-in: [11d73339] user: dan branch: exp-window-functions, size: 10548 | |
|
2018-06-22
| ||
| 20:51 | Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. file: [6ec7d892] check-in: [5f04b016] user: dan branch: exp-window-functions, size: 9683 | |
|
2018-06-19
| ||
| 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. file: [c4c138b1] check-in: [f4b1b6f8] user: dan branch: exp-window-functions, size: 9634 | |
| 17:13 | Fix a problem with using min() or max() as a window function. file: [8908f000] check-in: [801074ce] user: dan branch: exp-window-functions, size: 9166 | |
|
2018-06-18
| ||
| 20:34 | Fix problems with using window functions in CREATE VIEW statements. file: [f6624f97] check-in: [943bccd2] user: dan branch: exp-window-functions, size: 8135 | |
| 16:55 | Add new API function sqlite3_create_window_function(), for creating new aggregate window functions. file: [af17e847] check-in: [da03fb43] user: dan branch: exp-window-functions, size: 7186 | |
|
2018-06-15
| ||
| 20:46 | Add extra OOM test. file: [3398c541] check-in: [ac251f72] user: dan branch: exp-window-functions, size: 6988 | |
| 16:10 | Fix a bug in the lead() and lag() window functions causing them to fail when used in queries featuring multiple window functions. file: [fb076d92] check-in: [3839fb18] user: dan branch: exp-window-functions, size: 6903 | |
|
2018-06-14
| ||
| 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". file: [68607fd4] check-in: [43eb1e75] user: dan branch: exp-window-functions, size: 6678 | |
|
2018-06-11
| ||
| 18:16 | Fix handling of window frames containing negative number of rows. e.g. "ROWS x PRECEDING AND y PRECEDING" where (x<y). file: [94c626fe] check-in: [b6d9c7ed] user: dan branch: exp-window-functions, size: 6563 | |
|
2018-06-09
| ||
| 17:43 | Add support for FILTER clause on aggregate window functions. file: [6c648f3f] check-in: [ceaf798e] user: dan branch: exp-window-functions, size: 5431 | |
|
2018-06-08
| ||
| 16:11 | Do not flatten sub-queries that contain window functions. file: [4561399c] check-in: [236cb75b] user: dan branch: exp-window-functions, size: 5252 | |
|
2018-06-04
| ||
| 18:55 | Add implementation of window function ntile(). file: [905fe084] check-in: [3f093f60] user: dan branch: exp-window-functions, size: 4739 | |
|
2018-05-19
| ||
| 14:15 | Fix minor problems on this branch. file: [57053377] check-in: [19c2e4b2] user: dan branch: exp-window-functions, size: 4273 | |
|
2018-05-17
| ||
| 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. file: [5278e157] check-in: [c9f0f140] user: dan branch: exp-window-functions, size: 4016 | |
| 14:26 | Handle multiple window-functions in a single query. file: [c088fff1] check-in: [35af0b75] user: dan branch: exp-window-functions, size: 3520 | |
|
2018-05-16
| ||
| 20:58 | Start of experimental implementation of SQL window functions. Does not yet work. file: [d1766b0c] check-in: [3781e520] user: dan branch: exp-window-functions, size: 3000 Added | |