在finalize / close期间,sqlite3_column_text返回的数据被破坏

我不确定这里发生了什么,但我发现在finalize / close sqlite阶段,sqlite3_column_text返回的数据正在被更改.

// rc not handled in this abbreviated code

  sqlite3 *db;
  sqlite3_stmt *stmt;
  char * sql;

  const char * tail;
  int rc;

  char * dbname = "C:\\db\\myblobs.db";
  int myIndex = 0;

  char * myLOCATIOn1;
  String myLOCATIOn2;   

  rc = sqlite3_open(dbName,@R_290_4616@;

  sql = "SELECT LOCATIOn FROM blobs WHERE key = ?";
  rc = sqlite3_prepare(db,sql,strlen(sql),&stmt,&tail);
  sqlite3_bind_int(stmt,1,myIndeX);
  rc = sqlite3_step(stmt);

  myLOCATIOn1 = (char*)sqlite3_column_text(stmt,0);
  myLOCATIOn2 = (char*)sqlite3_column_text(stmt,0);

  // can process myLOCATIOn1 & myLOCATIOn2 fine here

  sqlite3_finalize(stmt); // data myLOCATIOn1 points to get corrupted
  sqlite3_close(db);      // data myLOCATIOn2 points to gets further corrupted

问题与myLOCATIOn1有关.它指向的数据很好,直到它到达sqlite3_finalize和sqlite3_close语句.然而,myLOCATIOn2保持不变.所以不确定这里发生了什么.执行sqlite3_close(db)后,myLOCATIOn1在Visual studio 2010中被标识为“Bad Ptr”.

任何帮助最受赞赏.