title: How can I have a SQLiteConstraintException: UNIQUE constraint doing an update on sqlite?
body: <p>How can I have a <strong>SQLiteConstraintException</strong> <strong><em>UNIQUE constraint</em></strong> doing an update in sqlite ?</p>
  
  <p>I'm trying to put my guids to lower case</p>
  
  <pre><code>db.execSQL("update user SET id = LOWER(id)");
  </code></pre>
  
  <blockquote>
    <p>Caused by android.database.sqlite.SQLiteConstraintException: UNIQUE
    constraint failed: user.id (code 1555)</p>
  </blockquote>