diff options
Diffstat (limited to 'test/select3.test')
-rw-r--r-- | test/select3.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/test/select3.test b/test/select3.test index 50039c551..fec8ba4a5 100644 --- a/test/select3.test +++ b/test/select3.test @@ -314,4 +314,13 @@ do_execsql_test select3-9.100 { SELECT * FROM t0 GROUP BY c0; } {1.0 1.0} +reset_db +do_execsql_test select3.10.100 { + CREATE TABLE t1(a, b); + CREATE TABLE t2(c, d); + SELECT max(t1.a), + (SELECT 'xyz' FROM (SELECT * FROM t2 WHERE 0) WHERE t1.b=1) + FROM t1; +} {{} {}} + finish_test |