title: Sqlite does not detect unique key on a table despite primary key being present
body: <p>I am trying to remove a record from <code>sqlite</code> database. I use <code>dbeaver</code> program for all operations. So when the action is performed, following error is shown:</p>
  
  <p><a href="https://i.stack.imgur.com/BCQW8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BCQW8.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/zF2Qj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zF2Qj.png" alt="enter image description here"></a></p>
  
  <p>The error says that unique key is not present. Query for table creation was this:</p>
  
  <pre><code>CREATE TABLE betGroups ( 
  id INTEGER PRIMARY KEY AUTOINCREMENT, 
  betgroupstatus INTEGER NOT NULL,
  dateInserted DATETIME DEFAULT CURRENT_TIMESTAMP)
  </code></pre>
  
  <p>However, If we check the unique keys tab - we will see that a unique key is present:</p>
  
  <p><a href="https://i.stack.imgur.com/ozjbc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ozjbc.png" alt="enter image description here"></a>
  <a href="https://i.stack.imgur.com/CJkMA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CJkMA.png" alt="enter image description here"></a></p>
  
  <p>So basically, <code>primary key</code> IS considered a <code>unique key</code>. Nevertheless an error is still shown.</p>
  
  <p>Is there a good explanation why I am getting this error? I tried adding a <code>UNIQUE</code> keyword for an <code>id</code> field. table was created, but it made no difference.. Is there anything else I can change either in program options or in SQL script in order for the error to go away.</p>
  
  <p>I am not sure if this is my script issue, a driver issue, or a program issue.</p>
  
  <p>Using: </p>
  
  <ul>
  <li>org.sqlite.JDBC 3.28.0</li>
  <li>dbeaver 6.1.1</li>
  </ul>