SQLite

All files named ”test/window2.tcl”
Login

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

History for test/window2.tcl

2020-07-29
16:18
[5018560b26] 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: 11404)
2019-12-27
15:31
[492c125fa5] 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: 11406)
2019-12-22
17:32
[114b217d4f] 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: 10872)
2019-09-26
15:53
[66db96fd9f] 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: 10550)
2019-07-05
19:10
[a44834af62] part of check-in [7a1e30a17f] Another very small performance improvement. (check-in: [7a1e30a17f] user: dan branch: filter-clause, size: 10205)
17:38
[a0de5e1e50] 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: 10125)
2019-05-10
14:26
[0c2918ef2a] 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: 10058)
2018-06-22
20:51
[9bfa842d8a] 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: 9915)
2018-05-30
20:44
[0983de5ead] part of check-in [c16125a884] Allow min() and max() to be used as window functions. (check-in: [c16125a884] user: dan branch: exp-window-functions, size: 9892)
2018-05-28
18:30
[4e05119968] part of check-in [e74c6e9185] Further window frame tests and fixes. (check-in: [e74c6e9185] user: dan branch: exp-window-functions, size: 12112)
2018-05-26
21:17
[fab2f4f27d] part of check-in [2c85668a0f] More fixes for different window frame types. (check-in: [2c85668a0f] user: dan branch: exp-window-functions, size: 10284)
2018-05-25
20:30
[4d0fd12b30] 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: 7727)
09:29
[fd079901ac] 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: 6627)
2018-05-24
21:10
[6df00293e3] 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: 6047)
17:49
[798cfc8bef] 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: 5353)
2018-05-23
20:55
[29e9bb16a5] 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: 4716)
2018-05-22
20:35
[7e0b692974] 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: 4057)
2018-05-21
19:45
[19a7d45c45] part of check-in [bc4b81d60d] Begin adding support for more esoteric window frames. (check-in: [bc4b81d60d] user: dan branch: exp-window-functions, size: 3817)
2018-05-19
14:15
Added: [f9df2fded8] part of check-in [19c2e4b2f1] Fix minor problems on this branch. (check-in: [19c2e4b2f1] user: dan branch: exp-window-functions, size: 3110)