/ Check-in [bfa61e78]
Login

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

Overview
Comment:Update a test in io.test to account for [05f98d4eec].
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: bfa61e781cb442be641486e7e55a1518e888d830
User & Date: dan 2012-05-01 14:21:57
Context
2012-05-07
18:10
Merge Windows directory checking changes to trunk. check-in: a4555a53 user: mistachkin tags: trunk
13:15
Do not do the AV retry loop on open if the file that is attempting to be opened is really a directory. check-in: 03875633 user: drh tags: win-check-dir
2012-05-05
01:03
Merge the latest trunk changes into the apple-osx branch. check-in: 2a99c007 user: drh tags: apple-osx
2012-05-04
23:31
Update the sessions branch with all the latest changes from trunk. check-in: 0f347fbf user: drh tags: sessions
23:11
Sync the latest trunk changes into the winRT branch. check-in: be4ab188 user: drh tags: winrt
2012-05-01
14:21
Update a test in io.test to account for [05f98d4eec]. check-in: bfa61e78 user: dan tags: trunk
2012-04-27
16:38
Fix a minor deviation from the coding style guidelines. check-in: 1e51bffe user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/io.test.

141
142
143
144
145
146
147




148
149
150
151
152
153
154
155
156
157
158
159
160
# Set the device-characteristic mask to include the SQLITE_IOCAP_ATOMIC,
# then do another INSERT similar to the one in io-2.2. This should
# only write 1 page and require a single fsync().
# 
# The single fsync() is the database file. Only one page is reported as
# written because page 1 - the change-counter page - is written using
# an out-of-band method that bypasses the write counter.




#
sqlite3_simulate_device -char atomic
do_test io-2.3 {
  execsql { INSERT INTO abc VALUES(3, 4) }
  list [nWrite db] [nSync]
} {1 1}

# Test that the journal file is not created and the change-counter is
# updated when the atomic-write optimization is used.
#
do_test io-2.4.1 {
  execsql {
    BEGIN;







>
>
>
>





|







141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
# Set the device-characteristic mask to include the SQLITE_IOCAP_ATOMIC,
# then do another INSERT similar to the one in io-2.2. This should
# only write 1 page and require a single fsync().
# 
# The single fsync() is the database file. Only one page is reported as
# written because page 1 - the change-counter page - is written using
# an out-of-band method that bypasses the write counter.
#
# UPDATE: As of [05f98d4eec] (adding SQLITE_DBSTATUS_CACHE_WRITE), the
# second write is also counted. So this now reports two writes and a
# single fsync.
#
sqlite3_simulate_device -char atomic
do_test io-2.3 {
  execsql { INSERT INTO abc VALUES(3, 4) }
  list [nWrite db] [nSync]
} {2 1}

# Test that the journal file is not created and the change-counter is
# updated when the atomic-write optimization is used.
#
do_test io-2.4.1 {
  execsql {
    BEGIN;