SQLite

All files named ”test/window4.tcl”
Login

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

History for test/window4.tcl

2020-07-29
16:18
[8ced700e72] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 9895)
2020-03-16
18:52
[6f85307eb6] part of check-in [38e3dd389d] Fix handling of window functions in aggregate queries that have no GROUP BY clause. Also remove a faulty assert causing the error reported in [618156e3]. (check-in: [38e3dd389d] user: dan branch: trunk, size: 9896)
2019-08-10
14:35
[d732df0e81] part of check-in [3c690b2b05] Add extra test cases related to the previous commit. (check-in: [3c690b2b05] user: dan branch: trunk, size: 9616)
2019-03-06
17:12
[5fbaab4896] part of check-in [e8eee566df] Improvements to the way built-in window functions are handled. (check-in: [e8eee566df] user: dan branch: window-functions, size: 9240)
2018-09-24
14:51
[511425f6b0] part of check-in [507d892c3a] Fix a problem with views that use window functions as part of complex expressions. (check-in: [507d892c3a] user: dan branch: trunk, size: 9239)
2018-07-09
13:31
[871364059b] part of check-in [1a06e57a0b] Throw an error if the second argument passed to nth_value() is not a positive integer. (check-in: [1a06e57a0b] user: dan branch: trunk, size: 8695)
2018-07-07
17:30
[9491acccf7] part of check-in [b76f35b092] Fix a problem with the handling of NULL values in the min() window function. (check-in: [b76f35b092] user: dan branch: trunk, size: 8514)
2018-07-06
13:25
[a7f0e51460] part of check-in [443f0c286f] Remove some bad assert() statements from the implementations of window functions percent_rank() and cume_dist(). (check-in: [443f0c286f] user: dan branch: trunk, size: 8199)
2018-06-25
11:42
[7cec7e578a] 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: 8066)
2018-06-22
20:51
[e52914d755] 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: 7897)
2018-06-21
19:20
[1ac3c81a21] part of check-in [b84fbf16ea] Fix a problem with handling single row partitions in the percent_rank() window function. (check-in: [b84fbf16ea] user: dan branch: exp-window-functions, size: 7875)
2018-06-15
19:01
[ce0c14185b] part of check-in [fadd4dc119] Fix another problem in lead()/lag(). And some errors that could occur following OOM faults. (check-in: [fadd4dc119] user: dan branch: exp-window-functions, size: 7504)
16:10
[edacba69c2] 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: 6704)
2018-06-14
20:52
[9a04d14649] part of check-in [567e09ef2a] Fix a problem with handling of statements containing two or more different windows. (check-in: [567e09ef2a] user: dan branch: exp-window-functions, size: 5923)
19:06
[3388b29669] 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: 5558)
2018-06-13
20:29
[09167855f6] part of check-in [c34f31dbd7] Fix problems with "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frames. (check-in: [c34f31dbd7] user: dan branch: exp-window-functions, size: 4296)
2018-06-12
20:53
[a77a7ab3c6] part of check-in [6413e38a17] Fix another issue to do with window-functions in aggregate queries. (check-in: [6413e38a17] user: dan branch: exp-window-functions, size: 4172)
18:40
[e64db87bac] part of check-in [fe7081e095] Fix some problems with using window-functions in aggregate queries. (check-in: [fe7081e095] user: dan branch: exp-window-functions, size: 4008)
2018-06-11
18:16
[bfea0c4f65] 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: 3416)
2018-06-09
17:43
[e459eb2fe5] part of check-in [ceaf798ea0] Add support for FILTER clause on aggregate window functions. (check-in: [ceaf798ea0] user: dan branch: exp-window-functions, size: 2748)
2018-06-08
20:58
[2da10ad7a6] part of check-in [19c983b511] Add support for the WINDOW clause. (check-in: [19c983b511] user: dan branch: exp-window-functions, size: 2640)
11:45
[9e5698ffb7] part of check-in [89bbc9ba8f] Fixes to allow group_concat() to be used as a window function. (check-in: [89bbc9ba8f] user: dan branch: exp-window-functions, size: 2482)
2018-06-07
20:08
[46f5d6adb4] part of check-in [ef34207073] Add window functions lag() and lead(). (check-in: [ef34207073] user: dan branch: exp-window-functions, size: 2347)
2018-06-06
20:51
[23918c0c0e] part of check-in [eb1fb420ac] Add implementation of nth_value() window function. (check-in: [eb1fb420ac] user: dan branch: exp-window-functions, size: 1908)
2018-06-04
18:55
Added: [3f81bec5bc] part of check-in [3f093f608c] Add implementation of window function ntile(). (check-in: [3f093f608c] user: dan branch: exp-window-functions, size: 848)