Fossil

Check-in [0b6d3eaf]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix another SQL error on the receiver side of "fossil config pull"
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 0b6d3eaf6cc3e221580d2f9ad95b7e045b7cc1d32bd376f883e4aca3af07b590
User & Date: drh 2018-06-25 18:20:34.009
Context
2018-06-25
18:43
Fix an extra call to db_end_transaction() in "fossil config pull ticket". ... (check-in: f5eb03f5 user: drh tags: trunk)
18:20
Fix another SQL error on the receiver side of "fossil config pull" ... (check-in: 0b6d3eaf user: drh tags: trunk)
18:17
Fix a syntax error in the SQL of the "config pull" mechanism. ... (check-in: 4e699c29 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/configure.c.
︙︙
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437

      blob_append_sql(&sql, "INSERT OR IGNORE INTO ");
    }
    blob_append_sql(&sql, "\"%w\"(\"%w\",mtime",
         &zName[1], aType[ii].zPrimKey);
    for(jj=2; jj<nToken; jj+=2){
       blob_append_sql(&sql, ",\"%w\"", azToken[jj]);
    }
    blob_append_sql(&sql,") VALUES(%s",
       azToken[1] /*safe-for-%s*/);
    for(jj=2; jj<nToken; jj+=2){
       blob_append_sql(&sql, ",%s", azToken[jj+1] /*safe-for-%s*/);
    }
    db_multi_exec("%s)", blob_sql_text(&sql));
    if( db_changes()==0 ){
      blob_reset(&sql);
      blob_append_sql(&sql, "UPDATE \"%w\" SET mtime=%s",








|
|








422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437

      blob_append_sql(&sql, "INSERT OR IGNORE INTO ");
    }
    blob_append_sql(&sql, "\"%w\"(\"%w\",mtime",
         &zName[1], aType[ii].zPrimKey);
    for(jj=2; jj<nToken; jj+=2){
       blob_append_sql(&sql, ",\"%w\"", azToken[jj]);
    }
    blob_append_sql(&sql,") VALUES(%s,%s",
       azToken[1] /*safe-for-%s*/, azToken[0]/*safe-for-%s*/);
    for(jj=2; jj<nToken; jj+=2){
       blob_append_sql(&sql, ",%s", azToken[jj+1] /*safe-for-%s*/);
    }
    db_multi_exec("%s)", blob_sql_text(&sql));
    if( db_changes()==0 ){
      blob_reset(&sql);
      blob_append_sql(&sql, "UPDATE \"%w\" SET mtime=%s",
︙︙