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