title: SQLite how to update a column which belongs to a multi-column index
body: <p>Say I have a index (id, name) and want to execute a query like:</p>
  
  <pre><code>update &lt;table&gt; set name='new name' where name='old name'
  </code></pre>
  
  <p>Then I got error like: </p>
  
  <pre><code>Query Error: columns id, name are not unique Unable to fetch row.
  </code></pre>
  
  <p>What is that error? And how can I update that column without getting error?</p>