Fossil

Check-in [3200a7c7]
Login

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

Overview
Comment:When dropping surplus tables during "fossil rebuild", make sure to use IF EXISTS so that shadow tables from previously dropped virtual tables do not cause an SQL error.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 3200a7c72e41e783a16f0d61d86464c50a7777da708375ecfc59cb471e6fa9e1
User & Date: drh 2017-06-13 05:12:55
Context
2017-06-15
03:13
Use -O0 instead of -O2 for compiling when the --fossil-debug option of ./configure is used. check-in: 8a6e31f6 user: drh tags: trunk
2017-06-13
05:12
When dropping surplus tables during "fossil rebuild", make sure to use IF EXISTS so that shadow tables from previously dropped virtual tables do not cause an SQL error. check-in: 3200a7c7 user: drh tags: trunk
04:45
Fix the blob_read_from_file() function so that it works with files larger than 2GiB. check-in: 837333fc user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to src/rebuild.c.

362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
                       "'config','shun','private','reportfmt',"
                       "'concealed','accesslog','modreq',"
                       "'purgeevent','purgeitem','unversioned')"
     " AND name NOT GLOB 'sqlite_*'"
     " AND name NOT GLOB 'fx_*'"
  );
  while( db_step(&q)==SQLITE_ROW ){
    blob_appendf(&sql, "DROP TABLE \"%w\";\n", db_column_text(&q,0));
  }
  db_finalize(&q);
  db_multi_exec("%s", blob_str(&sql)/*safe-for-%s*/);
  blob_reset(&sql);
  db_multi_exec("%s", zRepositorySchema2/*safe-for-%s*/);
  ticket_create_table(0);
  shun_artifacts();







|







362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
                       "'config','shun','private','reportfmt',"
                       "'concealed','accesslog','modreq',"
                       "'purgeevent','purgeitem','unversioned')"
     " AND name NOT GLOB 'sqlite_*'"
     " AND name NOT GLOB 'fx_*'"
  );
  while( db_step(&q)==SQLITE_ROW ){
    blob_appendf(&sql, "DROP TABLE IF EXISTS \"%w\";\n", db_column_text(&q,0));
  }
  db_finalize(&q);
  db_multi_exec("%s", blob_str(&sql)/*safe-for-%s*/);
  blob_reset(&sql);
  db_multi_exec("%s", zRepositorySchema2/*safe-for-%s*/);
  ticket_create_table(0);
  shun_artifacts();