SQLite

All files named ”test/window2.test”
Login

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

History for test/window2.test

2019-12-27
15:31
[e466a88bd6] part of check-in [45c64d39d5] 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: [45c64d39d5] user: dan branch: trunk, size: 47884)
2019-12-22
17:32
[dea2ffecb7] part of check-in [8c856404b4] 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: [8c856404b4] user: dan branch: trunk, size: 47192)
2019-09-26
15:53
[af2a001ded] part of check-in [1cc6cf6407] 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: [1cc6cf6407] user: dan branch: trunk, size: 46782)
2019-07-05
19:10
[2f3ae63e17] part of check-in [7a1e30a17f] Another very small performance improvement. (check-in: [7a1e30a17f] user: dan branch: filter-clause, size: 46008)
17:38
[d7236a84c9] part of check-in [81eed055de] Minor tweak to patch on this branch to reclaim some cycles. (check-in: [81eed055de] user: dan branch: filter-clause, size: 45920)
2019-05-10
14:26
[96ef949f01] part of check-in [7e4809eadf] Treat integer values in window definition ORDER BY clauses as constants, not as references to another expression. (check-in: [7e4809eadf] user: dan branch: trunk, size: 45826)
2018-06-22
20:51
[8e6d2a1b9f] 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: 45280)
2018-05-28
18:30
[79747b2edd] part of check-in [e74c6e9185] Further window frame tests and fixes. (check-in: [e74c6e9185] user: dan branch: exp-window-functions, size: 45233)
2018-05-26
21:17
[8fad10a743] part of check-in [2c85668a0f] More fixes for different window frame types. (check-in: [2c85668a0f] user: dan branch: exp-window-functions, size: 17493)
2018-05-25
20:30
[47bb1eb149] part of check-in [b4e9c68669] Fix "RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING" window frame processing. (check-in: [b4e9c68669] user: dan branch: exp-window-functions, size: 6735)
09:29
[4f5efb5971] part of check-in [5ac44872fd] Fixes for "ROWS BETWEEN <expr> FOLLOWING AND <expr> FOLLOWING" and "ROWS BETWEEN <expr> FOLLOWING AND UNBOUNDED FOLLOWING" (check-in: [5ac44872fd] user: dan branch: exp-window-functions, size: 5298)
2018-05-24
21:10
[ee542c30bf] part of check-in [7b709a989c] Allow "<expr> PRECEDING" to be used to specify the end of a window frame. (check-in: [7b709a989c] user: dan branch: exp-window-functions, size: 5124)
17:49
[ca65b0818d] part of check-in [ec7b648c7f] Support other frame types that use "<expr> PRECEDING" or "<expr> FOLLOWING" as start or end conditions. (check-in: [ec7b648c7f] user: dan branch: exp-window-functions, size: 4220)
2018-05-23
20:55
[f580e1cc96] part of check-in [3a203660f1] Add support for "ROWS BETWEEN <expr> PRECEDING AND <expr> FOLLOWING" window frames. (check-in: [3a203660f1] user: dan branch: exp-window-functions, size: 3627)
2018-05-22
20:35
[e1453371b6] part of check-in [16168146b2] Add comments to window.c describing how other window frames will be implemented. (check-in: [16168146b2] user: dan branch: exp-window-functions, size: 2363)
2018-05-21
19:45
[23daf25264] part of check-in [bc4b81d60d] Begin adding support for more esoteric window frames. (check-in: [bc4b81d60d] user: dan branch: exp-window-functions, size: 2041)
2018-05-19
14:15
Added: [57c0500f98] part of check-in [19c2e4b2f1] Fix minor problems on this branch. (check-in: [19c2e4b2f1] user: dan branch: exp-window-functions, size: 1385)