| Index: third_party/sqlite/sqlite-src-3100200/test/e_reindex.test
|
| diff --git a/third_party/sqlite/src/test/e_reindex.test b/third_party/sqlite/sqlite-src-3100200/test/e_reindex.test
|
| similarity index 95%
|
| copy from third_party/sqlite/src/test/e_reindex.test
|
| copy to third_party/sqlite/sqlite-src-3100200/test/e_reindex.test
|
| index 4b86787a05feac9af305a5aff2f833cc18771ac1..c6a9e0352f0ed2f04e9cc9578fa56efc20b71a16 100644
|
| --- a/third_party/sqlite/src/test/e_reindex.test
|
| +++ b/third_party/sqlite/sqlite-src-3100200/test/e_reindex.test
|
| @@ -48,8 +48,11 @@ 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
|
| @@ -59,7 +62,8 @@ do_execsql_test e_reindex-1.2 {
|
| 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
|
| @@ -261,10 +265,9 @@ 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 {
|
|
|