/ File History
Login

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