Import SQLite 3.10.2.

third_party/sqlite/src/test/e_reindex.test

 # 2010 September 24
 #
 # 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 30 matching lines @@
 # EVIDENCE-OF: R-52173-44778 The REINDEX command is used to delete and
 # recreate indices from scratch.
 #
 #    Test this by corrupting some database indexes, running REINDEX, and
 #    observing that the corruption is gone.
 #
 do_execsql_test e_reindex-1.1 {
   INSERT INTO t1 VALUES(1, 2);
   INSERT INTO t1 VALUES(3, 4);
   INSERT INTO t1 VALUES(5, 6);
+
+  CREATE TABLE saved(a,b,c,d,e);
+  INSERT INTO saved SELECT * FROM sqlite_master WHERE type = 'index';
   PRAGMA writable_schema = 1;
-  UPDATE sqlite_master SET sql = '-- ' || sql WHERE type = 'index';
+  DELETE FROM sqlite_master WHERE type = 'index';
 } {}
 
 db close
 sqlite3 db test.db
 do_execsql_test e_reindex-1.2 {
   DELETE FROM t1 WHERE a = 3;
   INSERT INTO t1 VALUES(7, 8);
   INSERT INTO t1 VALUES(9, 10);
   PRAGMA writable_schema = 1;
-  UPDATE sqlite_master SET sql = substr(sql, 4) WHERE type = 'index';
+  INSERT INTO sqlite_master SELECT * FROM saved;
+  DROP TABLE saved;
 } {}
 
 db close
 sqlite3 db test.db
 do_execsql_test e_reindex-1.3 {
   PRAGMA integrity_check;
 } [list \
   {row 3 missing from index i2} \
   {row 3 missing from index i1} \
   {row 4 missing from index i2} \
@@ skipping 181 matching lines @@
 test_index 5.34  aux.t1 collA   value
 test_index 5.35  aux.t1 collB   value
 do_execsql_test e_reindex-2.5.36 "REINDEX aux.i1_a" {}
 test_index 5.37  t1     collA   length
 test_index 5.38  t1     collB   value
 test_index 5.39  t2     collA   length
 test_index 5.40  t2     collB   value
 test_index 5.41  aux.t1 collA   length
 test_index 5.42  aux.t1 collB   value
 
-# EVIDENCE-OF: R-15639-02023 If no database-name is specified and there
-# exists both a table or index and a collation sequence of the specified
-# name, SQLite interprets this as a request to rebuild the indices that
-# use the named collation sequence.
+# EVIDENCE-OF: R-35892-30289 For a command of the form "REINDEX name", a
+# match against collation-name takes precedence over a match against
+# index-name or table-name.
 #
 set_collations value length
 do_execsql_test e_reindex-2.6.0 {
   CREATE TABLE collA(x);
   CREATE INDEX icolla_a ON collA(x COLLATE collA);
   CREATE INDEX icolla_b ON collA(x COLLATE collB);
 
   INSERT INTO collA SELECT x FROM t1;
 } {}
 
 test_index 6.1   collA  collA   value
 test_index 6.2   collA  collB   length
 
 set_collations length value
 do_execsql_test e_reindex-2.6.3 "REINDEX collA" {}
 test_index 6.4   collA  collA   length
 test_index 6.5   collA  collB   length
 do_execsql_test e_reindex-2.6.3 "REINDEX main.collA" {}
 test_index 6.4   collA  collA   length
 test_index 6.5   collA  collB   value
 
 set_collations value length
 do_execsql_test e_reindex-2.6.6 "REINDEX main.collA" {}
 test_index 6.7   collA  collA   value
 test_index 6.8   collA  collB   length
 
 finish_test