title: Comparison operators behave differently after indexing
body: <p>With this schema:</p>
  
  <pre><code>CREATE TABLE temperatures(
   sometext TEXT,
   lowtemp INT,
   hightemp INT,
   moretext TEXT);
  </code></pre>
  
  <p>When I do search</p>
  
  <pre><code>select * from temperatures where lowtemp &lt; 20 and hightemp &gt; 20;
  </code></pre>
  
  <p>I get the correct result which is always one record (due to the specifics of the data).</p>
  
  <p>Now, when I index the table:</p>
  
  <pre><code>CREATE INDEX ltemps ON temperatures(lowtemp);
  CREATE INDEX htemps ON temperatures(hightemp);
  </code></pre>
  
  <p>The exact same query above stops providing expected results -- now I get many records, including ones where the lowtemp and hightemp obviously don't meet the comparison test.</p>
  
  <p>I'm running this on the same sqlite3 database, same table. The only difference is adding the above 2 index statements after table creation.</p>
  
  <p>Can someone explain how indexing influences this behavior?</p>