diff options
Diffstat (limited to 'test/select4.test')
| -rw-r--r-- | test/select4.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/test/select4.test b/test/select4.test index 47a44081f..71171def3 100644 --- a/test/select4.test +++ b/test/select4.test @@ -863,5 +863,12 @@ do_execsql_test select4-14.8 { do_execsql_test select4-14.9 { SELECT * FROM t14 UNION ALL VALUES(3,2,1),(2,3,1),(1,2,3),(2,1,3); } {1 2 3 4 5 6 3 2 1 2 3 1 1 2 3 2 1 3} +do_execsql_test select4-14.10 { + SELECT (VALUES(1),(2),(3),(4)) +} {1} +do_execsql_test select4-14.11 { + SELECT (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) +} {1} + finish_test |