title: SQLite update returns effected row count but data is not updated
body: <p>I have a method which updates a single row in a table as below. Every now an then some rows will return a row count of 1 from the update method, but the value is not updated. Once that happens for a row it will always behave the same way. Other rows will be update just fine.</p>
  
  <pre><code>public void SetImageStatusToCompleted(String imageId)
     {
         String where = "id=?";
          String[] whereArgs = new String[] {String.valueOf(imageId)};
          ContentValues args = new ContentValues();
          args.put("status", 0);
          int success;
          try 
          {  
              db.beginTransaction();
              success = db.update("images", args, where, whereArgs);
              db.setTransactionSuccessful();
          } 
          finally 
          {
              db.endTransaction();
          }
      }
  </code></pre>
  
  <p>I just cant figure it out. There is never any exception and as I indicated the value of success is always 1 indicating 1 row has been update.</p>
  
  <p>Thanks!</p>