Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Minor additions to vacuum.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
a397ed162246fef32b8c5db36d995bf9 |
| User & Date: | dan 2010-11-15 11:35:50 |
Context
|
2010-11-15
| ||
| 14:44 | Merge the EXPLAIN QUERY PLAN changes from experimental into trunk. check-in: ce27bf38 user: drh tags: trunk | |
| 11:35 | Minor additions to vacuum.test. check-in: a397ed16 user: dan tags: trunk | |
|
2010-11-12
| ||
| 15:49 | Change the test_multiplex.c code to use wrapper functions for all sqlite3_vfs methods (instead of copying function pointers from the underlying vfs into the multiplex vfs). This is required to work with test_osinst.c. check-in: 1244ef9f user: dan tags: trunk | |
Changes
Changes to test/vacuum.test.
296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 |
file delete -force :memory:
do_test vacuum-7.0 {
sqlite3 db2 :memory:
execsql {
CREATE TABLE t1(t);
VACUUM;
} db2
execsql {
CREATE TABLE t2(t);
CREATE TABLE t3(t);
DROP TABLE t2;
VACUUM;
pragma integrity_check;
} db2
} {ok}
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
|
> > > > > > > > > > > > > > > > > > > > > > > > |
296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 |
file delete -force :memory:
do_test vacuum-7.0 {
sqlite3 db2 :memory:
execsql {
CREATE TABLE t1(t);
VACUUM;
} db2
} {}
do_test vacuum-7.1 {
execsql {
CREATE TABLE t2(t);
CREATE TABLE t3(t);
DROP TABLE t2;
PRAGMA freelist_count;
}
} {1}
do_test vacuum-7.2 {
execsql {
VACUUM;
pragma integrity_check;
} db2
} {ok}
do_test vacuum-7.3 {
execsql { PRAGMA freelist_count; } db2
} {0}
ifcapable autovacuum {
do_test vacuum-7.4 {
execsql { PRAGMA auto_vacuum } db2
} {0}
do_test vacuum-7.5 {
execsql { PRAGMA auto_vacuum = 1} db2
execsql { PRAGMA auto_vacuum } db2
} {0}
do_test vacuum-7.6 {
execsql { PRAGMA auto_vacuum = 1} db2
execsql { VACUUM } db2
execsql { PRAGMA auto_vacuum } db2
} {1}
}
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
|