/ History for test/window2.tcl
Login

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

History for test/window2.tcl

2019-12-27
15:31
[492c125f] part of check-in [45c64d39] Do not mistake constant integers in a PARTITION BY expression for references to ORDER BY style references to values returned by the SELECT statement. (check-in: [45c64d39] user: dan branch: trunk, size: 11406)
2019-12-22
17:32
[114b217d] part of check-in [8c856404] Ensure sqlite3WindowRewrite() is called on a SELECT statement before any terms aremoved from it as part of IN() clause processing. Fix for [f00d096ca]. (check-in: [8c856404] user: dan branch: trunk, size: 10872)
2019-09-26
15:53
[66db96fd] part of check-in [1cc6cf64] Fix a window-functions problem that could occur if an ORDER BY clause contains an alias for a window-function that is not a top-level expression. (check-in: [1cc6cf64] user: dan branch: trunk, size: 10550)
2019-07-05
19:10
[a44834af] part of check-in [7a1e30a1] Another very small performance improvement. (check-in: [7a1e30a1] user: dan branch: filter-clause, size: 10205)
17:38
[a0de5e1e] part of check-in [81eed055] Minor tweak to patch on this branch to reclaim some cycles. (check-in: [81eed055] user: dan branch: filter-clause, size: 10125)
2019-05-10
14:26
[0c2918ef] part of check-in [7e4809ea] Treat integer values in window definition ORDER BY clauses as constants, not as references to another expression. (check-in: [7e4809ea] user: dan branch: trunk, size: 10058)
2018-06-22
20:51
[9bfa842d] part of check-in [5f04b016] Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. (check-in: [5f04b016] user: dan branch: exp-window-functions, size: 9915)
2018-05-30
20:44
[0983de5e] part of check-in [c16125a8] Allow min() and max() to be used as window functions. (check-in: [c16125a8] user: dan branch: exp-window-functions, size: 9892)
2018-05-28
18:30
[4e051199] part of check-in [e74c6e91] Further window frame tests and fixes. (check-in: [e74c6e91] user: dan branch: exp-window-functions, size: 12112)
2018-05-26
21:17
[fab2f4f2] part of check-in [2c85668a] More fixes for different window frame types. (check-in: [2c85668a] user: dan branch: exp-window-functions, size: 10284)
2018-05-25
20:30
[4d0fd12b] part of check-in [b4e9c686] Fix "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frame processing. (check-in: [b4e9c686] user: dan branch: exp-window-functions, size: 7727)
09:29
[fd079901] part of check-in [5ac44872] Fixes for "ROWS BETWEEN <expr> FOLLOWING AND <expr> FOLLOWING" and "ROWS BETWEEN <expr> FOLLOWING AND UNBOUNDED FOLLOWING" (check-in: [5ac44872] user: dan branch: exp-window-functions, size: 6627)
2018-05-24
21:10
[6df00293] part of check-in [7b709a98] Allow "<expr> PRECEDING" to be used to specify the end of a window frame. (check-in: [7b709a98] user: dan branch: exp-window-functions, size: 6047)
17:49
[798cfc8b] part of check-in [ec7b648c] Support other frame types that use "<expr> PRECEDING" or "<expr> FOLLOWING" as start or end conditions. (check-in: [ec7b648c] user: dan branch: exp-window-functions, size: 5353)
2018-05-23
20:55
[29e9bb16] part of check-in [3a203660] Add support for "ROWS BETWEEN <expr> PRECEDING AND <expr> FOLLOWING" window frames. (check-in: [3a203660] user: dan branch: exp-window-functions, size: 4716)
2018-05-22
20:35
[7e0b6929] part of check-in [16168146] Add comments to window.c describing how other window frames will be implemented. (check-in: [16168146] user: dan branch: exp-window-functions, size: 4057)
2018-05-21
19:45
[19a7d45c] part of check-in [bc4b81d6] Begin adding support for more esoteric window frames. (check-in: [bc4b81d6] user: dan branch: exp-window-functions, size: 3817)
2018-05-19
14:15
[f9df2fde] part of check-in [19c2e4b2] Fix minor problems on this branch. (check-in: [19c2e4b2] user: dan branch: exp-window-functions, size: 3110) Added