diff options
Diffstat (limited to 'test/window6.test')
| -rw-r--r-- | test/window6.test | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/test/window6.test b/test/window6.test index 06cebcf1a..434a032f7 100644 --- a/test/window6.test +++ b/test/window6.test @@ -219,17 +219,17 @@ do_execsql_test 9.0 { } { 1 1 2 1,2 3 1,2,3 4 2,3,4 5 3,4,5 } -do_catchsql_test 9.1 { - WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5) - SELECT x, group_concat(x) OVER (ORDER BY x RANGE 2 PRECEDING) - FROM c; -} {1 {RANGE must use only UNBOUNDED or CURRENT ROW}} - -do_catchsql_test 9.2 { - WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5) - SELECT x, group_concat(x) OVER (ORDER BY x RANGE BETWEEN UNBOUNDED PRECEDING AND 2 FOLLOWING) - FROM c; -} {1 {RANGE must use only UNBOUNDED or CURRENT ROW}} +#do_catchsql_test 9.1 { +# WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5) +# SELECT x, group_concat(x) OVER (ORDER BY x RANGE 2 PRECEDING) +# FROM c; +#} {1 {RANGE must use only UNBOUNDED or CURRENT ROW}} +# +#do_catchsql_test 9.2 { +# WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5) +# SELECT x, group_concat(x) OVER (ORDER BY x RANGE BETWEEN UNBOUNDED PRECEDING AND 2 FOLLOWING) +# FROM c; +#} {1 {RANGE must use only UNBOUNDED or CURRENT ROW}} do_catchsql_test 9.3 { WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5) @@ -262,7 +262,7 @@ foreach {tn frame} { SELECT count() OVER ( ORDER BY x ROWS $frame ) FROM c; - " {1 {unsupported frame delimiter for ROWS}} + " {1 {unsupported frame specification}} } do_catchsql_test 9.8.1 { |