aboutsummaryrefslogtreecommitdiff
path: root/test/with2.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/with2.test')
-rw-r--r--test/with2.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/test/with2.test b/test/with2.test
index 660df52b7..68790fe86 100644
--- a/test/with2.test
+++ b/test/with2.test
@@ -156,6 +156,16 @@ do_execsql_test 1.15 {
SELECT * FROM t4;
} {4 5}
+do_execsql_test 1.15.2 {
+ WITH
+ t4(x) AS (
+ VALUES(4)
+ UNION ALL
+ SELECT x+1 FROM (SELECT * FROM main.t4) WHERE x<10
+ )
+ SELECT * FROM t4;
+} {4 5}
+
do_catchsql_test 1.16 {
WITH
t4(x) AS (