/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

30 check-ins using file src/btree.h version 7b557914

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)