Fossil SCM
Use query that is similar to other queries in function.
Commit
2145a12ce97300a21da6296f7c470185dfe2640c
Parent
41b29f38fdb4e5e…
1 file changed
+1
-1
+1
-1
| --- src/xfer.c | ||
| +++ src/xfer.c | ||
| @@ -701,11 +701,11 @@ | ||
| 701 | 701 | } |
| 702 | 702 | } |
| 703 | 703 | db_finalize(&q); |
| 704 | 704 | db_multi_exec( |
| 705 | 705 | "DELETE FROM unclustered WHERE rid NOT IN (0 %s)" |
| 706 | - " AND rid NOT IN (SELECT rid FROM phantom)", | |
| 706 | + " AND NOT EXISTS(SELECT 1 FROM phantom WHERE rid=unclustered.rid)", | |
| 707 | 707 | blob_str(&deleteWhere) |
| 708 | 708 | ); |
| 709 | 709 | blob_reset(&deleteWhere); |
| 710 | 710 | if( nRow>0 ){ |
| 711 | 711 | md5sum_blob(&cluster, &cksum); |
| 712 | 712 |
| --- src/xfer.c | |
| +++ src/xfer.c | |
| @@ -701,11 +701,11 @@ | |
| 701 | } |
| 702 | } |
| 703 | db_finalize(&q); |
| 704 | db_multi_exec( |
| 705 | "DELETE FROM unclustered WHERE rid NOT IN (0 %s)" |
| 706 | " AND rid NOT IN (SELECT rid FROM phantom)", |
| 707 | blob_str(&deleteWhere) |
| 708 | ); |
| 709 | blob_reset(&deleteWhere); |
| 710 | if( nRow>0 ){ |
| 711 | md5sum_blob(&cluster, &cksum); |
| 712 |
| --- src/xfer.c | |
| +++ src/xfer.c | |
| @@ -701,11 +701,11 @@ | |
| 701 | } |
| 702 | } |
| 703 | db_finalize(&q); |
| 704 | db_multi_exec( |
| 705 | "DELETE FROM unclustered WHERE rid NOT IN (0 %s)" |
| 706 | " AND NOT EXISTS(SELECT 1 FROM phantom WHERE rid=unclustered.rid)", |
| 707 | blob_str(&deleteWhere) |
| 708 | ); |
| 709 | blob_reset(&deleteWhere); |
| 710 | if( nRow>0 ){ |
| 711 | md5sum_blob(&cluster, &cksum); |
| 712 |