Return to jrnlmode3.test CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test

Annotation of embedaddon/sqlite3/test/jrnlmode3.test, revision 1.1.1.1

1.1       misho       1: # 2009 April 20
                      2: #
                      3: # The author disclaims copyright to this source code.  In place of
                      4: # 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: #
                     12: # Test cases inspired by ticket #3811.  Tests to make sure that
                     13: # the journal_mode can only be changed at appropriate times and that
                     14: # all reported changes are effective.
                     15: #
                     16: # $Id: jrnlmode3.test,v 1.5 2009/04/20 17:43:03 drh Exp $
                     17: 
                     18: set testdir [file dirname $argv0]
                     19: source $testdir/tester.tcl
                     20: 
                     21: ifcapable {!pager_pragmas} {
                     22:   finish_test
                     23:   return
                     24: }
                     25: 
                     26: #
                     27: # Verify that journal_mode=OFF works as long as it occurs before the first
                     28: # transaction, even if locking_mode=EXCLUSIVE is enabled.  The behavior if
                     29: # journal_mode is changed after the first transaction is undefined and hence
                     30: # untested.
                     31: #
                     32: do_test jrnlmode3-1.1 {
                     33:   db eval {
                     34:     PRAGMA journal_mode=OFF;
                     35:     PRAGMA locking_mode=EXCLUSIVE;
                     36:     CREATE TABLE t1(x);
                     37:     INSERT INTO t1 VALUES(1);
                     38:     SELECT * FROM t1;
                     39:   }
                     40: } {off exclusive 1}
                     41: do_test jrnlmode3-1.2 {
                     42:   db eval {
                     43:     BEGIN;
                     44:     INSERT INTO t1 VALUES(2);
                     45:     ROLLBACK;
                     46:     SELECT * FROM t1;
                     47:   }
                     48: } {1}
                     49: 
                     50: db close
                     51: forcedelete test.db test.db-journal
                     52: sqlite3 db test.db
                     53: 
                     54: do_test jrnlmode3-2.1 {
                     55:   db eval {
                     56:     PRAGMA locking_mode=EXCLUSIVE;
                     57:     PRAGMA journal_mode=OFF;
                     58:     CREATE TABLE t1(x);
                     59:     INSERT INTO t1 VALUES(1);
                     60:     SELECT * FROM t1;
                     61:   }
                     62: } {exclusive off 1}
                     63: do_test jrnlmode3-2.2 {
                     64:   db eval {
                     65:     BEGIN;
                     66:     INSERT INTO t1 VALUES(2);
                     67:     ROLLBACK;
                     68:     SELECT * FROM t1;
                     69:   }
                     70: } {1}
                     71: 
                     72: # Test cases to verify that we can move from any journal_mode
                     73: # to any other, as long as we are not in a transaction.  Verify
                     74: # that we cannot change journal_mode while a transaction is active.
                     75: #
                     76: set all_journal_modes {delete persist truncate memory off}
                     77: set cnt 0
                     78: foreach fromjmode $all_journal_modes {
                     79:   foreach tojmode $all_journal_modes {
                     80: 
                     81:     # Skip the no-change cases
                     82:     if {$fromjmode==$tojmode} continue
                     83:     incr cnt
                     84: 
                     85:     # Start with a fresh database connection an empty database file.
                     86:     #
                     87:     db close
                     88:     forcedelete test.db test.db-journal
                     89:     sqlite3 db test.db
                     90: 
                     91:     # Initialize the journal mode.
                     92:     #
                     93:     do_test jrnlmode3-3.$cnt.1-($fromjmode-to-$tojmode) {
                     94:       db eval "PRAGMA journal_mode = $fromjmode;"
                     95:     } $fromjmode
                     96: 
                     97:     # Verify that the initial journal mode takes.
                     98:     #
                     99:     do_test jrnlmode3-3.$cnt.2 {
                    100:       db eval {PRAGMA main.journal_mode}
                    101:     } $fromjmode
                    102: 
                    103:     # Start a transaction and try to change the journal mode within
                    104:     # the transaction.  This should fail.
                    105:     #
                    106:     do_test jrnlmode3-3.$cnt.3 {
                    107:       db eval {
                    108:         CREATE TABLE t1(x);
                    109:         BEGIN;
                    110:         INSERT INTO t1 VALUES($cnt);
                    111:       }
                    112:       db eval "PRAGMA journal_mode=$tojmode"
                    113:     } $fromjmode
                    114: 
                    115:     # Rollback the transaction.  
                    116:     #
                    117:     do_test jrnlmode3-3.$cnt.4 {
                    118:       db eval {
                    119:         ROLLBACK;
                    120:         SELECT * FROM t1;
                    121:       }
                    122:     } {}
                    123: 
                    124:     # Now change the journal mode again.  This time the new mode
                    125:     # should take.
                    126:     #
                    127:     do_test jrnlmode3-3.$cnt.5 {
                    128:       db eval "PRAGMA journal_mode=$tojmode"
                    129:     } $tojmode
                    130: 
                    131:     # Do a the transaction.  Verify that the rollback occurred
                    132:     # if journal_mode!=OFF.
                    133:     #
                    134:     do_test jrnlmode3-3.$cnt.6 {
                    135:       db eval {
                    136:         DROP TABLE IF EXISTS t1;
                    137:         CREATE TABLE t1(x);
                    138:         BEGIN;
                    139:         INSERT INTO t1 VALUES(1);
                    140:       }
                    141:       db eval ROLLBACK
                    142:       db eval {
                    143:         SELECT * FROM t1;
                    144:       }
                    145:     } {}
                    146:   }
                    147: }
                    148: 
                    149: finish_test