Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a typo in test file window1.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
8c80e81d01abde9a5032cdc1a492d0fc |
| User & Date: | dan 2019-07-13 17:54:24 |
Context
|
2019-07-13
| ||
| 18:27 | Fix a memory leak that could follow an OOM in the new FILTER code. check-in: 85fd70fe user: dan tags: trunk | |
| 17:54 | Fix a typo in test file window1.test. check-in: 8c80e81d user: dan tags: trunk | |
| 17:45 | Fix error handling for the case where a window function is passed the wrong number of arguments. check-in: 871796bb user: dan tags: trunk | |
Changes
Changes to test/window1.test.
255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 |
SELECT trim(x) OVER (ORDER BY y) FROM t1;
} {1 {trim() may not be used as a window function}}
do_catchsql_test 7.1.7 {
SELECT max(x) OVER abc FROM t1 WINDOW def AS (ORDER BY y);
} {1 {no such window: abc}}
do_catchsql_test 7.1.8 {
SELECT row_number(x) OVER () FROM t1
} {1 {wrong number of arguments to function row_number}}
do_execsql_test 7.2 {
SELECT
lead(y) OVER win,
lead(y, 2) OVER win,
lead(y, 3, 'default') OVER win
FROM t1
|
| |
255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 |
SELECT trim(x) OVER (ORDER BY y) FROM t1;
} {1 {trim() may not be used as a window function}}
do_catchsql_test 7.1.7 {
SELECT max(x) OVER abc FROM t1 WINDOW def AS (ORDER BY y);
} {1 {no such window: abc}}
do_catchsql_test 7.1.8 {
SELECT row_number(x) OVER () FROM t1
} {1 {wrong number of arguments to function row_number()}}
do_execsql_test 7.2 {
SELECT
lead(y) OVER win,
lead(y, 2) OVER win,
lead(y, 3, 'default') OVER win
FROM t1
|