aboutsummaryrefslogtreecommitdiff
path: root/test/window1.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/window1.test')
-rw-r--r--test/window1.test7
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