diff options
Diffstat (limited to 'test/with2.test')
-rw-r--r-- | test/with2.test | 10 |
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 ( |