Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix minor problems on this branch. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | exp-window-functions |
Files: | files | file ages | folders |
SHA3-256: |
19c2e4b2f164521eab84cb0a0e12984b |
User & Date: | dan 2018-05-19 14:15:29.031 |
Context
2018-05-21
| ||
19:45 | Begin adding support for more esoteric window frames. (check-in: bc4b81d60d user: dan tags: exp-window-functions) | |
2018-05-19
| ||
14:15 | Fix minor problems on this branch. (check-in: 19c2e4b2f1 user: dan tags: exp-window-functions) | |
2018-05-17
| ||
19:24 | Evaluate multiple window functions in a single pass if they use the same window definition. Add xValue callbacks for other built-in aggregate functions. (check-in: c9f0f14094 user: dan tags: exp-window-functions) | |
Changes
Changes to src/expr.c.
︙ | |||
3827 3828 3829 3830 3831 3832 3833 | 3827 3828 3829 3830 3831 3832 3833 3834 3835 3836 3837 3838 3839 3840 3841 | - + | zId = pExpr->u.zToken; pDef = sqlite3FindFunction(db, zId, nFarg, enc, 0); #ifdef SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION if( pDef==0 && pParse->explain ){ pDef = sqlite3FindFunction(db, "unknown", nFarg, enc, 0); } #endif |
︙ |
Changes to src/parse.y.
︙ | |||
1009 1010 1011 1012 1013 1014 1015 | 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 | - + + | } A = sqlite3ExprFunction(pParse, Y, &X); sqlite3WindowAttach(pParse, A, Z); if( D==SF_Distinct && A ){ A->flags |= EP_Distinct; } } |
︙ |
Changes to src/select.c.
︙ | |||
4681 4682 4683 4684 4685 4686 4687 | 4681 4682 4683 4684 4685 4686 4687 4688 4689 4690 4691 4692 4693 4694 | - - - - - - - - - - - - - - - | #ifndef SQLITE_OMIT_SUBQUERY Select *pSel = pFrom->pSelect; /* A sub-query in the FROM clause of a SELECT */ assert( pSel!=0 ); assert( pFrom->pTab==0 ); if( sqlite3WalkSelect(pWalker, pSel) ) return WRC_Abort; if( selectExpandSubquery(pParse, pFrom) ) return WRC_Abort; |
︙ |
Changes to test/permutations.test.
︙ | |||
163 164 165 166 167 168 169 | 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 | - + | test_suite "veryquick" -prefix "" -description { "Very" quick test suite. Runs in minutes on a workstation. This test suite is the same as the "quick" tests, except that some files that test malloc and IO errors are omitted. } -files [ test_set $allquicktests -exclude *malloc* *ioerr* *fault* *bigfile* *_err* \ |
︙ |
Changes to test/window1.test.
︙ | |||
147 148 149 150 151 152 153 | 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 | - + + + + + + + + + + + + + + + + | 2 3 1.0 3 6 1.5 4 10 2.0 5 15 2.5 6 21 3.0 } |
︙ |
Added test/window2.tcl.