title: sqlite: mathematical operation doesn't return numeric, even though the cell is REAL
body: <p>I have a <code>table</code> with three columns: <code>traffic INTEGER, revtraffic INTEGER, ratio REAL</code>.</p>
  
  <p>When I update the ratio column in the following way:</p>
  
  <pre><code>UPDATE table
  SET ratio = revtraffic/traffic
  </code></pre>
  
  <p>It returns 0.0 in all cells. However, if write:</p>
  
  <pre><code>SET ratio = revtraffic*100/traffic 
  </code></pre>
  
  <p>then it displays the right results but obviously, 100x magnitude too much. What is going on?  </p>