summaryrefslogtreecommitdiffstats
path: root/third_party/sqlite/test/subquery.test
diff options
context:
space:
mode:
Diffstat (limited to 'third_party/sqlite/test/subquery.test')
-rw-r--r--third_party/sqlite/test/subquery.test7
1 files changed, 6 insertions, 1 deletions
diff --git a/third_party/sqlite/test/subquery.test b/third_party/sqlite/test/subquery.test
index c6416fc9..169ceda 100644
--- a/third_party/sqlite/test/subquery.test
+++ b/third_party/sqlite/test/subquery.test
@@ -11,7 +11,7 @@
# This file implements regression tests for SQLite library. The
# focus of this script is testing correlated subqueries
#
-# $Id: subquery.test,v 1.16 2008/07/10 00:32:42 drh Exp $
+# $Id: subquery.test,v 1.17 2009/01/09 01:12:28 drh Exp $
#
set testdir [file dirname $argv0]
@@ -269,6 +269,11 @@ ifcapable view {
SELECT * FROM v1 WHERE EXISTS(SELECT * FROM t2 WHERE p=v1.b);
}
} {2}
+ do_test subquery-3.1.1 {
+ execsql {
+ SELECT * FROM v1 WHERE EXISTS(SELECT 1);
+ }
+ } {2}
} else {
catchsql { DROP TABLE t1; }
catchsql { DROP TABLE t2; }