Import SQLite 3.10.2.

third_party/sqlite/src/test/index.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 38 matching lines @@
 # Try adding an index to a table that does not exist
 #
 do_test index-2.1 {
   set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
   lappend v $msg
 } {1 {no such table: main.test1}}
 
 # Try adding an index on a column of a table where the table
 # exists but the column does not.
 #
-do_test index-2.1 {
+do_test index-2.1b {
   execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
   set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
   lappend v $msg
-} {1 {table test1 has no column named f4}}
+} {1 {no such column: f4}}
 
 # Try an index with some columns that match and others that do now.
 #
 do_test index-2.2 {
   set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
   execsql {DROP TABLE test1}
   lappend v $msg
-} {1 {table test1 has no column named f4}}
+} {1 {no such column: f4}}
 
 # Try creating a bunch of indices on the same table
 #
 set r {}
 for {set i 1} {$i<100} {incr i} {
   lappend r [format index%02d $i]
 }
 do_test index-3.1 {
   execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
   for {set i 1} {$i<100} {incr i} {
@@ skipping 646 matching lines @@
      CREATE TEMP TABLE t6(x);
      INSERT INTO temp.t6 values(1),(5),(9);
      CREATE INDEX temp.i21 ON t6(x);
      SELECT x FROM t6 ORDER BY x DESC;
   }
 } {0 {9 5 1}}
 
    
 
 finish_test