Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
41 check-ins using file test/window2.tcl version 0983de5e
2018-06-22
| ||
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) | |
17:45 | Add support for window function first_value(). (check-in: 060b2640 user: dan tags: exp-window-functions) | |
15:54 | Fix problems with the nth_value() function. (check-in: 63002b9a user: dan tags: exp-window-functions) | |
2018-06-06
| ||
20:51 | Add implementation of nth_value() window function. (check-in: eb1fb420 user: dan tags: exp-window-functions) | |
2018-06-05
| ||
16:16 | Add implementation of last_value() window function. (check-in: 2493ce1a user: dan tags: exp-window-functions) | |
2018-06-04
| ||
18:55 | Add implementation of window function ntile(). (check-in: 3f093f60 user: dan tags: exp-window-functions) | |
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) | |
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) | |
2018-05-30
| ||
20:44 | Allow min() and max() to be used as window functions. (check-in: c16125a8 user: dan tags: exp-window-functions) | |