Differences From:

File src/tkt.c part of check-in [df3e34c2e8] - Changes to the event mechanism to abbreviate a sequence of edits to the same ticket. Updates through this check-in require a "rebuild". by drh on 2009-09-14 15:14:32. [view]

To:

File src/tkt.c part of check-in [7a2c37063a] - merge trunk into creole branch by bob on 2009-09-22 07:49:39. Also file src/tkt.c part of check-in [0b76ce7b6b] - Treat NULL ticket fields as empty strings when appending new text. Ticket f6747f854ba62b3 by drh on 2009-09-19 14:33:04. [view]

@@ -219,9 +219,10 @@
     const char *zName = p->aField[i].zName;
     if( zName[0]=='+' ){
       zName++;
       if( fieldId(zName)<0 ) continue;
-      blob_appendf(&sql,", %s=%s || %Q", zName, zName, p->aField[i].zValue);
+      blob_appendf(&sql,", %s=coalesce(%s,'') || %Q",
+                   zName, zName, p->aField[i].zValue);
     }else{
       if( fieldId(zName)<0 ) continue;
       blob_appendf(&sql,", %s=%Q", zName, p->aField[i].zValue);
     }