/ Check-in [473626d5]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Indicate that the database may be corrupt in the fts3corrupt4.test test script.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 473626d5579dd19023abccaf7c1822ac0c883a0b98904837ea096fa16e4f41c4
User & Date: drh 2019-01-12 00:07:48
Context
2019-01-12
00:12
Improved shadow table corruption detection in the matchinfo() function of FTS3. check-in: 567be3bb user: drh tags: trunk
00:07
Indicate that the database may be corrupt in the fts3corrupt4.test test script. check-in: 473626d5 user: drh tags: trunk
2019-01-11
23:08
Use 64-bit APIs in the fileio.c extension. check-in: b49d56a0 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Show Whitespace Changes Patch

Changes to test/fts3corrupt4.test.

248
249
250
251
252
253
254

255
256
257
258
259
260
261
do_catchsql_test 5.1 {
  SELECT * FROM t1 WHERE t1 MATCH 'abandon';
} {1 {malformed database schema (sqlite_autoindey_t1_segdir_1) - orphan index}}


#-------------------------------------------------------------------------
reset_db

do_execsql_test 6.0 {
  CREATE VIRTUAL TABLE Table0 USING fts3();
  INSERT INTO Table0_segdir VALUES(1,NULL,1,NULL,NULL,NULL);
}

do_catchsql_test 6.1 {
  SELECT * FROM Table0 WHERE Table0 MATCH 'a';







>







248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
do_catchsql_test 5.1 {
  SELECT * FROM t1 WHERE t1 MATCH 'abandon';
} {1 {malformed database schema (sqlite_autoindey_t1_segdir_1) - orphan index}}


#-------------------------------------------------------------------------
reset_db
database_may_be_corrupt
do_execsql_test 6.0 {
  CREATE VIRTUAL TABLE Table0 USING fts3();
  INSERT INTO Table0_segdir VALUES(1,NULL,1,NULL,NULL,NULL);
}

do_catchsql_test 6.1 {
  SELECT * FROM Table0 WHERE Table0 MATCH 'a';