Index: third_party/sqlite/src/test/vacuum.test |
diff --git a/third_party/sqlite/src/test/vacuum.test b/third_party/sqlite/src/test/vacuum.test |
index 34be57ce7c8c3261c52c8f565c13127698304630..57429c29ea5f867d6e63c6272d3c05e15bd4cf14 100644 |
--- a/third_party/sqlite/src/test/vacuum.test |
+++ b/third_party/sqlite/src/test/vacuum.test |
@@ -208,7 +208,7 @@ db3 close |
do_test vacuum-3.1 { |
db close |
db2 close |
- file delete test.db |
+ delete_file test.db |
sqlite3 db test.db |
execsql { |
PRAGMA empty_result_callbacks=on; |
@@ -234,7 +234,7 @@ do_test vacuum-4.2 { |
ifcapable view { |
do_test vacuum-5.1 { |
db close |
- file delete -force test.db |
+ forcedelete test.db |
sqlite3 db test.db |
catchsql { |
CREATE TABLE Test (TestID int primary key); |
@@ -290,10 +290,10 @@ ifcapable {bloblit} { |
} |
# Check what happens when an in-memory database is vacuumed. The |
-# [file delete] command covers us in case the library was compiled |
+# [delete_file] command covers us in case the library was compiled |
# without in-memory database support. |
# |
-file delete -force :memory: |
+forcedelete :memory: |
do_test vacuum-7.0 { |
sqlite3 db2 :memory: |
execsql { |
@@ -337,8 +337,8 @@ db2 close |
# Ticket #873. VACUUM a database that has ' in its name. |
# |
do_test vacuum-8.1 { |
- file delete -force a'z.db |
- file delete -force a'z.db-journal |
+ forcedelete a'z.db |
+ forcedelete a'z.db-journal |
sqlite3 db2 a'z.db |
execsql { |
CREATE TABLE t1(t); |
@@ -383,6 +383,22 @@ ifcapable {autoinc} { |
} $::cksum |
} |
-file delete -force {a'z.db} |
+forcedelete {a'z.db} |
+ |
+# Test that "PRAGMA count_changes" does not interfere with VACUUM or cause |
+# it to return any rows to the user. |
+# |
+do_test vacuum-10.1 { |
+ db close |
+ forcedelete test.db |
+ sqlite3 db test.db |
+ execsql { |
+ CREATE TABLE t8(a, b); |
+ INSERT INTO t8 VALUES('a', 'b'); |
+ INSERT INTO t8 VALUES('c', 'd'); |
+ PRAGMA count_changes = 1; |
+ } |
+} {} |
+do_test vacuum-10.2 { execsql VACUUM } {} |
finish_test |