SHA1 Hash:	0b76ce7b6ba3b641168c14875d3d6f329f389b80
Date:	2009-09-19 14:33:04
User:	drh
Comment:	Treat NULL ticket fields as empty strings when appending new text. Ticket f6747f854ba62b3
Timelines:	ancestors | descendants | both | trunk
Other Links:	files | ZIP archive | manifest

• branch=trunk inherited from [a28c83647d]
• sym-trunk inherited from [a28c83647d]

Modified src/tkt.c from [c30fd6165c] to [98960a5cdc].

@@ -218,11 +218,12 @@
   for(i=0; i<p->nField; i++){
     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);
     }
   }