title: "SQLITE Full" exception
body: <p>I'm working on a Java program that uses the Xerial SQLite driver to perform some queries on a huge database.</p>
  
  <p>When I send the query</p>
  
  <pre><code>SELECT sequence,fieldOne,fieldTwo,pairs FROM events ORDER BY pairs DESC
  </code></pre>
  
  <p>where sequence is a TEXT, fieldOne, fieldTwo and pairs and integers. It takes some time and throws this exception:</p>
  
  <blockquote>
    <p>[SQLITE_FULL] Insertion failed because database is full (database or disk is full)</p>
  </blockquote>
  
  <p>If I add a limit constraint, it goes OK.</p>
  
  <p>What is happening? This is not an insert query and disk isn't full.</p>