Check-in [5da9a8c824]
Not logged in

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

Overview
Comment:Remove an unnecessary SQL operation that sometimes causes errors.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 5da9a8c824146e91cc6738ca952bda173f474d64
User & Date: drh 2011-10-28 20:40:00.730
Context
2011-10-29
17:22
For the /doc web method, append "index.html" if the path ends with "/". check-in: 49a015ef79 user: drh tags: trunk
2011-10-28
20:40
Remove an unnecessary SQL operation that sometimes causes errors. check-in: 5da9a8c824 user: drh tags: trunk
2011-10-26
15:41
Improvements to the User-Agent bot recognizer. Add the test-ishuman command for testing the bot recognizer. check-in: 06e0cb7005 user: drh tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/xfer.c.
635
636
637
638
639
640
641

642
643
644
645
646

647
648
649
650
651
652
653
  Blob cluster, cksum;
  Blob deleteWhere;
  Stmt q;
  int nUncl;
  int nRow = 0;
  int rid;


  /* We should not ever get any private artifacts in the unclustered table.
  ** But if we do (because of a bug) now is a good time to delete them. */
  db_multi_exec(
    "DELETE FROM unclustered WHERE rid IN (SELECT rid FROM private)"
  );


  nUncl = db_int(0, "SELECT count(*) FROM unclustered /*scan*/"
                    " WHERE NOT EXISTS(SELECT 1 FROM phantom"
                                      " WHERE rid=unclustered.rid)");
  if( nUncl>=100 ){
    blob_zero(&cluster);
    blob_zero(&deleteWhere);







>





>







635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
  Blob cluster, cksum;
  Blob deleteWhere;
  Stmt q;
  int nUncl;
  int nRow = 0;
  int rid;

#if 0
  /* We should not ever get any private artifacts in the unclustered table.
  ** But if we do (because of a bug) now is a good time to delete them. */
  db_multi_exec(
    "DELETE FROM unclustered WHERE rid IN (SELECT rid FROM private)"
  );
#endif

  nUncl = db_int(0, "SELECT count(*) FROM unclustered /*scan*/"
                    " WHERE NOT EXISTS(SELECT 1 FROM phantom"
                                      " WHERE rid=unclustered.rid)");
  if( nUncl>=100 ){
    blob_zero(&cluster);
    blob_zero(&deleteWhere);