diff options
Diffstat (limited to 'test/window1.test')
-rw-r--r-- | test/window1.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/test/window1.test b/test/window1.test index ccf798caa..a75489a38 100644 --- a/test/window1.test +++ b/test/window1.test @@ -2090,6 +2090,13 @@ do_catchsql_test 67.1 { SELECT nth_value(a,2) OVER w1 WINDOW w1 AS ( ORDER BY ((SELECT 1 FROM v1)) ) ) +} {1 {no such table: v1}} + +do_catchsql_test 67.2 { + SELECT a,c,b FROM t1 INTERSECT SELECT a,b,c FROM t1 ORDER BY ( + SELECT nth_value(a,2) OVER w1 + WINDOW w1 AS ( ORDER BY ((SELECT 1 FROM t2)) ) + ) } {1 {1st ORDER BY term does not match any column in the result set}} # 2021-05-07 |