Import SQLite 3.7.6.3.

third_party/sqlite/src/test/check.test

 # 2005 November 2
 #
 # 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 221 matching lines @@
     INSERT INTO t4 VALUES(1,10);
     SELECT * FROM t4
   }
 } {1 10}
 do_test check-4.3 {
   execsql {
     UPDATE t4 SET x=4, y=3;
     SELECT * FROM t4
   }
 } {4 3}
-do_test check-4.3 {
+do_test check-4.4 {
   execsql {
     UPDATE t4 SET x=12, y=2;
     SELECT * FROM t4
   }
 } {12 2}
-do_test check-4.4 {
+do_test check-4.5 {
   execsql {
     UPDATE t4 SET x=12, y=-22;
     SELECT * FROM t4
   }
 } {12 -22}
-do_test check-4.5 {
+do_test check-4.6 {
   catchsql {
     UPDATE t4 SET x=0, y=1;
   }
 } {1 {constraint failed}}
-do_test check-4.6 {
+do_test check-4.7 {
   execsql {
     SELECT * FROM t4;
   }
 } {12 -22}
-do_test check-4.7 {
+do_test check-4.8 {
   execsql {
     PRAGMA ignore_check_constraints=ON;
     UPDATE t4 SET x=0, y=1;
     SELECT * FROM t4;
   }
 } {0 1}
-do_test check-4.8 {
+do_test check-4.9 {
   catchsql {
     PRAGMA ignore_check_constraints=OFF;
     UPDATE t4 SET x=0, y=2;
   }
 } {1 {constraint failed}}
 ifcapable vacuum {
-  do_test check_4.9 {
+  do_test check_4.10 {
     catchsql {
       VACUUM
     }
   } {0 {}}
 }
 
 do_test check-5.1 {
   catchsql {
     CREATE TABLE t5(x, y,
       CHECK( x*y<:abc )
@@ skipping 76 matching lines @@
   }
 } {0 {}}
 do_test check-6.15 {
   execsql {SELECT * FROM t1}
 } {3 12.0 2 20.0}
 
 
 }
 
 finish_test