Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a problem in test file e_reindex.test. Cherrypick of [5b3de9390f2f]. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | branch-3.8.6 |
| Files: | files | file ages | folders |
| SHA1: |
80633682d714e5bedc129d8f579a46cc |
| User & Date: | dan 2015-05-20 20:50:59 |
Context
|
2015-05-21
| ||
| 17:21 | Avoid ever writing before the start of an allocated buffer in the DIRECT_OVERFLOW_READ code. Fix for [e3a290961a6]. Cherrypick of [c3c15d20c691]. check-in: 31b13eb5 user: dan tags: branch-3.8.6 | |
|
2015-05-20
| ||
| 20:50 | Fix a problem in test file e_reindex.test. Cherrypick of [5b3de9390f2f]. check-in: 80633682 user: dan tags: branch-3.8.6 | |
| 20:34 | Fix a problem causing the fts3 integrity-check to fail if run inside a transaction. Cherrypick of [3b925189a75e]. check-in: 7d7d633c user: dan tags: branch-3.8.6 | |
|
2015-04-16
| ||
| 08:54 | Fix a problem in test file e_reindex.test. check-in: 5b3de939 user: dan tags: trunk | |
Changes
Changes to test/e_reindex.test.
44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 |
# 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);
PRAGMA writable_schema = 1;
UPDATE sqlite_master SET sql = '-- ' || sql 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';
} {}
db close
sqlite3 db test.db
do_execsql_test e_reindex-1.3 {
PRAGMA integrity_check;
} [list \
|
> > > | | > |
44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 |
# 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;
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;
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 \
|