1 files changed, 4 insertions, 10 deletions
diff --git a/third_party/sqlite/src/test/memdb.test b/third_party/sqlite/src/test/memdb.test
index d987d21..1da3d7c 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}