Import SQLite 3.8.7.4.

third_party/sqlite/src/test/trans2.test

 # 2008 August 27
 #
 # 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 143 matching lines @@
 
   # Do a large update that aborts do to a constraint failure near
   # the end.  This stresses the statement journal mechanism.
   #
   do_test trans2-$i.10 {
     catchsql {
       UPDATE t1 SET u1=u1||'x',
           z = CASE WHEN id<$max_rowid
                    THEN zeroblob((random()&65535)%5000 + 1000) END;
     }
-  } {1 {t1.z may not be NULL}}
+  } {1 {NOT NULL constraint failed: t1.z}}
   do_test trans2-$i.11 {
     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
   } $newres
 
   # Delete all of the newly inserted records.  Verify that the database
   # is back to its original state.
   #
   do_test trans2-$i.20 {
     set s "DELETE FROM t1 WHERE id IN ([join $todel ,]);"
     append modsql $s\n
     db eval $s
     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
   } $origres
 
   # Do another large update that aborts do to a constraint failure near
   # the end.  This stresses the statement journal mechanism.
   #
   do_test trans2-$i.30 {
     catchsql {
       UPDATE t1 SET u1=u1||'x',
           z = CASE WHEN id<$max1
                    THEN zeroblob((random()&65535)%5000 + 1000) END;
     }
-  } {1 {t1.z may not be NULL}}
+  } {1 {NOT NULL constraint failed: t1.z}}
   do_test trans2-$i.31 {
     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
   } $origres
 
   # Redo the inserts
   #
   do_test trans2-$i.40 {
     db eval $inssql
     append modsql $inssql
     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
@@ skipping 24 matching lines @@
     }
     db eval COMMIT
     db eval {SELECT md5sum(u1), md5sum(u2) FROM t1 ORDER BY id}
   } $newres
   integrity_check trans2-$i.93
 }
 
 unset -nocomplain data i max_rowid todel n rec max1 id origres newres
 unset -nocomplain inssql modsql s j z
 finish_test