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/window8.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/window8.tcl')
| -rw-r--r-- | test/window8.tcl | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/test/window8.tcl b/test/window8.tcl index 362070ecb..f117dd533 100644 --- a/test/window8.tcl +++ b/test/window8.tcl @@ -89,6 +89,24 @@ foreach {tn frame} { " } +========== + +execsql_test 2.0 { + DROP TABLE IF EXISTS t1; + CREATE TABLE t1(a INTEGER, b INTEGER); + INSERT INTO t1 VALUES + (13, 26), (15, 30); +} + +foreach {tn frame} { + 1 { ORDER BY a RANGE BETWEEN 5 PRECEDING AND 5 FOLLOWING } + 2 { ORDER BY a RANGE BETWEEN 10 PRECEDING AND 5 PRECEDING } + 3 { ORDER BY a RANGE BETWEEN 2 FOLLOWING AND 3 FOLLOWING } +} { + execsql_test 2.$tn "SELECT a, sum(b) OVER win FROM t1 WINDOW win AS ($frame)" +} + + finish_test |