Import SQLite 3.8.7.4.

third_party/sqlite/src/test/intpkey.test

 # 2001 September 15
 #
 # 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 58 matching lines @@
 } {5 5 hello world}
 
 # Attempting to insert a duplicate primary key should give a constraint
 # failure.
 #
 do_test intpkey-1.6 {
   set r [catch {execsql {
      INSERT INTO t1 VALUES(5,'second','entry');
   }} msg]
   lappend r $msg
-} {1 {PRIMARY KEY must be unique}}
+} {1 {UNIQUE constraint failed: t1.a}}
 do_test intpkey-1.7 {
   execsql {
     SELECT rowid, * FROM t1;
   }
 } {5 5 hello world}
 do_test intpkey-1.8 {
   set r [catch {execsql {
      INSERT INTO t1 VALUES(6,'second','entry');
   }} msg]
   lappend r $msg
@@ skipping 28 matching lines @@
 
 # Make sure SELECT statements are able to use the primary key column
 # as an index.
 #
 do_test intpkey-1.12.1 {
   execsql {
     SELECT * FROM t1 WHERE a==4;
   }
 } {4 one two}
 do_test intpkey-1.12.2 {
-  set sqlite_query_plan
-} {t1 *}
+  execsql {
+    EXPLAIN QUERY PLAN
+    SELECT * FROM t1 WHERE a==4;
+  }
+} {/SEARCH TABLE t1 /}
 
 # Try to insert a non-integer value into the primary key field.  This
 # should result in a data type mismatch.
 #
 do_test intpkey-1.13.1 {
   set r [catch {execsql {
     INSERT INTO t1 VALUES('x','y','z');
   }} msg]
   lappend r $msg
 } {1 {datatype mismatch}}
@@ skipping 229 matching lines @@
 do_test intpkey-5.1 {
   execsql {
     INSERT INTO t1 VALUES(0,'zero','entry');
   }
   count {
     SELECT * FROM t1 WHERE a=0;
   }
 } {0 zero entry 0}
 do_test intpkey-5.2 {
   execsql {
-    SELECT rowid, a FROM t1
+    SELECT rowid, a FROM t1 ORDER BY rowid
   }
 } {-4 -4 0 0 5 5 6 6 11 11}
 
 # Test the ability of the COPY command to put data into a
 # table that contains an integer primary key.
 #
 # COPY command has been removed.  But we retain these tests so
 # that the tables will contain the right data for tests that follow.
 #
 do_test intpkey-6.1 {
@@ skipping 206 matching lines @@
   }
 } {y zero 2 hello second hello b-20 b-22 new 3 big-1 big-2}
 do_test intpkey-15.7 {
   execsql {
     SELECT b FROM t1 WHERE a>12345678901;
   }
 } {}
 
 
 finish_test