/ Check-in [6b270381]
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:Added ifcapable wal to some test scripts;
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 6b270381daad5d1a9ca5746cf439c90f9c735a1b
User & Date: shaneh 2011-04-05 02:33:44
Context
2011-04-05
11:26
Improved comment on the sqlite3SrcListLookup function. check-in: bcbc9ff5 user: drh tags: trunk
02:33
Added ifcapable wal to some test scripts; check-in: 6b270381 user: shaneh tags: trunk
02:21
Added ifcapable utf16 to a few test cases; check-in: 57e0919b user: shaneh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/e_vacuum.test.

   171    171     execsql VACUUM
   172    172     execsql { PRAGMA page_size ; PRAGMA auto_vacuum }
   173    173   } {2048 0}
   174    174   
   175    175   # EVIDENCE-OF: R-48521-51450 When in write-ahead log mode, only the
   176    176   # auto_vacuum support property can be changed using VACUUM.
   177    177   #
          178  +ifcapable wal {
   178    179   do_test e_vacuum-1.3.3.1 {
   179    180     execsql { PRAGMA journal_mode = wal }
   180    181     execsql { PRAGMA page_size ; PRAGMA auto_vacuum }
   181    182   } {2048 0}
   182    183   do_test e_vacuum-1.3.3.2 {
   183    184     execsql { PRAGMA page_size = 1024 }
   184    185     execsql { PRAGMA auto_vacuum = FULL }
   185    186     execsql VACUUM
   186    187     execsql { PRAGMA page_size ; PRAGMA auto_vacuum }
   187    188   } {2048 1}
          189  +}
   188    190   
   189    191   # EVIDENCE-OF: R-38001-03952 VACUUM only works on the main database. It
   190    192   # is not possible to VACUUM an attached database file.
   191    193   forcedelete test.db2
   192    194   create_db { PRAGMA auto_vacuum = NONE }
   193    195   do_execsql_test e_vacuum-2.1.1 {
   194    196     ATTACH 'test.db2' AS aux;