Index: third_party/sqlite/src/test/memdb.test |
diff --git a/third_party/sqlite/src/test/memdb.test b/third_party/sqlite/src/test/memdb.test |
index d987d21e05ce81144aa6c0f1f32169f1fc4650bf..1da3d7c58b43b05639fae630b6d123ef925b1967 100644 |
--- a/third_party/sqlite/src/test/memdb.test |
+++ b/third_party/sqlite/src/test/memdb.test |
@@ -363,19 +363,13 @@ do_test memdb-6.15 { |
} |
} {} |
-ifcapable subquery { |
+ifcapable subquery&&vtab { |
do_test memdb-7.1 { |
+ register_wholenumber_module db |
execsql { |
CREATE TABLE t6(x); |
- INSERT INTO t6 VALUES(1); |
- INSERT INTO t6 SELECT x+1 FROM t6; |
- INSERT INTO t6 SELECT x+2 FROM t6; |
- INSERT INTO t6 SELECT x+4 FROM t6; |
- INSERT INTO t6 SELECT x+8 FROM t6; |
- INSERT INTO t6 SELECT x+16 FROM t6; |
- INSERT INTO t6 SELECT x+32 FROM t6; |
- INSERT INTO t6 SELECT x+64 FROM t6; |
- INSERT INTO t6 SELECT x+128 FROM t6; |
+ CREATE VIRTUAL TABLE nums USING wholenumber; |
+ INSERT INTO t6 SELECT value FROM nums WHERE value BETWEEN 1 AND 256; |
SELECT count(*) FROM (SELECT DISTINCT x FROM t6); |
} |
} {256} |