diff options
| author | dan <dan@noemail.net> | 2019-03-09 20:49:17 +0000 |
|---|---|---|
| committer | dan <dan@noemail.net> | 2019-03-09 20:49:17 +0000 |
| commit | 72b9fdcf207adbf9632958d4e7ffb83d37fb452f (patch) | |
| tree | 430f49e52d529c81c5e9834effdc7a5fc710482a /test/windowerr.tcl | |
| parent | f7b846e4ed54c7859d022d12cfaa6510dbb1ac28 (diff) | |
| download | sqlite-72b9fdcf207adbf9632958d4e7ffb83d37fb452f.tar.gz sqlite-72b9fdcf207adbf9632958d4e7ffb83d37fb452f.zip | |
Add support for RANGE window frames. Some cases still do not work.
FossilOrigin-Name: ffc32b246d92d53c66094afe11950b53ffab6a1c230c602eebbfedafb2eb57f4
Diffstat (limited to 'test/windowerr.tcl')
| -rw-r--r-- | test/windowerr.tcl | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/test/windowerr.tcl b/test/windowerr.tcl index f1e3b49d7..38ef54edc 100644 --- a/test/windowerr.tcl +++ b/test/windowerr.tcl @@ -20,6 +20,11 @@ ifcapable !windowfunc execsql_test 1.0 { DROP TABLE IF EXISTS t1; CREATE TABLE t1(a INTEGER, b INTEGER); + INSERT INTO t1 VALUES(1, 1); + INSERT INTO t1 VALUES(2, 2); + INSERT INTO t1 VALUES(3, 3); + INSERT INTO t1 VALUES(4, 4); + INSERT INTO t1 VALUES(5, 5); } foreach {tn frame} { @@ -31,11 +36,13 @@ foreach {tn frame} { 5 "ORDER BY a GROUPS BETWEEN -1 PRECEDING AND 1 FOLLOWING" 6 "ORDER BY a GROUPS BETWEEN 1 PRECEDING AND -1 FOLLOWING" + + 7 "ORDER BY a,b RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING" } { errorsql_test 1.$tn " SELECT a, sum(b) OVER ( $frame - ) FROM t3 ORDER BY 1 + ) FROM t1 ORDER BY 1 " } |