/ Check-in [fc85c8aa]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Make sure auto_vacuum is turned off before running the tests in pragma2.test. (CVS 4138)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: fc85c8aa160cc46419b9ce83d9eb47970c67118a
User & Date: drh 2007-06-27 10:20:01
Context
2007-06-27
10:21
Fix typo in comments of the sqlite.h.in header file - comments from which documentation is automatically extracted and generated. Ticket #2468. (CVS 4139) check-in: 53b52620 user: drh tags: trunk
10:20
Make sure auto_vacuum is turned off before running the tests in pragma2.test. (CVS 4138) check-in: fc85c8aa user: drh tags: trunk
00:36
Set the connection error code when sqlite3_blob_read() or sqlite3_blob_write() fail. Ticket #2464. (CVS 4137) check-in: 3bd990be user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/pragma2.test.

8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
..
32
33
34
35
36
37
38

39
40
41
42
43
44
45
..
62
63
64
65
66
67
68

69
70
71
72
73
74
75
#    May you share freely, never taking more than you give.
#
#***********************************************************************
# This file implements regression tests for SQLite library.
#
# This file implements tests for the PRAGMA command.
#
# $Id: pragma2.test,v 1.1 2007/06/24 08:00:44 danielk1977 Exp $

set testdir [file dirname $argv0]
source $testdir/tester.tcl

# Test organization:
#
# pragma2-1.*: Test freelist_count pragma on the main database.
................................................................................
# Delete the preexisting database to avoid the special setup
# that the "all.test" script does.
#
db close
file delete test.db test.db-journal
file delete test3.db test3.db-journal
sqlite3 db test.db; set DB [sqlite3_connection_pointer db]


do_test pragma2-1.1 {
  execsql {
    PRAGMA freelist_count;
  }
} {0}
do_test pragma2-1.2 {
................................................................................

file delete -force test2.db
file delete -force test2.db-journal

do_test pragma2-2.1 {
  execsql {
    ATTACH 'test2.db' AS aux;

    PRAGMA aux.freelist_count;
  }
} {0}
do_test pragma2-2.2 {
  execsql {
    CREATE TABLE aux.abc(a, b, c);
    PRAGMA aux.freelist_count;







|







 







>







 







>







8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
..
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
..
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
#    May you share freely, never taking more than you give.
#
#***********************************************************************
# This file implements regression tests for SQLite library.
#
# This file implements tests for the PRAGMA command.
#
# $Id: pragma2.test,v 1.2 2007/06/27 10:20:01 drh Exp $

set testdir [file dirname $argv0]
source $testdir/tester.tcl

# Test organization:
#
# pragma2-1.*: Test freelist_count pragma on the main database.
................................................................................
# Delete the preexisting database to avoid the special setup
# that the "all.test" script does.
#
db close
file delete test.db test.db-journal
file delete test3.db test3.db-journal
sqlite3 db test.db; set DB [sqlite3_connection_pointer db]
db eval {PRAGMA auto_vacuum=0}

do_test pragma2-1.1 {
  execsql {
    PRAGMA freelist_count;
  }
} {0}
do_test pragma2-1.2 {
................................................................................

file delete -force test2.db
file delete -force test2.db-journal

do_test pragma2-2.1 {
  execsql {
    ATTACH 'test2.db' AS aux;
    PRAGMA aux.auto_vacuum=OFF;
    PRAGMA aux.freelist_count;
  }
} {0}
do_test pragma2-2.2 {
  execsql {
    CREATE TABLE aux.abc(a, b, c);
    PRAGMA aux.freelist_count;