Fossil

Check-in [94d8e9cd]
Login

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

Overview
Comment:Print a warning if there are unfinalized SQL statements when fossil shuts down. Take care to finalize all statements in the "commit" command.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 94d8e9cd4b454a2982241ffb6f44be9833c4f0e8
User & Date: drh 2010-08-23 22:19:45
Context
2010-08-23
22:24
Omit the link to the "ZIP archive" if the user does not have permissions to download the ZIP archive. Ticket [f18142409088bfc707e26]. check-in: 8474ca67 user: drh tags: trunk, release
22:19
Print a warning if there are unfinalized SQL statements when fossil shuts down. Take care to finalize all statements in the "commit" command. check-in: 94d8e9cd user: drh tags: trunk
19:33
Update SQLite to the 3.7.2 release candidate. check-in: 6fd2ff1b user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to src/checkin.c.

811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
    zUuid = db_text(0, "SELECT uuid FROM blob WHERE rid=%d", mid);
    if( zUuid ){
      blob_appendf(&manifest, " %s", zUuid);
      checkin_verify_younger(mid, zUuid, zDate);
      free(zUuid);
    }
  }
  db_reset(&q2);

  blob_appendf(&manifest, "\n");
  blob_appendf(&manifest, "R %b\n", &cksum1);
  if( zBranch && zBranch[0] ){
    Stmt q;
    if( zBgColor && zBgColor[0] ){
      blob_appendf(&manifest, "T *bgcolor * %F\n", zBgColor);







|







811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
    zUuid = db_text(0, "SELECT uuid FROM blob WHERE rid=%d", mid);
    if( zUuid ){
      blob_appendf(&manifest, " %s", zUuid);
      checkin_verify_younger(mid, zUuid, zDate);
      free(zUuid);
    }
  }
  db_finalize(&q2);

  blob_appendf(&manifest, "\n");
  blob_appendf(&manifest, "R %b\n", &cksum1);
  if( zBranch && zBranch[0] ){
    Stmt q;
    if( zBgColor && zBgColor[0] ){
      blob_appendf(&manifest, "T *bgcolor * %F\n", zBgColor);

Changes to src/db.c.

892
893
894
895
896
897
898

899
900
901
902
903




904
905
906
907
908
909
910
  db_open_repository(0);
}

/*
** Close the database connection.
*/
void db_close(void){

  if( g.db==0 ) return;
  while( pAllStmt ){
    db_finalize(pAllStmt);
  }
  db_end_transaction(1);




  g.repositoryOpen = 0;
  g.localOpen = 0;
  g.configOpen = 0;
  sqlite3_wal_checkpoint(g.db, 0);
  sqlite3_close(g.db);
  g.db = 0;
  if( g.dbConfig ){







>





>
>
>
>







892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
  db_open_repository(0);
}

/*
** Close the database connection.
*/
void db_close(void){
  sqlite3_stmt *pStmt;
  if( g.db==0 ) return;
  while( pAllStmt ){
    db_finalize(pAllStmt);
  }
  db_end_transaction(1);
  pStmt = 0;
  while( (pStmt = sqlite3_next_stmt(g.db, pStmt))!=0 ){
    fossil_warning("unfinalized SQL statement: [%s]", sqlite3_sql(pStmt));
  }
  g.repositoryOpen = 0;
  g.localOpen = 0;
  g.configOpen = 0;
  sqlite3_wal_checkpoint(g.db, 0);
  sqlite3_close(g.db);
  g.db = 0;
  if( g.dbConfig ){