Index: third_party/sqlite/src/test/e_reindex.test |
diff --git a/third_party/sqlite/src/test/e_reindex.test b/third_party/sqlite/src/test/e_reindex.test |
index 4b86787a05feac9af305a5aff2f833cc18771ac1..c6a9e0352f0ed2f04e9cc9578fa56efc20b71a16 100644 |
--- a/third_party/sqlite/src/test/e_reindex.test |
+++ b/third_party/sqlite/src/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 { |