Fossil SCM

Update FTS when creating/updating tickets. Also avoids a stray row with rid 0.

preben 2023-09-26 11:04 trunk
Commit fb5d53ec1182eaf5cef27d9ef5e936966db3f2665992c1095ae4bae5c208d6b9
1 file changed +2 -1
+2 -1
--- src/tkt.c
+++ src/tkt.c
@@ -450,11 +450,11 @@
450450
451451
fossil_free(zTag);
452452
getAllTicketFields();
453453
if( haveTicket==0 ) return;
454454
tktid = db_int(0, "SELECT tkt_id FROM ticket WHERE tkt_uuid=%Q", zTktUuid);
455
- search_doc_touch('t', tktid, 0);
455
+ if( tktid!=0 ) search_doc_touch('t', tktid, 0);
456456
if( haveTicketChng ){
457457
db_multi_exec("DELETE FROM ticketchng WHERE tkt_id=%d;", tktid);
458458
}
459459
db_multi_exec("DELETE FROM ticket WHERE tkt_id=%d", tktid);
460460
tktid = 0;
@@ -471,10 +471,11 @@
471471
manifest_destroy(pTicket);
472472
}
473473
createFlag = 0;
474474
}
475475
db_finalize(&q);
476
+ search_doc_touch('t', tktid, 0);
476477
/* Extract backlinks from the most recent values of TICKET fields */
477478
for(i=0; i<nField; i++){
478479
Blob *cards = fields + i;
479480
if( blob_size(cards) ){
480481
struct jCardInfo *x = (struct jCardInfo *)blob_buffer(cards);
481482
--- src/tkt.c
+++ src/tkt.c
@@ -450,11 +450,11 @@
450
451 fossil_free(zTag);
452 getAllTicketFields();
453 if( haveTicket==0 ) return;
454 tktid = db_int(0, "SELECT tkt_id FROM ticket WHERE tkt_uuid=%Q", zTktUuid);
455 search_doc_touch('t', tktid, 0);
456 if( haveTicketChng ){
457 db_multi_exec("DELETE FROM ticketchng WHERE tkt_id=%d;", tktid);
458 }
459 db_multi_exec("DELETE FROM ticket WHERE tkt_id=%d", tktid);
460 tktid = 0;
@@ -471,10 +471,11 @@
471 manifest_destroy(pTicket);
472 }
473 createFlag = 0;
474 }
475 db_finalize(&q);
 
476 /* Extract backlinks from the most recent values of TICKET fields */
477 for(i=0; i<nField; i++){
478 Blob *cards = fields + i;
479 if( blob_size(cards) ){
480 struct jCardInfo *x = (struct jCardInfo *)blob_buffer(cards);
481
--- src/tkt.c
+++ src/tkt.c
@@ -450,11 +450,11 @@
450
451 fossil_free(zTag);
452 getAllTicketFields();
453 if( haveTicket==0 ) return;
454 tktid = db_int(0, "SELECT tkt_id FROM ticket WHERE tkt_uuid=%Q", zTktUuid);
455 if( tktid!=0 ) search_doc_touch('t', tktid, 0);
456 if( haveTicketChng ){
457 db_multi_exec("DELETE FROM ticketchng WHERE tkt_id=%d;", tktid);
458 }
459 db_multi_exec("DELETE FROM ticket WHERE tkt_id=%d", tktid);
460 tktid = 0;
@@ -471,10 +471,11 @@
471 manifest_destroy(pTicket);
472 }
473 createFlag = 0;
474 }
475 db_finalize(&q);
476 search_doc_touch('t', tktid, 0);
477 /* Extract backlinks from the most recent values of TICKET fields */
478 for(i=0; i<nField; i++){
479 Blob *cards = fields + i;
480 if( blob_size(cards) ){
481 struct jCardInfo *x = (struct jCardInfo *)blob_buffer(cards);
482

Keyboard Shortcuts

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