Import SQLite 3.7.6.3.

third_party/sqlite/src/test/jrnlmode3.test

 # 2009 April 20
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 27 matching lines @@
     SELECT * FROM t1;
   }
 } {off exclusive 1}
 do_test jrnlmode3-1.2 {
   db eval {
     BEGIN;
     INSERT INTO t1 VALUES(2);
     ROLLBACK;
     SELECT * FROM t1;
   }
-} {1 2}
+} {1}
 
 db close
 file delete -force test.db test.db-journal
 sqlite3 db test.db
 
 do_test jrnlmode3-2.1 {
   db eval {
     PRAGMA locking_mode=EXCLUSIVE;
     PRAGMA journal_mode=OFF;
     CREATE TABLE t1(x);
     INSERT INTO t1 VALUES(1);
     SELECT * FROM t1;
   }
 } {exclusive off 1}
 do_test jrnlmode3-2.2 {
   db eval {
     BEGIN;
     INSERT INTO t1 VALUES(2);
     ROLLBACK;
     SELECT * FROM t1;
   }
-} {1 2}
+} {1}
 
 # Test cases to verify that we can move from any journal_mode
 # to any other, as long as we are not in a transaction.  Verify
 # that we cannot change journal_mode while a transaction is active.
 #
 set all_journal_modes {delete persist truncate memory off}
 set cnt 0
 foreach fromjmode $all_journal_modes {
   foreach tojmode $all_journal_modes {
 
@@ skipping 24 matching lines @@
     #
     do_test jrnlmode3-3.$cnt.3 {
       db eval {
         CREATE TABLE t1(x);
         BEGIN;
         INSERT INTO t1 VALUES($cnt);
       }
       db eval "PRAGMA journal_mode=$tojmode"
     } $fromjmode
 
-    # Rollback the transaction.  Verify that the rollback occurred
-    # if journal_mode!=OFF.
+    # Rollback the transaction.  
     #
     do_test jrnlmode3-3.$cnt.4 {
       db eval {
         ROLLBACK;
         SELECT * FROM t1;
       }
-    } [expr {$fromjmode=="off"?$cnt:""}]
+    } {}
 
     # Now change the journal mode again.  This time the new mode
     # should take.
     #
     do_test jrnlmode3-3.$cnt.5 {
       db eval "PRAGMA journal_mode=$tojmode"
     } $tojmode
 
     # Do a the transaction.  Verify that the rollback occurred
     # if journal_mode!=OFF.
     #
     do_test jrnlmode3-3.$cnt.6 {
       db eval {
         DROP TABLE IF EXISTS t1;
         CREATE TABLE t1(x);
         BEGIN;
         INSERT INTO t1 VALUES(1);
       }
       db eval ROLLBACK
       db eval {
         SELECT * FROM t1;
       }
-    } [expr {$tojmode=="off"?"1":""}]
+    } {}
   }
 }
 
 finish_test