Fossil SCM

Remove an unnecessary SQL operation that sometimes causes errors.

drh 2011-10-28 20:40 trunk
Commit 5da9a8c824146e91cc6738ca952bda173f474d64
1 file changed +2
+2
--- src/xfer.c
+++ src/xfer.c
@@ -637,15 +637,17 @@
637637
Stmt q;
638638
int nUncl;
639639
int nRow = 0;
640640
int rid;
641641
642
+#if 0
642643
/* We should not ever get any private artifacts in the unclustered table.
643644
** But if we do (because of a bug) now is a good time to delete them. */
644645
db_multi_exec(
645646
"DELETE FROM unclustered WHERE rid IN (SELECT rid FROM private)"
646647
);
648
+#endif
647649
648650
nUncl = db_int(0, "SELECT count(*) FROM unclustered /*scan*/"
649651
" WHERE NOT EXISTS(SELECT 1 FROM phantom"
650652
" WHERE rid=unclustered.rid)");
651653
if( nUncl>=100 ){
652654
--- src/xfer.c
+++ src/xfer.c
@@ -637,15 +637,17 @@
637 Stmt q;
638 int nUncl;
639 int nRow = 0;
640 int rid;
641
 
642 /* We should not ever get any private artifacts in the unclustered table.
643 ** But if we do (because of a bug) now is a good time to delete them. */
644 db_multi_exec(
645 "DELETE FROM unclustered WHERE rid IN (SELECT rid FROM private)"
646 );
 
647
648 nUncl = db_int(0, "SELECT count(*) FROM unclustered /*scan*/"
649 " WHERE NOT EXISTS(SELECT 1 FROM phantom"
650 " WHERE rid=unclustered.rid)");
651 if( nUncl>=100 ){
652
--- src/xfer.c
+++ src/xfer.c
@@ -637,15 +637,17 @@
637 Stmt q;
638 int nUncl;
639 int nRow = 0;
640 int rid;
641
642 #if 0
643 /* We should not ever get any private artifacts in the unclustered table.
644 ** But if we do (because of a bug) now is a good time to delete them. */
645 db_multi_exec(
646 "DELETE FROM unclustered WHERE rid IN (SELECT rid FROM private)"
647 );
648 #endif
649
650 nUncl = db_int(0, "SELECT count(*) FROM unclustered /*scan*/"
651 " WHERE NOT EXISTS(SELECT 1 FROM phantom"
652 " WHERE rid=unclustered.rid)");
653 if( nUncl>=100 ){
654

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button