/ Check-in [b79521d2]
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:Fix a test case in walro2.test so that it works with encryption extensions (when each page has a little less usable space available than usual).
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: b79521d255a4aa2a7b4424f3498443f27d329ab5428171ba6b87c987f3ccdfc2
User & Date: dan 2018-01-22 15:20:59
Context
2018-01-22
15:45
Avoid unnecessary OOM detection warnings in a debugging routine. check-in: 395f8ea7 user: drh tags: trunk
15:20
Fix a test case in walro2.test so that it works with encryption extensions (when each page has a little less usable space available than usual). check-in: b79521d2 user: dan tags: trunk
14:49
On the walro2-X.4.2.2 test case, show the size as part of the test output. check-in: ac5091d7 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/walro2.test.

257
258
259
260
261
262
263
264
265
266

267
268
269
270
271
272
273
274
        WITH s(i) AS (
          SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<500
          )
        INSERT INTO t2 SELECT randomblob(500) FROM s;
        SELECT count(*) FROM t2;
    } 
  } {500}
  do_test $TN.4.2.2 {
    set sz [file size test.db-wal]
    puts -nonewline " (sz=$sz)"

    expr {$sz>400000 && $sz<500000}
  } {1}
  do_test $TN.4.2.4 {
    file_control_persist_wal db 1; db close

    copy_to_test2 $bZeroShm
    code2 { sqlite3 db2 file:test.db2?readonly_shm=1 }
    sql2 {







<
|
<
>
|







257
258
259
260
261
262
263

264

265
266
267
268
269
270
271
272
273
        WITH s(i) AS (
          SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<500
          )
        INSERT INTO t2 SELECT randomblob(500) FROM s;
        SELECT count(*) FROM t2;
    } 
  } {500}

  set sz [file size test.db-wal]

  do_test $TN.4.2.2.(sz=$sz) {
    expr {$sz>400000}
  } {1}
  do_test $TN.4.2.4 {
    file_control_persist_wal db 1; db close

    copy_to_test2 $bZeroShm
    code2 { sqlite3 db2 file:test.db2?readonly_shm=1 }
    sql2 {