AryaWu/sqlite

1# 2005 August 282#3# The author disclaims copyright to this source code.  In place of4# a legal notice, here is a blessing:5#6#    May you do good and not evil.7#    May you find forgiveness for yourself and forgive others.8#    May you share freely, never taking more than you give.9#10#***********************************************************************11# This file implements regression tests for SQLite library.12#13# This file implements tests to verify that fsync is disabled when14# pragma synchronous=off even for multi-database commits.15#16 17set testdir [file dirname $argv0]18source $testdir/tester.tcl19 20#21# These tests are only applicable when pager pragma are22# enabled. Also, since every test uses an ATTACHed database, they23# are only run when ATTACH is enabled.24#25ifcapable !pager_pragmas||!attach {26  finish_test27  return28}29if {[atomic_batch_write test.db]} {30  finish_test31  return32}33 34set sqlite_sync_count 035proc cond_incr_sync_count {adj} {36  global sqlite_sync_count37  if {$::tcl_platform(os) eq "Windows NT"} {38    incr sqlite_sync_count $adj39  } else {40    ifcapable !dirsync {41      incr sqlite_sync_count $adj42    }43  }44}45 46do_test sync-1.1 {47  set sqlite_sync_count 048  forcedelete test2.db49  forcedelete test2.db-journal50  execsql {51    PRAGMA fullfsync=OFF;52    CREATE TABLE t1(a,b);53    ATTACH DATABASE 'test2.db' AS db2;54    CREATE TABLE db2.t2(x,y);55  }56  cond_incr_sync_count 257  set sqlite_sync_count58} 859ifcapable pager_pragmas {60  do_test sync-1.2 {61    set sqlite_sync_count 062    execsql {63      PRAGMA main.synchronous=on;64      PRAGMA db2.synchronous=on;65      BEGIN;66      INSERT INTO t1 VALUES(1,2);67      INSERT INTO t2 VALUES(3,4);68      COMMIT;69    }70    cond_incr_sync_count 471    set sqlite_sync_count72  } 973}74do_test sync-1.3 {75  set sqlite_sync_count 076  execsql {77    PRAGMA main.synchronous=full;78    PRAGMA db2.synchronous=full;79    BEGIN;80    INSERT INTO t1 VALUES(3,4);81    INSERT INTO t2 VALUES(5,6);82    COMMIT;83  }84  cond_incr_sync_count 485  set sqlite_sync_count86} 1187ifcapable pager_pragmas {88if {[permutation]!="journaltest"} {89  do_test sync-1.4 {90    set sqlite_sync_count 091    execsql {92      PRAGMA main.synchronous=off;93      PRAGMA db2.synchronous=off;94      BEGIN;95      INSERT INTO t1 VALUES(5,6);96      INSERT INTO t2 VALUES(7,8);97      COMMIT;98    }99    set sqlite_sync_count100  } 0101}102}103 104 105finish_test106